|
用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(); } } } |
|
|
