Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
clinton_eg
Yak Posting Veteran
60 Posts |
 Posted - 2010-11-03 : 16:26:10
|
| TeamI 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.ThanksEwan Gilby |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-11-21 : 17:44:48
|
| no you cant.You need a server technology, such as class asp or asp.net and put the logic in the code behind. |
 |
|
|
clinton_eg
Yak Posting Veteran
60 Posts |
Posted - 2010-12-09 : 09:59:57
|
| 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 |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 10:37:59
|
| http://www.vbdotnetheaven.com/UploadFile/dclark/StoredProceduresinVBdotNET04082005072716AM/StoredProceduresinVBdotNET.aspxhttp://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx |
|
|
|
clinton_eg
Yak Posting Veteran
60 Posts |
Posted - 2010-12-10 : 00:13:14
|
| Thanks for your help..Ewan Gilby |
|
|
|
clinton_eg
Yak Posting Veteran
60 Posts |
|
|
|
|
|
run stored procedure from a html button