Inserting data to SQL Server database in asp.net c#

Question

I am inserting data into database using the following code. Neither it gives error nor it adds data to database. Am i missing anything in it?

The columns are univ_regno and email have datatype nvarchar(50) respectively

protected void btnSubmit_Click(object sender, EventArgs e)
{
    if (chkaccept.Checked)
    {
        try
        {
            con = new SqlConnection(ConfigurationManager.ConnectionStrings["SQL Connection String"].ConnectionString);
            con.Open();
            com = new SqlCommand("INSERT INTO stdtable ([univ_regno],[email]) values(@univ_regno,@email)", con);

            com.Parameters.Add("@univ_regno", txtuniv.Text);
            com.Parameters.Add("@email", txtemail.Text);

            com.ExecuteNonQuery();
            con.Close();

            /*show javascript message */
            Type cstype = this.GetType();
            ClientScriptManager cs = Page.ClientScript;
            String cstext = "alert('Record Added Successfully');";
            cs.RegisterStartupScript(cstype, "PopupScript", cstext, true);
        }
        catch (System.Exception err)
        {
           Type cstype = this.GetType();
           ClientScriptManager cs = Page.ClientScript;
           String cstext = "alert('"+  err.Message.ToString() +" ');";
           cs.RegisterStartupScript(cstype, "PopupScript", cstext, true);
        }
   }
   else
   {
       Type cstype = this.GetType();
       ClientScriptManager cs = Page.ClientScript;
       String cstext = "alert('Not checked ');";
       cs.RegisterStartupScript(cstype, "PopupScript", cstext, true);
   }
}

This shouldn't effect your specific problem, but you aren't closing your connections correctly. — Joel Coehoorn
– Joel Coehoorn, Commented Oct 22, 2012 at 17:48
My guess is that there is an error in your javascript reporting. Set a break point in the catch to see what is actually happening with the sql call... — aserwin
– aserwin, Commented Oct 22, 2012 at 17:50
The connection must always be closed in a finally block, or you can end up creating a denial of service situation on your database. — Joel Coehoorn
– Joel Coehoorn, Commented Oct 22, 2012 at 17:51

Community · Accepted Answer · 2017-05-23 10:34:54Z

1

enter image description here com.Parameters.Add("@univ_regno", txtuniv.Text);

does this add the value to the parameter? it calls the Parameters.Add(string name, SqlDbType type) overload

refer this link:

Difference between Parameters.Add and Parameters.AddWithValue

Try adding parameters as

cmd.Parameters.Add("@univ_regno", SqlDbType.VarChar).Value = txtuniv.Text;

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Oct 22, 2012 at 17:57

Karthik

2,3996 gold badges35 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

عثمان غني Over a year ago

can u tell me that is there compulsary to declare scalar variable in sequence?

عثمان غني Over a year ago

as i m adding data to univ_regno and email and adding parameters seqeuntially. can i email first and then univ_regno?

Karthik Over a year ago

i think that wont be a problem.did you try changing the way you add parameters?use a break point and debug it line by line it may help

عثمان غني Over a year ago

let us continue this discussion in chat

Collectives™ on Stack Overflow

Inserting data to SQL Server database in asp.net c#

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related