Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Update command with parameters

using System; using System.Data; using System.Data.SqlClient; class MainClass {    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"] = "W";          foreach (DataRow row in dt.Rows)          {             Console.WriteLine("{0} {1} {2}",                row["firstname"].ToString().PadRight(15),                row["lastname"].ToString().PadLeft(25),                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();       }    } }