Inserting data into local database using parameters

Question

Hi all I have been stuck at this for two days. I am using Visual Studio 2013 and made a windows form project. Then using the following code I am trying to insert values but the "show Table data" option produces a table with null values. What have I done wrong?

        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.
 ConnectionStrings["WindowsFormsApplicationtodatabase.Properties.Settings.DatabasewebConnectionString"].ConnectionString);

        conn.Open();

        using (conn)
        {
            SqlCommand cmd = new SqlCommand("INSERT INTO webtable (Id, url_name) VALUES (@id, @url)");
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;
            cmd.Parameters.AddWithValue("@url", "nagia");
            cmd.Parameters.AddWithValue("@id", "9");

            cmd.ExecuteNonQuery();
        }

webtable has two columns Id and url_name both of type varchar....and I also remember to refresh every time — aneena
– aneena, Commented Apr 10, 2015 at 6:31

Pradnya Bolli · Accepted Answer · 2015-04-10 06:38:28Z

1

You can try this

 conn.Open();

 string strQuery = "INSERT INTO webtable (Id, url_name) VALUES (@id, @url)";
 SqlCommand cmd = new SqlCommand(strQuery, conn);
 cmd.Parameters.AddWithValue("@url", "nagia");
 cmd.Parameters.AddWithValue("@id", "9");
 cmd.Connection = conn;
 cmd.ExecuteNonQuery();
 conn.Close();

edited Apr 10, 2015 at 6:38

answered Apr 10, 2015 at 6:30

Pradnya Bolli

1,9391 gold badge20 silver badges37 bronze badges

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

8 Comments

aneena Over a year ago

copy pasted this one...still no data appears in table

Pradnya Bolli Over a year ago

just change con to conn in sqlcommand line..its work fine for me.

aneena Over a year ago

I did change that...why isnt it working for me. while adding the database in the windows form project I added the "service based database" ...well i hope that isnt causing trouble?

aneena Over a year ago

I know my connection is fine because when I added some data manually (clicking on the table gave the option) and ran the select query in my c# file ...it worked fine...but data isnt getting inserted through my code...why?

Pradnya Bolli Over a year ago

Its gives any error while inserting data into database?

|

Community · Accepted Answer · 2017-05-23 12:01:35Z

0

Try to Assign Data Types for the Parameters.

Refer this,

[SqlCommand Parameters Add vs. AddWithValue

edited May 23, 2017 at 12:01

CommunityBot

11 silver badge

answered Apr 10, 2015 at 6:29

Sarathi Jayapal

3002 silver badges16 bronze badges

4 Comments

Sarathi Jayapal Over a year ago

did you encounter any error while inserting. post the error if you get anything

aneena Over a year ago

When I run both insert and select in the same run like this string strQuery = "INSERT INTO webtable (Id, url_name) VALUES (@id, @url)"; SqlCommand cmd = new SqlCommand(strQuery, conn); cmd.Parameters.AddWithValue("@url", "nagia"); cmd.Parameters.AddWithValue("@id", "9"); cmd.Connection = conn; cmd.ExecuteNonQuery(); String qry = " select * from dbo.webtable"; SqlDataAdapter da = new SqlDataAdapter(qry, conn); DataSet ds = new DataSet(); da.Fill(ds);

aneena Over a year ago

It displays the inserted data here in the select but not in the table and if I run just the select again...nothing there

Sarathi Jayapal Over a year ago

Try Using Transaction to Commit your Data SqlTransaction transaction = null; transaction = con.BeginTransaction(); cmd.Transaction = transaction; //execute your query transaction.Commit();

Kevin Andrid · Accepted Answer · 2015-04-10 07:03:49Z

0

You can try this code..

using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["WindowsFormsApplicationtodatabase.Properties.Settings.DatabasewebConnectionString"].ConnectionString));
{

SqlCommand cmd = new SqlCommand("INSERT INTO webtable (Id, url_name) VALUES (@id, @url)",conn);

cmd.Parameters.AddWithValue("@url", "nagia");
cmd.Parameters.AddWithValue("@id", "9");
cmd.Connection = conn;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

}

edited Apr 10, 2015 at 7:03

answered Apr 10, 2015 at 6:42

Kevin Andrid

1,9811 gold badge16 silver badges28 bronze badges

1 Comment

Kevin Andrid Over a year ago

sorry, its conn.Open(); and conn.Close(); I have edited the code try it.

Collectives™ on Stack Overflow

Inserting data into local database using parameters

3 Answers 3

8 Comments

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related