John,

You don' need to create a new Command Object. Just pass the FillDataSet the command object in your class already. You can create a custom method that will do that automatically. You can pass to this method the parameters you want to populate the command object with.

>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