Getting System.Data.OleDb.OleDbException (0x80040E14): Syntax error (missing operator) in query expression Exception

See more:

C#

ASP

.NET

I have designed a login page in C# ASP .Net.I am using Oledbcommand to check the login credential.

Following is the code:-

try

{
                string connect = "Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:/Users/jahart/Documents/Visual Studio 2010/Projects/ScindiaEvents/ScindiaEvents/Account/Events.mdb;";
                string query = "Select Count(*) From Students Where User ID = ? And Psswrd = ?";
                int result = 0;
                using (OleDbConnection conn = new OleDbConnection(connect))
                {
                    using (OleDbCommand cmd = new OleDbCommand(query, conn))
                    {
                        cmd.Parameters.AddWithValue("User ID", "TextBox1.Text");
                        cmd.Parameters.AddWithValue("Psswrd", "TextBox2.Text");
                        conn.Open();
                        Session["User"] = TextBox1.Text;
                        result = (int)cmd.ExecuteScalar();
                    }
                }
                if (result > 0)
                {
                    Response.Redirect("Default.aspx");
                }
                else
                {
                    lblMessage.Text = "Invalid credentials";
                }

            }
            catch (Exception ex)
            {
                lblMessage.Text = ex.ToString();
            }
        }

When I Click on Login button I get an exception i.e. [System.Data.OleDb.OleDbException (0x80040E14): Syntax error (missing operator) in query expression 'User ID = ? And Psswrd = ?'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteScalar() at ScindiaEvents.Account.Login.Button1_Click(Object sender, EventArgs e) in C:\Users\jahart\Documents\Visual Studio 2010\Projects\ScindiaEvents\ScindiaEvents\Account\Login.aspx.cs:line 47]

Can somebody pls help me on this part.

Thanx in advance.