//populate the project drop down by user id
public void LoadProject()
{
da = new SqlDataAdapter("Select p.ProjectId, ProjectName from Projects p inner join UserProject up on p.projectId = up.projectId where UserId = " + user_id, con);
dt = new DataTable();
da.Fill(dt);
ProjectDropDownList.DataSource = dt;
ProjectDropDownList.DataTextField = "ProjectName";
ProjectDropDownList.DataValueField = "ProjectId";
ProjectDropDownList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
user_id = Request.QueryString["id"];
//populate project drop down by user id
if (!IsPostBack)
{
da = new SqlDataAdapter("Select p.ProjectId, ProjectName from Projects p inner join UserProject up on p.projectId = up.projectId where UserId = " + user_id, con);
dt = new DataTable();
da.Fill(dt);
ProjectDropDownList.DataSource = dt;
ProjectDropDownList.DataTextField = "ProjectName";
ProjectDropDownList.DataValueField = "ProjectId";
ProjectDropDownList.DataBind();
}
}
public void ClientDropDown()
{
using (SqlConnection connection = new SqlConnection(con))
{
SqlCommand cmd = new SqlCommand("DisplayProject", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CId", ClientDropDownList.SelectedValue);
connection.Open();
SqlDataReader rdr = cmd.ExecuteReader();
ProjectDropDownList.DataSource = rdr;
ProjectDropDownList.DataValueField = "PId";
ProjectDropDownList.DataTextField = "PName";
ProjectDropDownList.DataBind();
ListItem list = new ListItem("--Select--", "-1");
ProjectDropDownList.Items.Insert(0, list);
}
}