Solved

INSERT Data into SQL C#/.NET

Posted on 2010-09-23
2
441 Views
Last Modified: 2013-11-26
Unable to update a SQL table with form data....here is what i got. Thought maybe another set of eyes would help me out here.

Thanks!
protected void SubmitButton_Click(object sender, EventArgs e)
    {
        SqlConnection conn;
        SqlCommand comm;

        
        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

        conn = new SqlConnection(connectionString);
        comm = new SqlCommand(
            "INSERT INTO contactForm(mailID,firstName,lastName,company,title,email,inquiry,interests,dateCreated) VALUES (@mailID,@firstName,@lastName,@company,@title,@email,@inquiry,@interests,@dateCreated)", conn);

        comm.Parameters.Add("mailID", SqlDbType.Int);
        comm.Parameters["mailID"].Value = hiddenID.Text;

        comm.Parameters.Add("@firstName", System.Data.SqlDbType.VarChar, 50);
        comm.Parameters["@firstName"].Value = txtFirstName.Text;

        comm.Parameters.Add("@lastName", System.Data.SqlDbType.VarChar, 50);
        comm.Parameters["@lastName"].Value = txtLastName.Text;

        comm.Parameters.Add("@company", System.Data.SqlDbType.VarChar, 50);
        comm.Parameters["@company"].Value = txtCompanyName.Text;

        comm.Parameters.Add("@title", System.Data.SqlDbType.VarChar, 50);
        comm.Parameters["@title"].Value = txtTitle.Text;

        comm.Parameters.Add("@email", System.Data.SqlDbType.VarChar, 70);
        comm.Parameters["@email"].Value = txtEmail.Text;   

        comm.Parameters.Add("@inquiry", System.Data.SqlDbType.VarChar, 70);
        comm.Parameters["@inquiry"].Value = txtInquiry.Text; 

        comm.Parameters.Add("@interests", System.Data.SqlDbType.VarChar, 200);
        comm.Parameters["@interests"].Value = txtInterests.Text;

        comm.Parameters.Add("@dateCreated", System.Data.SqlDbType.DateTime);
        comm.Parameters["@dateCreated"].Value = txtHiddenDate.Text; 

        try

        {
            conn.Open();
            comm.ExecuteNonQuery();
           
           
        }
        catch
        {
            this.MessageLabel.Text = "There was an error updating the selected page content!<br />";
            
        }
        finally
        {
            conn.Close();
        }
        
        
    }

Open in new window

0
Comment
Question by:Shaggy1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 41

Accepted Solution

by:
guru_sami earned 125 total points
ID: 33749073
1: looks you need @maildId here:
comm.Parameters.Add("mailID", SqlDbType.Int);
comm.Parameters["mailID"].Value = hiddenID.Text;

2nd change your catch block to catch real exception like:

catch(Exception ex)
        {
            this.MessageLabel.Text = "There was an error updating the selected page content!<br />" + ex.Message;
           
        }



0
 

Author Closing Comment

by:Shaggy1
ID: 33749208
Thanks Sami,

Can't believe I missed the @ for mailID..thanks for pointing that out.

Also, adding the real exception enabled me to find the problem..

the parameter for @mailID is a Primary Key which is incremental
and @dateCreated is auto populated with the getnow() value.

I removed those, and success!

Thanks for that extra set of eyes..!!
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question