WPF Controls with MVVM: DataGrid 

I did not think I can be so capable this fast. I realize there is a lot to learn, and appreciate so much you created this content.

Well Done Tim, I've been a long time developer in VB and the transition to C# and WPF has been made so much easier with your tutorials, Please keep it up Thanks from down under

Hey Tim, That was quick. Thanks for obliging my request for a "DataGrid" session. Good job with the 'CellEditingTemplate'/'DatePicker', learnt something new. Looking forward to other contents on WPF... Keep up the good work. 👍

0:00 - Intro 0:57 - Prerequisites 1:46 - Demo app overview 2:36 - Creating DataGrid 4:11 - Alternating row background 5:01 - Adding data 7:18 - Columns 10:56 - Dropdown in column 18:19 - Date picker 21:56 - Summary and concluding remarks

always a blast being educated by you :)

Really nice! Thanks for sharing all that knowledge.

Its amazing! Your examples are useful and you make that easier! Thank you ;)! The best channel with C#.

Thank you so much Tim, this vid help me a lot! Keep on going!

never used caliburn but you made it very easy to get used to it in two to three videos, thanks Tim

clear and simple explanation. Thanks!

To the point. Easy to understand.

this really help alot thanks

Thanks! Very useful

Thanks so much !!! It's a great tutorial, I'm speak spanish but understand all perfect!!

Hey Tim, REALLY terrific content!! Thank you for everything. Think you could do a more advanced video which illustrates dealing with changes in the DataGrid in MVVM? For example, only processing objects or properties which have changed. Again, thanks for all of the great tutorials and knowledge sharing!!!

Nice, it’s useful

Thanks so much.

LMFAO... At 3:20.... LMFAO... This is the fourth or fifth video of the WPF collection that I have been watching... I can't stop laughing !!!! Your videos are awesome thank you so much!!

Nice!!!!!

Thanks man.

I'm gonna show this video to some of my coworkers for sure. I'm trying to convince them to move to WPF from winforms as our solution grows and grows and grows and their biggest worry is that somehow it will be be harder to work with grids. I think I'll just show them the first 5 minutes of the vid so I don't scare them off with the templating stuff :) bind to an item source. Done!

Didnt watch it yet but the title says it's going to be good!

im having issues with a Ambiguity between the and the BindableCollection People

I'm a newbie, I'm learning DataGrid using Dapper. let me download this video. thank you Tim, God bless you ..

Hey Tim! Do you have any materials on how to bind this ComboBox to List that is outside of Person model? Like if the Addresses are just a list(taken and updated from database) and you can select for every person a address from there? Makes more sense, if i have one list of address and Person model holds only the Id to that address(as its done with the WinForms combobox). I have searched a bit but haven't found as nice tutorial as you do on these topics(i even started the C# mastercourse on your website thanks to these youtube videos). Usually when the code starts to scare me, then i know that there is a simpler way to do it...

Nice

thanks!

Thanks

hi what is the best way to array control in wpf mvvm in two dim ( in X & Y direction ) to create table of data other than datagrid

Hi Tim, thanks for sharing this. I use DataGrids a lot, if fact it is my major way to show tables. I use HeaderTemplates, that allow to set filters on the data, I use RowDetails, to expand a row a bit. Up till now, I did not integrate editing like you do, it's an idea to consider. At the moment I try to master DataGrids with with a variable numer of columns, which are generated dynamically. My first attempt is now working, but it only supports strings. In my second attempt I want to use objects and create a form of templating for the DataGridCells, to allow for a nicer markup. I just discovered you can freeze the first column, which is very useful. I always will use scrollbars, but this requires to fix height and width of the DataGrid. So there really is a lot you can do with this.

Hi Tim, These videos are great to watch and I got to learn a lot from them. I am new to this WPF and I needed some help in grouping data in the data grid with collapsible and expandable button. This is an existing application that I am working on and it has been implemented using Caliburn Micro. So is there a simple way of doing this? Please do reply..

