Calling a Stored Procedure in an ASP Page

[praveensharmans]

Hi,

I have created a Stored Procedure Sp_test for Triggering the Mails.

Can anybody tell me how to Call it inside the function cmdSubmit_onclick()

which is a part of the ASP Script so that I can execute the same.

Any help will be really appreciated.


Thanks & Regards,
Praveen

[jhardman]

Praveen,

Everything in ASP scripts are executed before the page is sent to the browser. After the browser displays the page and the user begins interacting with it, no more asp procedures can work. The best way to handle this is that on the resulting page where the user visits after clicking the cmdSubmit button the stored procedure is called as the script is executing. I hope this makes sense.

Jared

[ilearneditonline]

If this is classic ASP, then the solution Jared recommended would be the easiest to implement. If this is ASP.NET, then you just associate the method with the button. If it is vb.net then it would be something like...

 Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' call you stored procedure
End Sub

c#

// in the asp.net page
<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
 
// in code behind or inline
protected void Button1_Click(object sender, EventArgs e)
{
// call stored procedure
}
 

If it is classic asp, and you want to call it without changing pages, you should look at using AJAX and call the stored procedure in a server side page.