private void fill_Project()
{
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.DataSource = ds.Tables[0];
Drp_Project.DataValueField = "Project_ID";
Drp_Project.DataTextField = "PROJNAME";
Drp_Project.DataBind();
Drp_Project.Items.Insert(0, new ListItem("--Select Project--", "0"));
if (Session["PROJECTID"] != null)
{
Drp_Project.Items.FindByValue(Session["PROJECTID"].ToString()).Selected = true;
}
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message.ToString();
}
}
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.DataSource = ds;
Drp_Project.DataValueField = "PROJNAME";
Drp_Project.DataBind();
Drp_Project.Items.Insert(0, new ListItem("--Select Project--", "0"));
Drp_User_Group.Items.Insert(0, new ListItem("--Select User Group--", "0"));
Drp_User.Items.Insert(0, new ListItem("--Select User--", "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.DataSource = ds.Tables[0];
Drp_Project.DataValueField = "Project_ID";
Drp_Project.DataTextField = "PROJNAME";
Drp_Project.DataBind();
Drp_Project.Items.Insert(0, new ListItem("--Select Project--", "0"));
}
catch (Exception ex)
{
lblErrorMsg.Text = ex.Message.ToString();
throw;
}
//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"));
}
