62,046
社区成员
发帖
与我相关
我的任务
分享
public DataRow dr;
public void datBD()
{
MySqlConnection mysqlcon = new MySqlConnection("Server=localhost;userid=root;password=1234;Database=zhwedo");
mysqlcon.Open();
//MySqlCommand mysqlcmd = new MySqlCommand("select uname from sdb_members where uname='" + usname + "' ", mysqlcon);
string mysqlcmd="select * from sdb_members where uname='" + usname + "'";
MySqlDataAdapter date = new MySqlDataAdapter(mysqlcmd, mysqlcon);
DataSet ds = new DataSet();
date.Fill(ds, "mymuma");
dr = ds.Tables["mymama"].Rows[0];//这里出现未处理NullReferenceException :未将对象引用设置到对象的实例 ...
this.Luname.Text = dr["usname"].ToString();
this.lemail.Text = dr["email"].ToString();
this.Textname.Text = dr["name"].ToString();
}
DataSet ds = new DataSet();
date.Fill(ds, "mymuma");
DataRow[] row = ds.Tables[0].Select();
foreach (DataRow dr in row)
{
this.Luname.Text = dr["usname"].ToString();
this.lemail.Text = dr["email"].ToString();
this.Textname.Text = dr["name"].ToString();
}