Edit DataView

[Roey]

I have a windows form with comboboxes and textboxes bound to a DataView. Upon the click of a Button I want to modify values for the currently displayed record. How would I go about editing the values in a dataview programatically?

[AlexCode]

I think that if you use the BindingContext it'll do...

Like this:

dim DRow as DataRow
DRow = me.BindingContext(DataView).Current

'Then just change the values
DRow("ColumnName") = "BlaBla"

 

Alex :D

[Roey]

I am getting the following Cast error with that code:

 

Option Strict On disallows implicit conversions from 'system.object' to 'system.data.datarow'

[PlausiblyDamp]

Dim DRow As DataRow
DRow = directcast(me.BindingContext(DataView).Current,DataRow)

'Then just change the values
DRow("ColumnName") = "BlaBla"

[Roey]

I'm still getting a Cast error:

 

An unhandled exception of type 'System.InvalidCastException' occurred in elantis_UI.exe

 

Additional information: Specified cast is not valid.

[PlausiblyDamp]

Which line is giving the error then? That seems to be the only part casting between object and DataRow.

[Roey]

(1) Dim dv As DataView

(2) dv = Me.dsCategory.Tables("Category").DefaultView

(3) Dim row As DataRow

(4) row = DirectCast(Me.BindingContext(dv).Current, DataRow)

 

Line 4

[PlausiblyDamp]

Ahhhh, it returns a DataRowView not a DataRow so the following will compile (haven't checked to see what it does at runtime though....)

dv = Me.dsCategory.Tables("Category").DefaultView
	Dim row As DataRowView
	row = DirectCast(Me.BindingContext(dv).Current, DataRowView)

[Roey]

Perfect, thanks for your help its only the second time that DataRow and DataRowView have caught me out. Maybe in a couple of years it will finally be implanted into my brain.

 

PS What does it say above Badger ???? Looks like wool

[Roey]

Sorry but another question for you. Why do you use DirectCast as oppossed to CType

 

Thanks

[PlausiblyDamp]

http://www.xtremedotnettalk.com/showthread.php?s=&threadid=81759&highlight=ctype+directcast

[Roey]

Once again "Thanks"