This question is locked. New answers and comments are not allowed.
Hi,
I am playing with Telerik's Silverlight controls in LightSwitch. I am dealing with a large amount of data. I can't seem to get the RadDataPager to work correctly. I have 3 millions rows of data/80 columns and the RadGridView only shows 10 records across 5 pages. If anyone has been able to get this to work. I would appreciate the feedback.
XAML Code
</Grid> </UserControl><UserControlx:Class="LightSwitchApplication.ActPendGrid"xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"mc:Ignorable="d"d:DesignHeight="373"d:DesignWidth="585"DataContext="{Binding}"><Gridx:Name="LayoutRoot"Background="White"><BorderGrid.RowSpan="3"/><telerik:RadGridViewx:Name="xRadGridView"ItemsSource="{Binding PagedSource,ElementName=RadDataPager1, Mode=OneWay}"AutoGenerateColumns="False"RowIndicatorVisibility="Collapsed"CanUserFreezeColumns="False"ColumnWidth="150"IsReadOnly="False"><telerik:RadGridView.Columns><telerik:GridViewDataColumnHeader="Field 1"DataMemberBinding="{Binding Field 1}"/><telerik:GridViewDataColumnHeader="Field 2"DataMemberBinding="{Binding Field 2}"/><telerik:GridViewDataColumnHeader="Field 3"DataMemberBinding="{Binding Field 3}"/><telerik:GridViewDataColumnHeader="Field 4"DataMemberBinding="{Binding Field 4}"/><telerik:GridViewDataColumnHeader="Field 5"DataMemberBinding="{Binding Field 5}"/><telerik:GridViewDataColumnHeader="Field 6"DataMemberBinding="{Binding Field 6}"/><telerik:GridViewDataColumnHeader="Field 7"DataMemberBinding="{Binding Field 7}"/><telerik:GridViewDataColumnHeader="Field 8"DataMemberBinding="{Binding Field 8}"/><telerik:GridViewDataColumnHeader="Field 9"DataMemberBinding="{Binding Field 9}"/><telerik:GridViewDataColumnHeader="Field 10"DataMemberBinding="{Binding Field 10}"/><telerik:GridViewDataColumnHeader="Field 11"DataMemberBinding="{Binding Field 11}"/><telerik:GridViewDataColumnHeader="Field 12"DataMemberBinding="{Binding Field 12}"/><telerik:GridViewDataColumnHeader="Field 13"DataMemberBinding="{Binding Field 13}"/><telerik:GridViewDataColumnHeader="Field 14"DataMemberBinding="{Binding Field 14}"/><telerik:GridViewDataColumnHeader="Field 15"DataMemberBinding="{Binding Field 15}"/><telerik:GridViewDataColumnHeader="Field 16"DataMemberBinding="{Binding Field 16}"/><telerik:GridViewDataColumnHeader="Field 17"DataMemberBinding="{Binding Field 17}"/><telerik:GridViewDataColumnHeader="Field 18"DataMemberBinding="{Binding Field 18}"/><telerik:GridViewDataColumnHeader="Field 19"DataMemberBinding="{Binding Field 19}"/><telerik:GridViewDataColumnHeader="Field 20"DataMemberBinding="{Binding Field 20}"/><telerik:GridViewDataColumnHeader="Field 21"DataMemberBinding="{Binding Field 21}"/><telerik:GridViewDataColumnHeader="Field 22"DataMemberBinding="{Binding Field 22}"/><telerik:GridViewDataColumnHeader="Field 23"DataMemberBinding="{Binding Field 23}"/><telerik:GridViewDataColumnHeader="Field 24"DataMemberBinding="{Binding Field 24}"/><telerik:GridViewDataColumnHeader="Field 25"DataMemberBinding="{Binding Field 25}"/><telerik:GridViewDataColumnHeader="Field 26"DataMemberBinding="{Binding Field 26}"/><telerik:GridViewDataColumnHeader="Field 27"DataMemberBinding="{Binding Field 27}"/><telerik:GridViewDataColumnHeader="Field 28"DataMemberBinding="{Binding Field 28}"/><telerik:GridViewDataColumnHeader="Field 29"DataMemberBinding="{Binding Field 29}"/><telerik:GridViewDataColumnHeader="Field 30"DataMemberBinding="{Binding Field 30}"/><telerik:GridViewDataColumnHeader="Field 31"DataMemberBinding="{Binding Field 31}"/><telerik:GridViewDataColumnHeader="Field 32"DataMemberBinding="{Binding Field 32}"/><telerik:GridViewDataColumnHeader="Field 33"DataMemberBinding="{Binding Field 33}"/><telerik:GridViewDataColumnHeader="Field 34"DataMemberBinding="{Binding Field 34}"/><telerik:GridViewDataColumnHeader="Field 35"DataMemberBinding="{Binding Field 35}"/><telerik:GridViewDataColumnHeader="Field 36"DataMemberBinding="{Binding Field 36}"/><telerik:GridViewDataColumnHeader="Field 37"DataMemberBinding="{Binding Field 37}"/><telerik:GridViewDataColumnHeader="Field 38"DataMemberBinding="{Binding Field 38}"/><telerik:GridViewDataColumnHeader="Field 39"DataMemberBinding="{Binding Field 39}"/><telerik:GridViewDataColumnHeader="Field 40"DataMemberBinding="{Binding Field 40}"/><telerik:GridViewDataColumnHeader="Field 41"DataMemberBinding="{Binding Field 41}"/><telerik:GridViewDataColumnHeader="Field 42"DataMemberBinding="{Binding Field 42}"/><telerik:GridViewDataColumnHeader="Field 43"DataMemberBinding="{Binding Field 43}"/><telerik:GridViewDataColumnHeader="Field 44"DataMemberBinding="{Binding Field 44}"/><telerik:GridViewDataColumnHeader="Field 45"DataMemberBinding="{Binding Field 45}"/><telerik:GridViewDataColumnHeader="Field 46"DataMemberBinding="{Binding Field 46}"/><telerik:GridViewDataColumnHeader="Field 47"DataMemberBinding="{Binding Field 47}"/><telerik:GridViewDataColumnHeader="Field 48"DataMemberBinding="{Binding Field 48}"/><telerik:GridViewDataColumnHeader="Field 49"DataMemberBinding="{Binding Field 49}"/><telerik:GridViewDataColumnHeader="Field 50"DataMemberBinding="{Binding Field 50}"/><telerik:GridViewDataColumnHeader="Field 51"DataMemberBinding="{Binding Field 51}"/><telerik:GridViewDataColumnHeader="Field 52"DataMemberBinding="{Binding Field 52}"/><telerik:GridViewDataColumnHeader="Field 53"DataMemberBinding="{Binding Field 53}"/><telerik:GridViewDataColumnHeader="Field 54"DataMemberBinding="{Binding Field 54}"/><telerik:GridViewDataColumnHeader="Field 55"DataMemberBinding="{Binding Field 55}"/><telerik:GridViewDataColumnHeader="Field 56"DataMemberBinding="{Binding Field 56}"/><telerik:GridViewDataColumnHeader="Field 57"DataMemberBinding="{Binding Field 57}"/><telerik:GridViewDataColumnHeader="Field 58"DataMemberBinding="{Binding Field 58}"/><telerik:GridViewDataColumnHeader="Field 59"DataMemberBinding="{Binding Field 59}"/><telerik:GridViewDataColumnHeader="Field 60"DataMemberBinding="{Binding Field 60}"/><telerik:GridViewDataColumnHeader="Field 61"DataMemberBinding="{Binding Field 61}"/><telerik:GridViewDataColumnHeader="Field 62"DataMemberBinding="{Binding Field 62}"/><telerik:GridViewDataColumnHeader="Field 63"DataMemberBinding="{Binding Field 63}"/><telerik:GridViewDataColumnHeader="Field 64"DataMemberBinding="{Binding Field 64}"/><telerik:GridViewDataColumnHeader="Field 65"DataMemberBinding="{Binding Field 65}"/><telerik:GridViewDataColumnHeader="Field 66"DataMemberBinding="{Binding Field 66}"/><telerik:GridViewDataColumnHeader="Field 67"DataMemberBinding="{Binding Field 67}"/><telerik:GridViewDataColumnHeader="Field 68"DataMemberBinding="{Binding Field 68}"/><telerik:GridViewDataColumnHeader="Field 69"DataMemberBinding="{Binding Field 69}"/><telerik:GridViewDataColumnHeader="Field 70"DataMemberBinding="{Binding Field 70}"/><telerik:GridViewDataColumnHeader="Field 71"DataMemberBinding="{Binding Field 71}"/><telerik:GridViewDataColumnHeader="Field 72"DataMemberBinding="{Binding Field 72}"/><telerik:GridViewDataColumnHeader="Field 73"DataMemberBinding="{Binding Field 73}"/><telerik:GridViewDataColumnHeader="Field 74"DataMemberBinding="{Binding Field 74}"/><telerik:GridViewDataColumnHeader="Field 75"DataMemberBinding="{Binding Field 75}"/><telerik:GridViewDataColumnHeader="Field 76"DataMemberBinding="{Binding Field 76}"/><telerik:GridViewDataColumnHeader="Field 77"DataMemberBinding="{Binding Field 77}"/><telerik:GridViewDataColumnHeader="Field 78"DataMemberBinding="{Binding Field 78}"/><telerik:GridViewDataColumnHeader="Field 79"DataMemberBinding="{Binding Field 79}"/><telerik:GridViewDataColumnHeader="Field 80"DataMemberBinding="{Binding Field 80}"/></telerik:RadGridView.Columns></telerik:RadGridView><telerik:RadDataPagerx:Name="RadDataPager1"Source="{Binding Screen.SNE_TBL_ACT_PEND_FMEs}"PageSize="10"Grid.Row="1"/>
Regards,
Kelly
8 Answers, 1 is accepted
0
Hello Kelly,
Ross
the Telerik team
Is the stock toolkit DataPager working in this same scenario?
All the best,Ross
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
0
Kelly
Top achievements
Rank 1
Rank 1
answered on 05 Oct 2011, 02:46 PM
Hello Ross,
The stock DataPager works fine if I don't use the stock Grid and not the RadGrid.
Could you or someone else look at my code and tell me if I am binding the data correctly. My company is purchasing the Premium suite for use in LightSwitch applications. What good is it to have the RadGrid working if I can't view all my data since the RadDataPager does not work? In the LightSwitch demos there isn't any examples in how to get the RadDataPager to work.
When I search on this topic, there are others that are having the same issue with no resolution.
Regards,
Kelly
The stock DataPager works fine if I don't use the stock Grid and not the RadGrid.
Could you or someone else look at my code and tell me if I am binding the data correctly. My company is purchasing the Premium suite for use in LightSwitch applications. What good is it to have the RadGrid working if I can't view all my data since the RadDataPager does not work? In the LightSwitch demos there isn't any examples in how to get the RadDataPager to work.
When I search on this topic, there are others that are having the same issue with no resolution.
Regards,
Kelly
0
Hello Kelly,
Ross
the Telerik team
Can you try the following.
Comment out the pager for a little while.
Bind RadGridView.ItemsSource directly to "{Binding Screen.SNE_TBL_ACT_PEND_FMEs}"
Does data show up in the grid correctly?
In case it does not, try to bind another ItemsControl such as a plain old ListBox to this same Binding and see whether data will show up in some way. I guess that the data comes alright through the binding but I need to be sure.
In case data shows up correctly in the grid, return the pager and bind it like this:
<telerik:RadDataPager x:Name="RadDataPager1" Source="{Binding Items, ElementName=xRadGridView}" PageSize="10" Grid.Row="1" />
We will bind them together the other way around, i.e. instead of binding the grid to the PagedSource of the pager, we will bind the pager to the Items property of the grid.
Does this resolve the issue? In case it does not, can you send us a small dummy version of your real version that we can debug on our side?
Ross
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
0
Kelly
Top achievements
Rank 1
Rank 1
answered on 05 Oct 2011, 04:43 PM
Hi Ross,
We are getting closer. I can see a full page of data now with the RadDataPager at the bottom. Even though I can see the RadDataPager, it does not work. It just shows 1 out of 1 pages. I attached the code of the XAML.
We are getting closer. I can see a full page of data now with the RadDataPager at the bottom. Even though I can see the RadDataPager, it does not work. It just shows 1 out of 1 pages. I attached the code of the XAML.
<UserControl x:Class="LightSwitchApplication.ActPendGrid" mc:Ignorable="d" d:DesignHeight="300" d:DesignWidth="400" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"> <Grid x:Name="LayoutRoot" Background="White"> <Grid.RowDefinitions> <RowDefinition Height="40"/> <RowDefinition Height="*"/> <RowDefinition Height="30"/> </Grid.RowDefinitions> <telerik:RadGridView x:Name="xRadGridView" AutoGenerateColumns="False" Grid.Row="1" ColumnWidth="120" ShowColumnFooters="False" ShowGroupPanel="False" ItemsSource="{Binding Screen.SNE_TBL_ACT_PEND_FMEs}" SelectedItem="{Binding Screen.SNE_TBL_ACT_PEND_FMEs.SelectedItem, Mode=TwoWay}"> <telerik:RadGridView.Columns> <telerik:GridViewDataColumn Header="Field 1"
DataMemberBinding="{Binding Field 1}" />
<telerik:GridViewDataColumn Header="Field 2"
DataMemberBinding="{Binding Field 2}" />
<telerik:GridViewDataColumn Header="Field 3"
DataMemberBinding="{Binding Field 3}" />
<telerik:GridViewDataColumn Header="Field 4"
DataMemberBinding="{Binding Field 4}" />
<telerik:GridViewDataColumn Header="Field 5"
DataMemberBinding="{Binding Field 5}" />
<telerik:GridViewDataColumn Header="Field 6"
DataMemberBinding="{Binding Field 6}" />
<telerik:GridViewDataColumn Header="Field 7"
DataMemberBinding="{Binding Field 7}" />
<telerik:GridViewDataColumn Header="Field 8"
DataMemberBinding="{Binding Field 8}" />
<telerik:GridViewDataColumn Header="Field 9"
DataMemberBinding="{Binding Field 9}" />
<telerik:GridViewDataColumn Header="Field 10"
DataMemberBinding="{Binding Field 10}" />
<telerik:GridViewDataColumn Header="Field 11"
DataMemberBinding="{Binding Field 11}" />
<telerik:GridViewDataColumn Header="Field 12"
DataMemberBinding="{Binding Field 12}" />
<telerik:GridViewDataColumn Header="Field 13"
DataMemberBinding="{Binding Field 13}" />
<telerik:GridViewDataColumn Header="Field 14"
DataMemberBinding="{Binding Field 14}" />
<telerik:GridViewDataColumn Header="Field 15"
DataMemberBinding="{Binding Field 15}" />
<telerik:GridViewDataColumn Header="Field 16"
DataMemberBinding="{Binding Field 16}" />
<telerik:GridViewDataColumn Header="Field 17"
DataMemberBinding="{Binding Field 17}" />
<telerik:GridViewDataColumn Header="Field 18"
DataMemberBinding="{Binding Field 18}" />
<telerik:GridViewDataColumn Header="Field 19"
DataMemberBinding="{Binding Field 19}" />
<telerik:GridViewDataColumn Header="Field 20"
DataMemberBinding="{Binding Field 20}" />
<telerik:GridViewDataColumn Header="Field 21"
DataMemberBinding="{Binding Field 21}" />
<telerik:GridViewDataColumn Header="Field 22"
DataMemberBinding="{Binding Field 22}" />
<telerik:GridViewDataColumn Header="Field 23"
DataMemberBinding="{Binding Field 23}" />
<telerik:GridViewDataColumn Header="Field 24"
DataMemberBinding="{Binding Field 24}" />
<telerik:GridViewDataColumn Header="Field 25"
DataMemberBinding="{Binding Field 25}" />
<telerik:GridViewDataColumn Header="Field 26"
DataMemberBinding="{Binding Field 26}" />
<telerik:GridViewDataColumn Header="Field 27"
DataMemberBinding="{Binding Field 27}" />
<telerik:GridViewDataColumn Header="Field 28"
DataMemberBinding="{Binding Field 28}" />
<telerik:GridViewDataColumn Header="Field 29"
DataMemberBinding="{Binding Field 29}" />
<telerik:GridViewDataColumn Header="Field 30"
DataMemberBinding="{Binding Field 30}" />
<telerik:GridViewDataColumn Header="Field 31"
DataMemberBinding="{Binding Field 31}" />
<telerik:GridViewDataColumn Header="Field 32"
DataMemberBinding="{Binding Field 32}" />
<telerik:GridViewDataColumn Header="Field 33"
DataMemberBinding="{Binding Field 33}" />
<telerik:GridViewDataColumn Header="Field 34"
DataMemberBinding="{Binding Field 34}" />
<telerik:GridViewDataColumn Header="Field 35"
DataMemberBinding="{Binding Field 35}" />
<telerik:GridViewDataColumn Header="Field 36"
DataMemberBinding="{Binding Field 36}" />
<telerik:GridViewDataColumn Header="Field 37"
DataMemberBinding="{Binding Field 37}" />
<telerik:GridViewDataColumn Header="Field 38"
DataMemberBinding="{Binding Field 38}" />
<telerik:GridViewDataColumn Header="Field 39"
DataMemberBinding="{Binding Field 39}" />
<telerik:GridViewDataColumn Header="Field 40"
DataMemberBinding="{Binding Field 40}" />
<telerik:GridViewDataColumn Header="Field 41"
DataMemberBinding="{Binding Field 41}" />
<telerik:GridViewDataColumn Header="Field 42"
DataMemberBinding="{Binding Field 42}" />
<telerik:GridViewDataColumn Header="Field 43"
DataMemberBinding="{Binding Field 43}" />
<telerik:GridViewDataColumn Header="Field 44"
DataMemberBinding="{Binding Field 44}" />
<telerik:GridViewDataColumn Header="Field 45"
DataMemberBinding="{Binding Field 45}" />
<telerik:GridViewDataColumn Header="Field 46"
DataMemberBinding="{Binding Field 46}" />
<telerik:GridViewDataColumn Header="Field 47"
DataMemberBinding="{Binding Field 47}" />
<telerik:GridViewDataColumn Header="Field 48"
DataMemberBinding="{Binding Field 48}" />
<telerik:GridViewDataColumn Header="Field 49"
DataMemberBinding="{Binding Field 49}" />
<telerik:GridViewDataColumn Header="Field 50"
DataMemberBinding="{Binding Field 50}" />
<telerik:GridViewDataColumn Header="Field 51"
DataMemberBinding="{Binding Field 51}" />
<telerik:GridViewDataColumn Header="Field 52"
DataMemberBinding="{Binding Field 52}" />
<telerik:GridViewDataColumn Header="Field 53"
DataMemberBinding="{Binding Field 53}" />
<telerik:GridViewDataColumn Header="Field 54"
DataMemberBinding="{Binding Field 54}" />
<telerik:GridViewDataColumn Header="Field 55"
DataMemberBinding="{Binding Field 55}" />
<telerik:GridViewDataColumn Header="Field 56"
DataMemberBinding="{Binding Field 56}" />
<telerik:GridViewDataColumn Header="Field 57"
DataMemberBinding="{Binding Field 57}" />
<telerik:GridViewDataColumn Header="Field 58"
DataMemberBinding="{Binding Field 58}" />
<telerik:GridViewDataColumn Header="Field 59"
DataMemberBinding="{Binding Field 59}" />
<telerik:GridViewDataColumn Header="Field 60"
DataMemberBinding="{Binding Field 60}" />
<telerik:GridViewDataColumn Header="Field 61"
DataMemberBinding="{Binding Field 61}" />
<telerik:GridViewDataColumn Header="Field 62"
DataMemberBinding="{Binding Field 62}" />
<telerik:GridViewDataColumn Header="Field 63"
DataMemberBinding="{Binding Field 63}" />
<telerik:GridViewDataColumn Header="Field 64"
DataMemberBinding="{Binding Field 64}" />
<telerik:GridViewDataColumn Header="Field 65"
DataMemberBinding="{Binding Field 65}" />
<telerik:GridViewDataColumn Header="Field 66"
DataMemberBinding="{Binding Field 66}" />
<telerik:GridViewDataColumn Header="Field 67"
DataMemberBinding="{Binding Field 67}" />
<telerik:GridViewDataColumn Header="Field 68"
DataMemberBinding="{Binding Field 68}" />
<telerik:GridViewDataColumn Header="Field 69"
DataMemberBinding="{Binding Field 69}" />
<telerik:GridViewDataColumn Header="Field 70"
DataMemberBinding="{Binding Field 70}" />
<telerik:GridViewDataColumn Header="Field 71"
DataMemberBinding="{Binding Field 71}" />
<telerik:GridViewDataColumn Header="Field 72"
DataMemberBinding="{Binding Field 72}" />
<telerik:GridViewDataColumn Header="Field 73"
DataMemberBinding="{Binding Field 73}" />
<telerik:GridViewDataColumn Header="Field 74"
DataMemberBinding="{Binding Field 74}" />
<telerik:GridViewDataColumn Header="Field 75"
DataMemberBinding="{Binding Field 75}" />
<telerik:GridViewDataColumn Header="Field 76"
DataMemberBinding="{Binding Field 76}" />
<telerik:GridViewDataColumn Header="Field 77"
DataMemberBinding="{Binding Field 77}" />
<telerik:GridViewDataColumn Header="Field 78"
DataMemberBinding="{Binding Field 78}" />
<telerik:GridViewDataColumn Header="Field 79"
DataMemberBinding="{Binding Field 79}" />
<telerik:GridViewDataColumn Header="Field 80"
DataMemberBinding="{Binding Field 80}" />
</telerik:RadGridView.Columns> </telerik:RadGridView> <telerik:RadDataPager x:Name="RadDataPager1" Source="{Binding Items, ElementName=xRadGridView}" PageSize="45" Grid.Row="2" /> </Grid> </UserControl> 0
Hi Kelly,
Ross
the Telerik team
This is an indication that for some reason the TotalItemCount is not reported correctly and thus the pager cannot do its math, i.e. divide the total item count by Page Size 45 in order to calculate its number of pages.
What is the total item count of your data, i.e. how many pages should there be if the PageSize is 45.
If you totally remove the pager, do you see all the data, i.e. more than 45 records?
What is this object called Screen.SNE_TBL_ACT_PEND_FMEs? Does it implement the IPagedCollectionView interface?
You mentioned that if you use the stock DataPager plus the stock DataGrid everything works absolutely correctly and you see a real number of pages? Can you confirm this information?
Unless we have something to debug, it would be really hard for us to understand what is going on on your end. We can only be guessing what is going on there.
Is it possible to prepare some kind of very dummy project that reproduces this behavior? Otherwise we will be simply shooting in the dark.
Ross
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
0
Kelly
Top achievements
Rank 1
Rank 1
answered on 05 Oct 2011, 07:57 PM
Hi Ross,
I am prepairing a Dummy project. Will take me about a day since I want to be sure you get enough data to need paging. Please tell me how to upload the project once it is finished.
Regards,
Kelly
I am prepairing a Dummy project. Will take me about a day since I want to be sure you get enough data to need paging. Please tell me how to upload the project once it is finished.
Regards,
Kelly
0
Hello Kelly,
Ross
the Telerik team
The sample project does not need to have tons of data. For example it can have only 4 rows and PageSize=2 which should produce 2 pages with 2 items each. The algorithm works the same way regardless of the number of pages. In other words, it is not the amount of data that is causing the problem here but the fact that the total item count cannot be deduced for some reason.
When you have the sample project you can open a new support ticket and attach it there.
Meanwhile, I would really appreciate it if you answer all of my questions from my previous post, since this information is very important for me. Here, I will paste them again for your reference:
What is the total item count of your data, i.e. how many pages should there be if the PageSize is 45.
If you totally remove the pager, do you see all the data, i.e. more than 45 records?
What is this object called Screen.SNE_TBL_ACT_PEND_FMEs? Does it implement the IPagedCollectionView interface?
You mentioned that if you use the stock DataPager plus the stock DataGrid everything works absolutely correctly and you see a real number of pages? Can you confirm this information?
I am looking forward to hearing from you.
Ross
the Telerik team
Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>
0
Kelly
Top achievements
Rank 1
Rank 1
answered on 06 Oct 2011, 01:20 PM
Hello Ross,
I'll answer your questions as best as I can. However, today when I tried to open the project, I am getting the following error. Hence, I cannot run the application right now. I tried to reload the Designer, which does not work.
I am dealing with just under 3 million rows of data. The total rows will never be the same from day to day.
When I remove the Pager, I only see one full page of data. That's why I tried to implement the Pager. I couldn't see all the records.
Screen.SNE_TBL_ACT_PEND_FMEs is the application's dataset.
When I use the LightSwitch stock Grid, I can view all the data and it pages without any issues. The purpose for the Telerik Grid is for the filtering capibilities on each row.
Did I answer all your questions?
Regards,
Kelly
I'll answer your questions as best as I can. However, today when I tried to open the project, I am getting the following error. Hence, I cannot run the application right now. I tried to reload the Designer, which does not work.
System.IO.FileNotFoundException Could not load file or assembly 'Microsoft.Silverlight.Testing, Version=2.0.5.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.Assembly.Load(AssemblyName assemblyRef) at MS.Internal.Package.VSIsolationProviderService.RemoteReferenceProxy.LoadAssembly(AssemblyName assemblyName) at MS.Internal.Package.VSIsolationProviderService.RemoteReferenceProxy.System.ComponentModel.Design.IDesignTimeAssemblyLoader.LoadRuntimeAssembly(AssemblyName targetAssemblyName) at Microsoft.VisualStudio.Shell.Design.VsTargetFrameworkUniverse.LoadRuntimeAssembly(AssemblyName assemblyName) at Microsoft.VisualStudio.Shell.Design.VsTargetFrameworkUniverse.ResolveAssemblyFromRuntimeLocation(AssemblyName name) at Microsoft.VisualStudio.Shell.Design.VsTargetFrameworkUniverse.ResolveAssembly(Module scope, Token tokenAssemblyRef) at Microsoft.MetadataReader.MetadataOnlyModule.ResolveTypeRef(ITypeReference typeReference) at Microsoft.MetadataReader.MetadataOnlyTypeReference.GetResolvedTypeWorker() at Microsoft.MetadataReader.TypeProxy.GetResolvedType() at Microsoft.MetadataReader.TypeProxy.GetHashCode() at Microsoft.Windows.Design.Metadata.ReflectionMetadataContext.GetTypeForReflectableType(Reflectable`1 reflectableType) at MS.Internal.Metadata.ClrType.GetTypeMetadata(Type type) at MS.Internal.Metadata.ClrType.get_BaseType() at MS.Internal.Design.Metadata.Xaml.XamlType.<GetAllAttachableProperties>d__7.MoveNext() at MS.Internal.Design.Metadata.Xaml.XamlType.<FindAttachableProperties>d__0.MoveNext() at Microsoft.Windows.Design.Metadata.Xaml.XamlExtensionImplementations.<FindAttachableProperties>d__7.MoveNext() at MS.Internal.VirtualModel.VirtualModelPropertyCollection.<GetUncachedProperties>d__0.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at MS.Internal.VirtualModel.VirtualModelPropertyCollection.GetEnumerator() at MS.Internal.VirtualModel.VirtualModelUtilities.WrapProperties(IVirtualModelItem item) at MS.Internal.VirtualModel.VirtualModelItem.System.ComponentModel.ICustomTypeDescriptor.GetProperties() at System.ComponentModel.TypeDescriptor.MergedTypeDescriptor.System.ComponentModel.ICustomTypeDescriptor.GetProperties() at System.ComponentModel.TypeDescriptor.GetPropertiesImpl(Object component, Attribute[] attributes, Boolean noCustomTypeDesc, Boolean noAttributes) at System.Windows.PropertyPath.ResolvePropertyName(String name, Object item, Type ownerType, Object context, Boolean throwOnError) at MS.Internal.Data.PropertyPathWorker.GetInfo(Int32 k, Object item, SourceValueState& svs) at MS.Internal.Data.PropertyPathWorker.ReplaceItem(Int32 k, Object newO, Object parent) at MS.Internal.Data.PropertyPathWorker.UpdateSourceValueState(Int32 k, ICollectionView collectionView, Object newValue, Boolean isASubPropertyChange) at MS.Internal.Data.ClrBindingWorker.AttachDataItem() at System.Windows.Data.BindingExpression.Activate(Object item) at System.Windows.Data.BindingExpression.AttachToContext(AttachAttempt attempt) at System.Windows.Data.BindingExpression.AttachOverride(DependencyObject target, DependencyProperty dp) at System.Windows.Data.MultiBindingExpression.AttachBindingExpression(Int32 i, Boolean replaceExisting) at System.Windows.Data.MultiBindingExpression.AttachOverride(DependencyObject d, DependencyProperty dp) at System.Windows.Data.BindingExpressionBase.Attach(DependencyObject target, DependencyProperty dp) at System.Windows.Data.BindingExpressionBase.OnAttach(DependencyObject d, DependencyProperty dp) at System.Windows.DependencyObject.SetValueCommon(DependencyProperty dp, Object value, PropertyMetadata metadata, Boolean coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType operationType, Boolean isInternal) at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value) at System.Windows.Data.BindingOperations.SetBinding(DependencyObject target, DependencyProperty dp, BindingBase binding) at System.Windows.FrameworkElement.SetBinding(DependencyProperty dp, BindingBase binding) at MS.Internal.GridControl.GridRowAdornerBase..ctor(ModelItem gridItem, ModelItem rowItem) at MS.Internal.GridControl.GridRowSelectAdorner..ctor(ModelItem grid, ModelItem row) at MS.Internal.GridControl.GridDesigner.EnsureRowAdorners(ModelItem rowDefModel, Boolean withHandle) at MS.Internal.GridControl.GridDesigner.EnsureAllRowAdorners() at MS.Internal.GridControl.GridDesigner.InitGridDesigner() at MS.Internal.GridControl.GridDesigner.GetDesigner(ModelItem gridItem) at MS.Internal.GridControl.AlwaysVisibleGridAdornerProvider.Activate(ModelItem item) at Microsoft.Windows.Design.Interaction.AdornerProvider.InvokeActivate(EditingContext context, ModelItem item) at MS.Internal.Features.AdornerProviderFeatureConnector.FeatureProvidersAdded(ModelItem item, IEnumerable`1 extensions) at Microsoft.Windows.Design.Policies.PolicyDrivenFeatureConnector`1.UpdateFeatureProviders() at MS.Internal.Features.PolicyDrivenToolFeatureConnector`1.UpdateCurrentTool(Tool newTool) at MS.Internal.Features.PolicyDrivenToolFeatureConnector`1.<.ctor>b__0(Tool newTool) at Microsoft.Windows.Design.ContextItemManager.SubscribeProxy`1.SubscribeContext(ContextItem item) at Microsoft.Windows.Design.SubscribeContextCallback.Invoke(ContextItem item) at Microsoft.Windows.Design.EditingContext.DefaultContextItemManager.OnItemChanged(ContextItem item) at Microsoft.Windows.Design.EditingContext.DefaultContextItemManager.SetValue(ContextItem value) at MS.Internal.Host.ToolSubsystem.ActivateTool(ToolFactory toolFactory) at MS.Internal.Host.ToolSubsystem..ctor(EditingContext editingContext, DesignerContext designerContext) at MS.Internal.Host.Designer.Load() at MS.Internal.Designer.VSDesigner.Load() at MS.Internal.Designer.VSIsolatedDesigner.VSIsolatedView.Load() at MS.Internal.Designer.VSIsolatedDesigner.VSIsolatedDesignerFactory.Load(IsolatedView view) at MS.Internal.Host.Isolation.IsolatedDesigner.BootstrapProxy.LoadDesigner(IsolatedDesignerFactory factory, IsolatedView view) at MS.Internal.Host.Isolation.IsolatedDesigner.BootstrapProxy.LoadDesigner(IsolatedDesignerFactory factory, IsolatedView view) at MS.Internal.Host.Isolation.IsolatedDesigner.Load() at MS.Internal.Designer.DesignerPane.LoadDesignerView(Boolean isReload) I am dealing with just under 3 million rows of data. The total rows will never be the same from day to day.
When I remove the Pager, I only see one full page of data. That's why I tried to implement the Pager. I couldn't see all the records.
Screen.SNE_TBL_ACT_PEND_FMEs is the application's dataset.
When I use the LightSwitch stock Grid, I can view all the data and it pages without any issues. The purpose for the Telerik Grid is for the filtering capibilities on each row.
Did I answer all your questions?
Regards,
Kelly