Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. private void button2_Click(object sender, EventArgs e)
  2. {
  3. DataRow[] row_update = ds.Tables["Plane"].Select("airline_id = " + aidbox.Text);
  4. try
  5. {
  6. row_update["airline_id"] = int.Parse(aidbox.Text);
  7. row_update["plane_id"] = int.Parse(pid_box.Text);
  8. row_update["name"] = name_box.Text;
  9. row_update["model"] = model_box.Text;
  10. row_update["f_seats"] = int.Parse(fc_box.Text);
  11. row_update["s_seats"] = int.Parse(sc_box.Text);
  12. row_update["b_seats"] = int.Parse(bs_box.Text);
  13. row_update["p_weight"] = float.Parse(weight_box.Text);
  14. }
  15. catch (Exception ex) { MessageBox.Show(ex.Message); }
  16.  
  17. try
  18. {
  19. builder = new SqlCommandBuilder(data_adapter);
  20. data_adapter.UpdateCommand = builder.GetUpdateCommand();
  21.  
  22. data_adapter.Update(ds, "Plane");
  23.  
  24. }
  25. catch (SqlException ex) { MessageBox.Show(ex.Message); }
  26. }
  27.  
  28. }
  29.  
  30. DataColumn[] temp = new DataColumn[1];
  31. temp[0] = ds.Tables["Plane"].Columns["airline_id"];
  32. ds.Tables["Plane"].PrimaryKey = temp;
  33. DataRow row_update = ds.Tables["Plane"].Rows.Find(aidbox.Text);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement