Vincent Sibal's Blog

PingBack from http://www.easycoded.com/net-35-sp1-and-wpf-datagrid-ctp-are-out-now

Well, their is a huge hype surrounding the release of .NET Framework 3.5 SP1 & Visual Studio 2008

When I reviewed some 3rd party WPF components out there I noticed the fact most of them showcased a datagrid

Vincent,

I watched Samantha's video, and something struck me as odd.  Why is the DataGrid's HeaderVisibility property not of type Visibility?  Every other WPF property I can think of whose name ends with "Visibility" is of type Visibility.  I think that property should be renamed, perhaps to something like "Headers" or "VisibleHeaders".

Josh

I’m going to be dissecting and discussing the DataGrid visuals and how they are all assembled together

Can that sample be included in the stuff on CodePlex? Seems like it would be really helpful.

Overview The DataGrid uses a set of DataGridColumns to describe how to display its data just like a GridView

Get a grip on the DataGrid - Snoop your way out of your troubles

We are looking for following features:

Will they be included in future? If yes, when can we expect?

1. Footer

2. Save Datagrid Layout

3. Merge Cells in Header/Footer/Body

4. Data Filtering (single / multi column)

5. Column Customization (To hide a column User

  can drag column to an area or on right click of a

  column give option to hide column)

6. Customized Summary Field where User can enter his

  formula which can consist of some condition

7. Exporting Grid to Excel/PDF/CSV

Thank you very much for gr8 work.

Regards,

Sandeep

I'm playing with your sample and I can't figure out what the checkbox "IsFrozen" is supposed to do. I was expecting it to freeze the column so that it could not be scrolled out of view, but it didn't do that. Thanks!

Thanks for the great article, could you please or anyone guide me in the right direction. I need to get the cell value of the cell clicked in the dg. Basically I want to open a new window when a user clicks on the row to pass the cell clicked value.

any advice would be muchly appreciated

I found no samples for the moment, for stuffs like CommitingEdit etc... Do you know where we can find some ?

The big question I always have and hope for is if this grid will allow copy and paste from the clipboard.  Because many business applications I work with, users want to copy Excel data to their grid.  Either one cell to many, or multiple cells to the same number of cells.

Can you do that with the new grid?

In the CTP drop, MS in included the source code for the DataGrid. I was really surprised.  It is a great learning tool.

Will it get released from RTM like that?

Can we extend and customize the code and put that into products?

Hi, can anybody tell me that how we can bind Images that comming from database to DataGrid?

and what kind of images we can bind?

thaks

Hi Vincent, I am facing one more problem today. That I am trying to bind my read-only proprty to grid in "OneWay". but it still display an error message "A TwoWay or OneWayToSource binding cannot work on the read-only property".

But the strange thing is that I am binding it as "OneWay" explicitly.

Any advice? thanks

Hi,

I tested the datagrid and are having problems (in some areas). I bind the grid to an ObservableCollection with contents and it worked fine. But if the collection does not contain any item, you cannot add a new row via the grid. This only happens when AutoGenerateColumns = True.

And also, say the grid has items. When you click on the last row (the NEW row) and begin edit, then click back on some other row, a new row is generated even though you did not enter a value on the then was new row. Is this by design?

Hi,

This is possibly a very silly question, but, how does one bind to a DataTable? I'm simply trying to bind the grid to a table in an SQL database, but I'm stumped as to how to do it.

There have been several questions on the WPF CodePlex discussion list relating to styling rows and columns

Hi Vincibal,

I have built my own CustomDataGrid for copy-paste based on your example, which I'm very grateful for. However, I would like the user to be able to add new rows to the grid by pasting many rows. In your example rows are only overwritten but no new ones are created. I've tryed to figure out how to manage that but I think I need some help... Thank you!

Thank you vincibal. It works great!

Hi,

I've read your blog about and it looks like the datagrid is shaping up to be a flexible control. Can't believe I just read this today. I have a question though. Does this datagrid support ierarchical views? If not, will it? Thanks!

Hi,

Adding the new row in DataGrid will (by default) call the default constuctor of object (whose collection is binded to datagrid).

so, is it possible to call contructor other than default constructor when adding a new row?

Any help?.... thanks in advance...

Thanks vinsibal for quick reply. That is the option I am following right now but according to my business logic, it's not healthy way to do.

So, will this feature be in next release or not?

thanks

Anybody tried binding to a collection that contains abstract objects?  When I make an attempt at adding a new row it will report to me that the type of object it's trying to instantiate is abstract and cannot be instantiated.  I would like to be able to go with the default object in this case but I'm not sure yet how to communicate that to the grid.  Is there an event before 'InitializingNewItem' I could possibly use to inject this logic?

Hi Vincent,

