I have a datatable with 182K rows and 167 columns. I built 2 simple projects:
WPF
DataTable dt = GetTable();
dgMain.DataSource = dt.AsEnumerable();
<Grid> <igDP:XamDataGrid Name="dgMain"/> </Grid>
WinForm
The WinForm loads fine as does the WPF form. However, the WPF gets a stuck clock and ultimately goes to an out of memory exception. The WinForm works as soon as it is loaded. both load about the same time.
This happens if BindToSampleData is set True and the DataSource is set in code behind. Hence, remove the sample data binding and the problem is corrected.
I have been doing more testing and that doesn't appear to be it. I sometimes see a stuck clock, other times, i do not. In WInForm, it runs fine every time. I am happy to send the solution or to rty and do some experimentation to find out what is happening.
Constructor:
var dc = new DataClasses1DataContext(); var recs = (from p in dc.GetTable<SAS_STATUS>() select p ) ; dgMain.DataSource = recs;
Yes, please post the solution that demonstrates the problem and we can look into this further.
Hi Alan,
Thank you for your feedback. I appreciate that you try to isolate it, and update us for the result. I am glad to hear that the issue was not reproducible with new data. Keep us posted if you found something.
Thank you.
Sincerely,DimiDeveloper Support Engineer, MCPD Infragistics, Inc.www.infragistics.com/support
Dimi,
Thanks for the offer.
At this point, I cannot recreate the behaviour. I absolutely know I saw it in a test project, stripped to nothing except for the databind. However, i have had to recreate the tables since then and it isn't showing up. The only major difference is the column names went from _200807 to something like Period000. The data table had around 170 columns so very wide and deep.
Without being able to reproduce what was happening, there isn't anywhere to go.
Keep it in the back of your mind in case you hear of it again. For now, though, we are closed.
Thanks,
Alan
Hello,
I was trying to import the Data from the txt file in new table but I get some errors. Would you mind if you send me the whole database, even containing only few rows and columns in order to reproduce the issue since I wasn’t able to reproduce it in very simple data. I am looking forward to hearing from you.
It is here:
http://cid-8bca55fbca813d37.office.live.com/embedicon.aspx/Public/Infragistics