Use DataTable to update table in Database : Update « Database « C# / C Sharp

Use DataTable to update table in Database

using System;
using System.Data;
using System.Data.SqlClient;

   class PropagateAddsBuilder {
      static void Main() {
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
         string qry = @"select * from employee";
         SqlConnection conn = new SqlConnection(connString);

         try {
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand(qry, conn);

            SqlCommandBuilder cb = new SqlCommandBuilder(da);

            DataSet ds = new DataSet();   
            da.Fill(ds, "employee");

            DataTable dt = ds.Tables["employee"];

            // Add a row
            DataRow newRow = dt.NewRow();
            newRow["firstname"] = "y";
            newRow["lastname"] = "y";

            foreach (DataRow row in dt.Rows){
                  "{0} {1}",

            da.Update(ds, "employee");
         } catch(Exception e)  {
            Console.WriteLine("Error: " + e);
         } finally {


Related examples in the same category

1.Update table using SqlDataAdapter
2.Illustrates how to perform INSERT, UPDATE, and DELETE statements using ADO.NET
3.Creating Data Tables and Populating Them
4.Using Data Table Mappings
5.Update A DataSource
6.Update Data Using Commond Builder
7.Update Data Using Sql Statements 2