Re: Stored Proc args
- From: "William \(Bill\) Vaughn" <billvaRemoveThis@xxxxxxxxxx>
- Date: Fri, 11 Nov 2005 19:29:07 -0600
Sure. Cn.GetSchema should do the trick. It can return "Procedures" or
"ProcedureParameters" (2.0 Framework).
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"baffled" <baffled@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51D40DCD-7987-495A-A0AE-7F087F2197A4@xxxxxxxxxxxxxxxx
> Is there an existing ADO.Net or Framework class or library for Sql Server
> that would allow me to get a list of stored procedures AND the arguments,
> default values, data types, etc...?
>
> I realize there are stored proces like sp_help &
> sp_procedure_params_rowset
> that can provide that info at the db level, but I was hoping to not have
> to
> reinvent the wheel.
>
> Thanks in advance!
.
- Prev by Date: Re: sqldatareader.read()
- Next by Date: Re: Add New in Bindings Navigator problem
- Previous by thread: Re: Stored Proc args
- Next by thread: ado.net begin informix transaction
- Index(es):
Relevant Pages
- Re: Books on ADO.NET 2.0?
... INETA Speaker ... Please reply only to the newsgroup so that others can
benefit. ... This posting is provided "AS IS" with no warranties, ... Also i'll
find the MSDN article that ... (microsoft.public.dotnet.framework.adonet) - Re: Can we use WinForm DataSet in WebForm
... INETA Speaker ... Please reply only to the newsgroup so that others can
benefit. ... This posting is provided "AS IS" with no warranties, ... > Now I
want to use the WH DataSet in WebApplicaiton. ... (microsoft.public.dotnet.framework.adonet) - Re: Creating a SQL Procedure from text file
... some of the previous questions in this newsgroup before posting yours - ...
but this is a classic ADO newsgroup. ... file that creates some stored procedures
for a database. ... (microsoft.public.data.ado) - Re: Timeout Error Question
... David Berry wrote: ... > creating any Stored Procedures. ...
You will get a quicker response by posting to the newsgroup. ... (microsoft.public.inetserver.asp.general) - Re: custom field in DataTable for listbox binding
... INETA Speaker ... Please reply only to the newsgroup so that others can
benefit. ... This posting is provided "AS IS" with no warranties, ... > items
in source list box to destination one. ... (microsoft.public.dotnet.framework.adonet)