Hi Tim, I've been trying to bind my checkbox (inside a datagrid template column) to an event (both property setter and methods, neither worked), i tried everything i could find online for the past couple of hours but nothing seems to work. A regular checkbox works fine with the notifyOfPropertyChange, this checkbox doesn't though. I tried UpdateSourceTrigger=PropertyChanged, RelativeSource AncestorType=DataGrid, and a few other things, with different combinations (all with IsChecked, as checked would give an error), but nothing worked yet

Hi Tim, Thanks for the video. Please advise how to use numeric up down control to change the number of rows shown in the data grid. Thanks!

Great Video Tim!! i was wondering if you have a video that explains all the different events on DataGrid such as BeginningEdit, PreviewLostKeyboardFocus, InitializingNewItem, CellEditEnding ... etc ?

Hi Tim, I'm glad you're still replying to comments until this day. I do have a problem on my project. Lets say I have a datagrid with rows of numbers and I have a property to add all of those numbers. Now I want to run the addition property every time I edit a row on the UI but it doesn't. Using a button obviously works but automatically, no. I used NotifyOfPropertyChanged but it seems to not trigger it when editing on the datagrid.

I have a question. How can i make it so a column only Accepts currency values? I'm pretty sure it will be with the edit template but I'm not sure how.

Will there be more videos coming for this series? This has been extremely helpful. Thank you for taking the time to make them.

Came here to see what I did wrong with adding my list of custom objects to a DataGrid source. You skipped over that part. But while writing a three-paragraph ranty text about it, checking my code and going back in your video for specifics, I figured my issue. Though you're not showing it in the video, I realized I had to both set each property I wanted to show to "public" rather than "protected" AND create the getters and setters. I had tried before by just switching them to public, but that did not work. I'm a newb when it comes to C#, so I don't yet know when it is important to specify { get; set; } yet. Most other languages I've worked with will assume these two methods on all accessible properties. Since, you know, it's rather silly to have a public property you cannot access from the outside. Anyway, great video as always, the issue was entirely on my end, and this has just been another example of how you sometimes find the answer to your problem by trying to explain it to someone else. Which I guess is why teaching others is a great way to learn yourself.

If I have a button with command parameter that has employee Id how do I access it in c# so I have int Id = (that command parameter employee I’d)

Was waiting for it eagerly. Thanks much Just curious which is next control you are going to teach us?

Works a treat. Can you pass a generic List to a BindableCollection, using a single DataGrid dependant on what DataModel is used?

Thank you for the excellent example Tim. Can you wire up for instance a click or double click event on the cell content of the datagrid and maybe have it filter the results of a particular column that you clicked in? For instance click in the Birthday column on a value with a certain year and filter the results with birthday's of that year.

How do you normally validate the data, it seems that INotifyDataErrorInfo, which is supposedly now recommended solution by many devs doesn't gel well with DataGrid, I have also ran with issues trying to customise it

Hi, I have a question. I'm making a small Inventory system Project. I'm doing this with the MVVM framework. And in one of my views, I also using a bindableCollection to display all my customers. I also added some Delete and Edit buttons in case the user wants to delete the customer from the datagrid. I have is I would like to use some commands that are also bonded to some ICommand Classes to delete or edit some of those customers. The problem is I can't get those commands because they are not part of the bindable collection. I can only bind to the properties in my collections. What is the best way to do still use those commands? I thought of multiple item sources in order to get those commands but apparently, a Datagrid only allows one item source binding not multiple. Thanks anyway for the amazing content you give.

hi any help for saving a datagrid an load again with observablecollection?

Please help how to reduce the space between the lines of the Gridview . Thank you in advance, sir

Great video Tim! Really usefuI. I am planning an app in which a user selects a person from the datagrid view and then opens a usercontrol to edit the person''s details in a form view. The user would then save the data (to database) and return to the datagrid. Would it be possible to show us perhaps in a future video the proper way to do that? Looking forward to see more WPF and any other topics you plan for us. Thanks.

