How to retrieve provider-side parameter information for the stored procedure in ADO.NET

[Johnson]

hello~

In ADO 2.7, there is a Refresh method can get the parameter infomation
of a store procedure
like this...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdamth03_7.asp
But, I can not find the same method in ADO.NET.

How can I do the same thing in ADO.NET?

 

[Frans Bouma]

hello~

In ADO 2.7, there is a Refresh method can get the parameter
infomation
of a store procedure
like this...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/h
tm/mdamth03_7.asp
But, I can not find the same method in ADO.NET.

How can I do the same thing in ADO.NET?

Use INFORMATION_SCHEMA.PARAMETERS view in SqlServer. If you are not
using SqlServer, use the OleDb .NET driver and call
OleDbConnection.GetOleDbSchemaTable(). See GetOleDbSchemaTable help for
details.

FB