protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-DSAICJG;Initial Catalog=LMS;Integrated Security=True"); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; if (Request.QueryString["Name"] != null) { Id = Request.QueryString["Name"]; sqlQuery = "Select CONCAT(FName,' ',LName) from Student where " + Id + " = StudentId"; cmd.CommandText = sqlQuery; cmd.Connection = conn; string Name = (String)cmd.ExecuteScalar(); TextBox1.Text = Name; TextBox2.Text = Id; sqlQuery = "Select Session from Student where " + Id + " = StudentId"; cmd.CommandText = sqlQuery; cmd.Connection = conn; string Semester = (String)cmd.ExecuteScalar(); TextBox3.Text = Semester; } Label1.Visible = false; SqlConnection conn2 = new SqlConnection(@"Data Source=DESKTOP-DSAICJG;Initial Catalog=LMS;Integrated Security=True"); conn2.Open(); SqlCommand cmd2 = new SqlCommand(); cmd2.CommandType = CommandType.Text; if (Request.QueryString["course"] != null) { String Code = Request.QueryString["course"]; String sqlQuery1 = "Select c.CourseId from Course c where c.CourseName=@Code"; cmd2.Parameters.AddWithValue("@Code", Code); cmd2.CommandText = sqlQuery1; cmd2.Connection = conn2; CourseId = (String)cmd2.ExecuteScalar(); TextBox4.Text = Code; } SqlConnection conn3 = new SqlConnection(@"Data Source=DESKTOP-DSAICJG;Initial Catalog=LMS;Integrated Security=True"); conn3.Open(); using (conn3) { String sqlQuery3 = "Select Dates,TotalMarks,ObatinMarks from AssesmentMarks where AssessmentType=1 and StudentId='" + @Id + "'" + "and CourseId='" + @CourseId + "'"; SqlDataAdapter sqDa = new SqlDataAdapter(sqlQuery3, conn); DataTable dtbl = new DataTable(); sqDa.Fill(dtbl); Quiz.DataSource = dtbl; Quiz.DataBind(); } SqlConnection conn4 = new SqlConnection(@"Data Source=DESKTOP-DSAICJG;Initial Catalog=LMS;Integrated Security=True"); conn4.Open(); using (conn4) { String sqlQuery4 = "Select Dates,TotalMarks,ObatinMarks from AssesmentMarks where AssessmentType=2 and StudentId='" + @Id + "'" + "and CourseId='" + @CourseId + "'"; SqlDataAdapter sqDa2 = new SqlDataAdapter(sqlQuery4, conn); DataTable dtbl1 = new DataTable(); sqDa2.Fill(dtbl1); Assignment.DataSource = dtbl1; Assignment.DataBind(); } using (conn) { String sqlQuery5 = "Select Dates,TotalMarks,ObatinMarks from AssesmentMarks where AssessmentType=3 and StudentId='" + @Id + "'" + "and CourseId='" + @CourseId + "'"; SqlDataAdapter sqDa3 = new SqlDataAdapter(sqlQuery5, conn); DataTable dtbl2 = new DataTable(); sqDa3.Fill(dtbl2); Exam.DataSource = dtbl2; Exam.DataBind(); } }