Hi All,

Does anyone knows how to use DataReader with SP in Firebird?

Currently I have:

FbCommand command = new FbCommand("select * from TEST", Connection, 
transaction);

IDataReader reader = command.ExecuteReader();
while (reader.Read())
{
    val = reader.GetValue(1);
}

and would like to replace all dynamic SQL with SPs.  What Do I have to do 
inside the SP?  I'd prefer to stay away from the out parameters.

Thanks,
Vlad



 
____________________________________________________________________________________
The fish are biting. 
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to