Joh,
One set of the FillDataSet overloads is dealing with sending a Command Object. You could fill the command object with the parameter info and then send it as a parameter to the FillDataSet method. See the Dev Guide help section called "Retrieving Data using Command objects".
>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
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi