[barcan]

this is the code
__________________________________________________ _______
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button3.Click
Dim Conn As New System.Data.OleDb.OleDbConnection("provider=micros oft.jet.oledb.4.0;data source=C:\Documents and Settings\MasterMinds\My Documents\Visual Studio 2008\Projects\WebApplication1\db1.mdb")
Conn.Open()
Dim sql As String
Dim i As Boolean
sql = "select StudentID,StudentPass from st1 Where [StudentID =]'" & Trim(TextBox1.Text) & "' AND [StudentPass =]'" & Trim(TextBox2.Text) & "' "

Dim cmd As New System.Data.OleDb.OleDbCommand(sql, Conn)
cmd = New OleDb.OleDbCommand(sql, Conn)
i = cmd.ExecuteNonQuery()
If (i = True) Then
Response.Redirect("~/stpage.aspx")
Else
Label5.Text = "Invalid username or password"
End If

cmd = Nothing

Conn.Close()
End Sub
__________________________________________________ __


and this is the error


Syntax error (missing operator) in query expression '[StudentID =]'20115001' AND [StudentPass =]'123456''.

[irealtysolution]

Change the sql string to:

sql = "SELECT StudentID, StudentPass from st1 Where StudentID ='"& Trim(TextBox1.Text) & "' AND StudentPass ='" & Trim(TextBox2.Text) & "' "

Thanks!
Zeeshan Dar
CEO iRealtySolution