c#訪問access資料庫

View Code

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.Sql;using System.Data;using System.Data.OleDb;namespace AccessVisit{class Program{static void Main(string[] args){DataTable DT = new DataTable();DT.Columns.Add("Name",typeof(string));DT.Columns.Add("Age",typeof(int));DT.Columns.Add("Sex",typeof(string));DT.Rows.Add("小王",22,"男");DT.Rows.Add("小李", 22, "女");DT.Rows.Add("小紅", 22, "男");DT.Rows.Add("小明", 22, "女");//Access資料庫需要先建立OleDbConnection conn = new OleDbConnection(@"provider=microsoft.jet.oledb.4.0; Data Source=C:\Documents and Settings\Administrator\案頭\access.mdb");if (conn.State != ConnectionState.Open){conn.Open();}OleDbTransaction tx = conn.BeginTransaction();OleDbCommand cmd = new OleDbCommand();cmd.Connection = conn;cmd.Transaction = tx;try{for (int i = 0; i < DT.Rows.Count; i++){StringBuilder sqlstr = new StringBuilder();sqlstr.Append("insert into People values('" + DT.Rows[i][0].ToString() + "',");sqlstr.Append(DT.Rows[i][1].ToString() + ",'");sqlstr.Append(DT.Rows[i][2].ToString() + "')");cmd.CommandText = sqlstr.ToString();cmd.ExecuteNonQuery();}tx.Commit();}catch (OleDbException E){tx.Rollback();throw new Exception(E.Message);}finally{if (conn.State == ConnectionState.Open){conn.Close();}}}}}