Wednesday, February 23, 2011

How to Insert Data CSV File to DataBase(Usign Bulk Copy)

Try This One:-

(SqlConnection cn = new SqlConnection
ConfigurationManager
.ConnectionStrings["ConnectionName"].ConnectionString);
cn.Open();
SqlBulkCopy copy = new SqlBulkCopy(cn);
copy.DestinationTableName = "Table Name";
//Dt Is DataTable
copy.WriteToServer(dt);

No comments:

Post a Comment