How to save a datarow into dataset??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I wanna save changes made to dataset liker adding a datarow by dr=ds.tables(0).newrow and then setting thev value for each column of the table. But I couldn't save those to dataset and eventually to Original database (Like SQL,Excel etc.

Please help
 
Did you also put the ds.tables(0).AddRow(dr) statement after filling the
datarow?

Regards,

--

Nico Debeuckelaere

ND-Sign BVBA (Microsoft Certified Partner since 2004)
URL: http://www.nd-sign.com
== ND-Sign, Designed for you ==
(This posting is provided "AS IS", with no warranties, and confers no
rights.)


Shalin said:
Hi,

I wanna save changes made to dataset liker adding a datarow by
Click to expand...
dr=ds.tables(0).newrow and then setting thev value for each column of the
table. But I couldn't save those to dataset and eventually to Original
database (Like SQL,Excel etc.)
 
Sorry

I can't find AddRow() fn in DataSet class. It's not there. Here ds is my dataset

Help..
 
Hi Shalin,

A dataset is an object that have references to datatables, which have
references to rows which contains items

(Or writing simpler)

A dataset contains tables which contains rows which contains items

ds.tables(x).rows(y).item(z)

Is an item in a row in a datatable in a dataset.

To add a row you can do
dim dr as datarow = ds.tables(x).newrow
ds.tables(x).rows.add(dr)

I hope this helps?

Cor
 
Back
Top