HI,:)

My Stored procedure inserts (OR DO NOT) user data to the database based on some conditions.

How can I inform VB.NET code of the "stored procedure's execution results" to inform the web form (I mean user)?

The Data inserted OR not inserted, this is the problem, says the code :D(asks user I mean). I tried ExecuteNonQuery, but it couldn't do that.

THANKS

Create a command object
Make it stored procedure
Set the name of the procedure
Create a parameter for each parameter of the stored procedure. Give these parameters a name for ease of access later.
Add the parameter from above. Repeat for each param.
.Execute the command
All IN/OUT or OUT parameters will now hold the value they were set to within the stored procedure.

You also can convert your procedure to a function, and return a code you devise as an indicator of what happened during execution.

You can raise an error within your procedure with text explaining what happened. When the error gets raised, read the results and ignore these raised errors that are actually intended as communication.