private void displayresult(string i)
{
string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT Exam_name,Subject,class,student_id,marks,outof FROM Tbl_exam_res_parents WHERE student_id=@Id ";
cmd.Parameters.AddWithValue("@Id", i);
cmd.Connection = con;
con.Open();
StudentResult_Tbl.DataSource = cmd.ExecuteReader();
StudentResult_Tbl.DataBind();
con.Close();
}
}
}
private void displayresult(string i)
{
string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT Exam_name,Subject,class,marks,outof,STUDENT_FIRST_NAME FROM Tbl_exam_res_parents t1 LEFT JOIN TBL_STUDENT_REGISTRATION t2 ON t2.STUDENT_ID = t1.student_id where t2.STUDENT_ID = t1.student_id and class=@Id";
cmd.Parameters.AddWithValue("@Id", i);
cmd.Connection = con;
con.Open();
StudentResult_Tbl.DataSource = cmd.ExecuteReader();
StudentResult_Tbl.DataBind();
con.Close();
}
}
}
