各位大侠帮俺看看是怎么回事啊SqlConnection conn = new SqlConnection();
string str = "Data Source=(local);Initial Catalog=forums2;Integrated Security=True";
conn.ConnectionString = str;
conn.Open();
string con1 = "select * from friends where friendid ='" + Session["username"] + "'and state ='0'";//查找被邀请人为当前用户并且state为0的人
SqlDataAdapter dataadapter1 = new SqlDataAdapter(con1, str);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, "personaldata");
Label5.Text = dataset1.Tables["friends"].Rows[0][1].ToString().Trim();
最后一句说是示将对象引用设置到对象的实例,请问为什么呢?谢谢!
string str = "Data Source=(local);Initial Catalog=forums2;Integrated Security=True";
conn.ConnectionString = str;
conn.Open();
string con1 = "select * from friends where friendid ='" + Session["username"] + "'and state ='0'";//查找被邀请人为当前用户并且state为0的人
SqlDataAdapter dataadapter1 = new SqlDataAdapter(con1, str);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, "personaldata");
Label5.Text = dataset1.Tables["friends"].Rows[0][1].ToString().Trim();
最后一句说是示将对象引用设置到对象的实例,请问为什么呢?谢谢!
SqlConnection conn = new SqlConnection();
string str = "Data Source=(local);Initial Catalog=forums2;Integrated Security=True";
conn.ConnectionString = str;
conn.Open();
string con1 = "select * from friends where friendid ='" + Session["username"] + "'and state ='0'";//查找被邀请人为当前用户并且state为0的人
SqlDataAdapter dataadapter1 = new SqlDataAdapter(con1, str);
DataSet dataset1 = new DataSet();
dataadapter1.Fill(dataset1, "friends");
Label5.Text = dataset1.Tables["friends"].Rows[0][1].ToString().Trim();
是不是那个表弄错了呀,刚开始学,也不太懂
if( dataset1.Tables.Count > 0 && dataset1.Tables[0].Rows.Count > 0 ){
Label5.Text = dataset1.Tables["friends"].Rows[0][1].ToString().Trim();
}
你前面没有将username存入session
然后调用就出错了
或者是这个地方
用下面方法