Data Insertion in data base

Ankit Kumar

11y860.NET

Hey guys,

can any one help me please. i am facing error while inserting data in database using asp .net.

Here is the complete code

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.Data;

public partial class home : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

SqlConnection con = new SqlConnection("");

protected void Button1_Click(object sender, EventArgs e)

{

string connection = "Data Source=127.0.0.1; Initial Catalog=test; Integrated Security=true";

con.ConnectionString=connection;

try

{

con.Open();

SqlCommand cmd = new SqlCommand("insert into studentfeedback values @name, @email, @contact, @company",con);

cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = TextBox1.Text;

if(Convert.ToBoolean(cmd.ExecuteNonQuery()))

{

Response.Write("");

}

catch (Exception exp)

{

Response.Write("");

}

finally

{

con.Close();

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Kumar11y ago
Thanks guys i was facing an issue with connectionstring.
it was a minor mistake(it was intial catalog instead of initial catalog.)
Thanks to all.
Nilesh Jadav11y ago
Might be it because of the connection string : Try like this: in button click :
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");

con.Open();
SqlCommand cmd = new SqlCommand("insert into studentfeedback values @name, @email, @contact, @company",con);
cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = TextBox1.Text;
cmd.Parameters.Add("@email", SqlDbType.NVarChar).Value = TextBox2.Text;
cmd.Parameters.Add("@contact", SqlDbType.NVarChar).Value = TextBox3.Text;
cmd.Parameters.Add("@company", SqlDbType.NVarChar).Value = TextBox4.Text;
if(Convert.ToBoolean(cmd.ExecuteNonQuery()))
{
Response.Write("");
}
}
catch (Exception exp)
{
Response.Write("");
}
finally
{
con.Close();
}
}
}

Hope that helps! Otherwise please share the full error.
Ankit Kumar11y ago
I am facing exceptions regarding connection to sql server.
Mukesh Kumar11y ago
Hi,

Your code looks good to me. can you share what type of error are you getting.?

thanks
Nilesh Jadav11y ago
Try this:

command.Parameters.Add("@ID", SqlDbType.Int)
command.Parameters("@ID").Value = customerID

OR

command.Parameters.AddWithValue("@id", id)