Defining Columns for a Silverlight DataGrid

re: Defining Columns for a Silverlight DataGrid

DM — Fri, 28 Mar 2008 05:46:45 GMT

This might be a little off-topic...

Does the Silverlight DataGrid supports group headers?

i.e. a cell above a determined number of headers that spans the combined width of the headers it groups together. When one of the headers in the group is resized, the group header follows and adapts itself to the new "combined width".

Thanks in advance!

re: Defining Columns for a Silverlight DataGrid

Malky — Fri, 28 Mar 2008 08:51:27 GMT

Hi Scott,

Nice post you have here, I'am waiting for your next post using "RowDetailsTemplate" , I am personally having difficulty to get reference control in <DataTemplate> under <RowDetailsTemplate> where I can use somewhere in my code

Thanks for your attention

- Malky

March 28th Links: ASP.NET, ASP.NET AJAX, ASP.NET MVC, Visual Studio, Silverlight, .NET

Blogs — Fri, 28 Mar 2008 11:43:45 GMT

Here is the latest in my link-listing series .  Also check out my ASP.NET Tips, Tricks and Tutorials

More Silverlight 2.0 DataGrid posts

Hot Topics — Sat, 29 Mar 2008 18:48:18 GMT

Scott Guthrie lists a number of posts and videos about the Silverlight 2.0 DataGrid in March 28th Links

Silverlight Cream for March 30, 2008 -- #240

Community Blogs — Mon, 31 Mar 2008 14:20:12 GMT

Dan Wahlin's latest articles, Cheryl at Silverlight SDK on SL2, WS, and WCF, Sam Landstrom on using

re: Defining Columns for a Silverlight DataGrid

Jody.Breshears — Tue, 01 Apr 2008 00:01:53 GMT

Very nice article. However, it and nearly every other article or blog entry I have seen concerning the DataGrid, as well as ALL the documentation, assume that you will be constructing your grid in XAML. My experience in the industry is that I am far more likely to need to create one dynamically. Could you provide some examples of that?

I just finished importing your source code and altering it in order to solve a problem of mine, it was so bad. I could sure use some examples.

- Jody

Defining Columns for a Silverlight DataGrid

Defining Columns for a Silverlight DataGrid — Wed, 02 Apr 2008 08:20:21 GMT

If you read my <a href="http://blogs.msdn.com/s

Silverlight Tips, Tricks, Tutorials and Links Page

ScottGu's Blog — Wed, 02 Apr 2008 12:03:18 GMT

I'll be using this page to link to Silverlight 2 articles and posts (both ones I write as well ones by

Defining Silverlight DataGrid Columns at Runtime

Scott Morrison — Tue, 15 Apr 2008 01:25:54 GMT

Now that you know the basics of the Silverlight DataGrid and how to specify the Columns in XAML , you

re: Defining Columns for a Silverlight DataGrid

VinodK — Mon, 21 Apr 2008 19:10:03 GMT

Great post/series. Thank you.

Any thoughts on how I can conditionally format some columns, like positive numbers in green and negative numbers in red.

Thanks again for great posts.

re: Defining Columns for a Silverlight DataGrid

scmorris — Mon, 21 Apr 2008 19:38:35 GMT

Hi Vinod,

You can coditionally format the contents of your columns by using a converter. To do this you would need to use a template column (for beta 1) since you cannot databind to properties on DataGridColumns just yet. What you are going to want to do is databind the property you want to conditionally change, probably in your case either the Foreground or Background property, to the value with a converter that takes positive numbers and returns a green Brush, and negative numbers and returns a red Brush.

Hope this helps!

-Scott

re: Defining Columns for a Silverlight DataGrid

VinodK — Tue, 22 Apr 2008 00:28:42 GMT

Scott,

It works great (data binding the property)

Thanks for your help.

- Vinod

silverlight 动态生成silverlight

星际 — Wed, 21 May 2008 04:19:27 GMT

NowthatyouknowthebasicsoftheSilverlightDataGridandhowtospecifytheColumnsinXAML,you...

re: Defining Columns for a Silverlight DataGrid

Kumar S — Wed, 21 May 2008 21:34:47 GMT

