SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Other Development Tools
 run stored procedure from a html button
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

clinton_eg
Yak Posting Veteran

India
60 Posts

Posted - 11/03/2010 :  16:26:10  Show Profile  Reply with Quote
Team

I am using SQL 2005, i have created a stored procedure (Lets name it as sp_updateTab) which will update a particula table based on data from another.

i know how to execute the SP using SQL Query, however im curious to know how to execute an SQL Stored Procedure by the click of a HTML button.

Please could anyone help me with this query.
Thanks

Ewan Gilby

Edited by - clinton_eg on 11/03/2010 16:37:11

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 11/21/2010 :  17:44:48  Show Profile  Reply with Quote
no you cant.

You need a server technology, such as class asp or asp.net and put the logic in the code behind.
Go to Top of Page

clinton_eg
Yak Posting Veteran

India
60 Posts

Posted - 12/09/2010 :  09:59:57  Show Profile  Reply with Quote
Thanks for your reply,
I have MS visual studio installed on my system which helps me in creating .aspx pages.
im fairly new to this.
Do you have any articles that i could refer to on what code i could use to get this done?

Ewan Gilby

Edited by - clinton_eg on 12/09/2010 10:00:34
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 12/09/2010 :  10:37:59  Show Profile  Visit russell's Homepage  Reply with Quote
http://www.vbdotnetheaven.com/UploadFile/dclark/StoredProceduresinVBdotNET04082005072716AM/StoredProceduresinVBdotNET.aspx

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx
Go to Top of Page

clinton_eg
Yak Posting Veteran

India
60 Posts

Posted - 12/10/2010 :  00:13:14  Show Profile  Reply with Quote
Thanks for your help..

Ewan Gilby
Go to Top of Page

clinton_eg
Yak Posting Veteran

India
60 Posts

Posted - 02/23/2011 :  06:24:30  Show Profile  Reply with Quote
I would also suggest having a look at this KB atricle from Microsoft.
http://support.microsoft.com/kb/306574

Ewan Gilby
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000