|
|
|
สอบถาม C# .NET เรื่องการ Login แบบแบ่งสถานะผู้ใช้ครับ |
|
|
|
|
|
|
|
Code (C#)
public void btnLogin_Click(object sender, EventArgs e)
{
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("database/mydatabase.mdb") + ";Jet OLEDB:Database Password=;";
objConn.ConnectionString = strConnString;
objConn.Open();
OleDbDataAdapter dtAdapter = default(OleDbDataAdapter);
DataTable dt = new DataTable();
strSQL = "SELECT * FROM member WHERE Username = '" + this.txtUsername.Text + "' AND [Password] = '" + this.txtPassword.Text + "' ";
dtAdapter = new OleDbDataAdapter(strSQL, objConn);
dtAdapter.Fill(dt);
if (dt.Rows.Count > 0) {
if (dt.Rows[0]["Status"] == "admin") {
Response.Redirect("admin.aspx");
} else {
Response.Redirect("user.aspx");
}
} else {
this.pnlLogin.Visible = false;
this.lblStatus.Visible = true;
this.lblStatus.Text = "Username/Password is wrong.";
}
objConn.Close();
objConn = null;
}
ตัวอย่างครับ
|
|
|
|
|
Date :
2014-06-30 21:20:13 |
By :
mr.win |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ขอบคุณครับพี่แอดมิน
|
|
|
|
|
Date :
2014-06-30 22:42:27 |
By :
jpong7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 03
|