รบกวน ขอcodeตัวอย่าง การทำ login เช็คสถานะรหว่าง admin กับ user ใช้ asp.net c# ครับ (มือใหม่ครับ)

  Sub btnLogin_Click(sender As Object, e As EventArgs)  

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("database/mydatabase.mdb")&";Jet OLEDB:Database Password=;"
objConn.ConnectionString = strConnString
objConn.Open()

Dim dtAdapter As OleDbDataAdapter
Dim dt As New DataTable
strSQL = "SELECT * FROM member WHERE Username = '"& Me.txtUsername.Text &"' AND [Password] = '"& Me.txtPassword.Text &"' "	
dtAdapter = New OleDbDataAdapter(strSQL, objConn)
dtAdapter.Fill(dt)

If dt.Rows.Count > 0 Then
	IF dt.Rows(0)("Status") = "admin" Then
		Response.Redirect("admin.aspx")
	Else
		Response.Redirect("user.aspx")
	End IF
	
Else	
	Me.pnlLogin.Visible = False
	Me.lblStatus.Visible = True
	Me.lblStatus.Text = "Username/Password is wrong."
End IF

objConn.Close()
objConn = Nothing

  End Sub

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;

}