protected void StudentsDataSource_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
DataView dvSql = (DataView)ClassDataSource.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView drvSql in dvSql)
{
e.Command.Parameters["@BatchId"].Value = drvSql["BatchId"];
e.Command.Parameters["@DepartmentId"].Value = drvSql["DepartmentId"];
}
e.Command.Parameters["@ClassId"].Value = Request.QueryString["id"];
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
DataView dvSql = (DataView)ClassDataSource.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView drvSql in dvSql)
{
Course.Text = drvSql["CourseName"].ToString();
Teacher.Text = drvSql["TeacherName"].ToString();
Batch.Text = drvSql["BatchName"].ToString();
Department.Text = drvSql["DepartmentName"].ToString();
Section.Text = drvSql["SectionName"].ToString();
Semester.Text = drvSql["SemesterName"].ToString();
CreditHours.Text = drvSql["CreditHours"].ToString();
}
AddStudents.DataSource = StudentsDataSource;
AddStudents.DataBind();
ClassStudentsGridview.DataSource = ClassStudentsDataSource;
ClassStudentsGridview.DataBind();
}
}
}