Student.aspx.cs

using System;
using System.Data.SqlClient;
using System.Configuration;

namespace question1
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void SaveButton_Click(object sender, EventArgs e)
        {
            string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

            using (SqlConnection sqlCon = new SqlConnection(connectionString))
            {
                try
                {

                    string studentQuery = "INSERT INTO Students (StudentID, StudentName) VALUES (@StudentID, @StudentName)";
                    SqlCommand studentCmd = new SqlCommand(studentQuery, sqlCon);
                    studentCmd.Parameters.AddWithValue("@StudentID", StudentIDText.Text);
                    studentCmd.Parameters.AddWithValue("@StudentName", StudentNameText.Text);

                    string courseQuery = "INSERT INTO Courses (CourseID, CourseName, Instructor, Department, CreditHours) VALUES (@CourseID, @CourseName, @Instructor, @Department, @CreditHours)";
                    SqlCommand courseCmd = new SqlCommand(courseQuery, sqlCon);
                    courseCmd.Parameters.AddWithValue("@CourseID", CourseIDText.Text);
                    courseCmd.Parameters.AddWithValue("@CourseName", CourseNameText.Text);
                    courseCmd.Parameters.AddWithValue("@Instructor", InstructorText.Text);
                    courseCmd.Parameters.AddWithValue("@Department", DepartmentText.Text);
                    courseCmd.Parameters.AddWithValue("@CreditHours", CreditHoursText.Text);

                    sqlCon.Open();
                    studentCmd.ExecuteNonQuery();
                    courseCmd.ExecuteNonQuery();

                    lblMessage.Text = "Record Inserted Successfully!";
                }
                catch (Exception ex)
                {
                    lblMessage.Text = "Error: " + ex.Message;
                }
                finally
                {
                    sqlCon.Close();
                }
            }
        }
    }
}