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