"ree32" <ree32@hotmail.com> wrote in message
news:7606ccc8.0408311855.16474e2f@posting.google.com...
>I am using the editItem templates of the datalist control. I have a
> problem as to transferring the changes made by the user to the
> dataset.
>
> As I am reading the results form a database to a dataset then using
> the dataset to fill the datalist.
> The problem is I am not sure how to transfer changes back to the
> dataset as I plan on using the update method of the dataset to change
> the database.
>
> Is this possible? or do I have to use the clumsy way of creating an
> sql string command to update the changes back to the database.
>
> Thanks

"Scott M." <s-mar@nospam.nospam> wrote in message news:<OOkpfy9jEHA.3144@TK2MSFTNGP10.phx.gbl>...
> Your DataList has an eventhandler for updates made to it (UpdateCommand, I
> think). In this eventhandler, you would change the row of the dataset that
> corresponds to the row of the DataList being edited.
>
> When you are ready to update the database, you use the Update method of the
> DataAdapter (not the DataSet) and, of course, you need to have configured
> the DataAdapter's update command before calling DataAdapter.update.
>

"ree32" <ree32@hotmail.com> wrote in message
news:7606ccc8.0409011859.71c52619@posting.google.com...
> "Scott M." <s-mar@nospam.nospam> wrote in message
> news:<OOkpfy9jEHA.3144@TK2MSFTNGP10.phx.gbl>...
>> Your DataList has an eventhandler for updates made to it (UpdateCommand,
>> I
>> think). In this eventhandler, you would change the row of the dataset
>> that
>> corresponds to the row of the DataList being edited.
>>
>> When you are ready to update the database, you use the Update method of
>> the
>> DataAdapter (not the DataSet) and, of course, you need to have configured
>> the DataAdapter's update command before calling DataAdapter.update.
>>
> The problem is how do I get control of this dataadapter, as this
> adapter is called in a separate function ( since this fuction is what
> initially populates the datalist on the page before the user clicks an
> edit button.

"Scott M." <s-mar@nospam.nospam> wrote in message news:<uKURw$JkEHA.3872@TK2MSFTNGP11.phx.gbl>...
> What do you mean "get control" of the DataAdapter. If it is declared at the
> module level, you can work with it anywhere in your class.
>
>

"ree32" <ree32@hotmail.com> wrote in message
news:7606ccc8.0409051446.7b45ad99@posting.google.com...
> "Scott M." <s-mar@nospam.nospam> wrote in message
> news:<uKURw$JkEHA.3872@TK2MSFTNGP11.phx.gbl>...
>> What do you mean "get control" of the DataAdapter. If it is declared at
>> the
>> module level, you can work with it anywhere in your class.
>>
>>
>
> What do you mean by the module level. I am only declaring the dataset
> in the sub. So when I finish with the sub I would not be able to get
> control of the dataset?
>
> Are you saying the dataset should be declared just inside the class
> declaration with all the the other asp web controls such as as
> buttons, dropdownlists?