Xceed DataGrid for Silverlight

DataGridComboBox Binding to Signed and Unsigned Key Values

Steve — Mon, 29 Oct 2012 04:50:30 GMT

I am having problems using the DataGridComboBox editor in the Silverlight DataGrid v2.0.12461.12470.

The data source for the grid is an ObservableCollection of a custom class. One column in the grid is data type Int32 which is used as an enumeration. I provide a CellEditorTemplate similar to some of the examples and handle the ActivatingCellEditor event for the enumeration column. The ActivatingCellEditor handler uses the event arguments to set the DataGridComboBox editor ItemsSource to a Dictionary(Of UInt32, String). SelectedValuePath is set to "Key" and DisplayMemberPath is set to "Value".

Problem: When the DataGridComboBox editor is initially displayed, the selected item is Nothing (a blank entry at the beginning of the pulldown list). It should be the value associated with the current Int32 value in the grid. When I make a new selection in the DataGridComboBox, the new value is correctly updated in the ObservableCollection.

I have discovered that if I change the column data type to UInt32, the DataGridComboBox editor pulldown selected item gets initialized to the current grid value (that's good), but when a new item in the pulldown is selected, the changes do not get written back to the ObservableCollection.

Therefore, it seems like DataGridComboBox data binding only works with unsigned integers in one direction and only works with signed integers in the other direction. I did not have this problem with previous version of the grid, however, a lot of my application code has changed since the last grid release.

I have tried all combinations of ItemsSource as a Dictionary(Of Int32/UInt32, String) and column data type Int32/UInt32. In all cases, data binding will not work in both directions.

It seems like there should be an easy solution, but I have not found it. Any help would be appreciated.

making a DataCell read only?

HoooKnew — Wed, 28 Nov 2012 15:21:06 GMT

How can I make a DataCell read only in the grid? It looks like the wpf grid has a readonly property on the cell, but the silverlight one does not. Thanks.

Help with help

Stephen — Fri, 28 Sep 2012 16:46:54 GMT

I read this: http://xceed.com/CS/forums/thread/26706.aspx after I installed everything.

It says that I need to manually import the help files now. It also says that they are 'located in the installation packager under "Documentation"'.

"Hmmm", I think, "I don't have an 'installation packager' that I know of. I just downloaded the exe installer."

So I tried un-packaging that. But there was no Help files in there (that I could find.)

I would like some clarification on this. Specifically: If I only downloaded an setup exe file, how do I get the documentation installed now that I have set my help setting to search local?

NOTE: It may be a good idea to update the thread I referenced above with the answer.

How to display a forign-key column?

lee — Fri, 14 Sep 2012 09:44:40 GMT

Hi,
Now I'm trying to bind data to datagrid and meet some problem about forign key column. I use ADO.NET Entity Framework and Domain Service Class to build o/r mapping to database. I have 2 tables: Module and Channel and there is a forign key between them(Channel table has a column " Module_Id" pointing to Module ). So I've got an entity like this:

public partial class Channel
{

        // This class allows you to attach custom attributes to properties
        // of the Channel class.
        //
        // For example, the following marks the Xyz property as a
        // required property and specifies the format for valid values:
        //    [Required]
        //    [RegularExpression("[A-Z][A-Za-z0-9]*")]
        //    [StringLength(32)]
        //    public string Xyz { get; set; }
        internal sealed class ChannelMetadata
        {

            // Metadata classes are not meant to be instantiated.
            private ChannelMetadata()
            {
            }

public string Description { get; set; }

public int Id { get; set; }

public Module Module { get; set; }

public Nullable<int> Module_Id { get; set; }

public string Name { get; set; }

public string No { get; set; }

            public EntityCollection<Variable_Channel> Variable_Channel { get; set; }
        }
    }

I can bind the result queryed by LINQ to Entity to a datagrid by using FieldName:

public IQueryable<Channel> GetChannelByModuleId(int moduleId)
        {
            var Channels = from o in this.ObjectContext.Channel
                           where o.Module_Id == moduleId
                           select o;
            return Channels;
        }

<sldg:DataGridControl Margin="8,239,8,41" x:Name="netflixGrid" AutoCreateColumns="False" d:LayoutOverrides="HorizontalAlignment">
                            <sldg:DataGridControl.Columns>
                            <sldg:Column FieldName="Name" Title="Name" />
                                <sldg:Column FieldName="Module_Id" Title="MId" />
                                <sldg:Column FieldName="Module.Name" Title="MName" />

                            </sldg:DataGridControl.Columns>
                        </sldg:DataGridControl>

The second column "Module_Id" can display a Module's Id correctly. But the third column display nothing. I just want to make it display a Module's Name but I don't know how to do it. Could anybody help me? Thanks!
I'm looking forward to your reply, thanks!

Automatically selecting FilterOperator when initially typing data into FilterCell

Steve — Sat, 14 Jul 2012 19:20:48 GMT

I have a Silverlight data grid with a filter row. The filter row contains both string and combobox filters. I want to automatically select a filter operator for a column when the user initially enters a filter value.

Two examples:

Column of type String. User types first character into FilterCell. I want to automatically select the StartsWith FilterOperator.

Enumeration column with a combo box filter cell. User makes initial filter selection on combo box. I want to automatically select the Equal FilterOperator.

In grid version 1.4, I handled the FilterRow LayoutChanged events and checked to see if there were any FilterCells where the value was set, but no operator was selected. In those cases, I set my default FilterOperator for the column.

The problem is that version 2.0 of the grid no longer exposes the FilterCell collection. I see the FilterExpression property and learned how to create child FilterExpressions to set the FilterOperators for each column. Since the FilterCell collection is no longer exposed in the 2.0 grid, I don't have a way to determine which FilterCells have content that is not Nothing, but don't have a FilterOperator selected.

I have a partial solution that handles the FilterRow TextInputStart event and uses the data grid CurrentColumn property. It does not work for the combobox columns. I don't seem to have any way to determine when a user has made a selection in a combobox FilterCell, but has not selected a FilterOperation. Note that the column's FilterExpression is not created until both the FilterOperator and the filter value are entered, so no help there.

Would it be possible to bring back the FilterCell collection as public ReadOnly property in the 2.0 grid? It would seem to solve my problem. Maybe there is an easier way I am missing?

WPF build of the Silverlight DataGrid

Teddy — Mon, 20 Aug 2012 19:57:03 GMT

Hi,

I've seen a couple of posts that mention that there will be a WPF build of the Silverlight datagrid, dating back 2 years ago. I haven't been able to find such a build anywhere. Is this available, yet?

The reason I ask is that I work on a project where we share code between Silverlight and WPF. Our current vendor's datagrid works the same in both Silverlight and WPF (same namespace, properties, etc.), so we're able to share the xaml between solutions. Is this at all possible with the Xceed datagrids?

Endless Progress Loader

Justin — Wed, 01 Aug 2012 00:38:11 GMT

Whenever I add the silverlight datagrid to my project I wind up getting nothing but an endless loader:

http://ediviewer.maisto.com/Sample/sample.html

Even if I create a new project and do nothing but drop in the datagrid, this is the result. Remove the datagrid and all it well again. It's hanging up within InitializeComponent() while trying to load the datagrid. I loaded the trial key and it still does it.

Any help would be appreciated!

EDIT:

Like a dummy I blew out the sample while developing. I put it in its own folder now. If you tried before and the link didn't work, it should work now.

Iterating Through Filtered Silverlight Datagrid Rows

Steve — Tue, 17 Jul 2012 19:07:37 GMT

I have a Silverlight Datagrid conencted to a local data source. I have applied various filter criteria through a FilterRow. In code behind, I would like to obtain a list of the rows that passed the filter criteria.

My first approach was to reapply the FilterRow's FilterExpression at the grid level and handle the grid's filter event. According to the documentation, the Filter event will only be raised for items that have not already been excluded by the filter. I found the Filter event was being raised for all rows and not just the rows I wanted.

My alternate approach is to convert the FilterExpression and all child filter expressions to a Linq query which I would then apply to my underlying data source (separate from grid operations). My grid displays approximately 14 columns, all of which may have a filter criteria. I only need a list of the primary keys (1 column) for rows that pass the filter criteria.

Is the strategy of converting the FilterExpression to a Linq query the best approach? It seems like the grid is already able to internally iterate through the filtered rows to calculate the statistical functions. Is there some StatContext property I might be able to use to obtain a list of filtered rows? (I have looked, but didn't find anything).

Silverlight Themes

Andreas — Mon, 27 Feb 2012 21:16:35 GMT

Hi,

I am using your Professional Themes for WPF but will now move onto Silverlight. It seems you don't have an equivalent product for Silverlight, but the features section of your Silverlight grid has this comment:

=======================================

Supports implicit styles, so the entire app can be styled in minutes with a couple of lines of code. Also supports explicit styles

=======================================

Does that mean that if I buy your Silverlight grid I can use the themes from there to style the rest of my Silverlight app?

Thanks

CellContentTemplate problems with v2.0

Peter — Mon, 16 Jul 2012 23:58:43 GMT

Hi,

I have been using DataGrid v1.4 for Silverlight and have the following working;

<sldg:Column FieldName="WorkTypeCode" Title="Work Type" Width="100" CellContentTemplate="{StaticResource workTypeTemplate}"></sldg:Column>

</DataTemplate>

<convertors:WorkTypeConvertor x:Key="workTypeConvertor" />

In v1.4 it used to send the contents of the column, eg. "FULLTIME" to the convertor, which would convert it to "Full Time".

I've just upgraded to v2.0 and now it's sending the entire row, which I can work around for now because I can get the column I need from the row and then return the required description. However, as I use the converter in multiple locations, which rows of different types, I'll have to setup the converter for each grid it is used in. How do I get around this?

Pete

Binding ReadOnly Property of a Column

Juerg — Thu, 12 Aug 2010 09:48:59 GMT

Hi,

Is there a way to bind the readonly property of a column depending on a property value of the underlying dataobject?

eg:

the dataobject has the properties category A and category B. If category A has a certain value, let's say 1, the user is allowed to edit category B in the grid. Therefore the dataobject has a bool property called "has_category_A_value_1" which returns true if A equals 1:

<sldg:column FieldName="categoryA"/>

<sldg:column FieldName="categoryB" ReadOnly="{Binding has_category_A_value_1" />

if this kind of binding is not possible, is it possible to somehow tell the ActivatingCellEditor function not to show up the editcontrol?

thanks

ComboBoxCellEditor and keyboard

Reinhard — Fri, 06 Apr 2012 23:29:09 GMT

Hello

Is it possible to enable keyboard support for a ComboBoxCellEditor similar to a combobox cell editor in he WPF Datagrid?

Regards,

Reinhard Schuerer

nascom GmbH

Memory Usage & Performance

JIbach — Tue, 29 May 2012 21:01:33 GMT

The grid appears to be consuming a great deal of memory for comparatively small data sets.

As an example:

A data set (fetched from an RIA service) containing 12 columns (3 string, 4 DateTime, 5 int) and 13k rows takes 12-13 seconds to be usable. Using the standard Silverlight datagrid, this process takes closer to 1 second (illustrating that record transfer time is not the limiting factor.) After loading the data, the Xceed grid has consumed an additional 170 MB of memory. Scrolling through this grid is also not as smooth as might be expected.

I understand that the grid has to process the data to a degree in order to enable rapid sorting and grouping, but this seems excessive...

For my project, I really only need the grouping and sorting capabilities of the grid. Features like smooth scrolling, animations, etc. are unnecessary. Are there any features I can disable/tweak on the grid in order to improve performance? Are there any best practices I can follow with my data set to improve its performance with the grid?

At the moment the grid in my application is totally unmodified, and all the columns are completely vanilla (no templates, converters, etc.)

Thanks for the help!

Paste directly from Excel into DataGrid

Nick — Fri, 04 May 2012 21:18:56 GMT

Is it possible to take data from excel, assuming all of the cols line up, and paste it directly into the Xceed DataGrid?

Row Styling Based on Row Content

JIbach — Wed, 02 May 2012 19:07:35 GMT

Hi there,

I'm sure there's some simple method I'm missing, but here's my problem:

How can I change a row's background color based on the value of data in that row? (E.g. In a grid listing an inventory of parts, change the background of the rows that have 0 parts in stock.)

It seems relatively easy to do in WPF since you have access to RelativeSource.Self in the style templates, but AFAIK that's not available in Silverlight.

I'd thought about iterating through the grid manually or harnessing the OnLoadingRow event, but the former is cumbersome and the latter doesn't even seem to be an option for the Xceed DataGrid.

Any help would be appreciated.

AsyncSqlDataSourceProvider with dynamic SQLs

Andreas — Mon, 27 Feb 2012 22:00:24 GMT

Hi,

The SQL for our wpf grids are designed at runtime in what we call a "grid designer". Would it be possible to use your new AsyncSqlDataSourceProvider and pass runtime created SQLs to it? The SQL would then be passed on to the underlying SQL server database and the result returned and shown in the grid?

Thanks,

Andreas

Deleting rows

Richard — Fri, 25 Nov 2011 16:32:25 GMT

Is there any way to allow the user to delete a row from the DataGrid?

Filtering in Xceed Datagrid using RemoteListDataSource

Rajat — Tue, 17 Jan 2012 13:35:03 GMT

Hello,

I am using RemoteListDataSource to bind the data with xceed silverlight datagrid, sorting is working, grouping is also working but when i am using the filtering option with :

<sldg:DataGridControl.FixedHeaders>

<sldg:FilterRow >

</sldg:FilterRow>

</sldg:DataGridControl.FixedHeaders>

The grid is not showing the template values(Equal, Not Equal, Greater Then, etc) for filtering.

Is that the limitation with remote data source or you have any other way to show filtering options.

If the filtering is possible then please tell me the way and if not then please let me know the exact reasons.

Quick answer will be appreciated as I have stucked at the part.

Thanks in advance.

With Regards,

Rajat Barik

how to Update datagrid content on addition or removal of list item

Greg — Fri, 25 Nov 2011 19:13:59 GMT

Hey guys i have 2 datagrids in my project, the content of one depends on the selected index of the other. This part works fine. The part that im having trouble with is getting the independent datagrid to update its content when i use a button's event to remove an item from the list which is the grid's itemsource. The grid displays a list of file which i've copied to a folder in the application directory. The file is removed as it should be, but to see the effect in the grid i have to change the sort or move a column. Is there a method or some way i can update the content from the button event right after i remove the file?

Loading Icon / Graphic

Jon — Thu, 08 Dec 2011 21:05:00 GMT

I am looking at the demos on the Xceed site, and in all of them when data is being retrieved (load / scroll) a nice circular loading graphic is displayed.

This does not happen on my grid. I am using code pretty much exactly like the RIA services demo. On page load I make my call and set the grid itemssource. But the grid just stays blank (no icon) and then the rows appear a few seconds later...

I am using version 1.4. Can someone point me in the right direction?

WPF version : Insertion row bug

Richard — Fri, 25 Nov 2011 16:31:43 GMT

In the WPF version of this control, clicking on the insertion row does not display the cell editors. To make the editors appear, you must:

Click on the insertion row;
Resize the column;
Click on the insertion row again.

Also, the cell editors do not fill the cell; there is a gap on both sides.

Am I missing something?

Print Grid Content

Reza — Fri, 18 Nov 2011 00:35:23 GMT

Hi,

Is it possible to print the contents of the grid similar to the WPF version of the grid?

thx

Headless Testing

Mike — Tue, 27 Sep 2011 16:15:18 GMT

Hello,

I'm looking for some guidance on how to proceed. We are using the SL DataGridControl to display query results from a server and are making use of virtualization. Everything works fine when running our application; however, we would like to write scenario-type tests that run these queries from the viewmodel layer. These tests are run without a view and are intended to execute the same code path (from the viewmodel down) that the application takes. For example a simple test might create the viewmodel that is the DataContext for the DataGridControl, set some query parameters, execute an ICommand to run the query and verify a results set.

The issue we're running into is that we are using an AsyncDataSourceProvider to query the server and since we are using virtualization and running headless, the data provider's overrides are never invoked (e.g. BeginExecuteDataQuery, etc.). Is there a way to turn off virtualization or force fetching data in these circumstances? Also, please let me know if I've omitted any crucial information here. Unfortunately I am not the developer who integrated the Xceed controls into our app so I'm picking this up as I go.

Thanks for any assistance you can offer.

change highlight color in cell editor

netdev — Mon, 26 Sep 2011 01:37:25 GMT

how do i do this?

ive tried to change it in the CellEditor style but the property does not exist. I am assuming hasto do with textbox property

<Style x:Key="shipperCellEditorStyle" TargetType="sldg:TextCellEditor"

BasedOn="{StaticResource SignatureThemeCellEditoStyle}">

</Style>

How to Persist grid settings per session

rajat — Thu, 18 Aug 2011 10:31:38 GMT

Hi,

We have a requirement to persist grid settings that are changed by the users e.g. column width, sort etc. Similar kind of functionality is available in WPF. But i was unable to find the same in silverlight datagrid.

How do I persist grid settings in Silverlight Datagrid?

Thanks

Rajat

Dynamic grid size

Michael — Thu, 21 Jul 2011 14:13:14 GMT

I have placed the Silverlight grid in a dynamic layout (i.e. a grid that resizes based on available space). However, when running in debug mode the grid displays the following warning message:"The grid cannot work properly if it is used in an unconstrained environment ... it is best that you explicitly set its size."

How then can I use the grid if I want it to resize as most UI layouts have dynamic components to them? I notice that despite the displayed message, the grid behaves as expected: it resizes the screen or other elements on the screen are resized.

Thanks

Unhandled exception which makes Xceed unusable

Dhananjaya — Wed, 20 Jul 2011 09:38:30 GMT

I am using Xceed Datagrid on a Silverlight Navigation Page and I get the below unhandled exception when I navigate into the page from 2nd time onwards. The very first time I navigate into this page everything works fine but throws the following exception 2nd time onwards. This keeps throwing the same exception everytime I navigate into this page. The only option available after I get this exception is to refresh the browser (which reloads the silverlight application) at which time It starts working fine but only the first time around.

Unable to cast object of type 'MS.Internal.ManagedObjectReference' to type 'Xceed.Silverlight.DataGrid.DataGridGroupConfigurationSelector'.

at Xceed.Silverlight.DataGrid.DataGridControl.get_GroupConfigurationSelector()

Here's the codes snippet where the exception occurs in DataGridControl.cs

public DataGridGroupConfigurationSelector GroupConfigurationSelector
    {
      get
      {
        return ( DataGridGroupConfigurationSelector )this.GetValue( DataGridControl.GroupConfigurationSelectorProperty );
      }
      set
      {
        this.SetValue( DataGridControl.GroupConfigurationSelectorProperty, value );
      }
    }

ComboBoxCellEditor filtering values depending on value of another cell of the same row

Reinhard — Tue, 14 Jun 2011 22:19:03 GMT

Hello

I need to filter the values of a ComboBoxCellEditor depending on the value of another cell of the same row.

A simplified view of the datagrid:

ID Customer Projects

1 3000 Project of Customer 3000

2 4000 Project of Customer 4000

Depending on the selection of the customer row, the values of the projects row should be filtered to show only the projects of the selected customer.

I have the same grid in a WPF application using Xceed DataGrid for WPF where this works.

First I tried it in the ActivatingCellEditor event, but this event fires when displaying the grid not when the user activates the cell for editing.

Next I tried to subclass the ComboBoxCellEditor and tried to set the ItemSource within the GetFocus event, this works for filtering the data but with this the ComboBoxCellEditor can't save the selected value. If I remove the setting of the ItemSource the subclassed ComboBoxCellEditor works as the original.

It seems that setting the ItemSource causes the unselection and when the user selects a value of the combobox it refires the GetFocus event.

How could this prevented or where else to set the ItemSource?

Regards,

Reinhard

How to show the sum of column in footer xceed grid

Gautam — Thu, 02 Jun 2011 06:50:28 GMT

how can i show the sum of column in footer.

Xceed Datagrid loses the ColumnManager row if NavigationCacheMode Enabled

Dhananjaya — Mon, 18 Apr 2011 10:08:41 GMT

Hi,

We are using Silverlight Navigation Application and have enabled CacheMode as we want to avoid loading pages all over again. The Xcced data grid works fine the first time around but loses the column manager row (becomes invisible) when I navigate to a different page and come back to original page (the EnableCacheMode set to enabled on the original page). I can still see the rows but lose the ability to search, filter, sort as I no longer have the column manager row (header). Could you please let me know if this is a bug or if there are any workarounds. I am using the v1.2 and am a Vanguard customer.

Change a row's datatemplate layout when user select it

Wang — Wed, 20 Apr 2011 12:55:55 GMT

My requirement is that we want to show a bigger picture and more some more detail information for a dataRow when user selects it.

But it seems that the DataGridControl requires that all the rows to have the same height such that when one row's height grows, all the other row's height also grows.

Is this a limitation of the grid?

Binding Grid at runtime

Paul — Wed, 10 Nov 2010 16:23:03 GMT

When I look at the documentation and examples I see no examples for code behind binding.

Using vs 2010 vb.net

I am currently testing the dataset/dataview silverlight controls http://silverlightdataset.net/silverlightdataset/Default.aspx

and here is the code that binds

With Me.dg

            .BeginInit()
            .ItemsSource = dv.GetBindableData(m_Connector)

              .EndInit()

End With

the correct number for rows are in the grid after binding, but all the cell values are empty.

Is this the correct procedure to bind at runtime?

Thanks.

turning off stickiness (column title space issues)

Jeff — Wed, 12 Jan 2011 18:09:31 GMT

I have a lot of narrow columns, and don't need the stickiness feature. Even if I set "StickyColumnToggleButtonVisibility" to "Never" on every column, it still appears to reserve the space that it would have used for the sticker control causing my column headers not to fit/center like they should. It seems to me like there should be an easy way to deal with this, but thus far I have been unable to find a workaround. Any suggestions?

feature suggestion for filtering

Jeff — Tue, 11 Jan 2011 19:17:58 GMT

It would be nice if the default drop down filter selection for columns bound to a DateTime had a BETWEEN operator in addition to the other ones that are already there.

FWIW, the new grid works nicely bound to a WCF Data Service - virtualized grouping and filtering with no code on my part is totally sweet!

How does DataGrid support Thumnails View like in windows explorer

Wang — Sun, 27 Mar 2011 01:19:47 GMT

Is this possible? That is to have multiple data items on a single line and wraps.

How do I bind dynamic data to Xceed Grid?

Andrew — Wed, 09 Mar 2011 20:25:00 GMT

Hi,

Just wondering if there's a good way to bind dynamic data to Xceed Grid? We have an Excel-like application in which we do not know table structure at compile time. One of the possible solutions is using the Lightweight DataTable approach (http://blogs.telerik.com/vladimirenchev/posts/09-04-23/lightweight_datatable_for_your_silverlight_applications.aspx), but is appears to be quite kludgy to me (I can foresee problems with memory consumption since the generated assemblies won't be unloaded, poor synchronization when adding/deleting columns, etc). The data size could be up to thousands of columns and millions of rows, so performance is critical here.

Any suggestions?

Cheers,
Andrew

How to notify grid the growth of data as more more rows is available

Wang — Fri, 11 Mar 2011 17:28:49 GMT

I am trying to implement AsyncDataSourceProvide and I have a thread which pulls in data in the background when new data appears.

But how do I notify the grid that more rows are coming in and need to update.

Fixed Headers disappearing

Yezdi — Wed, 19 Jan 2011 15:05:09 GMT

Hi XCeed,

In my SL application i have multiple tabs and in one of the tabs i have a XCEED grid. Nothing fancy, but when I switch from the tab having the XCEED grid to another and come back the fixed headers are gone. Please advise.

Regards,

Yezdi

Insertionrow runtime cell value

Paul — Sun, 20 Feb 2011 16:20:28 GMT

I have a case where the user clicks on a templated column button in the insertion row, which then opens a lookup list to select valid value(s) for another field(s) in the insertion row. once the user selects that value I want to be able to set the related field(s) with the value(s) .

I am able to find the insertion row from the button click. I am just wondering how to properly set the cell values after the user selects data in that insert row.

Thanks

How to cause a grid refresh query to the remote data server (ODATA)

Alfred — Sat, 19 Feb 2011 21:08:09 GMT

Hi,

Evaluating the product.

Let's say the user was viewing the Netfilx ODATA catalog in your Silverlight DataGrid and scrolling around. Let's say the catalog was updated on the server.

When or how would the DataGrid reflect those server updates or would they never be reflected? Would the user have to "scroll" back or forward so many rows to see the changes?

Resetting the entire DataContext seems like a poor option?

Am I missing something or is there a simple way to refresh the Grid with the Remote Data?

Thanks,

APD

copy and paste into excel

Jeff — Thu, 03 Feb 2011 19:58:00 GMT

I've got a readonly grid bound to a WCF data service and would like to be able to copy one or more selected items out of it onto the clipboard and then paste into Excel. The CopyPasteDragDrop example seems needlessly complicated and convoluted - is there a simpler way to configure the grid to just allow simple copy and paste via the clipboard? I can live with having to paste into Notepad as CSV or XMLSS as in interim step if need be, but it would be nicer if you could just paste into Excel natively.

Hiding the Row Selector

Paul — Fri, 04 Feb 2011 13:55:03 GMT

I am working on a Project to transform the Grid into a vertical toolbar with a custom user button as datatemplates, but I cannot find a way to remove the row selector from the grid.

How do I access the row selector to disable it from showing?

Thanks.

Combobox as filter

JohnnyT — Sat, 25 Dec 2010 21:32:08 GMT

Hello,

I'm trying to change my filter from a regular text box to a combo box selection like the filtering example on the demos section but i cant figure out how to do it...

Anyone managed to do it and can provide some tips?

Thanks ;)

