62,046
社区成员
发帖
与我相关
我的任务
分享
public DataRow dr;
public string usname;
protected void Page_Load(object sender, EventArgs e)
{
usname = Session["uname"].ToString();
}
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 + "'";//p 这里在调试时是有数据的!
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();
///省略
if(ds.Tables["mymama"].Rows.Count>0)
{
this.Luname.Text = ds.Tables["mymama"].Rows[0]["usname"].ToString(); //列“usname”不属于表 mymama
this.lemail.Text = ds.Tables["mymama"].Rows[0]["email"].ToString();
this.Textname.Text = ds.Tables["mymama"].Rows[0]["name"].ToString();
}
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 + "'";//p 这里在调试时是有数据的!
MySqlDataAdapter date = new MySqlDataAdapter(mysqlcmd, mysqlcon);
DataTable data = new DataTable();
date.Fill(data);
if(data.Rows.Count>0)
{
DataRow dr=data.Rows[0];
this.Luname.Text = dr["usname"].ToString();
this.lemail.Text = dr["email"].ToString();
this.Textname.Text = dr["name"].ToString();
}