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