01.SqlConnection objConn = new SqlConnection();
02. SqlCommand objCmd = new SqlCommand();
03. SqlDataAdapter dtAdapter = default(SqlDataAdapter);
04. DataTable dt = new DataTable();
05. string strConnString = null;
06. string strSQL = null;
07. int intCount = 0;
08. strConnString = "server=(local)\\SQLEXPRESS;database=myDatabase;Integrated Security=SSPI;";
09. objConn.ConnectionString = strConnString;
10. objConn.Open();
11. strSQL = " SELECT * FROM member WHERE Username = '" + this.txtUsername.Text + "' AND [Password] = '" + this.txtPassword.Text + "' ";
12. dtAdapter = new SqlDataAdapter(strSQL, objConn);
13. dtAdapter.Fill(dt);
14. if (dt.Rows.Count > 0)
15. {
16. if (dt.Rows[0]["Status"] == "1")
17. {
18. FormMain f = new FormMain();
19. f.Show();
20. this.Visible = false;
21. }
22. else if (dt.Rows[0]["Status"] == "2")
23. {
24. Form3 f = new Form3();
25. f.Show();
26. this.Visible = false;
27. }
28.
29. }
30. else
31. {
32. this.lblStatus.Visible = true;
33. this.lblStatus.Text = "กรุณาตรวจสอบ Username&Password!!";
34. }
35. objConn.Close();
36. objConn = null;
