c# Array Loading and data binding grid

Completed Posted Mar 25, 2015 Paid on delivery
Completed Paid on delivery

This is more of a question and I am willing to pay for the best answer. I have a unconventional database. I can fetch records at 100 times the speed of SQL. I am loaded them into arrays and then passing them to c# through an array that is binary(compressed and encrypted). I have an event in c# that loads the array to a datatable. I am including sample code in this project. I have noticed that my array fetching is lightening fast. 100,000 records in less than 2 seconds. The array is build and laying in memory on my data server. It is compressed and then loaded to any platform using .NET. The speed slowdown is when I add that array to a datatable and then bind the datatable to a grid or something to view it with. I understand this will have the overhead. I am looking for the best way I can speed this up. I want to shave as much time as I can off this process. I am using devexpress controls since most grids require databinding. I have been using all kinds of bindable data sources.

I am looking for the best approach to do this and an explaination as to why. The person with the best explaination and can back it up with facts I will award the bid to. I also want to look for a way to improve the existing code to do so, this will not be difficult for the right person. Thanks and good luck bidding.

There was a good point made why I just don't bind to the array directly. That is a great idea. The problem is this data will be editable. I am using the data source so I can update back to the database as things are changed. I do not want to have to use the grid to do the updating. Everything is MVVM pattern for the most part. I have a View that very little if any code and then model and view model that has all my logic and data elements in it. I am doing all the hard work from these modules rather than from the view. Thanks :)

I am using this same logic in ASP.NET, WPF, and Winforms. I am trying to keep it consistent for all platforms.

ASP.NET C# Programming

Project ID: #7370865

About the project

2 proposals Remote project Active Mar 25, 2015

Awarded to:

huypq5

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0