RE: Execute Stored Procedure from SharePoint

Tech-Archive recommends: Speed Up your PC by fixing your registry

You will need to write a WebPart that calls a stored procedure using ADO.NET.
There should be plenty of documentation in the SDK to help you do this.

Daniel Larson
http://www.portalbuilder.org
http://workspaces.gotdotnet.com/portaltools


"RedOakPackster" wrote:

> How can I execute a stored procedure in another database (not
> SharePoint) from within a SharePoint page. I have a SQL Server
> Standard Ed. license; I just need to know how to connect to a
> non-SharePoint database and execute a stored procedure wihtout MS
> FrontPage. Any help is appreciated.
>
>
.

Relevant Pages

  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)
  • Re: pass stored procedure parameters in asp
    ... you can use the EXECUTE AS statement to test the ... procedure and properties) of voidTran stored procedure and other ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.general)
  • Execute Stored Procedure from SharePoint
    ... SharePoint) from within a SharePoint page. ... non-SharePoint database and execute a stored procedure wihtout MS ...
    (microsoft.public.sharepoint.portalserver.development)