WPF Controls with MVVM: DataGrid

If you have been following along in this WPF mini-series, this is probably the one you have been waiting for. Taking data and displaying it on a WPF form in a way that you can edit and manipulate is most easily accomplished with a DataGrid. In this video, we are going to look at how to populate a DataGrid with different types of data, including some advanced use cases.
Full courses: www.iamtimcorey.com/
Source Code: leadmagnets.app/?Resource=Dat...
Patreon: / iamtimcorey
Newsletter signup: signup.iamtimcorey.com/
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
Thanks to Ralfs HBK for the chapters breakdown

[@shawnmofid7131]

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.

[@IAmTimCorey]

I'm glad you are getting up to speed so quickly.

[@robertocallaghan576]

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

[@IAmTimCorey]

I'm glad I could help.

[@RalfsBalodis]

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

[@IAmTimCorey]

Thanks again!

[@youtube.com-handle]

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

[@IAmTimCorey]

Excellent!

[@bharathyadav3614]

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. 👍

[@IAmTimCorey]

Yep. It has been sitting there ready to go for a while. Glad you enjoyed it.

[@hararr1980]

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

[@IAmTimCorey]

I appreciate the kind words.

[@longuinni]

Really nice! Thanks for sharing all that knowledge.

[@IAmTimCorey]

You are most welcome. Thanks for watching.

[@krishnanblr]

clear and simple explanation. Thanks!

[@IAmTimCorey]

You're welcome!

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

[@IAmTimCorey]

You are welcome.

[@d0opify]

always a blast being educated by you :)

[@IAmTimCorey]

I'm glad.

[@leosanni]

To the point. Easy to understand.

[@IAmTimCorey]

Thanks!

[@zohar127]

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!

[@IAmTimCorey]

I am glad it can be helpful.

[@accsoftware3762]

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

[@IAmTimCorey]

Great!

[@cramtorte]

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!!!

[@IAmTimCorey]

I can add that suggestion to the list.

[@codewarez]

this really help alot thanks

[@IAmTimCorey]

You are welcome.

[@user-uh6qi1hr3p]

Thanks! Very useful

[@IAmTimCorey]

You're welcome!

[@heloisaduarte4745]

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!!

[@IAmTimCorey]

I'm glad you enjoyed it and I'm glad I could give you a good laugh.

[@BudiSantoso-er6cq]

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

[@IAmTimCorey]

Glad it was helpful!

[@_buffer]

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

[@IAmTimCorey]

I hope you enjoy it.

[@Naeuuin]

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

[@solvedplus858]

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

[@HollandHiking]

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.

[@IAmTimCorey]

You are welcome.

[@andremartins4770]

Thanks so much.

[@IAmTimCorey]

You are welcome.

[@grampygamer8584]

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

[@IAmTimCorey]

I'm not sure I follow your design.

[@grampygamer8584]

@@IAmTimCorey Basically I have a File converter for a tool I'm writing. It reads in data from a legacy system, which I convert and then upload to SQL Server tables, depending on the data model. I have a static method which I pass a file, this says Ahh! It's this Table you are dealing with (do some magic) pass back the List and my WPF DataGrid displays a sample of that converted data. So, what I did is use dynamic in the BindableCollection. Works a treat! I don't normally think of dynamics as they have a price :)

[@user-lg2ev7lk6t]

Nice, it’s useful

[@IAmTimCorey]

Thank you!

[@hassanpatel3630]

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)

[@Rohan-zj8nl]

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..

[@KarlooAudi]

Thanks man.

[@IAmTimCorey]

You are welcome.

[@nouribenyahia8742]

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

[@morphman86]

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.

[@tomthelestaff-iamtimcorey7597]

Thanks for sharing. I hope that will help others.

[@sevabante7781]

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.

[@IAmTimCorey]

If it runs when you click the button, run that same code where you are calling the NotifyOfPropertyChanged.

[@SevAbante]

@@IAmTimCorey It doesn't trigger NotifyOfPropertyChanged which is inside the datagrid property.

[@SevAbante]

@@IAmTimCorey I posted it on stackoverflow. stackoverflow.com/questions/62707786/run-a-method-after-editing-a-cell-on-a-datagrid

[@doluobatusin9547]

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!

[@IAmTimCorey]

You would need to have the get for the list filter by the selected numeric value.

[@zuurik666]

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...

[@hashimkz]

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

[@jimjupiter9012]

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

[@stephanerichard3979]

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.

