SQLExpress: 1.about "Execute sql button" 2.about

garaxan · September 3rd, 2007, 06:30 AM

HI,

I can NOT see table records (inserted trough my web form _in Internet Explorer) until pressing "Execute sql button" (it has a red exclamation mark on it _in Visual Web Developer).

1. What SQL code can I add to my stored procedure to work like "Pressing Execute sql button"? After deploying the web form I'm not there to press the button

, so I'm concerned about users data.

---------------------------------------------------------------------

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

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

gbianchi · September 3rd, 2007, 07:26 AM

hi there..

1. there is no problem with the data.. you have to execute the query to see the results because the data explorer will not refresh by itself, even if the data has changed, so there is no problem with that..

2.If you SP sometimes not insert the data, you should better check for that conditions before running the SP and avoid them, if you are doing validations on the SP (and that what you refers by conditions), you better validate the data before. If you however want to do it within the SP, a executenonquery will return the number of affected rows, if that is 0 then you didn't do anything...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========