private void fill_drpdwn_User_Group_ID() { try { SqlConnection con = new SqlConnection(constr.getconstr()); SqlCommand cmd = new SqlCommand("Get_User_Group_ID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Dept_Name", Drp_Dept.SelectedValue); cmd.Parameters.AddWithValue("@User_ID", Session["User_ID"].ToString()); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ad.Fill(ds); Drp_User_Group.DataSource = ds.Tables[0]; Drp_User_Group.DataValueField = "UserGroup_Name"; Drp_User_Group.DataBind(); con.Close(); Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0")); Drp_Exp.SelectedValue = "0"; Drp_Gender.SelectedValue = "0"; Drp_User_Type.SelectedValue = "0"; txt_Dt_of_Join.Text = ""; Chk_Lev1_Manager.Checked = false; Chk_Lev2_Manager.Checked = false; lblErrorMsg.Text = ""; } catch (Exception ex) { lblErrorMsg.Text = ""; lblErrorMsg.Text = ex.Message; } }
private void fill_drpdwn_User_Group_ID() { try { SqlConnection con = new SqlConnection(constr.getconstr()); SqlCommand cmd = new SqlCommand("Get_User_Group_ID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Project_Name", Drp_Project_Name.SelectedItem.Text); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ad.Fill(ds); Drp_User_Group.DataSource = ds.Tables[0]; Drp_User_Group.DataValueField = "UserGroup_Name"; Drp_User_Group.DataBind(); Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0")); Drp_User_Group1.DataSource = ds.Tables[0]; Drp_User_Group1.DataValueField = "UserGroup_Name"; Drp_User_Group1.DataBind(); Drp_User_Group1.Items.Insert(0, new ListItem("--Select User Group--", "0")); con.Close(); lblErrorMsg.Text = ""; } catch (Exception ex) { lblErrorMsg.Text = ""; lblErrorMsg.Text = ex.Message; } }
private void fill_drpdwn_User_Group_ID() { try { SqlConnection con = new SqlConnection(constr.getconstr()); SqlCommand cmd = new SqlCommand("Get_User_Group_ID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "Get_UGByUser"); cmd.Parameters.AddWithValue("@Dept_Name", Drp_Dept.SelectedValue); cmd.Parameters.AddWithValue("@User_ID", Session["User_ID"].ToString()); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ad.Fill(ds); Drp_User_Group.DataSource = ds.Tables[0]; Drp_User_Group.DataValueField = "UserGroup_Name"; Drp_User_Group.DataBind(); con.Close(); Drp_Exp.SelectedValue = "0"; lblErrorMsg.Text = ""; } catch (Exception ex) { lblErrorMsg.Text = ""; lblErrorMsg.Text = ex.Message; } }