Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Update through SqlDataAdapter

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();     } }