各位高手,大家好,现在本人碰到一个迷惑的问题string sql = "select Count(*) from Tb_User ";
SqlCommand cmd = db.getcmd ( sql );
Label1.Text =cmd.ExecuteNonQuery ( ).ToString ( );
这个返回值始终是-1,其实表中是有数据的,如果改成这样的,则可以显示表中的数据
string sql = "select * from Tb_User";
SqlCommand cmd = db.getcmd ( sql );
SqlDataReader dr = cmd.ExecuteReader ( );
while ( dr.Read ( ) )
{
Label1.Text += dr[ "UserName" ].ToString ( ) + "___" + dr[ "UserPwd" ].ToString ( ) + "<br />";
}
dr.Close ( );
db.CnClose ( );哪们大侠知道,分数全给你
SqlCommand cmd = db.getcmd ( sql );
Label1.Text =cmd.ExecuteNonQuery ( ).ToString ( );
这个返回值始终是-1,其实表中是有数据的,如果改成这样的,则可以显示表中的数据
string sql = "select * from Tb_User";
SqlCommand cmd = db.getcmd ( sql );
SqlDataReader dr = cmd.ExecuteReader ( );
while ( dr.Read ( ) )
{
Label1.Text += dr[ "UserName" ].ToString ( ) + "___" + dr[ "UserPwd" ].ToString ( ) + "<br />";
}
dr.Close ( );
db.CnClose ( );哪们大侠知道,分数全给你
Label1.Text =cmd.ExecuteNonQuery ( ).ToString ( );cmd.ExecuteScalar
应该 用 ExecuteScalar() 返回第一行第一列的值