Thanks for the article. I've also read your article about the DataGridComboBoxColumn and when I tried it out, I noticed that the DataGridComboBoxColumn is read-only. I want to be able to implement an AutoComplete feature when a user edits the contents of a cell. Any ideas?

Great demo but can you show us all how to have a simple button on the screen that will delete the selected row from the DataGrid in code-behind? Go on, please show us, sounds simple!

Hi Vicent,

Is it possible to get the coordinates of a cell (left, top, right, bottom)? I want to be able to show a usercontrol directly below the cell, or directly to the right of a cell, etc. Thanks!

Hi,

When is the official release (of datagrid)? And will MS release a downloadable .NET 3.5 with SP1 bundle?

Is it possible to change how the ENTER key works when focus is on the grid? Say, I want the focus to be on the next column of the same row, not on the next row when I press ENTER.

Hi Vincent,

Is it possible to get the coordinates of a cell (left, top, right, bottom)? I want to be able to show a usercontrol directly below the cell, or directly to the right of a cell, etc. Thanks!

Hi Vincent,

First of all thanks for your articles. I find your blog the most helpful for the current datagrid.

I've been playing around the datagrid and am quite satisfied with what is available with it. But I have stumbled into a problem. And, seeing that many asks for your help with regards to the datagrid, I would like your help too.

While editing a text column on the datagrid, if you set focus on another control, the text column commits the values and the editing control (textbox) gets hidden. Is there a way for the textbox to stay visible and editable even if focus changes, say to a listview? Thank you very much.

Hi Vincent,

I got a problem and im hoping you can help me out. I bound a datagrid to a List<T>. Only one column is bound: a Name column. What I can't seem to figure out is I need to get the unique ID a new object added to the grid. But since there is only a Name column, when you add a new column, of course only the Name property of T has a value. I can't think of a way how to get the T's ID after editing Name. Any ideas?

Hi Vince!

