private void fill_drpdwn_User_ID()
{
try
{
SqlConnection con = new SqlConnection(constr.getconstr());
SqlCommand cmd = new SqlCommand("Get_User_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Project_Name", Drp_Project_Name.SelectedValue);
cmd.Parameters.AddWithValue("@UserGroup_Name", Drp_User_Group.SelectedValue);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
Drp_User.DataSource = ds.Tables[0];
Drp_User.DataValueField = "User_Name";
Drp_User.DataBind();
con.Close();
Drp_User.Items.Insert(0, new ListItem("--Select User--", "0"));
}
catch (Exception ex)
{
lblErrorMsg.Text = "";
lblErrorMsg.Text = ex.Message;
}
}
private void fill_drpdwn_User_ID()
{
try
{
lblErrorMsg.Text = "";
SqlConnection con = new SqlConnection(constr.getconstr());
SqlCommand cmd = new SqlCommand("Get_User_ID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "Get_UserByUserID");
cmd.Parameters.AddWithValue("@UserGroup_Name", Drp_User_Group.SelectedValue);
cmd.Parameters.AddWithValue("@User_ID", Session["User_ID"].ToString());
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
Drp_User.DataSource = ds.Tables[0];
Drp_User.DataValueField = "User_Name";
Drp_User.DataBind();
con.Close();
if (Drp_User.SelectedValue != "0")
{
cmd = new SqlCommand("Get_User_Details");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
con.Open();
cmd.Parameters.AddWithValue("@User_Name", Drp_User.SelectedValue);
using (SqlDataReader sdr = cmd.ExecuteReader())
{
sdr.Read();
Drp_Exp.SelectedValue = sdr["Exp_Details"].ToString();
}
con.Close();
}
}
catch (Exception ex)
{
lblErrorMsg.Text = "";
lblErrorMsg.Text = ex.Message;
}
}