Like many others, I jumped on to Silverlight 2.0 to create an internal application for my company. But, I couldn't produce an useful app since there is no Combobox control I can use in a DataGrid column. There are some examples in the web using Javascript or combining it with a textbox, button and listbox. I need a column in the Datagrid to have Combobox, like WinForm datagrid. It is disappointing hvaing the combobox control.

re: Defining Columns for a Silverlight DataGrid

scmorris — Sat, 31 May 2008 05:35:51 GMT

Hi Kumar,

I can't comment on the status of a first party ComboBox, however if you are able to find a control that serves your purposes, you can create a ComboBox column using a template column. If instead you want to pair up a ListBox, Button, PopUp, and TextBox you can do that as well since even though my sample above only has a single DatePicker in the template, you can use any DataTemplate as complicated as you want to define the contents of a cell.

Hope this helps.

-Scott

Silverlight DataGrid (2)

蓝色飞翔 — Thu, 05 Jun 2008 10:47:59 GMT

DefiningColumnsforaSilverlightDataGrid

Silverlight DataGrid(1)

蓝色飞翔 — Thu, 05 Jun 2008 10:48:44 GMT

DefiningSilverlightDataGridColumnsatRuntime

NowthatyouknowthebasicsoftheSilverlightD...

re: Defining Columns for a Silverlight DataGrid

Pawel — Sat, 07 Jun 2008 11:53:28 GMT

Hi,

If i add some editable control to CellEditingTemplate (for example WatermarkedTextBox), after entering "Edit mode" focus is not on my editable control, and i have to click on this control to edit.

Is there any solution to make editable control focused after entering cell in edit mode?

re: Defining Columns for a Silverlight DataGrid

phil.d — Wed, 11 Jun 2008 12:55:39 GMT

Hi Scott,

Using the great reply you gave to Vinod, I've had a colour coded cell working in a datagrid using a converter returning one of six brushes when given a number (0 - 5). Worked/looked great in beta 1 but, having moved to beta 2 it's now failing during the page InitializeComponent LoadComponent with a method access exception on the converter module (called ColourAlerts) with System.MethodAccessException: Tams.ColourAlerts..ctor() at System. Reflection. MethodBase. PerformSecurityCheck

I've gone through the beta 2 datagrid breaking changes but can't see any relevant details on this. If you have any info' on why I'm getting this fault it would be much appreciated.

thanks, Phil

March 28th Links: ASP.NET, ASP.NET AJAX, ASP.NET MVC, Visual Studio, Silverlight, .NET

Readed By Wrocław NUG members — Sun, 15 Jun 2008 18:30:24 GMT

Here is the latest in my link-listing series .  Also check out my ASP.NET Tips, Tricks and Tutorials

re: Defining Columns for a Silverlight DataGrid

RMS81 — Fri, 20 Jun 2008 04:17:39 GMT

Hi,

I´m using this tutorial to create and populate a datagrid in silverlight beta 2, but when the grid is populated with the columns defined in the xaml file and with autogenerate columns set to false, I get all the rows but no values. If I don´t define de columns and set autogenerate columns to true everything works fine. Any ideia why this is happening?

re: Defining Columns for a Silverlight DataGrid

paridhi — Fri, 20 Jun 2008 17:04:57 GMT

how to change styles of column values at runtime depending upon some condition like one column which contains checkbox if checkbox is checked style of row should be changed

re: Defining Columns for a Silverlight DataGrid

Two way binding and insert item — Fri, 27 Jun 2008 19:55:33 GMT

Excellent post, I was not able to find how to setup the two way binding.

One thing... if we add an element to the entity list associated, do we need to rebind the datasource? or the Datagrid is smart enough to detect the change and refresh the grid displayed?

StringFormat

Miguel Madero — Fri, 04 Jul 2008 10:21:13 GMT

Scott,

I can see how IValueConverter can be useful in certain escenarios, but most of the time using a FormString would be easier, in your example we could specify a formatString of "d"

I dont know if there's something like that in SL or WPF. I did a trick to do something similar using ValueConverters, it work fine, but I think there should be a sexier solution.

Here's the XAML.