is there a post out there somewhere than can give me an example of how to access the content of in individual cell (code behind XAML c#) .. ie datagrid populated with toList() six columns accross 10 rows

I want to get the content of the cell that intersects the fourth rown and the second column..

Thanks

Hi Vincent, is that possible for one column last one or any one to spring or fill the remaining of the grid area automatically?

Lev

So, I cannot use AutoGenerateColumns and ItemsSource BOUND TO Collection? Should I do something similar to WinForm DataGridView -- no autogenerate, manually create datagrid column, set HeaderText, AutoSizeMode, DataPropertyName, and then add it to grid's column collection?

Thank you for your answer

Lev

Hi Vincent,

How do you get the current row?

Hi again,

About the current row, could you elaborate a bit? The CurrentItem returns an object and if I call GetType(), it returns the type that is bound on that row. How exactly do I get the current row from CurrentItem?

I am trying to get the new Wpf datagrid to work with an EditableRootList(CSLA Framework). When I update one of my items in the collection through editing a cell in the grid everything works fine first time changes are made. I can see the events being fired in the grid and Save is called on the item. The properties passed in are the new ones after editing.

Second time, same cell, same picture although the item passed seems to be the old one. IsDirty not checked, properties not modified. Of course the Save is ignored in BusinessBase.

Looks like the Grid is not replacing the references after the first update. However the UI is showing the correct values after the modifications although they are never modified in the DB. I am using a StaticResource and the CslaDataProvider. Csla Version 3.5.1 with VS 2008 Express C# :Net 3.5 Sp1

Am I missing something or is it really an issue with the new DataGrid?

hi,

when will the next version of the DataGrid be released (I saw that it will be part of the PDC)?

Vincent,

About the current row I asked you, how do you exactly use CurrentItem to get the row? The CurrentItem is of type whatever object type when the grid is bound to a collection. Do you mean I find the CurrentItem in the bound collection and use the item's index in the collection?

Vincent, I don't get this. I have a datagrid bound to a List<MySubject>. MySubject is like this:

public class MySubject

{

public string Description {get; set;}

public string Units {get; set;}

public Subject Subject {get; set;}

}

public class Subject

{

public string Name {get; set;}

}

I've got three columns bound like this:

           DataGridTextColumn colAccount = new DataGridTextColumn();

           Binding b = new Binding("Subject.Name");

           b.Mode = BindingMode.TwoWay;

           colAccount.DataFieldBinding = b;

           colAccount.Header = "Name";

           dgrdChild.Columns.Add(colAccount);

           DataGridTextColumn colDescription = new DataGridTextColumn();

           b = new Binding("Description");

           b.Mode = BindingMode.TwoWay;

           colDescription.DataFieldBinding = b;

           colDescription.Header = "Description";

           dgrdChild.Columns.Add(colDescription);

           dgrdChild.ItemsSource = _SubjectList;

The problem is, when I add new values to an empty datagrid, the name column won't commit, but description column does. Does it have anything to do with the Name column bound to an aggregate class?

How do you resolve this, Vincent? If you have a datagrid in a modal window and a Cancel button (isCancel=True), when you click a cell of the datagrid and start typing, and if the first character you type is 'c', the Cancel button is triggered. So instead of being able to type, the window gets closed. How do you prevent this?

Hi Vincent,

That's what I can't get. Cancel's hot key is 'C' (_Cancel) and IsCancel = True. I tried adding an event handler to Cancel_Click and whenever I press 'C' when focus is on datagridcell (but not in edit mode), instead of entering edit mode and writing 'C' on the cell (textbox), Cancel_Click is triggered. I have no code whatsoever for the datagrid. I hope you can I try it out. Thanks.

Hi Vincent,

Thanks for having the time to help me. But it suddenly worked now. What I did was, in Expression Blend, I deleted the DataGrid in the Window, then I added a new DataGrid (same name, default properties) and now when I press 'C', it goes into edit mode. Don't know what happened. I did install toolkit v1 but I doubt that's got anything to do with it. Maybe. Thanks anyway!

Me again Vincent,

I thought the problem was gone but apparently, it wasn't. I've included the whole code I used. This Window only contains a DataGrid (no properties changed except width, height, and position-related properties) and a button (IsCancel = False, Content = _Cancel). If you want to reproduce the behavior, upon loading, single-click the first cell and type 'C'. The window will close and if you try to put a breakpoint in btnCancel, you will see that it is triggered upon pressing 'C'. BTW, my email is bongbong_23@yahoo.com. Thanks a lot!

using System;

using System.IO;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Navigation;

using System.Collections.ObjectModel;

using Microsoft.Windows.Controls;

namespace UntitledProject1

{

public partial class Window1

{

       private ObservableCollection<Employee> _EmployeeList = new ObservableCollection<Employee>();

       //

       //

       //

public Window1()

{

this.InitializeComponent();

// Insert code required on object creation below this point.

           this.Loaded += new RoutedEventHandler(Window1_Loaded);

           this.btnCancel.Click += new RoutedEventHandler(btnCancel_Click);

}

       // Cancel's Content property is _Cancel.

       private void btnCancel_Click(object sender, RoutedEventArgs e)

       {

           this.Close();

       }

       private void Window1_Loaded(object sender, RoutedEventArgs e)

       {            

           dgrd.AutoGenerateColumns = false;

           // Columns.

           DataGridTextColumn colFirstName = new DataGridTextColumn();

           Binding b = new Binding("FirstName");

           b.Mode = BindingMode.TwoWay;

           colFirstName.Binding = b;

           colFirstName.Width = new DataGridLength(100, DataGridLengthUnitType.Star);

           colFirstName.CanUserSort = false;

           colFirstName.Header = "First Name";

           dgrd.Columns.Add(colFirstName);

           DataGridTextColumn colMiddleName = new DataGridTextColumn();

           b = new Binding("MiddleName");

           b.Mode = BindingMode.TwoWay;

           colMiddleName.Binding = b;

           colMiddleName.Width = new DataGridLength(200, DataGridLengthUnitType.Star);

           colMiddleName.CanUserSort = false;

           colMiddleName.Header = "Middle Name";

           dgrd.Columns.Add(colMiddleName);

           DataGridTextColumn colLastName = new DataGridTextColumn();

           b = new Binding("LastName");

           b.Mode = BindingMode.TwoWay;

           colLastName.Binding = b;

           colLastName.Width = new DataGridLength(50, DataGridLengthUnitType.Star);

           colLastName.CanUserSort = false;

           colLastName.Header = "Last Name";

           dgrd.Columns.Add(colLastName);

           dgrd.ItemsSource = _EmployeeList;

       }

       private class Employee

       {

           public string FirstName { get; set; }

           public string MiddleName { get; set; }

           public string LastName { get; set; }

       }

}

}

Could you point me to any write up on the changes between the RTM and V1 of:

In the RTM it was  - DataFieldBinding

In the RTM it was -  DataGridRowsPresenter

In the RTM it was - DataGridColumnHeader

Each of these RTM Names break my code when using version 1, so it would help if you could point me to the right place to start reading about the changes.

Hi Vincent!

I need to generate group summaries like sums and averages. Can you point me in the right direction?

Thanks for all your hard work!

Could you pls show an xample of using linq to bind a data to the SP1 Datagrid?

i cant seem to find any example whatsoever..

It seems all the articles assume that we all know how databind but its not so.

thxs

I need to customize my cell value in WPF. Previously I have done the same by inheriting DataGridView - DataGridViewTextBoxCell and override Paint method.  

Do we have an equivalent for the same in WPF DataGrid?

Hi Vincent,

    I am working on a typical big project in VB 2005. Recently, we decided to migrate to 2008 version using WPF to create a new UI. I am using WPF datagrid from the WPF toolkit.

    However, I am NOT able to dynamically add row values in the datagrid. Since I can't attach any sample code.I will describe the same.

    Plz create a WPF app. Add 6 textboxes, a button and the WPF datagrid. I the code view I have something like this:

'%%%%CODE STARTS%%%%%%%%%%

   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles Button1.Click

       Dim colcount As Integer = 3         ' values hardcoded here, as there are 3 textboxes for column entry

       Dim rowcount As Integer = 1         ' values hardcoded here

       Dim TD_Param_Column(0, 2) As String

       Dim TD_Param_Columnname

       ReDim TD_Param_Columnname(colcount - 1)

       'For l = 0 To colcount - 1

       TD_Param_Columnname(0) = TextBox1.Text

       TD_Param_Columnname(1) = TextBox2.Text

       TD_Param_Columnname(2) = TextBox3.Text

       ' Next

       TD_Param_Column(0, 0) = TextBox4.Text

       TD_Param_Column(0, 1) = TextBox5.Text

       TD_Param_Column(0, 2) = TextBox6.Text

       '===========================================

       'Adding the columns to the Datagridview1 : 2005 version

       'For l = 1 To colcount - 2

       '    Me.DataGridView3.Columns.Add(("Column" & l), TD_Param_Columnname(l - 1))

       'Next

       'Adding the columns to the Datagrid1 : 2008 version

       For l = 0 To colcount - 1

           Try

               Dim dgtc As Microsoft.Windows.Controls.DataGridTextColumn = New Microsoft.Windows.Controls.DataGridTextColumn()

               dgtc.Header = TD_Param_Columnname(l)

               Me.DataGrid1.Columns.Add(dgtc)

           Catch

           End Try

       Next

       '===========================================

       '===========================================

       'Adding the rows to the Datagrid1 : 2005 version

       'Dim l As Integer

       ''Writing the the test datas in Old Variant grid

       'For k = 1 To rowcount - 1

       '    l = 1

       '    For g = colcount - 2 To 1 Step -1

       '        Try

       '            Me.DataGridview3.Rows(k).Cells(l).Value() = TD_Param_Column(k, g)

       '            l = l + 1

       '        Catch

       '        End Try

       '    Next

       'Next

       'Adding the rows to the Datagrid1 : 2008 version  NOT WORKING !!!!

       For l = 0 To colcount - 1

           Try

               Dim dgtr As Microsoft.Windows.Controls.DataGridRow = New Microsoft.Windows.Controls.DataGridRow()

               dgtr.SetValue(DataGrid1.Items(0), TD_Param_Column(0, l))

               Me.DataGrid1.Items.Add(dgtr)

           Catch

           End Try

       Next

       '===========================================

   End Sub

'%%%%% CODE ENDS%%%%%%%

Please tell me how to add row values dynamically in the above code.

Thanks and Regards,

Abhishek

Hi

I am trying to setup two-way binding in the datagrid, but some how it does not seem to work.  I am able to change the value in the cell, but as soon as the cell loses focus, the value in the cell reverts back to what was there before I made the change.  The DataGrid is setup like this:

       <dg:DataGrid  Grid.Row="2" x:Name="melodyListView" ItemsSource="{StaticResource melody}" AutoGenerateColumns="False" HorizontalAlignment="Right" Width="224" Margin="0,6,0,0">

           <dg:DataGrid.Columns>

               <dg:DataGridTextColumn Binding="{Binding Name, Mode=TwoWay}" Header="Name" CanUserSort="False" />

               <dg:DataGridTextColumn Binding="{Binding Duration, Mode=TwoWay, Converter={StaticResource durationConverter}}" CanUserSort="False" Header="Duration" />

               <dg:DataGridTextColumn Binding="{Binding Volume, Mode=TwoWay, Converter={StaticResource volumeConverter}}" CanUserSort="False" Header="Volume" />

           </dg:DataGrid.Columns>

       </dg:DataGrid>

In the code the binding is setup:

melody = new Melody();

           melodyListView.DataContext = melody;

           Binding b = new Binding();

           melodyListView.SetBinding(Microsoft.Windows.Controls.DataGrid.ItemsSourceProperty, b);

       }

Any idea what am I missing here?

Hi,

I want to Copy the contents of the datagrid on a button click event. If i try to set the Application Command.Copy in my button, it is getting disabled always.

Can you help me to acheive this clipboard copy of datagrid by button click.

Thanks,

Sriram

Vinsibal,

how could i get the datagridcell from datagridcellinfo object?

thanks,

charley

I am trying to iterate through all checked rows on the DataGrid. How is this done?

Hi vinsibal,

I want to map A CSV file on to WPF datagrid. How can I do that? Thanks in advance.