新手,这个登录验证老是搞不好,请大神指点一下。帮忙更正一下
private void LoginForm_Load(object sender, EventArgs e)
{
{
string SqlStr = ("server=.; uid=sa; pwd=555411; database=TomDB");//数据库连接
SqlConnection conn = new SqlConnection(SqlStr);
conn.Open();//打开数据库
string sql = "select count(*) from userTB where userid = @userid AND password = @pwd ";//用户名和密码表连接
SqlParameter[] parameters = {
new SqlParameter("@userid", SqlDbType.VarChar, 20),
new SqlParameter("@pwd", SqlDbType.VarChar, 30) };
SqlCommand com = new SqlCommand(sql, conn);
int a = (int)com.ExecuteScalar();//返回第一行第一列
if (a > 0 )
{
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("登录失败");
}
}