CODEWITHSUNDEEP
c#sql.netsql-serverinsert
Marek
Marek

Reputation: 3575

SqlCommand INSERT INTO query does not execute

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

Upvotes: 0

Views: 21144

Answers (3)

mck
mck

Reputation: 988

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

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

Upvotes: 3

Darren
Darren

Reputation: 70786

You haven't executed the command. 

prikaz.ExecuteNonQuery();

Upvotes: 3

Steve
Steve

Reputation: 216353

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

Upvotes: 6

Related Questions