Update through SqlDataAdapter : DataAdapter : ADO.Net C# Examples

    
using  System;
using  System.Data;                      
using  System.Data.SqlClient;  
using  System.Collections.Generic;
using  System.Text;

class  Program  {
        static  void  Main(string[]  args)  {
                SqlConnection  thisConnection  =  new  SqlConnection(@"Server=(local)\sqlexpress;Integrated  Security=True;Database=northwind");
                SqlDataAdapter  thisAdapter  =  new  SqlDataAdapter("SELECT  CustomerID,  CompanyName  FROM  Customers",  thisConnection);
                SqlCommandBuilder  thisBuilder  =  new  SqlCommandBuilder(thisAdapter);
                DataSet  thisDataSet  =  new  DataSet();
                thisAdapter.Fill(thisDataSet,  "Customers");
                Console.WriteLine("name  before  change:  {0}",thisDataSet.Tables["Customers"].Rows[9]["CompanyName"]);
                thisDataSet.Tables["Customers"].Rows[9]["CompanyName"]  =  "Acme,  Inc.";
                thisAdapter.Update(thisDataSet,  "Customers");
                Console.WriteLine("name  after  change:  {0}",  thisDataSet.Tables["Customers"].Rows[9]["CompanyName"]);
                thisConnection.Close();
        }
}