Sorry it has taken me some time to respond to your post, I have taken a look at the site but it does not really help me. I will try to explain my requirements a little more clearly. I am currently using an ms listview to display a maximum of 150 records in 17 columns I am using a disconnected data source to populate the listview at runtime. The records in the sql table are constantly updated from other sources; I use a background worker to check for changes in the data by loading the current values from the listview into a public array and then the background worker is called from a timer and loads the current sql data into a dataset and checks the array values against the dataset for changes if any are found another array is populate with updated records and when the background workers complete event fires the updated records are loaded onto the listview. I am sure there must be a cleaner method to achieve this! I want to replace the listview with a radgrid control should I continue to use the existing method to update the radgrid or would you suggest another method.?
answered on 11 May 2009, 09:33 AM
Hi Joe Bohen,
Thank you for the detailed description. First I will try to summarize your scenario -- you need to present data using a disconnected model and constantly check the data base for updates so that you can update your local data. I will answer your question from UI standpoint which is in our support scope. The simplest way to implement your scenario is to use a data table which is the data source for your grid. There are two options - retrieve all the data every time you check for updates or use some code to update only the rows that have been changed. Using the former form UI standpoint means that the grid will be refreshed entirely which brings slow performance in UI layer. Using the latter means that the grid will update only the rows that are changed and visible which means better performance in the UI layer. Please note that I am not considering your code in the UI layer.
I hope that this answers your question. Do not hesitate to write me back if you have further questions.