Need Help with form to Database

See more:

ASP.NET

I have a form I made and I have the code I wrote. When I fill in the data and click submit the it says that You Have Successfully Submitted the Information!!! but when I go into the database and select the table it went to there is nothing there. What did I do wrong? Here is my code:

using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Drawing;
using System.Text;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Data.SqlClient;
using System.Configuration;
using System.Drawing.Printing;

public partial class FTEEnrollmentInformation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void ButtonSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PassConnectionString"].ConnectionString);
        con.Open();

         
        
        string insCmd1 = "Insert into TableFTE (FT_UNDERGR, FT_GRAD, FTE_UNDERG, FTE_GRAD, NON_CREDIT, TOTAL_FTE, FCFTUHC, FCFTPBHC, FCPTUHC, FCPTBHC, NCHC) values (@FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTBHC, @NCHC)";


        string insCmd2 = "Insert into TableGRADRATE (ASTUDENTS, ACOMPLETED, ATRANSFERS, BSTUDENTS, BCOMPLETED, BTRANSDERS, YEAR, DATE) values (@ASTUDENTS, @ACOMPLETED, @ATRANSFERS, @BSTUDENTS, @BCOMPLETED, @BTRANSDERS, @YEAR, @DATE)";

        SqlCommand insertUser1 = new SqlCommand(insCmd1, con);
        insertUser1.Parameters.AddWithValue("@FT_UNDERGR", TextBoxFTUG.Text);
        insertUser1.Parameters.AddWithValue("@FT_GRAD", TextBoxFTG.Text);
        insertUser1.Parameters.AddWithValue("@FTE_UNDERG", TextBoxTHUGDR.Text);
        insertUser1.Parameters.AddWithValue("@FTE_GRAD", TextBoxTHGDR.Text);
        insertUser1.Parameters.AddWithValue("@NON_CREDIT", TextBoxNCCDR.Text);
        insertUser1.Parameters.AddWithValue("@TOTAL_FTE", TextBoxTCNC.Text);
        insertUser1.Parameters.AddWithValue("@FCFTUHC", TextBoxTNFUG.Text);
        insertUser1.Parameters.AddWithValue("@FCFTPBHC", TextBoxTNFG.Text);
        insertUser1.Parameters.AddWithValue("@FCPTUHC", TextBoxTNCPUG.Text);
        insertUser1.Parameters.AddWithValue("@FCPTBHC", TextBoxTNCPG.Text);
        insertUser1.Parameters.AddWithValue("@NCHC", TextBoxTNNCC.Text);

        SqlCommand insertUser2 = new SqlCommand(insCmd2, con);
        insertUser2.Parameters.AddWithValue("@ASTUDENTS", TextBoxTNUGSC.Text);
        insertUser2.Parameters.AddWithValue("@ACOMPLETED", TextBoxTNUGSCD.Text);
        insertUser2.Parameters.AddWithValue("@ATRANSFERS", TextBoxTTOUG.Text);
        insertUser2.Parameters.AddWithValue("@BSTUDENTS", TextBoxTNGSC.Text);
        insertUser2.Parameters.AddWithValue("@BCOMPLETED", TextBoxTNGSCD.Text);
        insertUser2.Parameters.AddWithValue("@BTRANSDERS", TextBoxTTOG.Text);
        insertUser2.Parameters.AddWithValue("@YEAR", TextBoxYEAR.Text);
        insertUser2.Parameters.AddWithValue("@DATE", TextBoxDATE.Text);
        try
        {
            insertUser1.ExecuteNonQuery();
            insertUser2.ExecuteNonQuery();
            con.Close();
            Response.Redirect("FinancialProfileFormA.aspx");
        }
        catch (Exception er)
        {
            Response.Write("You Have Successfully Submitted the Information!!!");
        }
        finally
        {

        }
    }
   public class PCPrint : System.Drawing.Printing.PrintDocument
    {
        
    }
   protected void ButtonPrint_Click(object sender, EventArgs e)
   {
       
   }
}