Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > visual basic .net > answers

How to update datatable in memory without dataadapter?

=?Utf-8?B?UGV0ZXI=?=
Guest
  
Posts: n/a
#1: Oct 1 '07
A datatable is returned from a .NET method. Since there is no dataadapter
in this case, how can I update a column for all the rows in that datatable?

Spam Catcher
Guest
  
Posts: n/a
#2: Oct 1 '07

re: How to update datatable in memory without dataadapter?

=?Utf-8?B?UGV0ZXI=?= <Peter@discussions.microsoft.comwrote in
news:A2D37C2A-0445-4EAA-B612-3702D9ABED99@microsoft.com:
Quote:
A datatable is returned from a .NET method. Since there is no
dataadapter in this case, how can I update a column for all the rows
in that datatable?
Do you have access to the database?
=?Utf-8?B?UGV0ZXI=?=
Guest
  
Posts: n/a
#3: Oct 1 '07

re: How to update datatable in memory without dataadapter?

No. The datatable is the one returned by
DbDataSourceEnumerator.GetDataSource. So, I just want to update the
datatable in memory.

"Spam Catcher" wrote:
Quote:
=?Utf-8?B?UGV0ZXI=?= <Peter@discussions.microsoft.comwrote in
news:A2D37C2A-0445-4EAA-B612-3702D9ABED99@microsoft.com:
>
Quote:
A datatable is returned from a .NET method. Since there is no
dataadapter in this case, how can I update a column for all the rows
in that datatable?
>
Do you have access to the database?
>
Spam Catcher
Guest
  
Posts: n/a
#4: Oct 1 '07

re: How to update datatable in memory without dataadapter?

=?Utf-8?B?UGV0ZXI=?= <Peter@discussions.microsoft.comwrote in
news:1A38518A-0EDE-4D3F-931F-062F0921F97C@microsoft.com:
Quote:
No. The datatable is the one returned by
DbDataSourceEnumerator.GetDataSource. So, I just want to update the
datatable in memory.
If you do not have access to the data - you cannot send updates back to the
DB.

A datatable is a disconnected representation of the database. It has no
access to the underlying data source.
=?Utf-8?B?UGV0ZXI=?=
Guest
  
Posts: n/a
#5: Oct 1 '07

re: How to update datatable in memory without dataadapter?

Yes and I don't want to update any datasource in this case (actually don't
know the datasource). I have resolved the issue by using for loop and assign
value to column.

"Spam Catcher" wrote:
Quote:
=?Utf-8?B?UGV0ZXI=?= <Peter@discussions.microsoft.comwrote in
news:1A38518A-0EDE-4D3F-931F-062F0921F97C@microsoft.com:
>
Quote:
No. The datatable is the one returned by
DbDataSourceEnumerator.GetDataSource. So, I just want to update the
datatable in memory.
>
If you do not have access to the data - you cannot send updates back to the
DB.
>
A datatable is a disconnected representation of the database. It has no
access to the underlying data source.
>
Closed Thread

« previous question | next question »

Similar Visual Basic .NET bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,449 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved