Updating Data Using CommondBuilder : SqlDataReader : ADO.Net C# Examples

Updating Data Using CommondBuilder

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

class  MainClass
{
    static  void  Main(string[]  args)
    {
        SqlConnection  MyConnection  =  new  SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;");
        SqlDataAdapter  MyDataAdapter  =  new  SqlDataAdapter("SELECT  ID,  FirstName  FROM  Employee",  MyConnection);
        DataSet  MyDataSet  =  new  DataSet();

        MyDataAdapter.Fill(MyDataSet);
        MyDataSet.Tables[0].Rows[0][0]  =  55;

        SqlCommandBuilder  MyCmd  =  new  SqlCommandBuilder(MyDataAdapter);

        MyDataAdapter.Update(MyDataSet);
    }
}
    
   
  
   

Related in same category :
• SqlDataReader
• Use SQL Server Data Provider
• Reference result set by column name in SqlDataReader
• Reference result set by column index in SqlDataReader
• OrdinalIndexer
• Use loop to read all data in SqlDataReader
• Use SqlDataReader to retrieve data in the resultset
• Get data by data type using SqlDataReader
• Using a DataReader to read row by row
• SqlDataReader
• Typed Accessors
• SqlDataReader.GetString, GetDateTime
• how to read a table schema
• Use indexer to read data