Great sets of videos I have learn a ton. I did have a question on the datagrid combox. I noticed that the down arrow is missing unless you click on the cell. Is it possible to have the arrow showing all the time? if so how?

Great video. One question: while I see how the edits modify the instantiated model (data in memory), how would you trigger committing the changes back to the database?

Very clearly explained, thank you. I would like user have provision to sort and filter data grid columns like Excel, It will be great if you could share a link where it has implemented or guided how it has to be done. Thank you so much.

Hi Tim, thank you again. Your tutorials are the best! Is there an easy way to display only the persons that are alive? Even if in the Collection are people which aren’t.

This is very good! Thanks for putting effort into making this video. I’m fairly new to WPF and I’ve learnt a lot from this video. I have a question if you don’t mind... how would you do it if you’d have to highlight cells that have a certain value? Say, for example, a list of users having an “Active” column that can be “Yes”/“No” (or true/false) and you want to set the background colour to light green for all those having “Yes” in that column. Many thanks.

Thank you for the great videos. I would like to request a video on Singleton pattern. Thanks a Lot.

These videos are very helpful, thank you. 1 small question, how can you make calculations with the rows of the datagrid so you can show them in another row? Thank you in advance

Please make a video on Dependency property and attached property in wpf. Thank you

Hi Tim, if I change values, or add a new line, does that automatically change the values in the object? For example, if I have bound an Entity Framework Class to the DataGrid and I make changes in the grid, is it enough, just to call 'SaveChanges()' Method of the EF Framework?

I saw your video "How to connect C# to SQL (the easy way) " (which is great by the way) and now this and I have a question. What can I do if I want to update the database when I write a new row into the gridview??? Basically I have a problem extracting the data from datagrid and save it as a list. Please do a video because for the last 8 hours I found nothing on RU-vid.

Hi Tim, I can populate the WPF Datagrid - is there more information about saving the row changes back to an object model that can be saved back to SQL Database Table?

How can we make the DataGrid header fixed on scroll?

Hi! Do You have a video there you show doubleclick in datagrid and get that row in viewmodel? Im using mvvm and caliburn micro

Hi Tim, how would I get all the displayed data out of that datagrid and into a sql server table? Coming from winforms I cannot use row.Cells[0] anymore

Nice video what is left here to add some demo for changing column order (DisplayIndex)

Hi, Thanks for the videos but I think the wpf series is highly missing a tutorial for events (or event aggregation) on caliburn micro. Can you please make a tutorial on that?

You are big help. Own you beer.

Hey Tim, you got some awesome and informative videos! I have a quick question, how would you set a button that would delete a row that the user selected from the DataGrid? I'm trying to figure out how to retrieve the data in that selected row to be used to pass a query to my SQLite database. For example, following your video, I would click on a "Full Name" row and click a delete button that would retrieve all the data of that person (Birthday, address, etc..). From there, the rest of the code would use that data to fill in a delete query to a SQLite database. Any advice would be appreciated!

Tim does not x:Name define the name of the UI control? So if we use the same name for a property and a UI component, CM renders it? ( I hope I used the right technical words ) And if the UI control like TextBlock does not have x:Name option, we use Binding right?

Hi. A year late, but I've spent the last couple of days with just this problem - a combo box with binding (the default one doesn't appear to do anything due to the information it is "fed" from the partent datagrid from my understanding. Maybe I am talking rubbish. But this did work for me ...

Hi Tim, I was playing around with Datagrid in this demo. One feature that came to my mind was how to implement Find and replace functionality as we see in Microsoft Excel. This was a practice and to do problem solving. I bind datagrid item source to a datatable in my viewmodel. To implement Find and replace functionality, i found one approach but couldn't achieve it. It is like this: I compare a textbox value entered by user with one datatable column's value, and change those value with a new textbox value(say RepalcetextBox), but after I bound data to datagrid, I couldn't compare data column value with textbox value as now I have to deal with DataGrid data and not DataTable values. Can you please tell me if my approach is correct or where I'm going wrong. Do you see think of any other approach I can achieve?

