Retrieve data from database using asp.net (Incorrect Syntax near 'user')

Question

The error I am receiving is "Incorrect syntax near 'user'" - however, I cannot see anything wrong with my code - does anyone have any ideas?

protected void Page_Load(object sender, EventArgs e)
{
    string db = "";
    db = ConfigurationManager.ConnectionStrings["myConnection"].ConnectionString;
    SqlConnection con = new SqlConnection(db);
    con.Open();

    SqlCommand cmd = new SqlCommand();
    cmd.CommandText = "SELECT * FROM user";
    cmd.Connection = con;
    SqlDataReader dr;
    dr = cmd.ExecuteReader();
    while (dr.Read())
    {
        Response.Write(dr[0].ToString());
        Response.Write(dr[1].ToString());
        Response.Write(dr[2].ToString());
        Response.Write(dr[3].ToString());
    }

    con.Close();
}

Do you have a table called user? Is your connection string correct? — devdigital
– devdigital, Commented Sep 14, 2012 at 7:18
Is it because user is a reserved word (as well as, presumably, the name of your table)? Try "SELECT * FROM [user]" — Jude Fisher
– Jude Fisher, Commented Sep 14, 2012 at 7:19

codingbiz · Accepted Answer · 2012-09-14 07:28:36Z

3

Try this

"SELECT * FROM [user]";

user is a keyword/reserved word. I guess that's the problem. I always end up using USERS instead of user. Try as much as possible to avoid using reserved words as column names, table names, etc. Use them whenever you can't avoid it

edited Sep 14, 2012 at 7:28

answered Sep 14, 2012 at 7:19

codingbiz

26.4k9 gold badges62 silver badges99 bronze badges

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

Comments

BugFinder · Accepted Answer · 2012-09-14 07:19:52Z

3

user is a reserved word - you would need to change it to

"select * from [user]"

answered Sep 14, 2012 at 7:19

BugFinder

17.9k4 gold badges42 silver badges58 bronze badges

Comments

Amarnath Balasubramanian · Accepted Answer · 2014-02-26 10:27:36Z

2

Is it because user is a reserved word (as well as, presumably, the name of your table)?

Try

"SELECT * FROM [user]"

edited Feb 26, 2014 at 10:27

Amarnath Balasubramanian

9,5028 gold badges37 silver badges62 bronze badges

answered Sep 14, 2012 at 7:21

Jude Fisher

11.3k9 gold badges56 silver badges92 bronze badges

Collectives™ on Stack Overflow

Retrieve data from database using asp.net (Incorrect Syntax near 'user')

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related