GroupByCollectionChanged event

Jeff — Tue, 01 Feb 2011 22:12:46 GMT

I've often wished that the default grid behavior would be that when you drop a column into the group by area, it would automatically set its width to zero in the grid and vice versa when you remove it from the group by area it would put the width back to like before. One of your competititors silverlight grid exposes a GroupByCollectionChanged event that makes it easy to do this, but I don't see anything like this in your documentation.

Any thoughts on how to achieve this easily?

Removing the "Drag a column header here to group by that column"

Samuel — Fri, 14 Jan 2011 15:03:43 GMT

Hi,

I am trying to remove this title from the Datagrid but I cannot find which property is used for this. I did a search in the entire solution for that string but I couldn't find anything.

Help please.

datatemplate binding property

Paul — Mon, 13 Dec 2010 22:26:33 GMT

I have a datatemplate that has the binding property set to a field in the datasource

"{Binding PartCode}" it uses a textblock to display text in stack panel where PartCode is field name.

when assigning the datatemplate to and unbound grid column there is no text, but other items in stack panel show that are not databound.

if I run the same template with ms grid it works fine and displays the text.

Is this a bug?

the entire template:

<Button FontSize="9" Height="18" HorizontalAlignment="Left" Margin="0,0,0,0"

x:Name="btnPDF" VerticalAlignment="Top" Click="btn_DownloadPDF_Click">