[@karendoran3692]

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.

[@IAmTimCorey]

Yep, you can check out the event list by looking in the properties window and viewing possible events when you have selected the grid or row definition. Then you can bind it to a method in your ViewModel.

[@jamalume]

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.

[@IAmTimCorey]

I don't have an example of this. Sorry.

[@amasoumi]

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 ?

[@IAmTimCorey]

Nope, I don't. They mostly explain themselves but that might be an interesting video for the more obscure ones.

[@piotrgoacki9070]

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

[@arno94s58]

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.

[@pukavita]

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.

[@IAmTimCorey]

You would need to do a conditional check for each cell after each update and then update the cell's background color based upon the value.

[@n9434178]

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.

[@IAmTimCorey]

I could probably do that. For now, it should just be an event on the click event for the row where you call a method in your controller and edit that row in the new UserControl.

[@jonestako4721]

Thanks

[@IAmTimCorey]

You are most welcome. Thanks for watching.

[@markschueler5360]

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?

[@IAmTimCorey]

That's because it isn't a combobox in view mode, it is a textblock. You can change the template to be a combobox in view mode as well, if you want.

[@m1cx657]

Nice!!!!!

[@IAmTimCorey]

Thanks!

[@pierreplourde]

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?

[@IAmTimCorey]

Put a command that observes the change and saves it to the database, or trigger a save at your convenience (maybe when they leave the form).

[@sudheernani2470]

How can we make the DataGrid header fixed on scroll?

[@Milan-rc8qg]

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.

[@IAmTimCorey]

It looks like you are binding the ComboBox ItemSource to a single item. You need to bind it to a list of items (the items in the dropdown).

[@philochill]

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.

[@IAmTimCorey]

You could query the data before loading the list so that the list is only the records you want to see.

[@VinuP2023]

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

[@IAmTimCorey]

You will have to wait and see (although I always take suggestions).

[@mrspacer1]

thanks!

[@IAmTimCorey]

You are most welcome. Thanks for watching.

[@quantomic1106]

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

[@IAmTimCorey]

Possibly. Let me know what suggestions you have for things you would like to see.

[@quantomic1106]

@@IAmTimCorey Awesome! I'd like to see how to exactly save edits from the data grid and working with multiple views/pages. I'm still new to WPF and MVVM so excuse my ignorance.

[@steliosromanopoulos4589]

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 KZbin.

[@IAmTimCorey]

If you do it the way I outlined in this video, you already have it outside the grid in a List. You can use that data to save it to the database.

[@wim874]

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

[@IAmTimCorey]

I don't have an example to show you of that, sorry. Typically, you would use a third-party library for this, although it can be done manually.

[@sunayvatansever5905]

Nice

[@IAmTimCorey]

Thanks!

[@CoderboyPB]

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?

[@IAmTimCorey]

Yes, changing the value changes the object.

[@MegaGamers98]

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

[@IAmTimCorey]

It is on the list. Thanks for the suggestion.

[@siiilo]

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

[@johanhansson2531]

Aaaaahh it works... it was so easy tbh :) Love it!

[@joellustigman]

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?

[@IAmTimCorey]

You would just need to call the API like normal but pass in your offset (which page of data you want).

[@markfoad3809]

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?

[@IAmTimCorey]

That isn't a UI function really. I have videos on how to save data to SQL. They are what you need to save your data back to SQL.

[@epichalo3]

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!

[@IAmTimCorey]

I think you need to set up a model for selected row and then just remove that row when the button is pressed.

[@andywalter7426]

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.

[@IAmTimCorey]

You can do that. The button can actually be in the model that you have a list of. You could also have the button send the row information on click I believe. Sorry, I don't think I have an example right at hand to show you.

[@rajashekharh756]

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

[@IAmTimCorey]

The textbox is bound to a property so when you hit the cancel button, clear out the property value and it will clear out the textbox.

[@wagnereliasdeandrade]

How can I pass a list of objects to rowdetail?

[@BartEndhoven]

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!

[@IAmTimCorey]

I don't have sample code for that, sorry.

[@yourdailydoseofcode]

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

[@IAmTimCorey]

That's when you use the auto for the column display. It will handle setting up all of the columns.

[@v3dmodels593]

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

[@IAmTimCorey]

The ViewModel has the list of your data. That is the data you use to save to the database. You don't need to query the UI to get the data back.

[@ahmadkelany]

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.

[@IAmTimCorey]

Thanks for sharing.

