Re: DataGrid - clever way to update DataSet
- From: "Scott M." <s-mar@xxxxxxxxxxxxx>
- Date: Wed, 15 Jun 2005 17:23:08 -0400
How does this help the OP? The question wasn't how to dynamically generate
tables, it was how to dynamically update a dataset from changes in a grid
when the dataset has been created dynamically.
In addition, a CommandBuilder is also available for other data sources
besides SQL, however it is generally considered NOT a good idea to use it as
it is limited in situations where it will create correct statements.
"Val Mazur (MVP)" <group51a@xxxxxxxxxxx> wrote in message
news:OspeDGVcFHA.132@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> If you are using SQL Server, then you could use CommandBuilder class that
> will allow you automatically build INSERT, UPDATE and DELETE SQL
> statements for your DataAdapter based on your SELECT statement. I believe
> it should work for you
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "st" <st@xxxxxxxxx> wrote in message
> news:1118800256.333813.54220@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> Hi Scott,
>>
>> Thanks for the information.
>>
>> As the source table for the DataGrid can change, I need a solution that
>> doesn't hard-code field names into the update.
>>
>> Has anybody created a routine that will cope with this situation?
>>
>> Thanks,
>>
>> Simon
>>
>
>
.
- References:
- DataGrid - clever way to update DataSet
- From: st
- Re: DataGrid - clever way to update DataSet
- From: Scott M.
- Re: DataGrid - clever way to update DataSet
- From: st
- Re: DataGrid - clever way to update DataSet
- From: Val Mazur \(MVP\)
- DataGrid - clever way to update DataSet
- Prev by Date: A couple of questions about updating data through a dataset
- Next by Date: Re: DataGrid - clever way to update DataSet
- Previous by thread: Re: DataGrid - clever way to update DataSet
- Next by thread: Re: DataGrid - clever way to update DataSet
- Index(es):
Relevant Pages
|
