private void fill_drpdwn() { using (SqlConnection con = new SqlConnection(constr.getconstr())) { using (SqlCommand cmd = new SqlCommand("SELECT PROJNAME FROM PROJDETAILS")) { cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); Drp_Project_Name.DataSource = cmd.ExecuteReader(); Drp_Project_Name.DataValueField = "PROJNAME"; Drp_Project_Name.DataBind(); con.Close(); } } Drp_Project_Name.Items.Insert(0, new ListItem("--Select Project--", "0")); }
private void fill_drpdwn() { DAL dal; dal = new DAL(); DataSet ds = dal.GetSetPROJECTDETAILS( Action: "Get_Specific_Project", Project_ID: Convert.ToInt32(Session["PROJECTID"]), ENTEREDBY: Session["User_ID"].ToString() ); Drp_Project_Name.DataSource = ds; Drp_Project_Name.DataValueField = "PROJNAME"; Drp_Project_Name.DataBind(); Drp_Project_Name.Items.Insert(0, new ListItem("--Select Project--", "0")); Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0")); }
private void fill_Proj_Name() { using (SqlConnection con = new SqlConnection(constr.getconstr())) { using (SqlCommand cmd = new SqlCommand("SELECT PROJECT_ID,PROJNAME FROM PROJDETAILS")) { cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); Drp_Project_Name.DataSource = cmd.ExecuteReader(); Drp_Project_Name.DataTextField = "PROJNAME"; Drp_Project_Name.DataValueField = "PROJECT_ID"; Drp_Project_Name.DataBind(); con.Close(); } } Drp_Project_Name.Items.Insert(0, new ListItem("--Select Project Name--", "0")); Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0")); // Drp_Site_ID.Items.Insert(0, new ListItem("--Select Site ID--", "0")); }
private void fill_drpdwn() { try { DAL dal; dal = new DAL(); DataSet ds = dal.GetSetPROJECTDETAILS( Action: "Get_Specific_Project", Project_ID: Convert.ToInt32(Session["PROJECTID"]), ENTEREDBY: Session["User_ID"].ToString() ); Drp_Project_Name.DataSource = ds; Drp_Project_Name.DataValueField = "PROJNAME"; Drp_Project_Name.DataBind(); Drp_Project_Name.Items.Insert(0, new ListItem("--Select Project--", "0")); } catch (Exception ex) { lblErrorMsg.Text = ex.Message.ToString(); throw; } }