protected void btnSubmit_Click(object sender, EventArgs e)
 {
     Student newStudent = new Student();
     string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
     newStudent.AddStudent(connectionString, txtName.Text, Convert.ToInt32(txtEnrollmentNumber.Text), Convert.ToInt32(txtMarks.Text), Convert.ToInt32(txtAge.Text), txtGender.Text);
     Response.Redirect("Home.aspx");
 }
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            var connectionString = ConfigurationManager.ConnectionStrings["connection"].ConnectionString;
            _student = new Student(connectionString);

            _student.AddStudent(txtName.Text, Convert.ToInt32(txtEnrollNumber.Text), Convert.ToInt32(txtstreamId.Text), Convert.ToInt32(txtMarks.Text), Convert.ToInt32(txtStateId.Text), txtState.Text, txtStream.Text);
            Response.Redirect("HomePage.aspx");
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            var connectionString = ConfigurationManager.ConnectionStrings["connection"].ConnectionString;
            _studentService = new Student(connectionString);
            if (!IsPostBack)
            {

                int enrollmentNumber = Convert.ToInt32(Request.Params["RollNo"]);
                _studentService.GetDetails(enrollmentNumber);

                txtName.Text = _studentService.Name;
                txtEnrollNumber.Text = _studentService.EnrollmentNumber.ToString();
                txtMarks.Text = _studentService.Marks.ToString();

                List<string> states =_studentService.GetAllStateName();

                ddlState.DataSource = states;
                ddlState.DataBind();

                List<int> stateId = _studentService.GetAllStateId();
                ddlStateId.DataSource = stateId;
                ddlStateId.DataBind();

                List<string> streams = _studentService.GetAllStreamName();
                ddlStream.DataSource = streams;
                ddlStream.DataBind();

                List<int> streamsId = _studentService.GetAllStreamId();
                ddlStreamId.DataSource = streamsId;
                ddlStreamId.DataBind();

            }
            else
            {
                _studentService.AddStudent(txtName.Text, Convert.ToInt32(txtEnrollNumber.Text), Convert.ToInt32(ddlStreamId.Text), Convert.ToInt32(txtMarks.Text), Convert.ToInt32(ddlStateId.Text), ddlState.Text, ddlStream.Text);
            }
        }