<UserControl.Resources>

<local:StringFormatConverter x:Name="stringFormatter"/>

</UserControl.Resources>

<StackPanel.DataContext>

<SilverlightApplication3:Person/>

</StackPanel.DataContext>

</StackPanel>

Here's de Code

public class StringFormatConverter:IValueConverter

{

#region IValueConverter Members

public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)

{

string formatString = parameter.ToString();

return String.Format("{0:" + formatString + "}", value);

}

public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)

{

throw new InvalidOperationException("This Convert supports only OneWay binding");

}

#endregion

}

re: Defining Columns for a Silverlight DataGrid

Stanley — Wed, 17 Sep 2008 00:14:23 GMT

Great post! Coming from WPF apps using ListView, I'm struggling with customizing the silverlight datagrid.

One thing that I frequently use in WPF standalone app, and XBAP is the ValueConverter. In this case to give back an image path for showing an image in one of the columns in the datagrid. But when scrolling the datagrid the images are lost forever once they're scrolled out of view, not until the datagrid i refreshed again the images are shown. It seems the virtulization isn't working properly.

I'm currently using VS2008sp1,FW 3.5SP1,Blend 2 June preview and downloaded the SilverLight 2.0 Beta 2 for VS.

Any ideas?

Silverlight 2 DataGrid is Released

Scott Morrison — Wed, 15 Oct 2008 09:46:04 GMT

As you might have heard , we just released Silverlight 2 , and with it the first version of the Silverlight

re: Defining Columns for a Silverlight DataGrid

Peter — Thu, 23 Oct 2008 17:17:20 GMT

I am having a hard time with the DataGrid and its Template Column. The problem is that I don't know until runtime what property in my datasource to bind to because that is driven by some configuration data that I read up. I have no problem doing this with a DataGridTextColumn since that class offers a Binding property that I can set at runtime but I need to use the Template column since I want to provide a richer UI then just a text string. The Template column doesn't have the Binding property so I would need to specify my binding at design time in Xaml...and that is too early for me.

The only way around this seems to have the datatemplate stored as a string, do some type of string substition of that string and then load it as a datatemplate. This doesn't sound like the best idea to me...I would like to keeep my datatemplate/styles in Xaml files so that they can be worked on by my designer in Blend.

Is there any other direction that you could point me to?

Thanks,

Peter

re: Defining Columns for a Silverlight DataGrid

Paul Jenkins — Wed, 29 Oct 2008 23:15:38 GMT

i'm having a devil of a time with the release version of Silverlight 2.0 defining my DataGrid header information (styling the header row so that it has a particular color/font/etc.) as well as the hover over row treatment and the selection treatment.

do you have a definitive guide on how to change these key elements? Should I shell into Blend and edit a control template there and play around or what??

re: Defining Columns for a Silverlight DataGrid

Scott Peterson — Thu, 04 Dec 2008 23:08:52 GMT

When using a datagrid with AutoGenerateColums = true, I can individually check each box in each row as I would expect. However, when I define a checkbox column manually, I can only select one row at a time.

How do I resolve this? I would like to be able to name my own columns. Any help would be appreciated.

re: Defining Columns for a Silverlight DataGrid

Nick — Tue, 16 Dec 2008 01:37:01 GMT

How can I create grid columns on the fly and bind them to a data source?

joins

61231 - Julien Lemarié — Mon, 23 Mar 2009 11:50:26 GMT

hi Scott

If I want have in my datagrid, one information which is stored in an other table, who I can make that ?

For example, I want display in the datagrid all my invoices with the name of client for each row.

I need to create an object which contains the joint of 2 tables and binding the datagrid with this object ?

Thanks

re: Defining Columns for a Silverlight DataGrid

madhavi — Mon, 27 Apr 2009 10:09:47 GMT

This artical is nice .

I want that how to bind data from data base to grid using silver light is it possible.

re: Defining Columns for a Silverlight DataGrid

Bill — Wed, 29 Apr 2009 06:04:33 GMT

How about creating a DataGridComboBoxColumn that inherits from DataGridBoundColumn.

I need a combo box in a datagrid, and dont want to keep usuing the Column Template.

