I Need Help!!
I have a problem in the following codes:
When it run, an Exception was thrown : INSERT INTO syntax error
the wrong line is printed red .
...
OleDbConnection mConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " +
@"Data Source=database\csmng.mdb;");
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = new OleDbCommand("select * from T_Course",mConn);
OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
mConn.Open();
DataSet ds = new DataSet();
da.Fill(ds,"T_Course");
DataTable dt = ds.Tables["T_Course"];
dt.Columns[0].AutoIncrement = true;
DataRow row = dt.NewRow();
row["College"] = "a string";
row["Major"] = "a string";
row["Grade"] = "a string";
ds.Tables["T_Course"].Rows.Add(row);
da.Update(ds,"T_Coures");
...
|