plz tell me why Syntax error in FROM clause is occuring

[usman_070]

string str="Provider=Microsoft.Jet.OLEDB.4.0;"; str+=@"Data Source=C:\info.mdb"; OleDbConnection con=new OleDbConnection(str); string sql="SELECT * FROM user"; OleDbDataAdapter ada=new OleDbDataAdapter(sql,con); DataSet ds =new DataSet("ds"); ada.Fill(ds,"user");****error occurs in this line Repeater1.DataSource=ds.Tables["user"].DefaultView; DataBind();

[Guffa]

"User" is a reserved keyword in SQL.

--- b { font-weight: normal; }

[safat]

put the user as [user] and try again

:mad:
Sathik