private void Grid2Bind() { try { if (gridSubmitExmpFee.SelectedRow.Cells[4].Text == "Civil") { SqlDataAdapter adp = new SqlDataAdapter("select SubID,SubName,SubjectType from CivilSubMaster where SubID Not in(select SubID from SExamMarks where Part='" + gridSubmitExmpFee.SelectedRow.Cells[5].Text + "' and SID='" + gridSubmitExmpFee.SelectedRow.Cells[2].Text + "' and Status='Pass') and (([Section] ='" + gridSubmitExmpFee.SelectedRow.Cells[5].Text + "') and ([CourseID]=081)) ORDER BY [SubID]", con); DataTable dt = new DataTable(); adp.Fill(dt); GridCivilArch.DataSource = dt; GridCivilArch.DataBind(); } else { SqlDataAdapter adp = new SqlDataAdapter("select SubID,SubName,SubjectType from ArchiSubMaster where SubID Not in(select SubID from SExamMarks where Part='" + gridSubmitExmpFee.SelectedRow.Cells[5].Text + "' and SID='" + gridSubmitExmpFee.SelectedRow.Cells[2].Text + "' and Status='Pass') and (([Section] ='" + gridSubmitExmpFee.SelectedRow.Cells[5].Text + "') and ([CourseID]=081)) ORDER BY [SubID]", con); DataTable dt = new DataTable(); adp.Fill(dt); GridCivilArch.DataSource = dt; GridCivilArch.DataBind(); } } catch (SqlException ex) { } finally { } }
protected void gridSubmitExmpFee_SelectedIndexChanged(object sender, EventArgs e) { Grid2Bind(); panelVisible.Visible = true; GridCivilArch.Focus(); }