Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 3rd, 2007, 06:30 AM
Registered User
 
Join Date: Aug 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQLExpress: 1.about "Execute sql button" 2.about

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

 
Old September 3rd, 2007, 07:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Resolved! - code behind button won't execute dartcoach Access VBA 1 February 4th, 2008 06:17 PM
enter key should execute button click event MunishBhatia ASP.NET 2.0 Professional 6 November 25th, 2007 10:59 PM
Server Button Control event execute twice bluebeta ASP.NET 2.0 Basics 2 May 19th, 2006 03:25 PM
execute sql fishypew SQL Server 2000 4 May 18th, 2005 09:00 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.