Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using parameters with mmDataAccessSql
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Divers
Thread ID:
00813270
Message ID:
00813287
Vues:
7
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform