« Previous Next »

• 11-06-2009, 10:22 AM

  davidiusk Joined on 06-09-2008, 4:40 AM Posts 8	running SQL code from form or page Reply Contact I’d like to setup a simple page to run database scripts on internal web servers. Ideally there’d be a box to paste the sql into or a browse button to find a *.sql file. It would be great if it would work for SLQ Server and Oracle. Any suggestions on simple code samples or web based applications to do this?

• 11-06-2009, 10:30 AM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,238	Re: running SQL code from form or page Reply Contact Simple enough. What coding platform do you have experience with? Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/

• 11-06-2009, 10:38 AM

  In reply to

  davidiusk Joined on 06-09-2008, 4:40 AM Posts 8	Re: running SQL code from form or page Reply Contact T-SQL and PL-SQL with some .NET and VB7   Thanks

• 11-06-2009, 1:05 PM

  In reply to

  tomkmvp Joined on 03-20-2003, 10:27 AM Central NJ Posts 6,238

  Re: running SQL code from form or page Reply Contact The best place for your question then is at http://forums.asp.net/. The short answer though is to create a form with a textbox and a button, create a click event handler for the button and use the textbox.text as your queryString parameter.  Use this sample code as the code within the click handler (instead of CreateCommand). http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx Tom Kaminski IIS MVP http://mvp.support.microsoft.com/ http://blogs.iis.net/tomkmvp/ http://www.linkedin.com/pub/8/690/408 http://www.bluesrepublic.org/