SqlCommand INSERT INTO query does not execute

Question

Hello guys I have got this code:

SqlCommand scom = new SqlCommand(
                                "INSERT INTO klient(name,surname) 
                                values(@kname,@ksurname)", 
                                conn);

scom.Parameters.AddWithValue("@kname", kname.Text);
scom.Parameters.AddWithValue("@ksurname", ksurname.Text);
conn.Open();
DataTable dt = new DataTable();
SqlDataAdapter SDA = new SqlDataAdapter("SELECT * FROM klient", spojeni);
SDA.Fill(dt);
conn.Close();

It should insert data from textboxes: kname, ksurname, but it closes the form without showing them in MS SQL table klient

You simply haven't executed prikaz

Marc Gravell
– Marc Gravell

2013-07-10 11:08:17 +00:00
Commented Jul 10, 2013 at 11:08 — Marc Gravell
– Marc Gravell, Commented Jul 10, 2013 at 11:08

Steve · Accepted Answer · 2013-07-10 11:07:35Z

6

Missing the ExecuteNonQuery call

SqlCommand prikaz = new SqlCommand("INSERT INTO klient(name,surname) values(@kname,@ksurname)", spojeni);

prikaz.Parameters.AddWithValue("@kname", kname.Text);
prikaz.Parameters.AddWithValue("@ksurname", ksurname.Text);
spojeni.Open();
prikaz.ExecuteNonQuery();
......

A command should be executed to update the database...

answered Jul 10, 2013 at 11:07

Steve

217k22 gold badges242 silver badges296 bronze badges

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

Comments

Darren · Accepted Answer · 2013-07-10 11:08:36Z

3

You haven't executed the command.

prikaz.ExecuteNonQuery();

answered Jul 10, 2013 at 11:08

Darren

71.2k24 gold badges141 silver badges146 bronze badges

Comments

mck · Accepted Answer · 2013-07-10 11:11:43Z

3

The above stated problem is due to the missing executenonquery() statement, add this statement in your code

spojeni.Open();
prikaz.ExecuteNonQuery();

answered Jul 10, 2013 at 11:11

mck

9883 gold badges14 silver badges39 bronze badges

Collectives™ on Stack Overflow

SqlCommand INSERT INTO query does not execute

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related