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;
}
}
