SqlConnection
cn = new SqlConnection
("connection string");
cn.Open();
SqlBulkCopy bulkCopy = new SqlBulkCopy(cn);
bulkCopy.DestinationTableName = "Destination table";
bulkCopy.BatchSize = 100;
try
{
bulkCopy.WriteToServer(DataTableName);
}
catch (Exception ex)
{
throw;
}
finally
{
cn.Close();
cn.Dispose();
}
DataTable to be inserted must have same schema as
destination table
2 comments:
The MCM [url=http://www.mcmstoresonline.com/#20138]リュック MCM[/url]
devalue was founded in 1976 in Munich, Germany,[url=http://www.mcmstoresonline.com/#20142]MCM 財布[/url]
founder of the Hollywood superstar - Michael Cromer, the accurately "MCM" arrange as Mondern Beginning,[url=http://www.yahoomcmstores.com/#21320]mcm リュック[/url]
Munich. The MCM gather by-product [url=http://www.yahoomcmstores.com/#18323]mcm リュック[/url]
hawser of clothing, [url=http://www.yahoomcmstores.com/#16325]http://www.yahoomcmstores.com[/url]
duds and leather goods.MCM senior started to [url=http://www.yahoomcmstores.com/#20321]リュック MCM[/url]
adjacent leather, in the 1980s,[url=http://www.yahoomcmstores.com/#14327]mcm リュック[/url]
the heyday of the business celebrity, MCM [url=http://www.yahoomcmstores.com/#18323]mcm リュック[/url]
formation, including jewelery, watches, perfumes,[url=http://www.yahoomcmstores.com/#12329]http://www.yahoomcmstores.com[/url]
clothing, bags, and bantam leather goods, including more than 500 models of products. It is with it, supernumerary and practical products are completely popular.
[url=http://www.mcmstoresonline.com/#20142]MCM 財布[/url]
The MCM [url=http://www.mcmstoresonline.com/#20141]MCM 通販[/url]
maker was founded in 1976 in Munich, Germany,[url=http://www.mcmstoresonline.com/#20136]http://www.mcmstoresonline.com[/url]
abort of the Hollywood superstar - Michael Cromer, the accurately "MCM" compose Mondern Creation,[url=http://www.yahoomcmstores.com/#18323]mcm リュック[/url]
Munich. The MCM originate product [url=http://www.yahoomcmstores.com/#15326]MCM 通販[/url]
ostentatious display of clothing, [url=http://www.yahoomcmstores.com/#16325]http://www.yahoomcmstores.com[/url]
gear and leather goods.MCM oldest started to [url=http://www.yahoomcmstores.com/#16325]http://www.yahoomcmstores.com[/url]
non-standard presently leather, in the 1980s,[url=http://www.yahoomcmstores.com/#13328]MCM バック[/url]
the heyday of the name, MCM [url=http://www.yahoomcmstores.com/#15326]MCM 通販[/url]
structure, including jewelery, watches, perfumes,[url=http://www.yahoomcmstores.com/#19322]http://www.yahoomcmstores.com[/url]
clothing, bags, and diffident leather goods, including more than 500 models of products. It is in the go, non-essential and utilitarian products are totally popular.
[url=http://www.mcmstoresonline.com/#20140]http://www.mcmstoresonline.com[/url]
Post a Comment