发表于 2009-1-5 19:48
| 
ADO.NET 2.0 Dataset鍜孌atatable 鏂板姛鑳芥柊鐗规
鍙戝竷: 2008-6-26 22:34 | 浣滆: admin | 鏌ョ湅: 12娆
1.鏂扮殑绱㈠紩寮曟搸鏇村揩鐨勬墽琛屾晥鐜
涓嬮潰杩欐浠ｇ爜鍦2003涓渶瑕157绉掞紝鍦2005涓彧瑕11绉掑氨鍙互瀹屾垚锛
DataSet ds = new DataSet();
ds.Tables.Add("BigTable");
ds.Tables[0].Columns.Add("ID", Type.GetType("System.Int32"));
ds.Tables[0].Columns["ID"].Unique = true;
ds.Tables[0].Columns.Add("Value", Type.GetType("System.Int32"));
Cursor.Current = Cursors.WaitCursor;
DateTime datBegin = DateTime.Now;
Random rand = new Random();
int i, intValue;
DataRow dr;
for (i = 1; i <= 500000; i++)
{
try
{
intValue = rand.Next();
dr = ds.Tables[0].NewRow();
dr["ID"] = intValue;
dr["Value"] = intValue;
ds.Tables[0].Rows.Add(dr);
}
catch { }
}
Cursor.Current = Cursors.Default;
MessageBox.Show("Elapsed Time: " + (DateTime.Now - datBegin).Seconds.ToString());
MessageBox.Show("count = " + ds.Tables[0].Rows.Count.ToString());
2.Dataset鍙互搴忓垪鍖栦负浜岃繘鍒舵枃浠
string connstr = "server=(local);database=northwind;integrated security=true;async=true";
