protected void btnSave_Click(object sender, EventArgs e)
        {
            int idi = Convert.ToInt32(txtID.Text);
            string nam = txtName.Text;
            decimal ban = Convert.ToDecimal(txtBangla.Text);
            decimal en = Convert.ToDecimal(txtEnglish.Text);
            decimal mat = Convert.ToDecimal(txtHMath.Text);
            decimal isl = Convert.ToDecimal(txtIslam.Text);
            decimal ssci = Convert.ToDecimal(txtSocial.Text);
            decimal ph = Convert.ToDecimal(txtPhysics.Text);
            decimal ch = Convert.ToDecimal(txtChemistry.Text);
            decimal bi = Convert.ToDecimal(txtBiology.Text);
            decimal hmt = Convert.ToDecimal(txtHMath.Text);

            ConnectionClass cl = new ConnectionClass();

            if (cl.InsertMarks(idi, nam, ban, en, mat, isl, ssci, ph, ch, bi, hmt))
            {
                try
                {
                    lblMsg.Text = "Value Insert Succesfully";
                    Response.Redirect("MarkSheet.aspx");
                }
                catch (Exception ex)
                {
                    lblMsg.Text = "Exception" + ex;
                }
            }
            else lblMsg.Text = "Connection Problem.";
        }
 protected void Button1_Click(object sender, EventArgs e)
 {
     int idi = Convert.ToInt32(TextBox1.Text);
     ConnectionClass cl = new ConnectionClass();
     DataTable dt = cl.SearchMarkSheet(idi);
     GridView1.DataSource = dt;
     GridView1.DataBind();
 }