从数据库检索数据到文本框? [英] retrieve datas to textbox from database?

问题描述

嗨....
如何在页面加载时从数据库填充文本框值...

hi....
how to fill the textbox values from the database at page load...

推荐答案

DataSet ds;
sqldataAdapter sda =新sqldataAdapter();
sda.Fill(ds);

//您的ds在第1列包含该数据表

textbox1.text = ds.tables [0] .rows [0] .itemarray [1] .tostring();

DataSet ds;
sqldataAdapter sda=new sqldataAdapter();
sda.Fill(ds);

//your ds contain that data table at column 1

textbox1.text=ds.tables[0].rows[0].itemarray[1].tostring();

 protected void Page_Load(object sender, EventArgs e)
    {
     try
        {
            string selectSQL = "select name,gender,Designation,Deptt,Location,dob,emailid from empbirth where userid='" + txtempcode.Text + "'";
            SqlCommand cmd = new SqlCommand(selectSQL, cnn);
            SqlDataReader dr;
            cnn.Open();
            dr = cmd.ExecuteReader();
            
            if (dr.Read())
            {
                txtname.Text = dr[0].ToString();
                txtgender.Text = dr[1].ToString();
                txtdesignation.Text = dr[2].ToString();
                txtdepartment.Text = dr[3].ToString();
                txtlocation.Text = dr[4].ToString();
                txtdob.Text = dr[5].ToString();
                txtEid.Text = dr[6].ToString();

            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.ToString());
        }
}

这篇关于从数据库检索数据到文本框?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！