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