Hi Cathy,

Thanks for the help.

Maybe I'm not being clear enough. I've create a suclass of mmDataAccessSql that has a private SqlDataAdapter and four private SqlCommand objects. These were created by Configure Data Adapter Wizard using a parametrized query. The SelectCommand object has a parameter object for the parameter required for the query.

I don't see how creating a new command object, with a new command string and prarmeters helps me set the existing parameter value and fill a dataset using the existing command object.

>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