Error Accessing Data from Access Database

[Shayer]

Hello All,
I write the following code to access Data from a table
But i get the exception "Syntax Error in From Clause"

when i write the code in SQL then it works perfectly.

OleDbConnection Myconnection = null;

OleDbDataReader dbReader = null;

Myconnection = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; User
Id=; Password=; Data Source=C:\STTS.mdb");

Myconnection.Open();

OleDbCommand cmd = Myconnection.CreateCommand();

cmd.CommandText = "SELECT * FROM user";

dbReader = cmd.ExecuteReader();

string Email;

while(dbReader.Read())

{

Email = (string)dbReader.GetValue(0);

lb.Items.Add(Email);

}

dbReader.Close();

Myconnection.Close();



Can anybody tell me where is the error

Thanks

 

[Nicholas Paldino [.NET/C# MVP]]

Shayer,

Can you provide a copy of the STTS.MDB file? The command is simple
enough that it seems like it should work. The only thing I can think of
would be to check the cmd variable and see that the command is not trying to
execute a stored procedure or something like that (I don't know what the
defaults for the instance returned from the CreateCommand method are).

Hope this helps.

 

[NULL]

Hello All,
I write the following code to access Data from a table
But i get the exception "Syntax Error in From Clause"

when i write the code in SQL then it works perfectly.
Myconnection = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; User
Id=; Password=; Data Source=C:\STTS.mdb");

Check out www.connectionstrings.com for appropriate connectionstrings
for an Access DB (nice site very usefull):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"

cmd.CommandText = "SELECT * FROM user";

try:
cmd.CommandText = "SELECT * FROM [user]"; //NOTE the []

BTW, is 'user' thegood table (does it exist? I suppose so because the
error would be another if it did not, but I'm just confirming)

 

[NULL]

On Tue, 2 Sep 2003 09:45:47 -0400, "Nicholas Paldino [.NET/C# MVP]"

Hey...

What does C# MVP (Most Valued Partner??) mean... What do you have to
do to be allowed to carry that title?

 

[Nicholas Paldino [.NET/C# MVP]]

NULL,

It stands for Most Valuable Professional. It is not a certification,
but rather an award. For more details on the MVP program, you can check out
the following link (watch for line wrap):

http://mvp.support.microsoft.com/default.aspx?scid=fh;en-us;mvpfaqs

 

[Shayer]

Hello

Everyyhing is okay here

I have to replace the table name. I have a user table . I think User is a
key word , i have to replace it . IF i replace it , it works perfectly

thanks

Hello All,
I write the following code to access Data from a table
But i get the exception "Syntax Error in From Clause"

when i write the code in SQL then it works perfectly.
Myconnection = new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; User
Id=; Password=; Data Source=C:\STTS.mdb");

Check out www.connectionstrings.com for appropriate connectionstrings
for an Access DB (nice site very usefull):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"

cmd.CommandText = "SELECT * FROM user";

try:
cmd.CommandText = "SELECT * FROM [user]"; //NOTE the []

BTW, is 'user' thegood table (does it exist? I suppose so because the
error would be another if it did not, but I'm just confirming)