Hello,
I have an UltraGrid that contains 91,000 rows that is a fixed catalog that will never be edited. I load these rows from a SQL Server query.
Since this is fixed information, I'd like to to find a way serialize and de-serialize these rows. RowsCollection doesn't support serialization.
Is there any way possible to save the RowsCollection to a binary file, and then assign binary containing RowsCollection to a new instance of the grid?
I just don't want to keep reading 91,000 records to display this identical information. Any comments much appreciated. Thank you!!!
What you could do is after you populate your data table from your database you could use WriteXml method of the DataTable object it ass override that takes stream argument so you could save your stream a binary data
https://msdn.microsoft.com/en-us/library/ms135455(v=vs.110).aspx
then to read your data you should use corresponding ReadXml method
https://msdn.microsoft.com/en-us/library/yfxbc3by(v=vs.110).aspx
please let me know if you have any further questions.