Question

如何实现向ACCESS数据库中插入记录

Answer 1

String sql = "insert into 表名(字段1,字段2) values( '" + 字段1对应的值+ "' , '" + 字段2对应的值 + "')";
String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\\data.mdb";
OleDbConnection connection = new OleDbConnection(connectionString);
OleDbCommand cmd = new OleDbCommand(sql,connection);
connection.Open();
if (cmd.ExecuteNonQuery() > 0)//判断插入数据是否成功 { //执行要操作的语句 }