private void btnLogin_Click(object sender, EventArgs e)
{
//将数据库名称,账户密码及服务器名称赋值给connStr
string connStr = "UID=sa;pwd=8888;database=ComputerLogin;server=.";
//新建一个数据库连接对象
using ( SqlConnection conn = new SqlConnection(connStr))
{
//打开数据库
conn.Open();
//新建一个sql命令对象
using (SqlCommand cmd = new SqlCommand())
{
//sql命令对象连接数据库
cmd.Connection = conn;
//cmd.CommandText = @"Select count(*) form NameAndPwd where Name='"+txtUserName.Text+"',Pwd='"+txtUserPwd.Text+"'";
//将需要查找的信息存储至str字符串中
string str = string.Format("Select count(*) from NameAndPwd where ComputerName='{0}' and Pwd='{1}'",txtUserName.Text,txtUserPwd.Text);
//将需要查询的字符串赋值sql命令对象下的Commadtext(属性)中
cmd.CommandText = str;
//将查询结果赋值给result,如果存在result有值,如果不存在result为null;
object result =cmd.ExecuteScalar();
//将result强转成int类型
int row = (int)result;
//
if (row >= 1)
{
MessageBox.Show("登陆成功");
}
else
{
MessageBox.Show("账户密码不正确");
}
}
}
}