<TextBlock Text="{Binding PartCode}" x:Name="PDFText" HorizontalAlignment="Right" Margin="6,0,0,0"

VerticalAlignment="Center" Foreground="Black"/>

</StackPanel>

<ToolTipService.ToolTip>

</ToolTipService.ToolTip>

</Button>

</DataTemplate>

the column bind

<sldg:Column FieldName="DownloadPDF"

Title="" Width="50"

CellContentTemplate ="{StaticResource buttonPDF}"/>

WCF Ria Services Maximum URI Length Exceeded

Calvin — Thu, 09 Dec 2010 02:09:31 GMT

I’m attempting to use the WcfRiaServicesDataSourceProvider with a larger dataset (comprised of 41 columns).

I’m seeing this error:

Unhandled Error in SilverlightApplication The maximum uri length of 2083 was exceeded. at System.ServiceModel.DomainServices.Client.WebDomainClient`1.BeginQueryCore(EntityQueryquery, AsyncCallback callback, Object userState)

at System.ServiceModel.DomainServices.Client.DomainClient.BeginQuery(EntityQueryquery, AsyncCallback callback, Object userState)

at System.ServiceModel.DomainServices.Client.DomainContext.Load(EntityQueryquery, LoadBehavior loadBehavior, Action`1 callback, Object userState)

