今天上午+下午做的些东西吃了个晚自习给吃没了。。。虽然做的不多,但还得重做~~~纠结啊。。。发个登录按钮的代码吧。。。以后直接copy就哦了~~~
private void btn_login_Click(object sender, EventArgs e)
{
string str = ConfigurationManager.ConnectionStrings["strcnn"].ConnectionString;
SqlConnection sqlcnn = new SqlConnection(str);
SqlCommand sqlcmm = new SqlCommand();
sqlcmm.Connection = sqlcnn;
sqlcmm.CommandText = "select * from T_User where UserName=@username and Password=@password";
sqlcmm.Parameters.AddWithValue("@username", textBox1.Text);
sqlcmm.Parameters.AddWithValue("@password", textBox2.Text);
SqlDataAdapter adapter = new SqlDataAdapter(sqlcmm);
DataTable da = new DataTable();
adapter.Fill(da);
if (da.Rows.Count <= 0)
{
MessageBox.Show("密码错误");
}
else
{
MessageBox.Show("登录成功");
this.Hide();
main f = new main();
f.Show();
}
sqlcmm.Dispose();
sqlcnn.Dispose();
}