Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. protected void editSection_selected(object sender, EventArgs e) {
  2. int index = grdPhone.SelectedIndex;
  3. GridViewRow row = grdPhone.Rows[index+1];
  4. string values = ((DropDownList)sender).SelectedValue;
  5. int tempVal = Convert.ToInt32(values);
  6. int caseage = Convert.ToInt32(keyId);
  7. int value = tempVal;
  8. /*OleDbConnection con = new OleDbConnection(strConnstring);
  9. //string query = "Update Categories set HRS_LEVEL_AMOUNT=" + tempVal + " where parent_id=65 and ID=" + caseage;
  10. string query = "Delete HRS_LEVEL_AMOUNT from Categories where parent_id=65 and id=" + caseage;
  11. OleDbCommand cmd = new OleDbCommand(query, con);
  12. con.Open();
  13. cmd.ExecuteNonQuery();
  14. con.Dispose();
  15. cmd.Dispose();
  16. con.Close();
  17. accPhoneNumbers.UpdateCommand = "Update Categories set HRS_LEVEL_AMOUNT=" + tempVal + " where parent_id=65 and ID=" + caseage;
  18. */
  19. string str = "UPDATE Categories SET HRS_LEVEL_AMOUNT = ? WHERE ID=?";
  20. using (OleDbConnection con = new OleDbConnection(strConnstring))
  21. {
  22. using (OleDbCommand cmd = new OleDbCommand(str, con))
  23. {
  24.  
  25. cmd.CommandType = CommandType.Text;
  26. cmd.Parameters.AddWithValue("HRS_LEVEL_AMOUNT", tempVal);
  27. cmd.Parameters.AddWithValue("ID", caseage);
  28. con.Open();
  29. cmd.ExecuteNonQuery();
  30. }
  31. }
  32. Label1.Text += " editSection Success! (B) " + tempVal;
  33. }
  34.  
  35. string str = "UPDATE Categories SET HRS_LEVEL_AMOUNT = @value1 WHERE ID=@value2";
  36. using (OleDbConnection con = new OleDbConnection(strConnstring))
  37. {
  38. using (OleDbCommand cmd = new OleDbCommand(str, con))
  39. {
  40.  
  41. cmd.CommandType = CommandType.Text;
  42. cmd.Parameters.AddWithValue("@value1", tempVal);
  43. cmd.Parameters.AddWithValue("@value2", caseage);
  44. con.Open();
  45. cmd.ExecuteNonQuery();
  46. con.close();
  47. }
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement