Page 1 of 1
DbDataTable() function - Is there DbCursorFromDataTable() function???
Posted: Wed Apr 22, 2020 8:01 pm
by Anonymous
Robert - I see in the What’s New file version 2.4 that there’s a new function called DbDataTable(), so I want to ask if there is also a function that will create a data table from a local cursor?
DbDataTable() function - Is there DbCursorFromDataTable() function???
Posted: Wed Apr 22, 2020 9:05 pm
by robert
Matt,
Sure we can add that. But why would you need that ?
To show data on a .Net control (DataGridview for example) you need a bindable .Net collection and not a cursor.
That is why we added DbDataTable() and DbDataSource().
Robert
DbDataTable() function - Is there DbCursorFromDataTable() function???
Posted: Thu Apr 23, 2020 12:09 am
by FoxProMatt
Okay, you’re teaching me here... I wasn’t aware of BindingList in .Net, so after some reading, I see what you are saying.
I’ll keep reading and experimenting.
I’m especially curious to see how X# keeps the Cursor updated from changes in the BindingList as stated in the What’s New file.
Updates to properties in the bindinglist will be directly written to the attached workarea.
Keeping data sets synchronized is hard.. what if I delete a row from the WorkArea after the BindingList is created? Or add a new row to the WorkArea?