Question

如何将数据库中查询出来的值赋给textbox?

Answer 1

//估计还没有学三层 所以就用这个吧
string connstr=ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;//web.config里面去配
public SqlConnection GetConn()
{
return new SqlConnection(connstr);
}
public void BindData()
{
string id="";
string name = "";
using (SqlConnection c = GetConn())
{

string sqlString = "select id,name from xxx where id=5";
SqlCommand cmd = new SqlCommand(sqlString, c);
c.Open();
SqlDataReader r = cmd.ExecuteReader();

if (r.Read())//如果有多条就 while 那样绑定时候就得筛选了
{
//XClass x = new XClass();
id = r.GetString(0);
name = r.GetString(1);
}
}
this.tbxId = id;
this.tbxName = name;
}