protected void btnUserUpdate_Click(object sender, EventArgs e) { User = Convert.ToInt32(hidUserIDVal.Value); hidValue.Value = hidValue.Value.Replace("`", ""); string groupID = hidValue.Value.Replace(",", "','"); string whereCond = " and psecGroupID in ('" + groupID.Remove(groupID.Length - 3, 3) + "')"; //InsertUserGroup string columnValue = ""; DataTable dtUpdate = employee.GetSecurityData(UserID, whereCond); //string secUserId = employee.GetSecUserID(lblUserName.Text); //string columnvalues = "'" + User + "','" + lblUserName.Text + "','"+Session["UserName"].ToString()+"','"+ DateTime.Now.ToShortDateString()+"'"; //secUserId = employee.InsertSecurityUser(columnvalues); foreach (DataRow dr in dtUpdate.Rows) { columnValue = "'" + dr["ListValue"].ToString() + "'," + "'" + dr["GroupCd"].ToString() + "'," + UserID + ", " + "'" + Session["UserName"].ToString() + "'," + "'" + DateTime.Now.ToShortDateString() + "'"; employee.InsertUserGroup(columnValue); } columnValue = ""; hidValue.Value = ""; BindUserGrid(); BindSecurityGrid(); ScriptManager.RegisterClientScriptBlock(btnUserUpdate, btnUserUpdate.GetType(), "Cursor", "document.form1.style.cursor='auto';", true); upnlGroupGrid.Update(); upnlSecurityGrid.Update(); }