How to test whether the sql command executed or not ?

Question

0.00/5 (No votes)

See more:

Hi,
I have used the following code:-

string sql = "insert into reg_table(name, gender, phone, country) values('" + name + "', '" + gender + "', " + phone + ", '" + country + "')";

            SqlCommand MyCmd = new SqlCommand(sql, conn);

Now, i want to test if the data is inserted in the database or not. If the data is inserted then it will show me a messagebox and say "data inserted" or "not inserted"...??
can anybody help?

Thanks and Regards
Akiii

Posted 22-Mar-11 1:39am

Akiii123

Add a Solution

2 solutions

Solution 3

To add to Sandeep's good answer, wrap the operation into try..catch block. In case of syntax errors, trigger raised errors etc you will have an exception at client side and obviously then no row is inserted...

Posted 22-Mar-11 2:58am

Wendelius

Comments

Akiii123 22-Mar-11 9:50am

@mika wendelius...
how will i wrap the code and raise trigger.....?
can u give me an example please...?

Akiii

Wendelius 22-Mar-11 10:01am

What I meant is that a trigger defined on the table can cause an exception by calling RAISERROR. When the error is raised, you will receive an exception at the client side which you should handle properly (much like if the statement has syntax errors).

Akiii123 22-Mar-11 23:44pm

i shd wrap that in try-catch block then....?
can you give me some good links where i can study stored procedures and triggers....i really want to learn in detail....
thanks for ur answer...
much appreciated..

Akiii

Wendelius 23-Mar-11 13:57pm

You could start from here: http://msdn.microsoft.com/en-us/library/ms189626.aspx

Akiii123 24-Mar-11 0:00am

thanks for the link...

Akiii

Wendelius 24-Mar-11 1:47am

You're welcome

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-03-22T01:47:00

Solution 2

Well, use ExecuteNonQuery to execute your command.
As, ExecuteNonQuery: For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

Details here: SqlCommand.ExecuteNonQuery Method[^]

Thus, if one row of data would be inserted it would return 1 and then based on this value show the message as per your need.

Posted 22-Mar-11 1:47am

Sandeep Mewara

Comments

Ankit Rajput 22-Mar-11 7:54am

It's a good idea to check the return value if a function returns something. It will increase the performance as well in your case.

Akiii123 22-Mar-11 8:29am

yes with ExecuteNonQuery its working fine.....
thank you very much for the prompt reply....

Thanks and Regards
Akiii

Sandeep Mewara 22-Mar-11 8:34am

Good to know.

:thumbsup:

Akiii123 22-Mar-11 9:51am

@ankit.....
thanks for the answer....
if the function returns void then?

Akiii

Wendelius 22-Mar-11 9:09am

Good answer, 5 :)

Sandeep Mewara 22-Mar-11 11:14am

Some platinum downvoted - atleast give a reason! :)

Akiii123 22-Mar-11 23:43pm

yes give a reason for the vote down....

Akiii