DataView / DataSet / ADO.NET HELP

[A_PK]

Ok I want to filter a dataset into a dataview and be able to reference back
to the dataset from the filtered dataview.


Example:


100 record dataset
filter it to a 5 record dataview


loop thought the Dataview and update the original dataset .... if there is a
way to index the dataset from the dataview. I know I can update the
dataview its self but I am updating the filter column so as soon as that
happens the record is gone from the dataview and all the dataview indexes
change.


Any Ideas would be well appreciated


Thanks for your time,

 

[Cor Ligthert]

APK,

I gave you an answer in another newsgroup,

Cor

 

[A_PK]

which newsgroup u are giving ?

 

[Sahil Malik [MVP]]

A_PK,

You can use the DataView.Table and DataRowView.Row property to find the
underlying table and row - that way you can easily reach the underlying
datatable and datarow.

Is that what you are looking for?

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[A_PK]

I have tried to use DataView. I can do filter and find all the stuff using
DataView...

but my problem is that....I need to get the filtered data and export to
XML....

Pls guide me how to do that....

I do not know where my XML shoud get the source....
mydataset1 = DataGrid1.Datasource
datagrid1.datasource = mydateset.Tables("TBLName").DefaultView.RowFilter =
"A = '2'"

so now, how my XML can read the latest filtered data ?
pls guide

 

[Sahil Malik [MVP]]

My apologies, I don't think I quite understand. If you need to filter XML,
then XSLT is the right tool - but maybe I am misunderstanding you again.

- Sahil Malik [MVP]
http://codebetter.com/blogs/sahil.malik/

 

[Cor Ligthert]

Stephen,

I gave yesterday almost this sample in the language.vb newsgroup where this
was multiposted.

However with this in it
dim dtNew as datatable = dtOld.clone

Just to make you attent on it, that makes it a lot easier.

Cor