对于此类任务,请考虑使用数据适配器 http://msdn.microsoft.com/en-us/library/system.data.idbdataadapter.aspx抽象。通过 Microsoft Access 数据库,您可以使用OleDbDataAdapter http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbdataadapter.aspx实现如下例所示:
// Prerequisite: The data to be inserted is available in a DataTable/DataSet.
var data = new DataTable();
data.Columns.Add("CompanyName", typeof(string));
data.Columns.Add("Phone", typeof(string));
data.Rows.Add("Foo", "12345678");
data.Rows.Add("Bar", "87654321");
// Now, open a database connection using the Microsoft.Jet.OLEDB provider.
// The "using" statement ensures that the connection is closed no matter what.
using (var connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=Northwind.mdb"))
{
connection.Open();
// Create an OleDbDataAdapter and provide it with an INSERT command.
var adapter = new OleDbDataAdapter();
adapter.InsertCommand = new OleDbCommand("INSERT INTO Shippers (CompanyName, Phone) VALUES (@CompanyName , @Phone)", connection);
adapter.InsertCommand.Parameters.Add("CompanyName", OleDbType.VarChar, 40, "CompanyName");
adapter.InsertCommand.Parameters.Add("Phone", OleDbType.VarChar, 24, "Phone");
// Hit the big red button!
adapter.Update(data);
}
您也可以通过替换来对其他品牌的数据库引擎执行相同的操作OleDbCommand
, OleDbDataAdapter
and OleDbConnection
为您的数据库引擎提供适当的实现。对于 Microsoft SQL Server,查找前缀为的类Sql
, eg. SqlCommand http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx.