protected void gdvDept_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtNewAllow = (TextBox)gdvDept.Rows[e.RowIndex].Cells[1].Controls[0]; TextBox txtNewRate = (TextBox)gdvDept.Rows[e.RowIndex].Cells[2].Controls[0]; //string strSectionName = gdvCart.Rows[e.RowIndex].Cells[2].Text; //lblMsg.Text = txtNewValu.Text; try { string strExistQty = "select count(*) from all_mst where all_name = '" + txtNewAllow.Text.Trim() + "' and all_id <> " + Convert.ToInt32(Session["intAllowNo"]).ToString(); object intExistCnt = objPayroll.GetScalar(strExistQty); if (Convert.ToInt32(intExistCnt) > 0) { lblMessage.Text = "Record Already Exists...!!!"; SqlDSdept.UpdateCommand = "Update all_mst set all_name = '" + Session["strAllowName"] + "',all_rate = " + Convert.ToDecimal(Session["strAllowRate"]) + " WHERE all_id = " + Session["intAllowNo"]; return; } SqlDSdept.UpdateCommand = "Update all_mst set all_name ='" + txtNewAllow.Text.Trim() + "',all_rate = " + Convert.ToDecimal(txtNewRate.Text.Trim()) + " WHERE all_id=" + Session["intAllowNo"]; SqlDSdept.Update(); lblMessage.Text = "RECORD UPDATED SUCCESSFULLY...!!!"; } catch (Exception ex1) { lblMessage.Text = "Access Denied... :: " + ex1.Message; } }
protected void gdvDept_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtNewDept = (TextBox)gdvDept.Rows[e.RowIndex].Cells[1].Controls[0]; //string strSectionName = gdvCart.Rows[e.RowIndex].Cells[2].Text; //lblMsg.Text = txtNewValu.Text; try { string strExistQty = "select count(*) from dept_mst where dept_name = '" + txtNewDept.Text.Trim() + "'"; object intExistCnt = objPayroll.GetScalar(strExistQty); if (Convert.ToInt32(intExistCnt) > 0) { lblMessage.Text = "Record Already Exists...!!!"; SqlDSdept.UpdateCommand = "Update dept_mst set dept_name = '" + Session["strDeptName"] + "' WHERE dept_no = " + Session["intDeptNo"]; return; } SqlDSdept.UpdateCommand = "Update dept_mst set dept_name ='" + txtNewDept.Text.Trim() + "' WHERE dept_no=" + Session["intDeptNo"]; SqlDSdept.Update(); lblMessage.Text = "RECORD UPDATED SUCCESSFULLY...!!!"; } catch (Exception ex1) { lblMessage.Text = "Access Denied... :: " + ex1.Message; } }
protected void gdvDept_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtNewBank = (TextBox)gdvDept.Rows[e.RowIndex].Cells[1].Controls[0]; TextBox txtNewBrName = (TextBox)gdvDept.Rows[e.RowIndex].Cells[2].Controls[0]; try { string strExistQty = "select count(*) from bank_mst where bank_name = '" + txtNewBank.Text.Trim() + "' and bank_id <> " + Convert.ToInt32(Session["intBankNo"]).ToString(); object intExistCnt = objPayroll.GetScalar(strExistQty); if (Convert.ToInt32(intExistCnt) > 0) { lblMessage.Text = "Record Already Exists...!!!"; SqlDSdept.UpdateCommand = "Update bank_mst set bank_name = '" + Session["strBankName"] + "',branch_name = '" + Session["strBrName"].ToString() + "' WHERE bank_id = " + Session["intBankNo"]; return; } SqlDSdept.UpdateCommand = "Update bank_mst set bank_name ='" + txtNewBank.Text.Trim() + "',branch_name = '" + txtNewBrName.Text.Trim() + "' WHERE bank_id=" + Session["intBankNo"]; SqlDSdept.Update(); lblMessage.Text = "RECORD UPDATED SUCCESSFULLY...!!!"; } catch (Exception ex1) { lblMessage.Text = "Access Denied... :: " + ex1.Message; } }