writedata.cs

来自「解压包里的是用C#写的100个例子」· CS 代码 · 共 37 行

using System;
using System.Data;   
using System.Data.OleDb;   
namespace ADONETWriteQuery  
{ 
      class Class1 
      {  
            static void Main(string[] args)  
            {  
                  string strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mcTest.MDB";  
                  string strSQL = "INSERT INTO Developer(Name, Address ) VALUES('NewNameIInsert', 'NewAddressIInsert')" ;  
                   
                  // 实例化OleDbCommand对象
                  OleDbConnection myConn = new OleDbConnection(strDSN); 

                  // 实例化OleDbCommand对象
                  OleDbCommand myCmd = new OleDbCommand(strSQL, myConn); 

                  // 打开数据库，执行插入SQL语句
                  try  
                  {  
                        myConn.Open();  
                        myCmd.ExecuteNonQuery(); 
                        Console.WriteLine("插入操作成功!");
                  }  
                  catch (Exception e)  
                  {  
                        Console.WriteLine("在操作数据库过程中发生错误:\n{0}", e.Message);  
                  }  
                  finally  
                  {  
                        myConn.Close();  
                  }  
            } 
      }  
}