ASP button to Execute Stored proc in table Adapter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Datasort - 26 Jun 2007 18:33 GMT

Is it possible to add a stored proc to a table adapter and execute the proc
inside an ASP button click event?

I have a table adapter called Claimers and a sp called AddWatch. On the
onclick event I would like to call the table adapter and execute the sp.
Note that the sp does not return records.

Something like:

    ..onclick
        Dim ClaimersAdapter As New ClaimersAdapters.ClaimersTableAdapter()
            Claimers.AddWatch(@RecordID)

Thanks in advance

Signature

Stewart Rogers
DataSort Software, L.C.

Reply to this Message

Evertjan. - 26 Jun 2007 18:54 GMT

=?Utf-8?B?RGF0YXNvcnQ=?= wrote on 26 jun 2007 in
microsoft.public.inetserver.asp.general:

> Is it possible to add a stored proc to a table adapter and execute the
> proc inside an ASP button click event?

There is no ASP button click event.

asp runs serverside, and a click is clientside.

Perhaps you mean asp.net?

This is a classic asp group.
Dotnet questions should be asked in
<microsoft.public.dotnet.framework.aspnet>

Signature

Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

Reply to this Message

Bob Barrows [MVP] - 26 Jun 2007 18:55 GMT

> Is it possible to add a stored proc to a table adapter

There was no way for you to know it (except maybe by browsing through
some of the previous questions before posting yours - always a
recommended practice), but this is a classic asp newsgroup. ASP.Net is
a different technology from classic ASP. While you may be lucky enough
to find a dotnet-savvy person here who can answer your question, you
can eliminate the luck factor by posting your question to a newsgroup
where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.
There are also forums at www.asp.net where you can find a lot of people
to help you.

Signature

Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Reply to this Message

Webmaster Forum / ASP / Database Access / June 2007

ASP button to Execute Stored proc in table Adapter