Question

.net里执行SQL语句

string ConnectionString = "Data source = 127.0.0.1; Initial Catalog = incubator;Persist Security Info = True;User ID=sa;Password=sa";
SqlConnection conn = new SqlConnection(ConnectionString);
conn.Open();
string strSQL = "select count(*) from [member] where userName ='" + strUserName + "' and password = '" + strPass + "'";
SqlCommand cmd = new SqlCommand(strSQL, conn);

int num = cmd.ExecuteNonQuery();
我在写验证用户名和密码.我要得到count数出来的值,本来用的这个ExecuteNonQuery(),发现不对.我要用什么函数才能得到想要的值.

Answer 1

ExecuteScalar方法,返回值为返回表的第一行第一列,你选的是个Count,就是它
它的返回值是Object型,你需要强转一下
int count = int.parse(cmd.ExecuteScalar().tostring());

Answer 2

int count = int.parse(cmd.ExecuteScalar().tostring());

Answer 3

SqlDataReader rd= cmd.ExecuteReader();
rd.Read();
int num = rd[0];

Answer 4

ExecuteScalar方法,返回值为返回表的第一行第一列,你选的是个Count,就是它
它的返回值是Object型,你需要强转一下