Need to Export Data using Adding RadGridView to a LightSwitch Solution

[Kelly]

Hi,

I completed the tutorial Adding RadGridView to a LightSwitch Solution.  I now need to create a button that will download data in .csv and Excel format.  How would I go about doing this?

Regards,

Kelly

[Vlad]

Hi Kelly,

 Have you tried our exporting demo?

All the best,
Vlad
the Telerik team

[Kelly]

Hi Vlad,

Thanks for the demo link.  Before I can download my data, I realized that I can't see all the data on the screen.  I need a paging control.  I am following Paging Large Data Demo.  When I paste in the XAML Editor  

<telerik:RadDataPager PageSize="100" Grid.Row="1" Source="{Binding Items,
ElementName=GridView}" IsTotalItemCountFixed="True"
DisplayMode="FirstLastPreviousNextNumeric, Text" />

The Pager control displays; however when I run the application, I get the following error:

 

<P dir=ltr align=left>System.IO.FileNotFoundException</P>
<P dir=ltr align=left>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.</P>
<P dir=ltr align=left>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.Designer.PropertyEditing.Model.Properties.ModelPropertyMerger.<GetFirstProperties>d__0.MoveNext()
at
MS.Internal.Designer.PropertyEditing.Views.PropertyEntryReader.RedraftEntries(IPropertyViewManager
viewManager, Selection selection, Boolean attachedOnly, IEventCodeBehindProxy
eventCodeBehindProxy, CategoryList categoryList) at
MS.Internal.Designer.PropertyEditing.PropertyInspector.UpdateCategories(Selection
selection, Boolean attachedOnly, IEntryReader entryReader) at
MS.Internal.Designer.PropertyEditing.PropertyInspector.RefreshPropertyList(Boolean
attachedOnly) at
MS.Internal.Designer.PropertyEditing.PropertyInspector.OnCurrentViewManagerChanged(Object
sender, EventArgs e) at
MS.Internal.Designer.PropertyEditing.PropertyToolBar.OnCurrentViewManagerChanged(DependencyObject
obj, DependencyPropertyChangedEventArgs e) at
System.Windows.DependencyObject.OnPropertyChanged(DependencyPropertyChangedEventArgs
e) at
System.Windows.FrameworkElement.OnPropertyChanged(DependencyPropertyChangedEventArgs
e) at
System.Windows.DependencyObject.NotifyPropertyChange(DependencyPropertyChangedEventArgs
args) at System.Windows.DependencyObject.UpdateEffectiveValue(EntryIndex
entryIndex, DependencyProperty dp, PropertyMetadata metadata,
EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, Boolean
coerceWithDeferredReference, Boolean coerceWithCurrentValue, OperationType
operationType) 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
MS.Internal.Designer.PropertyEditing.PropertyToolBar.OnGlobalPropertyViewManagerRestored(Object
sender, EventArgs e) at
MS.Internal.Designer.PropertyEditing.State.PropertyViewStateContainer.RestoreState(Object
state) at
MS.Internal.Designer.PropertyEditing.State.AggregateStateContainer.RestoreState(Object
state) at
MS.Internal.Designer.PropertyEditing.PropertyInspector.set_SessionState(Object
value) at
MS.Internal.Designer.PropertyEditing.PropertyInspectorHost.CommandElementHost.set_SessionState(Object
value) at
MS.Internal.Designer.VSIsolatedViewFactory.VSIsolatedView.set_SessionState(Object
value) at MS.Internal.Designer.IPropertyInspectorState.set_SessionState(Object
value) at
MS.Internal.Package.PropertyBrowserPane.PropertyBrowserIsolatedViewHolder.OnContentChanged(IsolatedView
oldContent) at
MS.Internal.Host.Isolation.IsolatedViewHolder.SetContent(IsolatedView view) at
MS.Internal.Host.Isolation.IsolatedViewContext.set_Item(Guid key, IsolatedView
value) at MS.Internal.Designer.DesignerPane.LoadDesignerView(Boolean
isReload)<BR></P>

Your help is appreciated!

Regards,

Kelly