How to update datatable in memory without dataadapter?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 01 Oct 2007 19:10 GMT

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?

Reply to this Message

Spam Catcher - 01 Oct 2007 19:51 GMT

> 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?

Reply to this Message

Peter - 01 Oct 2007 20:36 GMT

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

> > 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?

Reply to this Message

Spam Catcher - 01 Oct 2007 21:13 GMT

> 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.

Reply to this Message

Peter - 01 Oct 2007 21:54 GMT

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.

> > No. The datatable is the one returned by
> > DbDataSourceEnumerator.GetDataSource. So, I just want to update the
[quoted text clipped - 5 lines]
> A datatable is a disconnected representation of the database. It has no
> access to the underlying data source.

Reply to this Message

How to update datatable in memory without dataadapter?

Free Magazines