Hello Expert,
data not show on when ddlSupevisor Select in gridview
My Code Behind are given below: protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ddlFaculty.DataSource = GetData("spGetFaculty", null);
ddlFaculty.DataBind();
ListItem liFaculty = new ListItem("Select Faculty", "-1");
ddlFaculty.Items.Insert(0, liFaculty);
ListItem liSubject = new ListItem("Select Subject", "-1");
ddlSubject.Items.Insert(0, liSubject);
ListItem liSupervisor = new ListItem("Select Supervisor", "-1");
ddlSupervisor.Items.Insert(0, liSupervisor);
ddlSubject.Enabled = false;
ddlSupervisor.Enabled = false;
//ThesisAwardGridView.Visible = false;
}
}
private DataSet GetData(string SPName, SqlParameter SPParam)
{
string cs = ConfigurationManager.ConnectionStrings["DPSMLSU"].ConnectionString;
SqlConnection con = new SqlConnection(cs);
SqlDataAdapter da = new SqlDataAdapter(SPName, con);
DataTable dt = new DataTable();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
if (SPParam != null)
{
da.SelectCommand.Parameters.Add(SPParam);
}
DataSet DS = new DataSet();
da.Fill(DS);
return DS;
}
protected void ddlFaculty_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlFaculty.SelectedIndex == 0)
{
ddlSubject.SelectedIndex = 0;
ddlSubject.Enabled = false;
ddlSupervisor.SelectedIndex = 0;
ddlSupervisor.Enabled = false;
}
else
{
ddlSubject.Enabled = true;
SqlParameter parameter = new SqlParameter("@FacultyId ", ddlFaculty.SelectedValue);
DataSet DS = GetData("spGetSubjectByFacultyId", parameter);
ddlSubject.DataSource = DS;
ddlSubject.DataBind();
ListItem liSubject = new ListItem("Select Subject", "-1");
ddlSubject.Items.Insert(0, liSubject);
ddlSupervisor.SelectedIndex = 0;
ddlSupervisor.Enabled = false;
}
}
protected void ddlSubject_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlSubject.SelectedIndex == 0)
{
ddlSupervisor.SelectedIndex = 0;
ddlSupervisor.Enabled = false;
}
else
{
ddlSupervisor.Enabled = true;
SqlParameter parameter = new SqlParameter("@SubjectId ", ddlSubject.SelectedValue);
DataSet DS = GetData("spGetSupervisorListBySubjectId ", parameter);
ddlSupervisor.DataSource = DS;
ddlSupervisor.DataBind();
ListItem liSupervisor = new ListItem("Select Supervisor", "-1");
ddlSupervisor.Items.Insert(0, liSupervisor);
LoadGirdView();
}
}
private void LoadGirdView()
{
SqlParameter parameter = new SqlParameter("@supervisorId", ddlSupervisor.SelectedValue);
DataSet DS = GetData("sp1GetThesisAwardedBySupervisorId", parameter);
ThesisAwardGridView.DataSource = DS;
ThesisAwardGridView.DataBind();
}
}
}