Question

visual studio 2008 c# dataadapter 无法 实现update 调试时显示select语句错误

public int Add(String Stu_ID, String Course,double Score)
{
String commandString = "Select * From " + Course;
String connectionString1 = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=db1.mdb";
OleDbConnection connection = new OleDbConnection(connectionString1);
connection.Open(); //make the link and initialize the adapter
OleDbDataAdapter scoreAdapter = new OleDbDataAdapter(commandString, connectionString1);
DataTable chaxun = new DataTable();

scoreAdapter.Fill(chaxun);
DataRow row = chaxun.NewRow();
row[0] = Stu_ID; row[1] = Score;
chaxun.Rows.Add(row);

OleDbCommandBuilder builder = new OleDbCommandBuilder(scoreAdapter );
scoreAdapter.Update(chaxun);

int i = 1;
return i;

}

Answer 1

String commandString = "Select * From " + Course;改成
String commandString =“Select * From " + Course+"" 试下