Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using parameters with mmDataAccessSql
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00813270
Message ID:
00813287
Views:
6
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.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform