I am using VS 2010 with C#. I have six textboxes on the form. I also have jQuery to mask the textboxes when the user enters their data. What I am trying to do is to get the value of the data from the textrboxes to my SQL database. When the user enters the data into the textbox the numbers are masked by using the jQuery plugin. Then the user hits tab or clicks to the next textbox. The masked value in textbox1 is unmasked and shown in textbox1a. I am trying to insert the value in textbox1a to the database but with no luck. Can someone please help me and tell me what I am doing wring?
<script src="Jquery Scripts/jquery-1.8.3.min.js" type="text/javascript"></script>
<script src="Jquery Scripts/jquery.maskedinput.js" type="text/javascript"></script>
<script type='text/javascript'>
$(document).ready(function () {
$.mask.definitions['~'] = "[+-]";
$("#TextBoxMaskTNUGSC").mask('999,999,999,999');
$("#TextBoxMaskTNUGSCD").mask('999,999,999,999');
$("#TextBoxMaskTTOUG").mask('999,999,999,999');
$("#TextBoxMaskTNGSC").mask('999,999,999,999');
$("#TextBoxMaskTNGSCD").mask('999,999,999,999');
$("#TextBoxMaskTTOG").mask('999,999,999,999');
$("#TextBoxMaskTNUGSC").blur(function () {
$("#TextBoxTNUGSC").val(" " + $(this).mask());
$("#TextBoxMaskTNUGSCD").blur(function () {
$("#TextBoxTNUGSCD").html(" " + $(this).mask());
$("#TextBoxMaskTTOUG").blur(function () {
$("#TextBoxTTOUG").val(" " + $(this).mask());
$("#TextBoxMaskTNGSC").blur(function () {
$("#TextBoxTNGSC").val(" " + $(this).mask());
$("#TextBoxMaskTNGSCD").blur(function () {
$("#TextBoxTNGSCD").val(" " + $(this).mask());
$("#TextBoxMaskTTOG").blur(function () {
$("#TextBoxTTOG").val(" " + $(this).mask());
}).dblclick(function () {
$(this).unmask();
});
});
});
});
});
});
});
Here is my C# code to insert it into the database:
protected void Submit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HotConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("Insert into Table1 (INST12_ID, UNITID, ASTUDENTS, ACOMPLETED, ATRANSFERS, BSTUDENTS, BCOMPLETED, BTRANSFERS, YEAR, DATE) values (@INST_ID, @UNITID, @ASTUDENTS, @ACOMPLETED, @ATRANSFERS, @BSTUDENTS, @BCOMPLETED, @BTRANSFERS, @YEAR, @DATE); Insert into Table1a (INST12_ID, UNITID, ASTUDENTS, ACOMPLETED, ATRANSFERS, BSTUDENTS, BCOMPLETED, BTRANSFERS, YEAR, DATE) values (@INST_ID, @UNITID, @ASTUDENTS, @ACOMPLETED, @ATRANSFERS, @BSTUDENTS, @BCOMPLETED, @BTRANSFERS, @YEAR, @DATE);", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ASTUDENTS", TextBoxTNUGSC.Text);
cmd.Parameters.AddWithValue("@ACOMPLETED", TextBoxTNUGSCD.Text);
cmd.Parameters.AddWithValue("@ATRANSFERS", TextBoxTTOUG.Text);
cmd.Parameters.AddWithValue("@BSTUDENTS", TextBoxTNGSC.Text);
cmd.Parameters.AddWithValue("@BCOMPLETED", TextBoxTNGSCD.Text);
cmd.Parameters.AddWithValue("@BTRANSFERS", TextBoxTTOG.Text);
cmd.Parameters.AddWithValue("@YEAR", lblYear1.Text);
cmd.Parameters.AddWithValue("@DATE", TextBoxDATE.Text);
cmd.Parameters.AddWithValue("@UNITID", TextBoxUNITID.Text);
cmd.Parameters.AddWithValue("@INST_ID", TextBoxINST_ID.Text);
cmd.ExecuteNonQuery();
con.Close();
}