2021年8月3日
数据库原理及应用
4 页
public void InsertRow(string myConnectionString)
{
// If the connection string is null, use a default.
if(myConnectionString = = "")
{
myConnectionString ="Provider=SQLOLEDB;Data Source = localhost;
Initial Catalog=Northwind;"+"Integrated Security=SSPI;";
}
OleDbConnection myConnection = new
OleDbConnection(myConnectionString);
string myInsertQuery = "INSERT INTO Customers
(CustomerID, CompanyName) Values('NWIND',
'Northwind Traders')";
OleDbCommand myCommand = new OleDbCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
}
OleDbConnection 的使用（ Cont. ）
