Values not goin to Database

Question

2.33/5 (4 votes)

See more:

C#

protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=HP-PC\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("sp_userinformation", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Name", Name);
        cmd.Parameters.AddWithValue("@Emailid", Emailid);
        cmd.Parameters.AddWithValue("@Phoneno", Phoneno);
        cmd.Parameters.AddWithValue("@Address", Address);
        cmd.Parameters.AddWithValue("@Pincode", Pincode);
        cmd.Parameters.AddWithValue("@Heard", Heard);
        cmd.Parameters.AddWithValue("@Enquiryabout", EnquiryAbout);
        cmd.Parameters.AddWithValue("@Message", Message);
        cmd.ExecuteNonQuery();
        con.Close();
    }
}

i had written this code for registration page...but values are not getting to database...
my database name is: Enquiry
table: EnquiryTable

please help me out...
i m a beginer and want guidance.

Posted 27-Feb-14 0:44am

manishmns12

Updated 27-Feb-14 0:53am

Snehasish_Nandy

v2

Add a Solution

Comments

Animesh Datta 27-Feb-14 6:52am

provide your store procedure definition .

[no name] 27-Feb-14 6:54am

Share "sp_userinformation"

V5709 27-Feb-14 7:01am

Is there any error which you are getting? If possible post your stored procedure also.

Ramug10 27-Feb-14 7:02am

Show your SP script

manishmns12 27-Feb-14 7:21am

where i will get my stored procedure???

i just copied a code over internet..
i dnt know what to write instead of "sp_userinformation"

manishmns12 27-Feb-14 7:26am

