ASP - ASP button to Execute Stored proc in table Adapter

Author

ASP button to Execute Stored proc in table Adapter

Datasort

2007-06-26, 6:56 pm

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
--
Stewart Rogers
DataSort Software, L.C.

Evertjan.

2007-06-26, 6:56 pm

=?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>

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

Bob Barrows [MVP]

2007-06-26, 6:56 pm

Datasort wrote:
> 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.

--
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.

Sponsored Links