Any recommendation for WPF Datagrid??
-
I've been evaluating around 5 third-party WPF datagrids for my project.. Each Datagrid has some issues.. (Ref[^]) The following are my requirement for buying WPF datagrid.. * Controls inside the Datagrid Column: I wanna display one or more WPF controls (e.g. Checkedbox or Combobox, Textbox or etc) inside the column of Datagrid. Plus, I should be able to set/get the value to/from those controls at runtime. * Excel-Like Filtering: Should we call it as the row filtering? In Microsoft Excel, we are able to filter by the rows.For example: There are ten student records showing in Datagrid and those students are from Math Major and Physic Major. So, I should be able to filter those students by Major. Yes. it’s like grouping but if I say “grouping”, you might get confused with grouping features of Datagrid. * Sorting, Grouping: Of course! * Hierarchical display: Same as Grouping featuer? (Importantly, It would be better if we can specify the appearance of hierarchical in XAML) * SelectedItem Binding (two ways): I believe that this feature should be included in every datagrid but surprisely, I found a few datagrids that don’t provide this feature. Weird. * Less work from Code-behind file: What does it mean? It means, I should be able to do the most of works in XAML. In my current project, we are using MVVM (Model-View-ViewModel) pattern with CompositeWPF (Codename: Prism) framework so we do the most of jobs in either XAML or ViewModel (which is not a code-behind file) and we try not to write as much as possible in code-behind file. It would be great if anyone can recommend some cool WPF datagrid control.. Thanks in advance...
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
-
I've been evaluating around 5 third-party WPF datagrids for my project.. Each Datagrid has some issues.. (Ref[^]) The following are my requirement for buying WPF datagrid.. * Controls inside the Datagrid Column: I wanna display one or more WPF controls (e.g. Checkedbox or Combobox, Textbox or etc) inside the column of Datagrid. Plus, I should be able to set/get the value to/from those controls at runtime. * Excel-Like Filtering: Should we call it as the row filtering? In Microsoft Excel, we are able to filter by the rows.For example: There are ten student records showing in Datagrid and those students are from Math Major and Physic Major. So, I should be able to filter those students by Major. Yes. it’s like grouping but if I say “grouping”, you might get confused with grouping features of Datagrid. * Sorting, Grouping: Of course! * Hierarchical display: Same as Grouping featuer? (Importantly, It would be better if we can specify the appearance of hierarchical in XAML) * SelectedItem Binding (two ways): I believe that this feature should be included in every datagrid but surprisely, I found a few datagrids that don’t provide this feature. Weird. * Less work from Code-behind file: What does it mean? It means, I should be able to do the most of works in XAML. In my current project, we are using MVVM (Model-View-ViewModel) pattern with CompositeWPF (Codename: Prism) framework so we do the most of jobs in either XAML or ViewModel (which is not a code-behind file) and we try not to write as much as possible in code-behind file. It would be great if anyone can recommend some cool WPF datagrid control.. Thanks in advance...
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
I've only used two of note, both of which I'm sure you'll have already tested. Xceed WPF Grid & Infragistics XamDataGrid. I'm working on a project for my own company and I'm also working on a large LOB WPF app for my employer, both are using the XamDataGrid. We too are using MVVM (Dan's flavour) in the LOB app. So far we are really pleased with the XamDataGrid. Before opting for the XamDataGrid I test run a few myself and wasn't overly impressed. The Component One stuff just looks terrible in my opinion. The Xceed looks good but due to us wanting to buy a complete suite we ended up opting for the Infragistics stuff (we wanted a good chart as well). In my opinion the Infragistics stuff is still the WPF suite of controls to measure things by. That said I had an interested reply from one of the sales guys as Nevron. He basically said that for their WPF offering (not available yet) they were going to be implementing their own framework which will be merely hosted by WPF citing performance as their reasoning. I'll be looking out for that as I'm intrigued to find out exactly what he was on about. I've been using the XamDataGrid with datasets of 100,000+ records and i've not had any problems ... There are a few other small component houses that are making things but they really don't compare to Infragistics yet. Not to mention that the support and developer interaction that I've had with the Infragistics folks has been exemplary. That's worth the price of admission. Don't forget that you can get a full blown copy of the XamDataGrid for FREE!!!! Look for their Express suite ... you get the grid, checkbox and an editor for zilcho ... nada ... nothing ... wooo! Just out of interest, what have you found that you have liked??
Jammer Going where everyone here has gone before! :) My Blog | Article(s)
-
I've only used two of note, both of which I'm sure you'll have already tested. Xceed WPF Grid & Infragistics XamDataGrid. I'm working on a project for my own company and I'm also working on a large LOB WPF app for my employer, both are using the XamDataGrid. We too are using MVVM (Dan's flavour) in the LOB app. So far we are really pleased with the XamDataGrid. Before opting for the XamDataGrid I test run a few myself and wasn't overly impressed. The Component One stuff just looks terrible in my opinion. The Xceed looks good but due to us wanting to buy a complete suite we ended up opting for the Infragistics stuff (we wanted a good chart as well). In my opinion the Infragistics stuff is still the WPF suite of controls to measure things by. That said I had an interested reply from one of the sales guys as Nevron. He basically said that for their WPF offering (not available yet) they were going to be implementing their own framework which will be merely hosted by WPF citing performance as their reasoning. I'll be looking out for that as I'm intrigued to find out exactly what he was on about. I've been using the XamDataGrid with datasets of 100,000+ records and i've not had any problems ... There are a few other small component houses that are making things but they really don't compare to Infragistics yet. Not to mention that the support and developer interaction that I've had with the Infragistics folks has been exemplary. That's worth the price of admission. Don't forget that you can get a full blown copy of the XamDataGrid for FREE!!!! Look for their Express suite ... you get the grid, checkbox and an editor for zilcho ... nada ... nothing ... wooo! Just out of interest, what have you found that you have liked??
Jammer Going where everyone here has gone before! :) My Blog | Article(s)
I have tested 5 third-party controls and updated my post yesterday.. Based on my experience, Infragistics/C1 are so unstable for now even though they are big companies. I like Xceed Datagrid and I think their doc and samples are really great.... I got one reply from Xceed in their forum.. http://xceed.com/CS/forums/thread/13984.aspx[^] Hopefully, they can solve the problem that Im having now.
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
-
I have tested 5 third-party controls and updated my post yesterday.. Based on my experience, Infragistics/C1 are so unstable for now even though they are big companies. I like Xceed Datagrid and I think their doc and samples are really great.... I got one reply from Xceed in their forum.. http://xceed.com/CS/forums/thread/13984.aspx[^] Hopefully, they can solve the problem that Im having now.
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
Infragistics?? Unstable??? Are you sure we're talking about the same things??? I have an app out at Beta testing stage using that grid and no-one is reporting problems with the grid ... What exactly do you mean by unstable?
Jammer Going where everyone here has gone before! :) My Blog | Article(s)
-
Infragistics?? Unstable??? Are you sure we're talking about the same things??? I have an app out at Beta testing stage using that grid and no-one is reporting problems with the grid ... What exactly do you mean by unstable?
Jammer Going where everyone here has gone before! :) My Blog | Article(s)
Please take a look at my post[^]? I have four problems. It would be great if you can help me to solve those problems..
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
-
Please take a look at my post[^]? I have four problems. It would be great if you can help me to solve those problems..
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
okay. If you don't want to go to my blog, I will post those issues here. Hope, you may suggest something... * No SelectedItem: There is no dependency property called SelectedItem or equalivalient in xamlDatagrid. But they do have SelectedItems (with s). I wonder what wrong with SelectedItem. I don’t allow the user to select more than one row at a time so why do I need to loop through the SelectionItem list to get that selected item. Weird. * Can’t get the reference of controls inside the Datagird: Maybe, I don’t know the correct way of doing this. And also, there is no documentation or sample for that. I tried to use VisualTreeHelper class to walk throught each and every element of Datagird but I just can’t find the controls which are inside DataTemplate. (It’s so easy to do with Xceed Datagrid.). Okay. Never mind. * Showing the incorrect record if the datasource has some filters: I was using ListCollectionView as a datasource to bind the datagrid. There are some records that need to be excluded so I used the filter predicate for excluding those unnessary records. Then, I binded that ListCollectionView with Datagird. It works for the first time. So, I added new record to ListCollectionView and make it refresh. Opps! it shows the exclued record. crazy! then, I put WPF listview to find out whether this is a ListCollectionView problem or datagrid problem. And I found that it’s working fine with ListView. This issue is really crazy.. * Showing wrong checkedstate when scrolling: Here is another crazy issue. I created three columns for Datagrid in XAML. One of three columns has the checkbox inside. I showed around 30 records on the datagrid but only 10 rows are viewable within datagrid since I specify the height of datagrid explicitly. Then, I run the problem and checked a couple of checkbox. After that, I scrolled up and down a bit then the checkbox that I haven’t checked are automatially checked after scrolling.
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
-
I have tested 5 third-party controls and updated my post yesterday.. Based on my experience, Infragistics/C1 are so unstable for now even though they are big companies. I like Xceed Datagrid and I think their doc and samples are really great.... I got one reply from Xceed in their forum.. http://xceed.com/CS/forums/thread/13984.aspx[^] Hopefully, they can solve the problem that Im having now.
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
Just reading the bit you did on XamDataGrid (since this is what I have most experience with) ... 1. Their "SelectedItem" is called "ActiveRecord" ... 2. I have loads of embedded controls in our grids with no problems. All easily controlable, I have some dynamically animated based on the grids contents as well. 3. In the app I'm doing for my company I used filters extensively to sort the results in the grid, not sure why you'd see problems here. 4. Not sure what is going wrong here, they did have an issue with the checkboxes that was fixed in a hotfix some months ago now. Anyway, seems like you decicded on Xceed now. Although I'm not sure you have given them all a good thorough testing however.
Jammer Going where everyone here has gone before! :) My Blog | Article(s)
-
Just reading the bit you did on XamDataGrid (since this is what I have most experience with) ... 1. Their "SelectedItem" is called "ActiveRecord" ... 2. I have loads of embedded controls in our grids with no problems. All easily controlable, I have some dynamically animated based on the grids contents as well. 3. In the app I'm doing for my company I used filters extensively to sort the results in the grid, not sure why you'd see problems here. 4. Not sure what is going wrong here, they did have an issue with the checkboxes that was fixed in a hotfix some months ago now. Anyway, seems like you decicded on Xceed now. Although I'm not sure you have given them all a good thorough testing however.
Jammer Going where everyone here has gone before! :) My Blog | Article(s)
Jammer wrote:
1. Their "SelectedItem" is called "ActiveRecord" ..
Is this bindable? Let's say I bind this "ActiveRecord" with AA Get/Set property. If I select one row after another on datagrid, can i get the selected record from AA property?
Jammer wrote:
2. I have loads of embedded controls in our grids with no problems. All easily controlable, I have some dynamically animated based on the grids contents as well.
How can I get the reference of those embedded controls? I wanna use like DG.Row[1].Cell[1].FindControl("myextendedtextbox")
Jammer wrote:
3. In the app I'm doing for my company I used filters extensively to sort the results in the grid, not sure why you'd see problems here.
Are you using ListCollectionView.Filter? Did you bind it to Datagrid? Have you tried to add new item to that ListCollectionView? I'm not sure why I got that error, man. >>seems like you decicded on Xceed now. Not yet. I'm doing with Telerik Datagrid before I got the solution from Xceed. If Xcced can give me some solutions, I may use that grid. Otherwise, I hav to go with Telerik....
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)
-
I've been evaluating around 5 third-party WPF datagrids for my project.. Each Datagrid has some issues.. (Ref[^]) The following are my requirement for buying WPF datagrid.. * Controls inside the Datagrid Column: I wanna display one or more WPF controls (e.g. Checkedbox or Combobox, Textbox or etc) inside the column of Datagrid. Plus, I should be able to set/get the value to/from those controls at runtime. * Excel-Like Filtering: Should we call it as the row filtering? In Microsoft Excel, we are able to filter by the rows.For example: There are ten student records showing in Datagrid and those students are from Math Major and Physic Major. So, I should be able to filter those students by Major. Yes. it’s like grouping but if I say “grouping”, you might get confused with grouping features of Datagrid. * Sorting, Grouping: Of course! * Hierarchical display: Same as Grouping featuer? (Importantly, It would be better if we can specify the appearance of hierarchical in XAML) * SelectedItem Binding (two ways): I believe that this feature should be included in every datagrid but surprisely, I found a few datagrids that don’t provide this feature. Weird. * Less work from Code-behind file: What does it mean? It means, I should be able to do the most of works in XAML. In my current project, we are using MVVM (Model-View-ViewModel) pattern with CompositeWPF (Codename: Prism) framework so we do the most of jobs in either XAML or ViewModel (which is not a code-behind file) and we try not to write as much as possible in code-behind file. It would be great if anyone can recommend some cool WPF datagrid control.. Thanks in advance...
Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net)