如何从数据库绑定文本框 [英] How to bind textbox from database

问题描述

如何从数据库绑定文本框.例如，我在数据库中有要在五个文本框中绑定所有字段的字段.

How to bind textbox from database. Ex- i have fields in database i want bind all in five textbox.

推荐答案

Try:

Try:

SqlConnection con = new SqlConnection(connString);
SqlDataAdapter da = new SqlDataAdapter(@"SELECT * FROM Employees ", con);
DataSet ds = new DataSet();
da.Fill(ds, "Employees");
textBox1.DataBindings.Add("text", ds, "Employees.firstname");
textBox2.DataBindings.Add("text", ds, "Employees.lastname");

SqlDataAdapter objAdpt = new SqlDataAdapter("select * from testtable", myConnection);

DataSet objDS = new DataSet();
objAdpt.Fill(objDS, "testtable ");

if (objDS.Tables[0].Rows.Count > 0)
{

  txt1.Text = objDS.Tables[0].Rows[0]["ColumnName"].ToString();
  txt2.Text = objDS.Tables[0].Rows[0]["ColumnName"].ToString();

}

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