C# Programming
04-29-2009, 03:43 PM
OleDbConnection clsConnection;
clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\.one.mdb;");
clsConnection.Open();
//first table
WTest1.oneDataSet f_table = new WTest1.oneDataSet();
OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from first", clsConnection);
dAdapter.Fill(f_table, "first"); // runtime error incorrect FROM syntax
clsConnection.Close();
I've used this code in a previous application and it worked fine, however in this application, it's giving me this error about FROM syntax.
Can someone please tell me what's wrong??http://www.barakasoft.com/script/Forums/Images/smiley_confused.gif
Star
clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\.one.mdb;");
clsConnection.Open();
//first table
WTest1.oneDataSet f_table = new WTest1.oneDataSet();
OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from first", clsConnection);
dAdapter.Fill(f_table, "first"); // runtime error incorrect FROM syntax
clsConnection.Close();
I've used this code in a previous application and it worked fine, however in this application, it's giving me this error about FROM syntax.
Can someone please tell me what's wrong??http://www.barakasoft.com/script/Forums/Images/smiley_confused.gif
Star