SqlDataReader的问题
在写登陆的代码时候，status = "0";
if (dr.Read())
和写成wlile(dr.Read())
有区别吗？
string
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=;database=stu");
con.Open();
string sql = "select * from biao where Name=@name and Pwd=@password";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@name",SqlDbType.VarChar,50),
new SqlParameter("@password",SqlDbType.VarChar,50)
};
para[0].Value = TextBox1.ToString().Trim();
para[1].Value = TextBox2.ToString().Trim();
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = SqlHelper.ExecuteReader(sql, CommandType.Text, para);
if (dr.Read())
{
status = "1";
}
else
{
status = "0";
}
dr.Close();
con.Close();
return status;