String userName = textBox1.Text;//用户名

String userPw = textBox2.Text;//密码

string connString = @"Data Source=ASUS\SQLEXPRESS;Initial Catalog=StudentScore;Integrated Security=True";

SqlConnection conn = new SqlConnection(connString);

string sql = String.Format("select count(*) from [user] where UserName='{0}'and Password='{1}'", userName, userPw);

try

{

conn.Open();// 打开数据库连接

SqlCommand comm = new SqlCommand(sql, conn);//创建 Command 对象

int n = (int)comm.ExecuteScalar();//执行查询语句,返回匹配的行数

if (n==1)

{

Console.WriteLine("----->" + userName + " " + userPw + "登陆成功");

this.DialogResult = DialogResult.OK;

this.Tag = true;



Form2 f2 = new Form2();

f2.Show();

this.Hide();

}

else

{

MessageBox.Show("用户名或者密码错误", "登录失败",

MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

this.Tag = false;


}


}

catch (Exception ex)

{

MessageBox.Show(ex.Message, "操作数据库出错！",

MessageBoxButtons.OK, MessageBoxIcon.Exclamation);

this.Tag = false;

}

finally

{

conn.Close();// 关闭数据库连接

}