SELECT * FROM table-user WHERE USER = '"&Session("UserID")&"'
Date :
2009-09-18 21:29:37
By :
webmaster
No. 2
Guest
ผมไม่ได้ใช้ Session ทำล็อกอินอ่ะคับ
ใช้โค้ดนี้อ่ะ
Code (VB.NET)
Cnnstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Documents\Visual Studio 2008\Projects\test\bin\Debug\Member.mdb;"
With Cnn
If .State = ConnectionState.Open Then Close()
.ConnectionString = Cnnstring
.Open()
.Close()
End With
If TextBox1.Text = "" Then
MessageBox.Show("กรุณาใส่ข้อมูล", "No UserID", MessageBoxButtons.OK, MessageBoxIcon.Error)
Else
main_form.ToolStripMenuItem18.Enabled = True
main_form.ToolStripStatusLabel1.Text = "User :: " & TextBox1.Text & " กำลังใช้งานอยู่"
ReadMyData(Cnnstring)
End If
End Sub
Public Sub ReadMyData(ByVal myConnString As String)
On Error GoTo 0
With Cnn
If .State = ConnectionState.Open Then Close()
.ConnectionString = Cnnstring
.Open()
End With
SqlSelect = "select * from tbMember Where Username = '" & TextBox1.Text & "'"
Dim OleCommand As New OleDbCommand(SqlSelect, Cnn)
OleReader = OleCommand.ExecuteReader
OleReader.Read()
If OleReader.HasRows Then
UserIDA = OleReader.Item("Username")
PassIDA = OleReader.Item("Password")
Else
MessageBox.Show("Username นี้ไม่มีในระบบ", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning)
Form1.reload = "1"
Me.Close()
Exit Sub
End If
Cnn.Close()