data won't insert in database via asp.net

Question

Im trying to insert some text that a Label has, and it wont insert it for some reason.

this is my code :

cmd = new SqlCommand(sqlquery1, conn);
cmd.Parameters.AddWithValue("Status", UserNameOrGuest.Text);
ErrorLabel.Text = "Movie rental succeeded!";

the sqlquery is : string sqlquery1 = "INSERT INTO Movies (Status) VALUES (@Status)";

Thanks for the help

how do you create and open the connection? when do you call cmd.ExecuteNonQuery ?? can you show more code in your question? — Davide Piras
– Davide Piras, Commented Dec 20, 2011 at 13:27
So where is the cmd.ExceuteNonQuery? What exception do you get? — Tim Schmelter
– Tim Schmelter, Commented Dec 20, 2011 at 13:27

Niranjan Singh · Accepted Answer · 2011-12-20 13:34:19Z

2

You created the SqlCommand object but you are not executing the command to perform insert operation. use cmd.ExecuteNonQuery() to execute the command.

cmd = new SqlCommand(sqlquery1, conn); 
cmd.Parameters.AddWithValue("Status", UserNameOrGuest.Text); 
cmd.ExecuteNonQuery();
ErrorLabel.Text = "Movie rental succeeded!";

Check example here : SqlCommand.ExecuteNonQuery Method and SqlCommand.ExecuteScalar Method

create a SqlCommand and then executes it using ExecuteNonQuery/ExecuteScaler.

edited Dec 20, 2011 at 13:34

answered Dec 20, 2011 at 13:28

Niranjan Singh

18.3k2 gold badges45 silver badges76 bronze badges

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

Comments

Morten Anderson · Accepted Answer · 2011-12-20 13:27:11Z

2

Is this your entire code? you seem to miss a call which executes the query?

cmd.ExecuteNonQuery();

answered Dec 20, 2011 at 13:27

Morten Anderson

2,29115 silver badges20 bronze badges

Comments

DonCallisto · Accepted Answer · 2011-12-20 13:28:46Z

2

You forgot a statment?

cmd.ExecuteNonQuery();

answered Dec 20, 2011 at 13:28

DonCallisto

30k9 gold badges74 silver badges104 bronze badges

Collectives™ on Stack Overflow

data won't insert in database via asp.net

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related