instead i have tried thisone by my one...
but the data is not going to the database..

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Collections;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class Enquiry : System.Web.UI.Page
{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
{
con.Open();

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("insert into EnqTable values('" + txtName.Text + "','" + txtEmailid.Text + "','" + txtPhoneno.Text + "','" + txtAddress.Text + "','" + txtPincode.Text + "','" + txtHeardfrom.Text + "','" + txtEnquiryabout.Text + "','" + txtMessage.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();
Label1.Visible = true;
Label1.Text = "your data has been stored, we will be back shortly";
txtName.Text = " ";
txtEmailid.Text = " ";
txtPhoneno.Text = " ";
txtAddress.Text = " ";
txtPincode.Text = " ";
txtHeardfrom.Text = " ";
txtEnquiryabout.Text = " ";
txtMessage.Text = " ";

}
}

amjnj 27-Feb-14 10:00am

In your original post you said your table was named 'EnquiryTable' however in the code above it seems you are inserting into 'EnqTable'.

Also, it might be beneficial to wrap your connection into a using statement to properly dispose of the connection.

Edit: Check out this link for an example that uses a using statement and SqlParameter(s) - it uses a select statement, but the general idea is the same.
http://msdn.microsoft.com/en-us/library/dw70f090(v=vs.110).aspx

manishmns12 27-Feb-14 13:33pm

ya sir..please can u gv me some code which might work..
as i m creating an enquiry form and want to link values to data base...
Data base is SQl which is integrtd in Visual studio..
Database name: Enq
Table: Enqtable
these are final names...cn u plz help me out.......

2 solutions

Solution 1

Please add a try catch block like below

C#

protected void Button1_Click(object sender, EventArgs e)
    {
      try
       {
        SqlConnection con = new SqlConnection(@"Data Source=HP-PC\SQLEXPRESS;Initial                            Catalog=Enquiry;Integrated Security=True");
        con.Open();
        SqlCommand cmd = new SqlCommand("sp_userinformation", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Name", Name);
        cmd.Parameters.AddWithValue("@Emailid", Emailid);
        cmd.Parameters.AddWithValue("@Phoneno", Phoneno);
        cmd.Parameters.AddWithValue("@Address", Address);
        cmd.Parameters.AddWithValue("@Pincode", Pincode);
        cmd.Parameters.AddWithValue("@Heard", Heard);
        cmd.Parameters.AddWithValue("@Enquiryabout", EnquiryAbout);
        cmd.Parameters.AddWithValue("@Message", Message);
        cmd.ExecuteNonQuery();
        con.Close();
        }
catch(exception ex)
     {

     }

    }

then run this program in debug mode then you will get exact error message that will help you to solve this issue by yourself.

Posted 27-Feb-14 5:18am

Teddy Kurian

Comments

manishmns12 27-Feb-14 13:35pm

sir cn u please explain me about sp_userinformation
what is this about..
i copied it over internet..so plz help me out

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

V5709 · Accepted Answer · 2014-02-27T18:28:00

Solution 3

I think you are getting confused with stored procedure. Replace stored procedure parameters with simple query.

C#

protected void Button1_Click(object sender, EventArgs e)
    {
      try
       {
        SqlConnection con = new SqlConnection(@"Data Source=HP-PC\SQLEXPRESS;Initial                                                                    Catalog=Enquiry;Integrated Security=True");
        con.Open();
        
        string query="insert into EnquiryTable values('" + txtName.Text + "','" +             txtEmailid.Text + "','" + txtPhoneno.Text + "','" + txtAddress.Text + "','" + txtPincode.Text + "','" + txtHeardfrom.Text + "','" + txtEnquiryabout.Text + "','" + txtMessage.Text + "')"; 
      
        SqlCommand cmd = new SqlCommand(queryString, con);
        cmd.CommandType = CommandType.Text;
        cmd.ExecuteNonQuery();
        con.Close();
        }
catch(exception ex)
     {
 
     }
 
    }

Fore more information refer this link

** To Get clear idea about STORED PROCEDURES check this link

Refer this link
for Using stored procedures with ado.net.

Posted 27-Feb-14 18:28pm

V5709

Updated 27-Feb-14 18:31pm

v2

Comments

manishmns12 28-Feb-14 0:49am

sir i had tried this...but getting a error....
please look at this

the projet is runnning but aftr giving the values to textnboxes the error is coming.., means run time error is
error message is:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '@Name'. Incorrect syntax near the keyword 'where'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 36 ClientConnectionId:994391c8-ae81-46d7-ad86-1c7aa68a74ceThanks for Enquiring. We will be available shortly

and sir the code is:

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable where (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue(" @Name", txtName.Text);
com.Parameters.AddWithValue(" @EmailId", txtEmailid.Text);
com.Parameters.AddWithValue(" @Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue(" @Address", txtAddress.Text);
com.Parameters.AddWithValue(" @Pincode", txtPincode.Text);
com.Parameters.AddWithValue(" @Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue(" @ENquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue(" @Message", txtMessage.Text);

com.ExecuteNonQuery();
Response.Write("Thank You for Submitting your query");
Response.Redirect("Home.aspx");

con.Close();
Label.Visible = true;
Label.Text = "Thanks forEnquiring";
}

catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Response.Write("Thanks for Enquiring. We will be available shortly");

}

V5709 28-Feb-14 0:55am

My friend, check your query first. Replace your sql query by fallowing.

string insertQuery = "insert into EnquiryTable (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";

Please mark it as answer if worked for you. :)

manishmns12 28-Feb-14 1:03am

sorry sir but after submitting the values...error is still somin and is as:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '@Name'. Must declare the scalar variable "@Name". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 36 ClientConnectionId:ea9b27e2-1948-49c5-be6d-7cddd8c54571Thanks for Enquiring. We will be available shortly

manishmns12 28-Feb-14 1:03am

i tried this sir:

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue(" @Name", txtName.Text);
com.Parameters.AddWithValue(" @EmailId", txtEmailid.Text);
com.Parameters.AddWithValue(" @Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue(" @Address", txtAddress.Text);
com.Parameters.AddWithValue(" @Pincode", txtPincode.Text);
com.Parameters.AddWithValue(" @Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue(" @ENquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue(" @Message", txtMessage.Text);

com.ExecuteNonQuery();
Response.Write("Thank You for Submitting your query");
Response.Redirect("Home.aspx");

con.Close();
Label.Visible = true;
Label.Text = "Thanks forEnquiring";
}

catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Response.Write("Thanks for Enquiring. We will be available shortly");

}
}

V5709 28-Feb-14 1:09am

replace some code lines by fallowing..

com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@EmailId", txtEmailid.Text);
com.Parameters.AddWithValue("@Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue("@Address", txtAddress.Text);
com.Parameters.AddWithValue("@Pincode", txtPincode.Text);
com.Parameters.AddWithValue("@Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue("@ENquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue("@Message", txtMessage.Text);

Dont left space between " & '@'

V5709 28-Feb-14 1:16am

i worked mark it as answer.

manishmns12 28-Feb-14 1:21am

thanks thanks thanks alot.........
very veru very thanks sir...
sir cn i get ur email id so tht if in future required i can ask u....

V5709 28-Feb-14 1:28am

you can posting on this site is more than enough. :)You will get your required solution from here. Then also if you want to contact just add an comment under my posted answer with your question title..

manishmns12 28-Feb-14 1:50am

sorry sir but a error is occuring again aftr submitting the values....
please help me out sir:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 37 ClientConnectionId:0365041a-ad7e-404d-82db-63aae52e4e83Thanks for Enquiring. We will be available shortly

manishmns12 28-Feb-14 2:05am

please sir look for my prblm...i really need ur help..plz reply about my error as i hd mentioned earliar:

manishmns12 28-Feb-14 1:30am

sir once it ran..and then after its showing this error...
i had checkd the Heardfrom, its same everywhere in aspx page, .cs page n db too...
so where the error is coming from

A field or property with the name 'Heard' was not found on the selected data source.

manishmns12 28-Feb-14 1:33am

sorry but again a error sir...

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 37 ClientConnectionId:0365041a-ad7e-404d-82db-63aae52e4e83Thanks for Enquiring. We will be available shortly

V5709 28-Feb-14 2:22am

Check the lengths/size of parameter you are passing with the respective column size in database. I think you trying to save bigger size values in columns having compairatively less size.

manishmns12 28-Feb-14 2:18am

please sir help me out....
i m eagerly waiting for ur reply sir V5709

manishmns12 28-Feb-14 2:19am

plz V5709 sir....please help me out...
i m eagerly waiting for ur reply

V5709 28-Feb-14 2:26am

Check the lengths/size of parameter you are passing with the respective column size in database. I think you trying to save bigger size values in columns having compairatively less size.

manishmns12 28-Feb-14 2:40am

thank you sir...that was as i was entering a bigger size th mentioned...
but sir aftr submitting as the error comes .....how cn i referesh the page the error message should get removed...
and if error is coming it should show that phone no. size lenght increased ..not this bulk error...as users cnt understnd that error..
so user friendly error message shold come...
ho to do this sir....

V5709 28-Feb-14 2:44am

put an label field in form.. Use try catch block in code.If error comes ,control will go to catch block. Here add appropriate error message as text to label field

manishmns12 28-Feb-14 2:55am

sir for d last time please cn u explain by code that where to add the try catch ....
please..
i just want to not show that ugly error...just show any user friendly error message...
please help me out..
my entire code is as follows..:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Data.Common;

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

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@EmailId", txtEmailid.Text);
com.Parameters.AddWithValue("@Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue("@Address", txtAddress.Text);
com.Parameters.AddWithValue("@Pincode", txtPincode.Text);
com.Parameters.AddWithValue("@Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue("@Enquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue("@Message", txtMessage.Text);

com.ExecuteNonQuery();

con.Close();

}

catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Response.Write("Thanks for Enquiring. We will be available shortly");

}
}

V5709 28-Feb-14 3:37am

Check this one..

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@EmailId", txtEmailid.Text);
com.Parameters.AddWithValue("@Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue("@Address", txtAddress.Text);
com.Parameters.AddWithValue("@Pincode", txtPincode.Text);
com.Parameters.AddWithValue("@Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue("@Enquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue("@Message", txtMessage.Text);

com.ExecuteNonQuery();

con.Close();

}

catch (Exception ex)
{
lblMesage.Text="Error Occured! Try Again" + ex.ToString();
}

}

Add lblMesage as label control in your design page