....

This doesn't seem to be related to the DataGridControl or its WcfRiaServicesDataSourceProvider.

However, if I use the Silverlight SDK's DataGrid, then this problem doesn’t occur:

var lo = _domainContext.Load<HubAssemblyRecord>(_domainContext.GetHubAssembliesRecordsQuery());
lo.Completed += (s1, e1) => { uxMsDataGrid.ItemsSource = lo.Entities; };

Any ideas? Thanks!

Creating a custom DataSourceProvider

Etienne [Xceed] — Fri, 17 Dec 2010 16:06:37 GMT

UPDATE:

Since version 1.3 of the DataGrid and Listbox for Silverlight, a IndexDataSourceProvider is provided with the products. Refer to documentation ( http://doc.xceedsoft.com/products/XceedSilverlightDataGrid/Custom%20Data%20Sources.html ) and the "RemoteListDataSources" sample.

----------------------------

When it comes to bind the DataGrid or ListBox with your web service, the solution is quite easy if your web service offers a WCF Data Services (OData) or WCF RIA Service API; however, the binding is not as obvious if your web service offers a “custom” interface. In that case, you need to implement your own DataSourceProvider that will do the “link” between the DataSourceProvider interface and the one that your web service offers.

In the actual state of code, creating a full-fledged DataSourceProvider is not an easy task. The idea was not only to support any type of data source but also to take profit of the optimizations it can provide. This is why the actual API is complex. But depending on your data source and your grid’s needs, you can simplify the implementation. We are working towards making it a lot easier in regards to this aspect for a future version of Xceed DataGrid for Silverlight and Xceed Ultimate ListBox for Silverlight.

A common web service interface is the one where your business entities are accessible via an “Index”. This post will address the issue of creating an AsyncDataSourceProvider using an “Index access” API.

An example would be a web service offering this API:

public IEnumerable<Product> GetItems( long index, int count )

This kind of provider would be useful in some situations where a web service with this API was already in place because your previous DataGrid/ListBox used a “paging” scenario. As an "index access" DataSourceProvider, this limited API impose some constraints. Theses constraints will limit the functionality of your DataGrid/ListBox:

1) No Sorting. Since the only functional way to sort a data source on the client side is to download the entire source, this feature is not desired. Server side sorting could be possible if the API offered some kind of "sort" parameter on the data query API.

