 |
| |
[ASp.net #VB] การเช็คสถานะ คนล็อกอิน ทำยังไงแบบ ไม่ต้อง เลือก Type ครับ |
| |
 |
|
|
 |
 |
|
Code (VB.NET)
Dim strCommand As String = "Select [UserID], [Typeid] From [Member] Where [UserName]=@UserName AND [UserPassword]=@UserPassword"
Dim Command As New SqlCommand(strCommand, Connection)
Command.Parameters.AddWithValue("@UserName", userTextBox.Text)
Command.Parameters.AddWithValue("@UserPassword", passwordTextBox.Text)
Dim Dt As New DataTable()
Dim adapter As New SqlDataAdapter(Command)
adapter.Fill(Dt)
If Dt.Rows.Count > 0 Then
Dim UserId As Integer = DirectCast(Dt.Rows(0)("UserID"), Integer)
Dim TypeID As Integer = DirectCast(Dt.Rows(0)("Typeid"), Integer)
End If
|
 |
 |
 |
 |
| Date :
2010-10-07 15:15:44 |
By :
tungman |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|
