syntax error (missing operator) in sql query expression

Question

try
        {

            string Query = "SELECT Registrations list FROM [Records] WHERE textBox = '" + comboBox.SelectedValue + "'";
            OleDbConnection me = new OleDbConnection(connection);
            OleDbCommand constr = new OleDbCommand(Query, me);
            OleDbDataReader reader;
            connection.Open();
            reader = constr.ExecuteReader();

            if (reader.Read())
            {
                OleDbParameter parameter = constr.Parameters.Add(new OleDbParameter("Registrations list", OleDbType.Integer));
                textBox.Text = reader["Registrations list"].ToString();
            }
            me.Close();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }
    }

Im trying to get database values to display in textbox but keep getting the error, i've tried mostly everything possible

Have you tried executing the SQL command as-is to see if you can reproduce the error? That may lead you to what is causing the problem. — Anthony Forloney
– Anthony Forloney, Commented Sep 2, 2015 at 17:53
Can you post the schema for the table? The problem seems to be with how you are referencing the column in your SELECT. — Anthony Forloney
– Anthony Forloney, Commented Sep 2, 2015 at 17:56

Kritner · Accepted Answer · 2015-09-02 17:55:47Z

1

wrap the column name with square brackets

SELECT [Registrations list] FROM [Records] WHERE textBox

Otherwise sql server looks for a column called Registrations and then tries to alias it as [List]

edited Sep 2, 2015 at 17:55

Kritner

13.8k11 gold badges53 silver badges76 bronze badges

answered Sep 2, 2015 at 17:53

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rahul Tripathi Over a year ago

@Johnugo:- Can you tell us the exact error which you are getting when you execute the above query?

M.Ali Over a year ago

you need to do it in the select query itself.

Rahul Tripathi · Accepted Answer · 2015-09-02 17:53:45Z

0

Enclose the column name in square brackets.

SELECT [Registrations list]

If the column names contais space then you need to enclose the column name in square brackets else SQL Server will consider it as two column names and since comma will also be not present hence it will give you syntax error.

answered Sep 2, 2015 at 17:53

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Comments

Stefano Cazzola · Accepted Answer · 2015-09-02 17:55:52Z

0

I suppose there is an error in the SQL

string Query = "SELECT Registrations list FROM [Records] WHERE textBox = '" + comboBox.SelectedValue + "'";

Between SELECT and FROM there should be a comma separated list of columns belinging to the table Records. If you want to label the column place the keyword as between the column name and uts label.

If you placed a white space in the column name (never saw, never did, don't even know if it's possible at all), try including the column name between single quotes. Or (much better) rename the column.

answered Sep 2, 2015 at 17:55

Stefano Cazzola

1,6871 gold badge21 silver badges39 bronze badges

Collectives™ on Stack Overflow

syntax error (missing operator) in sql query expression

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related