using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?IsLine.Data.DataProvider;

namespace?ToSqlServer
{
????public?partial?class?InsertInto?:?Form
????{
????????public?static?StringBuilder?sb?=?null;
????????public?static?string?sql?=?““;

????????public?InsertInto（）
????????{
????????????InitializeComponent（）;
????????????sql?=?GetSql（）;
????????}

????????private?void?InsertInto_Load（object?sender?EventArgs?e）
????????{

????????}

????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????
????????????System.Diagnostics.Stopwatch?timer?=?new?System.Diagnostics.Stopwatch（）;
????????????timer.Start（）;

????????????for?（int?i?=?0;?i?????????????????SqlProvider.ExecuteNonQuery（sql?true?CommandType.Text?null）;?//調用了IsLine?frameWork中的方法，第二個參數表示開啟了事務

????????????timer.Stop（）;????????
????????????MessageBox.Show（timer.ElapsedMilliseconds.ToString（））;

????????}
????????private?string?GetSql（）
????????{
????????????sb?=?new?StringBuilder（）;
????????????try
????????????{
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????sb.Append（“insert?into?TableB?（value1）?values?（‘“?+?i?+?“‘）!“）;
????????????????}
????????????????sb.Append（“insert?into?TableB?（value1）?values?（‘200000‘）“）;
????????????????return?sb.ToString（）;
????????????}
????????????finally
????????????{
????????????????sb?=?null;
????????????????GC.Collect（）;
????????????}
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????920??2010-03-16?15:08??sqltest.sln

????..A..H.?????33280??2010-03-16?15:08??sqltest.suo

?????目錄??????????0??2010-03-16?15:06??sqltest1

?????文件????????240??2010-03-16?15:06??sqltest1\App.config

?????目錄??????????0??2010-03-14?12:56??sqltest1\bin

?????目錄??????????0??2010-03-16?13:42??sqltest1\bin\Debug

?????文件????????251??2010-03-05?09:17??sqltest1\bin\Debug\App.config

?????目錄??????????0??2010-03-16?13:42??sqltest1\bin\Debug\app.publish

?????目錄??????????0??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\Application?Files

?????目錄??????????0??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5

?????文件??????31232??2010-03-16?11:44??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\IsLine.DataProvider.dll.deploy

?????文件???????4608??2009-06-12?13:36??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\IsLine.dll.deploy

?????文件??????12288??2009-06-12?13:36??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\IsLine.HttpContentProvider.dll.deploy

?????文件???????7168??2009-05-06?11:36??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\IsLine.SecurityProvider.dll.deploy

?????文件????????251??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\ToSqlServer.exe.config.deploy

?????文件??????17920??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\ToSqlServer.exe.deploy

?????文件??????10152??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\Application?Files\ToSqlServer_1_0_0_5\ToSqlServer.exe.manifest

?????文件?????461768??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\setup.exe

?????文件???????5325??2010-03-16?13:42??sqltest1\bin\Debug\app.publish\ToSqlServer.application

?????文件??????31232??2010-03-16?11:44??sqltest1\bin\Debug\IsLine.DataProvider.dll

?????文件???????4608??2009-06-12?13:36??sqltest1\bin\Debug\IsLine.dll

?????文件??????12288??2009-06-12?13:36??sqltest1\bin\Debug\IsLine.HttpContentProvider.dll

?????文件???????7168??2009-05-06?11:36??sqltest1\bin\Debug\IsLine.SecurityProvider.dll

?????文件????????251??2010-03-05?09:17??sqltest1\bin\Debug\sqltest1.vshost.exe.config

?????文件???????1579??2010-03-16?15:08??sqltest1\bin\Debug\ToSqlServer.application

?????文件??????17920??2010-03-16?15:08??sqltest1\bin\Debug\ToSqlServer.exe

?????文件????????240??2010-03-16?15:06??sqltest1\bin\Debug\ToSqlServer.exe.config

?????文件???????6481??2010-03-16?15:08??sqltest1\bin\Debug\ToSqlServer.exe.manifest

?????文件??????65024??2010-03-16?15:08??sqltest1\bin\Debug\ToSqlServer.pdb

?????文件???????1579??2010-03-16?15:08??sqltest1\bin\Debug\ToSqlServer.vshost.application

............此處省略64個文件信息