private void bindProject()
{
adp = new SqlDataAdapter("select SN,SID,StudentName,Session,Status,SynopsisStatus,EntryStatus from Project where SID='" + txtSid.Text.ToString() + "'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridEval.DataSource = dt;
GridEval.DataBind();
}
private void BindGridEval()
{
adp = new SqlDataAdapter("select SID,StudentName,IMID,Course,Part,InstitutionID,Institution,CourseStatus from Project where Status='CopyDispatched' and Session='" + lblSessionHiddend.Text.ToString() + "' and EntryStatus='Running'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridEval.DataSource = dt;
GridEval.DataBind();
}
protected void txtSID_OnTextChanted(object sender, EventArgs e)
{
adp = new SqlDataAdapter("select SN,SID,StudentName,Session,Status,SynopsisStatus,EntryStatus from Project where SID='" + txtSid.Text.ToString() + "'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridEval.DataSource = dt;
GridEval.DataBind(); GridEval.Focus();
}
protected void txtSid_TextChanged(object sender, EventArgs e)
{
if (txtSid.Text == "")
{
lblexception.Text = "Please insert Membership No";
txtSid.Focus();
}
else
{
adp = new SqlDataAdapter("select SID,StudentName,IMID,Course,Part,InstitutionID,Institution,CourseStatus from Project where Status='CopyDispatched' and SID='" + txtSid.Text.ToString() + "' and EntryStatus='Running'", con);
DataTable dt = new DataTable();
adp.Fill(dt);
GridEval.DataSource = dt;
GridEval.DataBind();
}
}