Interrogate for Parameters?

[xenophon]

Is there a way to interrogate a database for expected Stored Procedure
parameters without using OleDbCommandBuilder.DeriveParameters() ?

Thanks.

 

[Miha Markic [MVP C#]]

Hi

I think OleDbConnection.GetOleDbSchemaTable should do.
Othere than that you should use database specific queries...

 

[Sahil Malik [MVP]]

Depends on the database you are using.

- Sahil Malik [MVP]
Upcoming ADO.NET 2.0 book - http://tinyurl.com/9bync

 

[Robbe Morris [C# MVP]]

If you are talking about Microsoft Access, yes. Use DAO. .DeriveParameters
is not support with Access databases.

Here's how:

http://www.eggheadcafe.com/articles/microsoftaccess_source_code_generator.asp

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net

Earn $$$ money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp