errorin where clause

[azfarhus]

I am trying to read some data from a db but I am getting an error on oledbdatareader.

here is my code.

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Power User\Desktop\Domains.accdb;Persist Security Info=False");
            conn.Open();
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            //cmd.CommandText = "Select * from Domains";
            cmd.CommandText = "Select * FROM Domains WHERE Domain= '" + TextBox1.Text + "'";
            OleDbDataReader dr = cmd.ExecuteReader();
            GridView1.DataSource = dr;
            GridView1.DataBind();
            conn.Close();

[Momerath]

On which line is the exception thrown? What error are you getting? What is the value of TextBox1.Text?

[Geekitygeek]

Try putting square bracers around any table and field names (eg "[Domains]"); I'm not sure about the database you are using, but i know some database standards have DOMAIN as a reserved word.

[azfarhus]

^ thanks, it worked.

[PierlucSS]

^ thanks, it worked.

If your satisfied with the answer, please flag this as solved (bottom of the page)