Hey Tim...using caliburn micro (or anything else) is there a way to get the datagrid to refresh without code-behind? I have a form that creates the new item and a button in the datagrid that deletes it; but it's not refreshing. My Datagrid is is named the same thing as my bindablecollection.

Hi Tim, I appreciate your input in making concept of learning C# easier, since I've watched lots' of video tutorials you've posted there. They are mostly very clear and intuitive to get close with the idea. But I have one very big notice regarding MVVM-concept and it's regarding the Caliburn Micro: I would like to implement MVVM without Caliburn micro. Is there any plans to make some observable video with datagrids and comboxes (for example) on this topic. Thank you in advance.

Can we show only month and year in date picker . Is there any string format for that ?? Bdw great informative video . Thanks 🙂

Hi Tim, I have data grid on the page....and I have enabled Canfilter property so when I mooise curser over grid column head I can see a tiny text box to filer the perticular column values...so here we ge on my question... When I click on the text box n type any character the data grid will get filtered ..but the text in the textbox which in next to grid header will remains untill unless we manually clear it....so here I want to clear that text when we click on cancel button(it's one of the button on my screen)...can you please help me on this ... Thanks

Hi Tim, Thanks for the amazing Tutorial. I am currently building a Datagrid and it has a column that is supposed to provide a drop down with a editable textbox in case if the desried value is not in the drop down. my datagrid is bound to a datatable. It takes in the value i enter correctly, but while displaying it splits the value into single characters and displays them as sepearet items. Would be glad to hear from you.

You are awesome many thanks for the magnificent tutorial but what is the BindableCollection is?? and how to bind data in excel to datagrid (number of columns & names are not know)? thanks again

Hello Tim, very quick question. What is the difference between Binding ="{Binding FullName}" and Binding="{Binding Path=FullName}" the reason why I am asking this, is because looking back at the other tutorials you used mostly the version without path and because both seem to work.

What would you recommend as a replacement for the Windows Forms PropertyGrid? I find it strange how there does not seem to be one in WPF when Microsoft very clearly has one built for their own use in several of their applications that utilise WPF, or so it would seem.

I have one question about data grids or other controls. If a person wanted to have several buttons and when you click on the button, then it runs a command on the view model, how can that be done with caliburn micro? I've done it before with old fashioned Command. However, I would prefer to be able to invoke a method without the commands. What I would want is when they click on an item, that becomes the parameter that gets sent to the method and even having the Can so if the validation fails, then the button would be disabled.

Hi first thank you for all your hard work :-). I am working on a datagrid where the data source is a request to a api how would I go about fetching more data from the api when the user scrolls to the bottom of the datagrid or a few rows before so by the time the user gets to the bottom new data has already been appended?

Great explanation, Is it possible to make a video on how to set DataGridTemplateColumn visibility via Binding using mvvm?

Thanks Tim, Great videos! Im am looking for changing the background color of a specific cell, Every cell contains a object Bag. This Bag has a TrialId. I want to give every cell with TrialId "1" the same background color. the same for every trial. So that i have a nice overview of all the cells with the attached trial. Do you know if i can do this in a datagrid, or maybe you have a different solution. Thanks for helping!

Your lessons are wonderful ... Thank you too much Sir. My question … are you think to do lectures in analyzing “Big data” using Excel, depending on “data mining Excel AddIns tools”, and also by using the some intelligence techniques like “Genetic Algorithm Excel AddIns tools” thank you too much and I wish you always success

Hello Tim, Do you have any tips on how to use a listbox in MVVM?

How can I pass a list of objects to rowdetail?

