用ADO添加數(shù)據(jù)到數(shù)據(jù)庫中:
using System;
using System.Data;
using System.Data.OleDb;
class TestADO
{
static void Main(string[] args)
{
string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\test.mdb";
string strSQL = "INSERT INTO Employee(FirstName, LastName) valueS(‘FirstName’, ’LastName’)" ;
// create Objects of ADOConnection and ADOCommand
OleDbConnection conn = new OleDbConnection(strDSN);
OleDbCommand cmd = new OleDbCommand( strSQL, conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine("Oooops. I did it again:\n{0}", e.Message);
}
finally
{
conn.Close();
}
}
}
本站僅提供存儲服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請
點擊舉報。