[@alphabetta7837]

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

[@IAmTimCorey]

Thanks!

[@shawnmofid7131]

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?

[@IAmTimCorey]

Yes, CM looks at the name and binds it to the matching property (if it exists). We can also use the binding if we need to (usually special cases).

[@hiromijorge400]

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

[@IAmTimCorey]

You can't really make a grid like Excel. You need to know what to do with the data once it is input.

[@lordamateur]

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?

[@IAmTimCorey]

You can see events and event aggregation in the TimCo Retail Manager series, where we have an API middle layer and a WPF front-end. Specifically, when the user logs in, it fires an event that opens up a new form.

[@santanukumarprusty6592]

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

[@tomthelestaff-iamtimcorey7597]

Thanks for watching and posting a question.

[@kostickar777]

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.

[@IAmTimCorey]

Path is typically implied.

[@duncancarr7822]

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 ...

[@IAmTimCorey]

I'm glad you got it to work.

[@VinuP2023]

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

[@IAmTimCorey]

I'll add that to the suggestion list. Thanks.

[@rmysterios]

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.

[@IAmTimCorey]

Yep, you could capture the click event on a button in the grid row that toggled the status. In that same event, you could trigger an update stored procedure and you would be all set.

[@VinuP2023]

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?

[@IAmTimCorey]

I would work directly with the models, not with the UI elements. So when you do a Find and Replace, don't search the DataGrid, search the List that supports the DataGrid. Then replace in them.

[@solvedplus858]

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

[@solvedplus858]

i mean in your example you have property for each column but when getting data from excel, i don't know how many columns and don't its type either

[@IAmTimCorey]

You would need to figure that out at some point. When you get data from Excel, you would need to put it into columns and rows. To use it effectively in C#, you would then need to assign that data to a strongly-typed object that has defined properties. Otherwise you can't do easy binding like this. You will need to do a more manual binding process.

[@solvedplus858]

@@IAmTimCorey first, many thanks for your fast replay i do put the excel data in datatable, i hope this not breaking the MVVM pattern but i can't have full control on it,i miss the properties to bind it as i wish also, i found it too hard to create checkbox column and bind it to row selection , so i can only processing the selected data i hope you can make more videos on this complicated control i'm in this for more than three weeks, but progress is too slow thanks

[@metekaba6532]

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 :)

[@anaraliyev214]

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.

[@IAmTimCorey]

Hint: When you go to my channel page (kzbin.info/door/-ptWR16ITQyYOglXyQmpzw), use the SECOND search option which is under the Subscribe/Unsubscribe button to search my channel. If you look for 'MVVM', for example, you would find these items to address your needs - kzbin.info/www/bejne/sKfcgoGrqrmkodU (Datagrid) and kzbin.info/www/bejne/pHytkIt6pKaXqrs (Combobox)

[@anaraliyev214]

@@IAmTimCorey thank you for the reply, I'll try it out. And once again thank you for the great input.

[@systematicloop3215]

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.

[@IAmTimCorey]

Off the top of my head, I can't think of one but I can look into it.

[@yazan.kioumgi]

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?

[@IAmTimCorey]

I use a dot whenever I can but if there is a situation where the binding won't work with a dot (where it conflicts) then I use the underscore.

[@talkathiriify]

Dear Tim ,Thank you for the amazing Videos, and also sharing knowledge I am a VB windows developer for more than 10 years but know i have to move to WPF with C# and your examples helped me a lot to do that. I am planning to develop a Point Of Sales system with all the functionality of POS regiments like Bar code,print a Precept and Touch screen. would you recommend me to use MVVM with Caliburn Micro or use othe tools for that system. Your recommendation will be highly appropriated, Thanks again for every thing.

[@IAmTimCorey]

I definitely recommend Caliburn Micro. It is a great tool for the job.

[@talkathiriify]

@@IAmTimCorey Thank you very much for your recommendation

[@efsanetespit7020]

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

[@IAmTimCorey]

This should help: stackoverflow.com/questions/19131091/align-datagrid-column-header-to-center

[@hamzaelmakhtari]

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

[@IAmTimCorey]

The data source isn't really important. You can just cut that part out and put in sample code or call an API. Up to you. You just need a List with your data but where it comes from doesn't really matter.

[@deepbule3517]

