Update Data Using Commond Builder : Update « Database ADO.net « C# / C Sharp






  1. C# / C Sharp
  2. Database ADO.net
  3. Update

Update Data Using Commond Builder


/*
 * C# Programmers Pocket Consultant
 * Author: Gregory S. MacBeth
 * Email: gmacbeth@comporium.net
 * Create Date: June 27, 2003
 * Last Modified Date:
 * Version: 1
 */
using System;
using System.Data;
using System.Data.SqlClient;

namespace Client.Chapter_13___ADO.NET
{
    public class UpdatingDataUsingCommondBuilder
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
            SqlDataAdapter MyDataAdapter = new SqlDataAdapter("SELECT ID, Contact, Email FROM Test", MyConnection);
            DataSet MyDataSet = new DataSet();

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

            SqlCommandBuilder MyCmd = new SqlCommandBuilder(MyDataAdapter);

            MyDataAdapter.Update(MyDataSet);
        }
    }
}








Related examples in the same category

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