2) No Grouping. At level of abstraction, grouping is converted into a sorting, so no grouping for the same reasons.

3) No Filtering (search box in the listbox). There is no filtering system on this API. Filtering could still be supported by the client side, BUT you will have performance degradation depending on the frequency of "filtered" items. If no items fill the search condition, the entire data source would be downloaded to detect such a case.

And here are others constraints. These are unfortunately our fault. We are working to fix this for a future version of the DataGrid and ListBox :

1) Single Selection Only.

2) You need to find a way to add an "Index" property on your business entity (ie. the Product class).

If you have full control on the declaration of your business entity class, this is an easy task. If the class is code generated, is it marked as "partial”? If so, simply add something like this to your project:

public partial class Product

{

public long Index { get; set; }

}

Another way to add an Index property would be to "wrap" all the items returned by your web service within another class where the Index property can be added:

public class ProductWrapper

{

public Product Product { get; set; }

public long Index { get; set; }

}

But this last solution implies that the objects viewed by your DataGrid/ListBox will be of ProductWrapper type. You will probably have to update some of your bindings from something like {Binding ProductName} to {Binding Product.ProductName}. The ElementType property of the DataSourceProvider implementation would also need to return the ProductWrapper type.

No need to initialize this "Index" property. The following implementation will take care of it.

Creating your DataSourceProvider

So to create your “Indexed DataSourceProvider”, download the “IndexedDataSource.cs” file provided as an attachment to this post and include it to your project (Don’t forget to update the namespace name!) . Then, create your own DataSourceProvider by declaring a class that inherit IndexedDataSource class.

You will need to implement the following Properties/Methods. For simplicity, the class name Product is used, but this should be replaced by your own business object type:

protected abstract Type ElementType { get; }

Return typeof(Product) or typeof(ProductWrapper) if needed.

protected abstract long? TotalCount { get; }

Return the total count of items in the entire data source. Mandatory for the DataGrid.

protected abstract long GetIndexForItem( object item )

Simply return the index of the Product object parameter.

Ex. return ( (Product)item ).Index;

protected override object SetIndexForItem( object item, long index )

Set the “Index” value of your Product item, and return it.

Ex.

( ( Order )item ).Index = index;

return item;

Or, in case you need a Wrapper:

return new ProductWrapper { Product = ( Product )item, Index = index };

protected override IAsyncResult BeginGetItems( long index, int count, ...)

protected override IEnumerable EndGetItems( IAsyncResult asyncResult )

Query your API to return the items. The “index” parameter tells you were to start the fetch, and “count” the number of items requested. If the IAsyncResult implementation seems troublesome for you, you can take a look at the implementation done in the IndexDataSource.cs file for an example.

IndexDataSource implementation

Now, if you need more details, or just curious about the IndexedDataSource implementation, here some explanations:

- [Begin|End]ExecuteCountQuery : This is only used when you have grouping and one or more groups are collapsed. So, in this case, it doesn't need to be implemented.

- [Begin|End]ExecuteGroupCountQuery : This is only used when you have group headers. Again, not needed in this case.

The GetPrimaryKeyInfo() method. Using an "index" API, the actual "Index" of your item will be it's primary key:

protected override IEnumerable<SortDescription> GetPrimaryKeyInfo()

{

return new SortDescription[]

{ new SortDescription( "Index", ListSortDirection.Ascending ) };

}

Since no filtering is supported, the IndexedDataSource will use what I call "Item Navigation". The default behaviour is "Filter Navigation" which is more flexible/complex and support all features of the DataGrid/ListBox . In this case, you need to “activate” item navigation:

public override bool CanJumpToItem

