Monday, May 27, 2013

Save Bulk Copy data table in c#

  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--

No comments:

Post a Comment

fill in blanks

ALL Reading Blanks: Special All approaches aim to increase blood flow to areas of tension and to release painful knots opt1 muscle kn...