1.啟動服務:sql server 配置
2.windows驗證進入sql server-安全-sa-改密碼;
3.新建數據庫booksystem;
4.public partial class Form1 : Form
{
SqlConnection conn;
public Form1()
{
InitializeComponent();
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
conn.Open();
MessageBox.Show(conn.State.ToString());
}
catch (Exception ex)
{
//友好提示
MessageBox.Show(ex.Message);
//throw ex;
}
finally {
conn.Close();
MessageBox.Show(conn.State.ToString());
}
}
private void Form1_Load(object sender, EventArgs e)
{
conn = new SqlConnection("server=.;database=booksystem;uid=sa;pwd=sa");
}
}
5.sql
//String sqlStr = "select * from admin where admName='lyc' and admPwd='123'";
//Trim()去掉兩邊的空格
String sqlStr = @"select * from admin
where admName='" + this.txtName.Text.Trim() + "' and admPwd='" + this.txtPwd.Text.Trim() + "'";
cmd = new SqlCommand(sqlStr, conn);
conn.Open();
//object obj=cmd.ExecuteScalar();
try
{
//
Int32 count = (Int32)cmd.ExecuteScalar();
//int count = (int)cmd.ExecuteScalar();
MessageBox.Show("正確");
}
catch (Exception ex)
{
MessageBox.Show("用戶名密碼不正確");
//throw ex;
}
finally {
conn.Close();
}