{

get

{

return true;

}

Each call to BeginExecuteDataQuery specifies a DataQueryParameters parameter that contains the following information:

- A Sort: In this case, it can only be "Index - Ascending", or "Index - Decending".

- A Skip Count: The count of item to skip in the fetch, starting at Item index 0, skip 5, take 5 would fetch items 5 to 10.

- A Take Count: The count of items to fetch, once the skip was applied.

- An Item : It is used to specify the starting point of your "skip/fetch" part.

(An exception exists when we are fetching the SelectedItems. Filter navigation will be used).

The EndExecuteDataQuery return a DataQueryResult class. This class contain the following values:

- Data: An IEnumerable of your queried entities.

- InlineCount: The count of item that “could” have been skipped/fetched if the “takeCount” was “infinite”. This allows us to know our position within the source and adjust the scrollbar accordingly.

Ex. A call on a 100 items source and a start Item index of 9, this would return an InlineCount of "90" for a “ascending” order and “10” for a “decending” order.

- TotalCount: The count of item that exist for the entire source. (Filtering applied, if any)

Some fetch are made in "Ascending Order", and some are made in "Descending Order". In descending order, the "skip 5" is like a "skip -5". Same concept applies on the "take" value. The result items also need to be returned in reversed order. This IndexedDataSource implementation essentially make all the index adjustments to result in a simple "index, count" query for your API.

There is unfortunately an issue when using any AsyncDataSourceProvider implementation with the ListBox. The selection might mis-behave when the keyboard “up/down” keys are used to scroll within the list. Ask us for a “special build” if your product need a fix for this. This issue will be fixed in the next service release.

I hope this will help you with the integration our DataGrid/ListBox.

Unbound column cell parent row

Paul — Mon, 13 Dec 2010 20:12:49 GMT

I have a button as cellcontenttemplate.

When the button is clicked how do I get the datarow that is associated with the button?

Thanks

WCF Data Services Example Fails on Chrome; Works on IE and Firefox

Calvin — Fri, 10 Dec 2010 19:33:52 GMT

I wired up the WCF Data Services example by provisioning an accompanying ASP.NET website with a Northwind data service:

namespace WcfDataServiceWebApp
{
    public class NorthwindDataService : DataService<NorthwindEntities>
    {
        public static void InitializeService(DataServiceConfiguration config)
        {
            config.SetEntitySetAccessRule("*", EntitySetRights.AllRead);
            config.DataServiceBehavior.MaxProtocolVersion = DataServiceProtocolVersion.V2;
        }
    }
}

It runs fine on IE and Firefox (without errors). But on Chrome it throws:

Uncaught Error: Unhandled Error in Silverlight ApplicationCode: 4004 Category: ManagedRuntimeError Message:Xceed.Silverlight.Data.DataSourceProviderException: An unhandled exception wasraised by the DataSourceProvider. Refer to the InnerException for moreinformation. ---> System.InvalidOperationException: The closed typeXceed.Silverlight.DataGrid.Samples.ServiceReference1.Order_Detail does not havea corresponding Product settable property. atXceed.Silverlight.Data.WcfDataServicesDataSourceProvider.EndExecuteDataQuery(IAsyncResultasyncResult) atXceed.Silverlight.Data.AsyncDataSourceProvider.EndExecuteDataQueryCore(IAsyncResultasyncResult) at Xceed.Silverlight.Data.DataSourceProvider.EndExecute(Action`1sendResultMethod, Func`2 endExecuteMethod, IAsyncResult asyncResult,IAsyncResult taskId, RetryAttempt taskRetryAttempt) --- End of inner exceptionstack trace --- atXceed.Silverlight.Data.DataSourceProvider.<>c__DisplayClass16.<HandleAsyncException>b__15()onSilverlightError

Since I have never previously used WCF Data Services, I'm not really sure what's going on here. But I thought I'd bring it to your attention.

Actually, I investigated the WCF Data Services example merely because I had trouble with the WCF Ria Services example which throws "The maximum uri length of 2083 was exceeded" when too many columns are added. See this post: http://xceed.com/CS/forums/thread/29413.aspx

How to display a stylized checkbox in a readonly grid

Calvin — Wed, 08 Dec 2010 20:09:21 GMT

What is the best way to display a stylized readonly checkbox for a boolean field?  The following approach works; but it has the disadvantage of being disabled (dimmed).
          <g:DataGridControl x:Name="uxDataGrid" ItemsSource="{Binding}"
                           AutoCreateColumns="False"
                           ReadOnly="True" >
            <g:DataGridControl.Columns>
                <g:Column FieldName="IsPublic"
                          Title="Public">
                    <g:Column.CellContentTemplate>
                        <DataTemplate>
                            <g:BooleanCellEditor Content="{Binding}" IsEnabled="False" />
                        </DataTemplate>
                    </g:Column.CellContentTemplate>
                </g:Column>
            </g:DataGridControl.Columns>
 One could use a CheckBox instead of the BooleanCellEditor in the CellContentTemplate; but it wouldn't have the proper styling.
Thanks!

WCF Ria Services Domain Service Metadata

Calvin — Wed, 08 Dec 2010 00:21:21 GMT

Is it possible to leverage the System.ComponentModel.DataAnnotations.Display(Name="...") attribute in a WCF Ria Service to avoid the necessity of explicitly setting the Title property on the Xceed.Silverlight.DataGrid.Column object?

When I attempted to use the Display attribute, I got the following error in conjunction with auto-generated fields:

Unhandled Error in Silverlight Application The AutoGenerateField property has not been set. Use the GetAutoGenerateField method to get the value. at .ComponentModel.DataAnnotations.DisplayAttribute.get_AutoGenerateField()

Consequently, I reverted to setting the Title property explicitly in XAML:

<sldg:Column FieldName="OrderID" Title="Order" ...

But, since I plan to localize this app, I'd rather use the metatdata class:

CatalogDomainService.metadata.cs

--------------------------------

[System.ComponentModel.DataAnnotations.Display(Name="Order")]

public int OrderID;

Thanks!

Custom DataSource Virtualization

Claudio — Fri, 26 Nov 2010 13:09:31 GMT

Hi there,

The last hours I was looking for a way to use the SL grid with my own virtualization capable data source. In the WPF version that's quite easy by hooking up with the event driven DataGridVirtualizingCollectionViewSource; but on the SL implementation i've found no such possibility.. Did I miss something? Can someone give me a hint?

Please keep in mind that we use our own optimized communication services between client and server and can therefore not use any WCF RIA/Data Services as a base for a possible solution.

I hope someone can help me out.

Cheers, claudio

ComboboxCellEditor

Nick — Thu, 18 Nov 2010 00:02:11 GMT

Hi...I have some quick questions regarding using comboboxes for cell editing in the datagrid. Perhaps the answers are buried in the documentation somewhere, but I have a limited amount of time left to evaluate this product before moving on to the next candidate grid control.

<1>I am unable to get the grid to automatically select the right value from the combobox when entering edit mode on that cell. Currently it just selects nothing. The combobox is populated with data. I have properly set the SelectedValuePath for the underlying ComboboxCellEditor instance. The combobox is being bound to an Entity collection, specifically I'm trying to bind to a type of IEnumerable(Of Entity). I can get it to select the value if i bind to a simple array using the same technique, but not with the Entity collection. I dont see why it would matter, any thoughts? If it can't be done then how do i manually set this value?

<2> Again, for a cell that uses a combobox as an editor: I have a cell which gets set to code "x". Code "x" has a description of "abc". I want the cell to display "abc" instead of "x". What is the best way to facilitate this mapping? The lookup list isn't populated until run time.

Thanks!

Nick

Unbound Button column

Paul — Sun, 21 Nov 2010 01:23:50 GMT

since I am new to silverlight, If I understand the how the grid works, I would need to add a cellcontenttemplate to a predefined column. What I am confused about is how to just set the cellcontenttemplate to the style of a button with text in the cell that says "Edit". It looks to me like I would have to bind this to data or can I just add a unbound column and somehow set the text

btw I would prefer doing all this at runtime in code behind

Thank

Unconstrained

MiddleTommy — Tue, 16 Nov 2010 20:41:42 GMT

I tried putting the Grid in a Telerik.RadDockPanel and the grid throws an error saying it is not constrained with width and height.

WCFDataService update

Nikola — Thu, 11 Nov 2010 23:34:32 GMT

Hi,

does anyone knows what needs to be done so a data source to which grid is binded via wcf data service would be updated?

Can we get the WcfDataService sample enhanced to reflect that update/insert scenario too?

Thanks,

Nikola

Styling DataGrid

David — Fri, 05 Nov 2010 07:09:12 GMT

Hello all

I would like to style the whole grid new. I have a screen design from our design team and like designers are... they want it exactly that way :)