Hi. Great tutorials. I am relatively new to WPF and was wondering if you could help me with something. I have a similar DataGrid with a Boolean value like isAlive. I get the data for the DataGrid from a SQL Server Database table using Dapper and Stored Procedures. It shows the data fine. But say I wanted to change the Boolean value in the DataGrid from false to true and vice versa, and wanted to reflect the change in the database (maybe using a stored procedure with an update statement?). Is there an easy way to do this? I am also using Caliburn Micro btw.

is there a video before this one? i have to create a table and fill it with data from tsql and this is what im looking for

Dumb question... where/what are the videos leading up to this? Building the VM and the M etc etc.. Definitely going to dive into that!

Hello Tim, thanks a lot for this valuable content. I have one question: When do you use just {Binding FullName] and when {Binding Path=FullName} ?

Hi Tim, from this video we can see that the data is static and if you don't mind I want to know what if we want dynamic data in the datagrid I mean the user can input like microsoft excel so we don't need to initialize the data first. thank you and god bless you

Hi Tim - Your videos have been so much help! I am able to use DataGrid with Caliburn Micro as you have described. What I am really struggling with is how to get the column index for a selected cell. I have tried every combination that I can think of for SelectedUnit = Cell with SelectedCells, SelectionChanged, SelectedCellsChanged, etc. and I have had no success linking my view and my viewmodel at the cell level. Any advice would be greatly appreciated. Thanks!

Hey Tim I just want to add data (your api exercise data ) and populate in in the DataGrid. Before it was easy cause u could create the columns and select a datasource. I have no idea how to insert simple data in this datagrid... You start off with a complex data source

When do we use binding alone, and when do we use a path please? Also do we have to use propfull or other types work with CM and XAML rendering?

I like to get at least a bit of auto-completion and also prevent typos especially in my xaml so I use to set up a bit of help. xmlns:d="schemas.microsoft.com/expression/blend/2008" xmlns:vm="clr-namespace:ProjectXYZ.UI.WPF.ViewModel" d:DataContext="{d:DesignInstance vm:ContainerDetailViewModel}" ... Would you recommend doing this or are there some critical deficits to this?

Hello, Sorting on column-header click for the data template column doesn't work directly in this example, we need to set the SortMemberPath attribute to enable sorting. Just for other beginners like me who face the same issue.

Why are you using "." and not "_" when binding to a property of a property of the view model? Which one is the right one? Are they interchangeable?

How would I save the BindableCollection to EF Core ? .AddRange() is not working for some reason .. Thank you ..

Hi Tim Corey. thanks for this freat tutorial :) It really helped me to learn datagrids in c# but I have a question. I am developing a point of sale program which has a datagrid for the products. If the person enters the same product so just the quantity cell will be increased. So my question is how to get a specific column of a row in datagrid(not selected row!). I do not know why I got stuck about this info and I really researched over the internet detailed but still I could not find any solution. Could you please help me? I tried the following code: int colNo=1; int amount=0; for (int rowNo = 0; rowNo < dgProducts.Items.Count; rowNo++) { DataRowView rowView = (dgProducts.Items[rowNo] as DataRowView); //Get RowView if (rowView[colNo].ToString() == txtProductBarcode.Text)//If there is already the same item on the list, then confirm to add them together or not. { if (MessageBox.Show("There is already the same item in the list. Would you like to sum them?", "Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { amount += Convert.ToInt32(rowView[colNo]); rowView.BeginEdit(); rowView[colNo] = amount; rowView.EndEdit(); dgProducts.Items.Refresh(); // Refresh table addNewProductLine = false; break; } But it does not work :/ I could also send you the program's pictures if you have any e mail. Thanks in advance and thanks for this tutorial :)

Could you maybe do a video explaining the Dispatcher in WPF ?

I was searching for this for a decade. thank you sir. I have a question, how can I align the Column header to the right and also the text that will be inserted under the column to bel aligned to right?

What should I do if I want to display dynamic data? For example I don't know if I have 15 Colums or 120, it depends on the content in the database

How can I achieve to center WPF DataGridColumnHeader and ColumnCells; I want to set all cells and column headers as horizontal center?