Cathi,

It says I have to set the commandtext property for the update command. I am assuming that the update method for the data adapter uses a stored procedure to do the update and automatically sets any parameters required by the stored proc. Is this correct?

Jim

>Jim,
>
>The sample code was if you needed to change the data other than in bound controls. In your case, just call the Update method of the DataAdapter to perform the update on the backend. Depending on how you are working with the DataGrid, you might need to call EndEdit method prior to performing the Update.
>
>>Hey Cathi,
>>
>> Thanks for the reply. The user will be making the changes in a datagrid. So can I just call the update command on the dataadapter or do I have to code the changes for all the fields like you are doing?
>>
>>Jim
>>
>>>Hi Jim,
>>>
>>>Look at Message #724589 for examples about how to update data in the DataSet to the backend.
>>>
>>>>Bonnie,
>>>>
>>>> I want to add data from an existing DataSet to a table that exists on your back-end database.
>>>>
>>>>Jim
>>>>
>>>>>Hi Jim,
>>>>>
>>>>>I'm not sure what you're asking ... do you want to add data from an existing DataSet to a table that exists on your back-end database? Or do you have existing data in a DataTable that you want to add to your DataSet?
>>>>>
>>>>>~~Bonnie
>>>>>
>>>>>
>>>>>>All,
>>>>>>
>>>>>> I have a dataset that I want to add to an existing table selected by the user. Is there an easy way to do this? Are there any articles about this?