So I tried to create a new style in expression blend (actually this works with the standard silverlight grid quite well - I got different style templates like RowHeaderStyle, ColumnHeaderStyle, etc...). When I try the same thing with the Xceed Grid there are no such style templates.

Is there a way to got to the xaml definitions of your themes? I tried as well with reflector but I couldn't get the Baml files to look into the themes resources. Can you provide me with the style templates?

When I would be able to style the xceed grid against the screen design, the purchase of the grid is not far away. (because you did a good job with the DataVirtualization)

So thanks in advance for your help!

Buton click event thorws exception inside the grid.

ck — Mon, 01 Nov 2010 09:51:06 GMT

I had a column in datagrid that have CellContentTemplate property and this property holda a silverlight button. Button appers in datagrid but when write click event of this button then there is an exception thrown before the control loaded in the browser.

Let me know where is the problem?? I am doing r&d on trail version.

Thanks in advance.

Chandan

Status of compatibility/support of Xceed Silverlight DataGrid with OData for Windows Phone 7

Carl — Tue, 12 Oct 2010 19:46:19 GMT

What is current status of compatibility/support of Xceed Silverlight DataGrid with OData for Windows Phone 7?

If not currently compatible with WinPhone 7 Odata services, what are plans/timeline for future availability?

Of Frozen Columns, Selected ITems, and CellEditor

Dhananjaya — Thu, 23 Sep 2010 11:00:12 GMT

Hi,

I am evaluating Xceed Datagrid for Silverlight in one of our products and So far find it to have most of the features that we want. I had a few questions...

1) Is it possible to have frozen columns in the datagrid. We have requirement where the first 3 columns should be frozen and should not move as the user scrolls to right using the horizontal scroll bar. This is very crucial for us. I couldn't find any such property on the DataGrid. Can you please help me how to achieve this maybe with a workaround or a trick?

2) We have a particular column which is editable - some cells in the column are merely textboxes in edit mode while we want others to be combo boxes. I used to achieve this in the SilverlightTool kit data grid using have both Textbox and Combobox in collapsed state in EditTemplate and in the PrepareCellForEditing Event handler depending on the business logic either make the textbox or the combobox visible as follows

<data:DataGridTemplateColumn.CellEditingTemplate>
<DataTemplate>
<StackPanel>
<TextBox x:Name="TBEdit"Visibility="Collapsed"Text="{Binding DisplayC0, Mode=TwoWay, NotifyOnValidationError=True, ValidatesOnExceptions=True}" IsReadOnly="{Binding Converter={StaticResource PivotAttributeConverter}, ConverterParameter=IsReadOnly:0}" BorderThickness="0" Opacity="0.8"/>

Can you please let me know how to achive the same with Xceed Datagrid.

3) The final question is how do i get the SelectedITems of the grid regardless of whether its in single, multiple or selection mode. The Selction changed event doesn't seem to be working as expected as DataGrid.CurrentITem is null sometimes - am i missing anything here?

I do need to get the Selected items as we have facility for the user to delete them or copy them or move a rowitem one up or even add a new item

4) Is the reordering of rows supported in your DataGrid - We have rows sorted on a parituclar property/column that we do not display on the UI and we want rows to be moved up or moved down.

Waiting for your reply.

ps: Congrats on coming up with such a wonderful product. We actually wasted 2 weeks evaluating another 3rd party control suite and finally dumped it for performance reasons.

KeyDown event is unable to trap some keys

Guillaume — Mon, 27 Sep 2010 19:23:49 GMT

I am using the DataGridControl KeyDown event to trap keys like F2, F3, F4..

When I test with the F2 key it works well but if I try with F3 or F4 the event is not fired so I am unable to trap those keys. Anything I am missing ?

Private Sub Grid_KeyDown(ByVal sender As System.Object, ByVal e As System.Windows.Input.KeyEventArgs) Handles DataGridControl1.KeyDown

If e.Key = Key.Enter Then

MessageBox.Show("Enter key was pressed")

End If

If e.Key = Key.F4 Then

MessageBox.Show("F4 key was pressed")

e.Handled = True

End If

If e.Key = Key.F3 Then

MessageBox.Show("F3 key was pressed")

e.Handled = True

End If

If e.Key = Key.F2 Then

MessageBox.Show("F2 key was pressed")

e.Handled = True

End If

End Sub

NullReferenceException when resetting a grid's ItemSource property

Noah — Fri, 17 Sep 2010 14:17:51 GMT

I see this happen semi-randomly in my application when setting the grid's ItemSource property. This happens if I set the ItemSource to null or to a valid bindable list. It only happens after the grid has already been bound successfully at least once to a set of data.

{System.NullReferenceException: Object reference not set to an instance of an object.

at Xceed.Silverlight.DataGrid.DataGridControl.CleanupDataSource(Boolean cleanConfiguration)

at Xceed.Silverlight.DataGrid.DataGridControl.OnItemsSourceChanged(Object newItemsSource)

at Xceed.Silverlight.DataGrid.DataGridControl.OnItemsSourceChanged(DependencyObject sender, DependencyPropertyChangedEventArgs e)

at System.Windows.DependencyObject.RaisePropertyChangeNotifications(DependencyProperty dp, Object oldValue, Object newValue)

at System.Windows.DependencyObject.UpdateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)

at System.Windows.DependencyObject.SetValueInternal(DependencyProperty dp, Object value, Boolean allowReadOnlySet)

at System.Windows.DependencyObject.SetValue(DependencyProperty dp, Object value)

at Xceed.Silverlight.DataGrid.DataGridControl.set_ItemsSource(Object value)

at DFA.Client.QueryTool.Control.Panes.DisplayContent.LoadDisplay(DisplayMetadata display)

at DFA.Client.QueryTool.DataContexts.QueryDataContext.set_QueryMetadata(QueryMetadata value)

at DFA.Client.QueryTool.DataContexts.QueryDataContext.QueryToolService_SelectAxisValuesCompleted(Object sender, SelectAxisValuesCompletedEventArgs e)

at DFA.Client.AdviseService.QueryToolServiceClient.OnSelectAxisValuesCompleted(Object state)}

I'm currently the top 3 threads on this forum, can you give me an idea as to your responsiveness in dealing with these bugs and when I can expect a release that targets some of them? I'd really like to use your grid in my final product, but at this juncture it's a black box that breaks too often.

Binding within a cell template to the current row's DataContext?

Noah — Tue, 14 Sep 2010 19:06:14 GMT

When I'm within a CellContentTemplate my binding appears to be that of the Column.FieldName. I need to go up a level within the context so I can get to other data for use in the template

<sldg:Column FieldName="Width" >

<sldg:Column.Title>

Width

Width Factor

</TextBlock>

</sldg:Column.Title>

<sldg:Column.CellContentTemplate>

</TextBlock>

</Grid>

</DataTemplate>

</sldg:Column.CellContentTemplate>

</sldg:Column>