re: Defining Columns for a Silverlight DataGrid

ben — Tue, 19 May 2009 09:20:26 GMT

hi,

I have a problem, everytime i run my application two identical headers were display... Please check my code here... I had noticed that property method's name is also display in the datagrid. What I want is to display the image only dyanamically and remove the other column.

Could anyone help me... Thanks in advance...

In XAML..

<my:DataGrid x:Name="dataGrid" Margin="80,88,104,116" >

<my:DataGrid.Columns>

<my:DataGridTemplateColumn Header="Thumbnail">

<my:DataGridTemplateColumn.CellTemplate>

</DataTemplate>

</my:DataGridTemplateColumn.CellTemplate>

</my:DataGridTemplateColumn>

</my:DataGrid.Columns>

</my:DataGrid>

Propety page..

Property Thumbnail() As String

Get

Return _image

End Get

Set(ByVal value As String)

_image = value

End Set

End Property

XAML.vb...

source.Add(New TubeContent() With {.Thumbnail = imageURL})

re: Defining Columns for a Silverlight DataGrid

scmorris — Wed, 20 May 2009 03:31:41 GMT

Hi Ben,

The reason that you are seeing two columns is because the AutoGenerateColumns on your DataGrid is still true (this is the default value). Setting it to false should fix your problem.

Hope this helps!

re: Defining Columns for a Silverlight DataGrid

Ben — Wed, 20 May 2009 05:51:23 GMT

Hi scmorris,

This is works! Thank You Very Much...

re: Defining Columns for a Silverlight DataGrid

Ganesh — Mon, 20 Jul 2009 17:11:41 GMT

Hi, im new to silver light i have a got a basic doubt.

I need to bind an array of items. which contains 5 attributes, and i need only 3 of them to be displayed in the grid. I did the follwoing

<data:DataGrid.Columns>

<data:DataGridTextColumn Header="Page"

Binding="{Binding PageName}" />

<data:DataGridTextColumn Header="Data Item Caption"

Binding="{Binding DisplayName}" />

<data:DataGridTextColumn Header="Message"

Binding="{Binding Message}" />

<data:DataGridTextColumn Header="Item"

Binding="{Binding Item}" Visibility="Collapsed"/>

<data:DataGridTextColumn Header="Name"

Binding="{Binding Name}" Visibility="Collapsed" />

</data:DataGrid.Columns>

But in addition to these the other 5 attributes are also getting binded to the grid. How to make those five columns invisible.

Thanks.

re: Defining Columns for a Silverlight DataGrid

Ganesh — Mon, 20 Jul 2009 17:13:13 GMT

Hi i got the answer for my question. Thank u.

re: Defining Columns for a Silverlight DataGrid

Robert Fraser — Wed, 22 Jul 2009 05:45:55 GMT

Hi scmorris,

Since DataGridColumn properties aren't DependencyPropertys they can't be data-bound or whatever, right? So is there any way to bind the Width (or other) properties in XAML?

Thanks,

Robert

re: Defining Columns for a Silverlight DataGrid

scmorris — Mon, 03 Aug 2009 23:21:23 GMT

Hi Robert,

Unfortunately there is no way to databind properties on DataGridColumns yet. This is since they are DependencyObjects instead of Controls, and DO's cannot be the target of a binding in Silverlight 3. If the future when this functionality exists in the platform you can expect the DataGrid to fully support it.

In the mean time, you will have to use programmatic methods to try to emulate the binding logic.

Hope this helps.

re: Defining Columns for a Silverlight DataGrid

Majid MaghsudFar — Tue, 18 Aug 2009 16:06:52 GMT

Hi Scott...

Thanks, very much

nice topic, it was very useful :)

re: Defining Columns for a Silverlight DataGrid

Divya Prakash — Mon, 07 Sep 2009 16:08:11 GMT

can we transform row and column of the grid so that column appears in the top and row appears in the place of row

re: Defining Columns for a Silverlight DataGrid

bogdan71 — Wed, 18 Nov 2009 20:46:18 GMT

Scott,

This is a great article.

I would like to see if there is a way to create dynamic rows for silverlight datagrid??

Thanks