//設置一個(gè)數據庫的連接串 

string connectStr = "User Id=scott;Password=tiger;Data Source="; 

OracleConnection conn = new OracleConnection(connectStr); 

OracleCommand command = new OracleCommand(); 

command.Connection = conn; 

//到此為止，還都是我們熟悉的代碼，下面就要開(kāi)始嘍 

//這個(gè)參數需要指定每次批插入的記錄數 

command.ArrayBindCount = recc; 

//在這個(gè)命令行中,用到了參數,參數我們很熟悉,但是這個(gè)參數在傳值的時(shí)候 

//用到的是數組,而不是單個(gè)的值,這就是它獨特的地方 

command.CommandText = "insert into dept values(:deptno, :deptname, :loc)"; 

conn.Open(); 

//下面定義幾個(gè)數組,分別表示三個(gè)字段,數組的長(cháng)度由參數直接給出 

int[] deptNo = new int[recc]; 

string[] dname = new string[recc]; 

string[] loc = new string[recc]; 

// 為了傳遞參數,不可避免的要使用參數,下面會(huì )連續定義三個(gè) 

// 從名稱(chēng)可以直接看出每個(gè)參數的含義,不在每個(gè)解釋了 

OracleParameter deptNoParam = new OracleParameter("deptno", 

OracleDbType.Int32); 

deptNoParam.Direction = ParameterDirection.Input; 

deptNoParam.Value = deptNo; 

command.Parameters.Add(deptNoParam); 

OracleParameter deptNameParam = new OracleParameter("deptname", 

OracleDbType.Varchar2); 

deptNameParam.Direction = ParameterDirection.Input; 

deptNameParam.Value = dname; 

command.Parameters.Add(deptNameParam); 

OracleParameter deptLocParam = new OracleParameter("loc", 

OracleDbType.Varchar2); 

deptLocParam.Direction = ParameterDirection.Input; 

deptLocParam.Value = loc; 

command.Parameters.Add(deptLocParam); 

Stopwatch sw = new Stopwatch(); 

sw.Start(); 

//在下面的循環(huán)中,先把數組定義好,而不是像上面那樣直接生成SQL 

for (int i = 0; i < recc; i++) 

{ 

deptNo[i] = i; 

dname[i] = i.ToString(); 

loc[i] = i.ToString(); 

} 

//這個(gè)調用將把參數數組傳進(jìn)SQL,同時(shí)寫(xiě)入數據庫 

command.ExecuteNonQuery(); 

sw.Stop(); 

System.Diagnostics.Debug.WriteLine("批量插入:" + recc.ToString() 

+ "所占時(shí)間:" +sw.ElapsedMilliseconds.ToString());