Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected void editSection_selected(object sender, EventArgs e) {
- int index = grdPhone.SelectedIndex;
- GridViewRow row = grdPhone.Rows[index+1];
- string values = ((DropDownList)sender).SelectedValue;
- int tempVal = Convert.ToInt32(values);
- int caseage = Convert.ToInt32(keyId);
- int value = tempVal;
- /*OleDbConnection con = new OleDbConnection(strConnstring);
- //string query = "Update Categories set HRS_LEVEL_AMOUNT=" + tempVal + " where parent_id=65 and ID=" + caseage;
- string query = "Delete HRS_LEVEL_AMOUNT from Categories where parent_id=65 and id=" + caseage;
- OleDbCommand cmd = new OleDbCommand(query, con);
- con.Open();
- cmd.ExecuteNonQuery();
- con.Dispose();
- cmd.Dispose();
- con.Close();
- accPhoneNumbers.UpdateCommand = "Update Categories set HRS_LEVEL_AMOUNT=" + tempVal + " where parent_id=65 and ID=" + caseage;
- */
- string str = "UPDATE Categories SET HRS_LEVEL_AMOUNT = ? WHERE ID=?";
- using (OleDbConnection con = new OleDbConnection(strConnstring))
- {
- using (OleDbCommand cmd = new OleDbCommand(str, con))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("HRS_LEVEL_AMOUNT", tempVal);
- cmd.Parameters.AddWithValue("ID", caseage);
- con.Open();
- cmd.ExecuteNonQuery();
- }
- }
- Label1.Text += " editSection Success! (B) " + tempVal;
- }
- string str = "UPDATE Categories SET HRS_LEVEL_AMOUNT = @value1 WHERE ID=@value2";
- using (OleDbConnection con = new OleDbConnection(strConnstring))
- {
- using (OleDbCommand cmd = new OleDbCommand(str, con))
- {
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@value1", tempVal);
- cmd.Parameters.AddWithValue("@value2", caseage);
- con.Open();
- cmd.ExecuteNonQuery();
- con.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement