DataView loop and edit?

[Able]

Dear friends

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))

myDataView.RowF ilter = "City = 'London'"

My question is how to loop through all rows in myDataView and edit the field
fldZipCode so fldZipCode = "9800"

Regards Able

[Able]

Has to define my question more accurately:

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))

This works:
myDataView.RowF ilter = "City = 'London'"

For i as Integer = 0 to myDataView.coun t - 1
myDataView(i)(" fldZipCode")="9 800"
Next

....but this doesnt:
myDataView.RowF ilter = "City = 'London' And fldZipCode = '9000'"

For i as Integer = 0 to myDataView.coun t - 1
myDataView(i)(" fldZipCode")="9 800"
Next

Able
"Able" <ab**@epost.n o> skrev i melding
news:u5******** ***********@new s4.e.nsc.no...

Dear friends

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))

myDataView.RowF ilter = "City = 'London'"

My question is how to loop through all rows in myDataView and edit the field fldZipCode so fldZipCode = "9800"

Regards Able

[Jay B. Harlow [MVP - Outlook]]

Able,

myDataView.RowF ilter = "City = 'London' And fldZipCode = '9000'"
myDataView(i)(" fldZipCode")="9 800"
Because you used fldZipCode in your Filter, As you change the fldZipCode
field the contents of the collection (the items in the DataView) changes.

The easiest way maybe to use DataTable.Selec t in this case. As
DataTable.Selec t returns a fixed array of rows, where as the DataView is a
dynamic collection of rows.

Something like:
Dim table As DataTable = dsData.Tables(" tblCustomers")
Dim filterExpressio n As String = "City = 'London' And fldZipCode =
'9000'"
For Each row As DataRow in table.Select(fi lterExpression)
row("fldZipCode ")="9800"
Next

Hope this helps
Jay

"Able" <ab**@epost.n o> wrote in message
news:G0******** ***********@new s4.e.nsc.no... Has to define my question more accurately:

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))

This works:
myDataView.RowF ilter = "City = 'London'"

For i as Integer = 0 to myDataView.coun t - 1
myDataView(i)(" fldZipCode")="9 800"
Next

...but this doesnt:
myDataView.RowF ilter = "City = 'London' And fldZipCode = '9000'"

For i as Integer = 0 to myDataView.coun t - 1
myDataView(i)(" fldZipCode")="9 800"
Next

Able
"Able" <ab**@epost.n o> skrev i melding
news:u5******** ***********@new s4.e.nsc.no...

Dear friends

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))

myDataView.RowF ilter = "City = 'London'"

My question is how to loop through all rows in myDataView and edit the

field

fldZipCode so fldZipCode = "9800"

Regards Able

[Cor Ligthert]

In addition to Jay

with a dataview

For i As Integer = dv.Count - 1 to 0 step -1
dv(i)("fldZipCo de") = "9800"
Next

Cor

[Able]

Got it. Thanks a lot.

Regards Able
"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> skrev i melding
news:O$******** ******@tk2msftn gp13.phx.gbl...

Able,

myDataView.RowF ilter = "City = 'London' And fldZipCode = '9000'"
myDataView(i)(" fldZipCode")="9 800"

Because you used fldZipCode in your Filter, As you change the fldZipCode
field the contents of the collection (the items in the DataView) changes.

The easiest way maybe to use DataTable.Selec t in this case. As
DataTable.Selec t returns a fixed array of rows, where as the DataView is a
dynamic collection of rows.

Something like:
Dim table As DataTable = dsData.Tables(" tblCustomers")
Dim filterExpressio n As String = "City = 'London' And fldZipCode =
'9000'"
For Each row As DataRow in table.Select(fi lterExpression)
row("fldZipCode ")="9800"
Next

Hope this helps
Jay

"Able" <ab**@epost.n o> wrote in message
news:G0******** ***********@new s4.e.nsc.no...

Has to define my question more accurately:

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))

This works:
myDataView.RowF ilter = "City = 'London'"

For i as Integer = 0 to myDataView.coun t - 1
myDataView(i)(" fldZipCode")="9 800"
Next

...but this doesnt:
myDataView.RowF ilter = "City = 'London' And fldZipCode = '9000'"

For i as Integer = 0 to myDataView.coun t - 1
myDataView(i)(" fldZipCode")="9 800"
Next

Able
"Able" <ab**@epost.n o> skrev i melding
news:u5******** ***********@new s4.e.nsc.no...

Dear friends

Dim myDataView as DataView = New DataView(dsData .Tables("tblCus tomers"))
myDataView.RowF ilter = "City = 'London'"

My question is how to loop through all rows in myDataView and edit the

field

fldZipCode so fldZipCode = "9800"

Regards Able

[Jay B. Harlow [MVP - Outlook]]

Cor,
I was actually thinking of sorting the DataView descending, then only
changing element zero, when I did my initial post.

However now that you got me to actually think of the alternatives, you
wouldn't need the sort at all! :-)

myDataView.RowF ilter = "City = 'London' And fldZipCode = '9000'"

Do Until myDataView.Coun t = 0
myDataView(0)(" fldZipCode")="9 800"
Loop

I'm sure there are a couple of other methods...

Jay

"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:OO******** ******@TK2MSFTN GP11.phx.gbl...

In addition to Jay

with a dataview

For i As Integer = dv.Count - 1 to 0 step -1
dv(i)("fldZipCo de") = "9800"
Next

Cor