Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Persist Changes

using System; using System.Data; using System.Data.SqlClient;     class PersistChanges     {         static void Main(string[] args)         {             string connString = @"server = .\sqlexpress;integrated security = true;database = northwind";             string qry = @"select * from employees where country = 'UK'";             string upd = @"update employees set city = @city where employeeid = @employeeid";             SqlConnection conn = new SqlConnection(connString);             try             {                 SqlDataAdapter da = new SqlDataAdapter();                 da.SelectCommand = new SqlCommand(qry, conn);                 DataSet ds = new DataSet();                 da.Fill(ds, "employees");                 DataTable dt = ds.Tables["employees"];                 dt.Rows[0]["city"] = "Wilmington";                 foreach (DataRow row in dt.Rows)                 {                     Console.WriteLine(row["firstname"]);                     Console.WriteLine(row["lastname"]);                     Console.WriteLine(row["city"]);                 }                 SqlCommand cmd = new SqlCommand(upd, conn);                 cmd.Parameters.Add("@city",SqlDbType.NVarChar,15,"city");                 SqlParameter parm =cmd.Parameters.Add("@employeeid",SqlDbType.Int,4,"employeeid");                 parm.SourceVersion = DataRowVersion.Original;                 da.UpdateCommand = cmd;                 da.Update(ds, "employees");             }             catch (Exception e)             {                 Console.WriteLine("Error: " + e);             }             finally             {                 conn.Close();             }         }     }