Mega Code Archive

 

Categories / C# / ADO Database

 

Update table using SqlDataAdapter

using System; using System.Data; using System.Data.SqlClient;    class PropagateChanges {       static void Main(){          string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";          string qry = @"select * from employee ";          string upd = @"update employee set firstname = @firstname where id = @id";          SqlConnection conn = new SqlConnection(connString);          try {             SqlDataAdapter da = new SqlDataAdapter();             da.SelectCommand = new SqlCommand(qry, conn);             DataSet ds = new DataSet();                da.Fill(ds, "employee");             DataTable dt = ds.Tables["employee"];             dt.Rows[0]["firstname"] = "W";             foreach (DataRow row in dt.Rows){                Console.WriteLine(                   "{0} {1}",                   row["firstname"].ToString().PadRight(15),                   row["lastname"].ToString().PadLeft(25));             }             // Update employees             SqlCommand cmd = new SqlCommand(upd, conn);             cmd.Parameters.Add("@firstname",SqlDbType.NVarChar,15, "firstname");             SqlParameter parm = cmd.Parameters.Add("@id",SqlDbType.Int,4,"id");             parm.SourceVersion = DataRowVersion.Original;             da.UpdateCommand = cmd;             da.Update(ds, "employee");          } catch(Exception e) {             Console.WriteLine("Error: " + e);          } finally {             conn.Close();          }       }      }