DataRow dr = null;
DataTable dt = new DataTable();
dt.Columns.Add("EmpName", typeof(string));
dt.Columns.Add("EmpAddress", typeof(string));
dt.Columns.Add("EmpSalary", typeof(string));
foreach (var item in lst)
{
dr = dt.NewRow();
dr[0] = item.EmpName;
dr[1] = item.EmpAddress;
dr[2] = item.EmpSalary;
dt.Rows.Add(dr);
}
SqlBulkCopy sbc = new SqlBulkCopy("Server=CHD-PKUMAR1-DNE;Database=TestDB;Trusted_Connection=True");
sbc.DestinationTableName = "tblEmployee";
sbc.WriteToServer(dt);
--Happy coding--
DataTable dt = new DataTable();
dt.Columns.Add("EmpName", typeof(string));
dt.Columns.Add("EmpAddress", typeof(string));
dt.Columns.Add("EmpSalary", typeof(string));
foreach (var item in lst)
{
dr = dt.NewRow();
dr[0] = item.EmpName;
dr[1] = item.EmpAddress;
dr[2] = item.EmpSalary;
dt.Rows.Add(dr);
}
SqlBulkCopy sbc = new SqlBulkCopy("Server=CHD-PKUMAR1-DNE;Database=TestDB;Trusted_Connection=True");
sbc.DestinationTableName = "tblEmployee";
sbc.WriteToServer(dt);
--Happy coding--
No comments:
Post a Comment