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(); } } }