Hi Tim, thanks for your video - super helpful and easy to follow. One question I have that hasn't been mentioned is - is it possible to bind datagrid to not just the properties of a class but other data as well? Say in the Person class, in addition to the the properties you have now, there is also a "public Dictionary Families" that holds the title and names of his/her families as keyValuePairs like . Is it possible to do something like {Binding Path = Families["son"]}? If you have other tutorials that get into binding more please direct me to those. Appreciate your help!

[@IAmTimCorey]

That would be less than ideal. You can bind to a list or even a Dictionary but trying to bind to a specific entry in a Dictionary isn't usually done. Usually, you would surface that into its own property.

[@deepbule3517]

@@IAmTimCorey Thanks Tim! I'm rethinking the structure of my class. :)

[@josephniccoli617]

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

[@IAmTimCorey]

I show you how to create tables and populate them in the TimCo Retail Manager series. I also have a course titled "SQL Developer from Start to Finish" that would be really helpful.

[@ziyadhazim2417]

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

[@IAmTimCorey]

I'll be doing some things with Excel (exporting to and importing from Excel in C#) but I doubt I'll get into Big Data or data mining. That is kind of outside the scope of this channel.

[@ziyadhazim2417]

Thank too much Dear Doctor I hope that this will be within your interests in the future at least to deal with the data mining tool (AddINS) and how to add it to excel and deal with it and is it free and possible to be added at any time ...

[@YoussefRejouan]

can we make try by date?

[@jrichardw]

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.

[@IAmTimCorey]

You should be updating the grid by adding to the ViewModel, not by manipulating the grid directly.

[@jrichardw]

@@IAmTimCorey Not sure I follow just yet. So I have a ViewModel (SettingsViewModel) that loads up a Model called LinkPatterns. this is getting data the same your your example does: DataAccess class that loads data into the LinkPattern model from the app.config file. I'm calling DataAccess from the SettingsViewModel contructor so it loads at startup. Datagrid is populated just fine there. Based on your response, I think the problem is when I add a new link pattern, I'm adding by a method that writes xml to the app.config file directly. Soooo, basically nothing is going to automatically load this datagrid with the new entry until my VM opens again. I'm not very advanced, but I think I can find my way around adding my new pattern to the collection, but won't collection have all of my previous records there? If so, I don't know how to only write the new one.

[@gabrieltoh2169]

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

[@IAmTimCorey]

I will add it to the list. Thanks for the suggestion.

[@gabrieltoh2169]

@@IAmTimCorey maybe u can teach me?

[@majordan9747]

You are big help. Own you beer.

[@IAmTimCorey]

I'm glad I've been helpful.

[@BoyOfTheFuture4987]

Thank you so much sensei... I needed this..but I still have one more thing left ....it’s the totals row...I want to have a totals row below the last row...

[@IAmTimCorey]

Hmmm, I'll have to see if I can work that into a future video.

[@shawnmofid7131]

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?

[@IAmTimCorey]

Path is being explicit. Sometimes you need to be explicit when other parameters are involved or you have other properties coming in. In general, you don't need it but if you have a problem, adding it can't hurt and can sometimes be the solution.

[@shawnmofid7131]

@@IAmTimCorey Thanks.

[@shuttereff3ct593]

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

[@IAmTimCorey]

Sorry, that isn't something I can really answer for you.

[@spazieren99]

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} ?

[@pexoto5093]

as far as i know, both mean the same thing, except that one is more verbose

[@ChantingInTheDark]

@@pexoto5093 - Correct

[@tessvandiepenbos]

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

[@IAmTimCorey]

It is very similar to a combo box. I have a video on the combo box so you should be able to do everything in that video but with a listbox.

[@MrBigboyTX]

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!

[@IAmTimCorey]

I believe the solution isn't to try to get the selected row by index but rather through the binding. Bind an object to SelectedItem and you should be set.

[@MrBigboyTX]

@@IAmTimCorey Thanks Tim. I was able to bind a ViewModel property to CurrentCell and get the column index from the associated DataGridCellInfo. When Caliburn uses Name to bind a BindableCollection to a DataGrid, is it possible to assign property values to the DataGrid object programatically from within the ViewModel? I have tried but don't know how to access the DataGrid object from within the VM (I can only access the Collection). Thanks again for everything!

[@henrivandamme570]

@@IAmTimCorey I tried doing that but the binding doesn't seem to work. Why could that be? I can only presume no item is selected when I push the corresponding button (although the line with the button is colored dark blue so should be selected...)?? Binding using SelectedItem with ItemsControl does work out well so it's not that I cannot work with the "SelectedItem" property and bind it to an Object.