Automatically retrieve parameters from a sql statement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
StefanL
Posts: 5
Joined: Mon 05 Jan 2009 13:52

Automatically retrieve parameters from a sql statement

Post by StefanL » Mon 19 Apr 2010 09:33

Hi

is there a way to extract the names of all used parameters from a sql-statment with dotConnect?

Thanks
Stefan

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 20 Apr 2010 13:59

Please refer to the description of the PgSqlCommand.ParameterCheck property in our documentation. You can use this property to automatically populate PgSqlParameterCollection with the parameters used in CommandText, and iterate through it using the PgSqlCommand.Parameters property.

Post Reply