William Vaughn
2/6/2008 6:50:00 PM
Nope, I would still export the data to SQL Server (even express) via
SqlBulkCopy and then do the global or other operations there. Anything that
can be exposed with a DataReader can be exported and with 2.0 you can create
a DataReader on more objects than ever before.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker???s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Stren Assaf" <StrenAssaf@discussions.microsoft.com> wrote in message
news:CF121979-3BFC-4DDE-B179-08C4CEA67527@microsoft.com...
> William,
>
> First thanks for your reply.
>
> The table information in the dataset table is coming from an XML and there
> is no DBMS engine involved in the application...
>
> So if there is no way to update all rows at once what will be the best way
> doing it one by one?
>
> "William Vaughn" wrote:
>
>> You can't. But there is nothing to stop you from doing this on the DBMS
>> engine--where it should be executed. Bringing rows to the
>> client--especially
>> all the rows is ... challenged. Keep the data on the server and let the
>> engine do it's work. This avoids 2 round trips per row to fetch and post
>> the
>> updates.
>>
>> --
>> __________________________________________________________________________
>> William R. Vaughn
>> President and Founder Beta V Corporation
>> Author, Mentor, Dad, Grandpa
>> Microsoft MVP
>> (425) 556-9205 (Pacific time)
>> Hitchhiker???s Guide to Visual Studio and SQL Server (7th Edition)
>> ____________________________________________________________________________________________
>> "Stren Assaf" <StrenAssaf@discussions.microsoft.com> wrote in message
>> news:8CBCD5F3-B6C7-4846-8C68-BD2D9C88F4B5@microsoft.com...
>> > Hello, any help will be appreciated :)
>> >
>> > I have a dataset filled with data from a database table. Now I want to
>> > do
>> > an
>> > update command that will effect all rows in a specified table in this
>> > dataset
>> > (something like: "UPDATE TableName SET RowName = RowName + 10")
>> >
>> > How can I do it without executing it individually for each row?
>> >
>> > Thanks.
>> >
>>