Yikes!

Yes, I've looked at the section and all of the examples pass a SQL statement as a command string. The DataAdapter already contains the command string and the parameter object. I need to change the value of the parameter and tell the DataAdapter to fill the data set.

>Hi John,
>
>I think you ment for this message to appear in the Mere Mortals .NET Framework category. <s>
>
>Have you looked at the section in the Doc Guide called "Retrieving Data using Parameterized Queries"? It describes how to call the FillDataSet method. It also provides sample code.
>
>>I've created a Custom Data Access class using a parameterized SQL statement. The Configure Data Adapter Wizard correctly creates a parameter object for the parameter and add the parameter to the SelectCommand of the Data Adpater.
>>
>>My question is how do I set the parameter value from a BizObj class. None of the parameter lists of FillDataSet seem appropriate.
>-----------------------------------------
>
>Cathi Gero, CPA
>Prenia Software & Consulting Services
>Microsoft C# / .NET MVP
>cgero@prenia.com
>www.prenia.com