Vb.net 2008: Datagridview resetting unbound column values on remove

[rw409168]

Greetings,

I've programmatically created a datagridview which contains DataGridViewCheckBoxColumns.

I later assign the datagridview a datasource from a dataset -> datatable and for bound columns set the datapropery to the appropriate datatable columns.

When I remove datarows from the datagridview programmatically via the code below, the unbound columns always have their values reset to "false" (DataGridViewCheckBoxColumns).

 bookingsdata.Tables("bookings").Rows.Remove(DirectCast(DataGridView1.Rows(i).DataBoundItem, DataRowView).Row)
                        bookingsdata.Tables("bookings").AcceptChanges()

Firstly is this usual behaviour?
I'm sure code is not changing the column values.

Can anyone help me in resolving this?

I'm a newbie to sqlserver and don't like the idea of trying to store a boolean type value into the datatable if need be (ermm because I dont know how).

Seems silly to store it too as all it is used for to highlight selection.

Upon clicking a button a loop checks for selected rows then removes them.

Does anyone have any ideas how to progress, i.e. if a row gets removed from the datagridview then the unbound columns are not affected?

Thanks
Rob

 

[rw409168]

Would perhaps using the datagridview virtualmode help with this?

 

[rw409168]

Issue now resolved by adding a boolean datatype to the datatable.