Programmatic scrolling of the datagrid

Noah — Mon, 06 Sep 2010 19:50:33 GMT

I am implementing a pivot table comprised of three grids linked together. The bottom-right grid has scrollbars, where as the other two have their scrollbars hidden. When I scroll the bottom right grid, I programmatically update the scroll position of the other grid as required, however the grid fails to update. I've turned on the scrollers to confirm I am correctly setting the value and indeed the scroll bars position does update, however the grid refuses to redraw. I've tried UpdateLayout() and the like without effect. What do I need to call to force the grid to update and why doesn't the grid self-update when the scroller is changed?

Relevant code:

private void VerticalScrollBar_ValueChanged(object sender, RoutedPropertyChangedEventArgs<double> e)

{

_PivotRowsGrid.ChildrenOfType<ScrollBar>().Where(sb => sb.Orientation == Orientation.Vertical).First().Value = e.NewValue;

}

private void HorizontalScrollBar_ValueChanged(object sender, RoutedPropertyChangedEventArgs<double> e)

{

_PivotColumnsGrid.ChildrenOfType<ScrollBar>().Where(sb => sb.Orientation == Orientation.Horizontal).First().Value = e.NewValue;

}

private void _PivotResultsGrid_Loaded(object sender, RoutedEventArgs e)

{

foreach (var sb in _PivotResultsGrid.ChildrenOfType<ScrollBar>())

{

if (sb.Orientation == Orientation.Horizontal)

{

sb.ValueChanged += new RoutedPropertyChangedEventHandler<double>(HorizontalScrollBar_ValueChanged);

}

else

{

sb.ValueChanged += new RoutedPropertyChangedEventHandler<double>(VerticalScrollBar_ValueChanged);

}

Xceed DataGrid for Silverlight v1.0 evaluation questions

Mon, 13 Sep 2010 10:52:25 GMT

Hi All,

I received from you a notification email that you released a first official version of Xceed DataGrid for Silverlight and decided to try it.

Several questions have appeared during my evaluation:

1) Do you have any sorting events(begin, end)? I would like to control sorting operation at each stage.

2) Do your SL grid supports vertical deferred scrolling? I could not find a sample for this.

3) Do your SL grid supports out of box binding to hierarchical data? If yes, could you provide a sample?

4) In your marketing message you claim that the grid supports UI column & row virtualization. Am I right?

I bound the grid to data with many rows and columns and observed that all rows, columns, rows are created at the beginning ...

Maybe in the default grid mode virtualization is switch off. How I can switch on and tune for my scenarios the UI virtualization?

Any thoughts?

Thanks in advance, Greg

DataGrid "paging" and RIA Services

Mario — Thu, 09 Sep 2010 10:06:05 GMT

Hi!

I'm trying to use grid with larger set of data (50.000 records), but grid does not perform any paging as advertised it's simply trying to pull entire record set which breaks ria services (because of packet size and timeout restrictions). I know I can change both packed size and timeout, but I don't want to do that, I'd like DataGrid to perform paging behind the scenes. I've checked SQL Profiler and I can see SQLs pulling entire tables.

Is there an option which sets load size that I am missing?

Thanks,

Mario

@datagrid + RT to get Xceed DataGrid for Silverlight for $20 (Reg $399) ???

Chad — Wed, 08 Sep 2010 19:18:28 GMT

I've done both of these - I don't see any way to get the SL datagrid for $20? What am I missing?

Thanks --

access form-subform kind of experience with wpf/silverlight datagrids

Sat, 28 Aug 2010 04:37:02 GMT

I'm thinking about what I'd need to actually move off of access type forms to silverlight, in terms of a datagrid. It could be this is possible only with silverlight fully trusted or "out of the (sand)box" (which is fine with me), or wpf (--though it seems silverlight is the end goal according to MS). fwiw, this is my reaction--don't know if it's useful or maybe I have a fundamental misconception of wpf/silverlight tools:

First, a small point, it would help to have a "binding navigator" option with CRUD operation easily available for all views (including card view); for example:
http://weblogs.thinktecture.com/cnagel/2010/08/bindingnavigator-for-wpf-part-1---creating.html

On an ideal datagrid: I'd want a control that easily allows one to create master-detail (ContainingForm with contained subforms) with crud buttons and nav. bars on both form and subform, and one that easily "understands" the relation between form and subform. I mean something like Microsoft access has in its forms, or I think to some extent in winforms, but for silverlight (or wpf). I'd think one could use a datagrid for that by first having a big single container card view (one-record-at-a-time view, fields vertically arranged), with a navigation bar--this would be for the master table, for ex. customers, as the master form or master grid. Then drop another datagrid into it for a fully contained "subform" (a child/details table, e.g. Orders, probably horizontally arranged fields), and perhaps a second subform or contained datagrid (for a second child table, or grandchild ("orderdetails") linked to the selected child). But I don't know if that's easy with the tools now and I don't know how comparable to access form templates ("split form"; "columnar," each with subforms etc); the datagrids I see available don't seem to have that. The peculiar advantage of a datagrid in ease of use is large, because one is not creating a whole form layout composed of unrelated elements with their own custom formats and individual positioning etc, but relying on a simple auto-organization (i.e. a row of fields, but the fields can also be in vertical layout or two column wrap organization etc.). --Looking for as simple and automatic an experience as possible, "churn out" forms based on dropping a couple of related tables for crud operations, and that require only minor customization. The goal is not to have the whole wpf/blend design experience -- I don't need or want it, too much time, too many options etc. One wants the wpf/silverlight tools support (and future), but with a simple lob autoform generator for standard crud operations. That's my general impression, perhaps as I learn more about wpf/silverlight I'll have a better handle on the best combination of rad tools (what I don't want to do is spend a lot of time on ui).

as far as I can see, the closest view in xceed to what I use most often seems to be the master/detail (in the wpf grid), but there I didn't see master as card view container with one or more detail tables as contained elements. Master-detail view in xceed seems (in the most basic format) to be like a tree explorer view (like table/subtable in access datasheet view). I assume one could do two or three grids separately (e.g. one card master grid and two child table view grids) and link them up, and then add a navigation bar and crud buttons and synchronization logic etc., or perhaps even do it in a customized template, but offhand that's not as autogenerated/automatic as I'd like. Thanks.

Lightswitch

Thu, 19 Aug 2010 23:02:13 GMT

Is the new xceed silverlight control compatible with Lightswitch? (I realize the latter is still in beta, so perhaps the question is whether there are any thoughts or expectations about that.)

http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/thread/45671c55-52ef-4534-aef5-14f5514d15c4

Question about new Silverlight grid

Michael — Wed, 23 Jun 2010 14:01:28 GMT

I've just been reading the press release and features for the forthcoming Silverlight grid. Looks very exciting.

From the features page:-

'Smooth-scrolling animations. Reduces the perception of lag thanks to the time required to execute the smooth scrolling effect. Fades in empty rows and data once they arrive. Also improves readability by letting the eye track record data as it is scrolled: instead of jumping into existence, it moves fluidly into place.'

Sounds a lot like TableFlow.

Will it handle variable height rows?

Can you confirm there will be a WPF build?

Can you post a feature comparison with the current grid? What might I lose if I move to the new grid?

Thanks

Michael