Insert Update and Delete in C# DataGridView

[@CodAffection]

goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/SUi4bg : Login Window in C# Using SQL Server goo.gl/zV892S : C# CRUD Operations With SQL Server goo.gl/bPcyXW : Buy me a Coffee

[@lancetv4826]

what if we use only one table ex. Employee table oly, how do we populate the combo box for cbxPosition?

[@darrenhind9948]

Great tutorial thank you. Coming up to 5 years old but probably the best dgv tutorial I've come accross, well paced and very well taught, you're an excellent teacher.

[@CodAffection]

Thanks for your kind words.

[@peterrumspringa9757]

You're a very good teacher. Really excellent.

[@zmareyshahi]

Thank You very Much . i have watched Many Videos But this is Just Like i Have explained to you what i Want . i Cant than You Enough.

[@CodAffection]

I'm happy to hear it helped!

[@ammaralivirtual3281]

Ammar, Thanks a lot! your video very useful to me. I got more knowledge from this video. Best of luck for your growing. Thank you.

[@SuperJamal76]

challenge accepted, challenge completed. ty for your Input.Keep it up!

[@augustocardoso5315]

Excellent and easy of understanding explanations. I hope you continue to do .this.() kind of work. I'll buy your book. God blass you.

[@cleberjunior8748]

Amazing video mate, works pretty well with MySql too

[@CodAffection]

Cool, thanks

[@pascualmartinez6167]

Thank you!! Love your teaching approach.

[@richguarino9304]

Very well done explanation. Appreciate your effort.

[@CodAffection]

glad you found the video helpful.

[@ChugiMoto]

Great video, very straightforward and easy to follow. Got my inventory system interface up and running with no problems. :)

[@naturewale1389]

bro you are good teacher

[@yuwendridesilva6956]

Simply awesome

[@KhalidAfridi1]

It's amazing tutorial on CRUD operation in Datagridview. Thank you so much bro. Only one thing @35:00 and @38:00 I notice a minor problem in this tutorial that is if you are inserting the new record for the first time with the name column, one should always leave the row for inserting the new record as you are doing in this tutorial, the update will not take place for the rest of the columns..... Kindly advise

[@germangentile735]

Thank you for tutorial!

[@bck45285]

Great tutorual! Thank you! I have a question about updating and inserting in tables. I populate my datagridview with a stored procedure, which has couple of join operations. Is it still possible to update and insert from datagridview?

[@elija.]

very helpfull video! Thanks!

[@CodAffection]

Glad it was helpful!

[@danlou865]

Great work.Thank you for sharing your talent. Do you have same project using a Mysql database.

[@CodAffection]

yes, there are. kzbin.infosearch?query=mysql

[@putin5503]

Thank very much teacher

[@aaj3078]

finally thank you very much!

[@surangapallattarage8833]

Excellent video tutorial. Thanks!!!!

[@ndvz8672]

This is gold. Thank you very much!

[@mustafarasol8631]

for the basic operation it is quite cool and good demonstration but what we like to see and understand how to do more complicated operation like math operation between cells or automatically insert conditioned values in other cells thanks a lot

[@tony3954]

I have some questions, in the second option, when you use stored procedure for adding, editing, what if someone has access to the database, they could change the stored procedure statement and the application will not work properly, right? In addition, I am confused when you said using query statement like "Select etc from ...." for adding , editing, etc in the second option will cause SQL injection. Could you explain more? I am a newbie in this. Thank you!

[@rohan-san8148]

(if you not understand what i say sorry my english is not good but i want to know) is c# windows form have any other tableform input like datagridview that we can input first column after lost focus events trigger it will goto database and got data to fill info to other columns, or it only have datagridview that can do like this?

[@malshanranaweera2970]

greate video and learned a lot

[@zoltanmeksz7625]

Excellent.

[@Callibree]

Good work. Here are a couple things I would change in your implementation: I notice that in order to insert a row you move the focus out of the row and then back into the row in order to complete data entry. There has to be way for continuity in data entry where the user can keep entering data values tabbing to the next cell without interruption. The row insert takes place after all data is entered into all cells. The update can take place on a cell by cell basis like you have it now. You are evaluating the same state in two places (either an insert state or update state). The first evaluation is in cell edit event and again in the store procedure. Should only need to evaluate in one place or the other. Personally I would evaluate state in the client and have two separate stored procedures. Overall you have a good video because you are conveying an overall how to and your code works. The nit-picking refining I suggest, these things come with time and experience. Keep up the good work.

[@imadsaidi5909]

Thank you so much!

[@makeayoutubechannel1940]

Thanks for share, you help me out. Wish you teach me how to validate data if exist for adding data or update data in gridview?

[@razazaidi5057]

Hi. I just wanted to know if this is possible/compatible with Entity Framework? Like modification on Data Grid View happens and then entity model gets updated/added/modified/deleted?

[@tahirmehmood1735]

I want to ask that i want to display my datagridview values in crystal report images limited data and want to use show paging plz help

[@MarcoAntonio-xg7qc]

hi! thank you so much its working in my proyect, but there is some way to add a datetimepiker only for pick the date, like the same way that you add combobox?

[@AaricAaiden]

what about searching through a grid view?

[@leoocallaghan8631]

Just what I was looking for, but I need to use Sqlite database which doesn't allow Stored Procedures. How can I do the same as your tutorial to insert, update and delete from a SQLite database. Will you do a new tutorial? Thanks

[@a26z1c2b3]

Thanks a lot. This was very helpful.

[@talhakhalid9343]

hy i want to do insert function on a button click.so can plzz tell me

[@muhammedali3835]

How will set Enter key imstead of tab for moving to next cell in grid?

[@MishraAvdesh]

sir how we drag and drop label control on form and then populate data these label from database just like we do in crystal report in c#

[@abdiazizhussein1375]

Thanks a lot Teacher

[@CodAffection]

You are welcome.

[@esoftlearn2618]

good job.... i really liked the way of demonstration. keep up the good work... try, catch, finally (subscribed )...lol

[@CodAffection]

it makes sense :)

[@carolineandersen3611]

Compound key. Nice video. I have a compound key made up of id and part number. Both do not allow nulls. How could i make this work for me? Thank you

[@allyanamanabat7323]

Hi, I hope you see this immediately. Can I also do the same in the built-in SQL database in Microsoft visual studio??? I don't have the SQL server management studio right and this video is the closest to my thesis. Please hope you see this one.

[@CodAffection]

Sure, No need for a management studio. You only need an SQL server installed on your system. you could access it from anywhere. Let me know if you are stuck anywhere.

[@hangc10]

can you do one without creating a procedure as mysql procedure is not working properly for me.

[@mohamadalibrahim2995]

thanks,I like your video

[@thomasvilliger6887]

There is a mistake, I implemented it exactly as you said but the "e.Control.Keypress" event gets raised if you click any cell of the row. because "e.Control" references the selected row and not cell

[@NimishP]

Can you create a video for Access Database?

[@kentthedev]

I just tried this with EF6 . The problem is after I saved one cell in db and populate datagridview again then I can't add new row.

[@Anzil_think_diff]

i am using VS 2012 , i didn't have UserDeletingRow Option in Grid properties

[@Anzil_think_diff]

which version you using

[@harisqasim7940]

thanks keep it up good work

[@CodAffection]

Awesome! Glad to hear it helped.

[@iFormationPc]

Primary Key Identity Column is auto increment during Insert Operation

[@CodAffection]

yes.

[@qolbilatiq5498]

Excellent tutorial. but i got errors when i use it with 2 combo box. the error is field called "dept" does not exist and im still can't move on... any suggestion??? Please..

[@putin5503]

please let me know how to display multiple columns in combobox, thanks. combobox .DisplayMember = "FirstName"; combobox .DisplayMember = "LastName"

[@telespago]

Good Job until minute 22 but after that you start building a store procedure to insert and update records... You must continue with c#. In your demo the code is not portable on other Database. That's a pity. I will try to implement insert update and delete by myself.

[@amitsingh-jz8ul]

I just want to know that, If am creating an Automated serial number in my app and I have declared that serial number as my primary key in my data base then how i can do all this work using this work using data grid view.

[@CodAffection]

try this : stackoverflow.com/questions/25697917/how-to-display-serial-number-in-datagridview try not use the primary key as serial no - few numbers will skipped after delete operation.

[@erumyaseen]

i Don't have cell value changes, Control in DataGridView Controls

[@udomacha3286]

What happens if the user selects multiple rows in the DataGrid and then presses DEL?

[@CodAffection]

Didn't try, did you? Coud have implemented the feature with a checkbox on each row.

[@udomacha3286]

private void CellValueChanged(...) { ... sqlCmd.ExecuteNonQuery() ; PopulateDataGridView() ; ... } After Insert or Edit, the DataGrid will be shown from the beginning. But what will happen it the table has 2000 records and you have to make a small corrections on the last 200 records ? After each correction you have to scroll to the end to make the next correction

[@CodAffection]

Split records into multiple pages.

[@dailyquran2072]

Sir my I know that how can multiply two cells and set the calculated value in the third cell in this grid view please

[@samuelwinter2554]

same thing I want to know ha

[@92beebo]

Ah, what a nice tutorial. I'm using it to access an SQLite db which works well regarding the reading part. Unfortunately SQLite has no stored procedures so I can't reproduce the insert and update functionality. Anyone has an idea how to recreate these for SQLite?

[@CodAffection]

what about plain sql query with parameters.

[@bijayalaxminayak7001]

I'm following same process but delete , edit it's not happening Any suggestions ??

[@tejaspanchmatiya]

By running program and u must check the code of mine bt I don't know hw to send unless I get Ur mail

[@tejaspanchmatiya]

Dotnet Mob same.rror

[@studentdemitrius1111]

Does not save the changes for me, nothing happens

[@tejaspanchmatiya]

Sir the data entry of same row is done multiple times according to this event

[@tejaspanchmatiya]

???????????

[@tejaspanchmatiya]

i wll wait for ur repy sir i have send mails to you

[@oystercam1040]

hi, can you plz do a video showing how to do a board game on unity, where can the character choose to go or not to the other way? like a square with a line on de midle where they walk on it based on a dice movement..it would be really amazing ;v;

[@altairlight5729]

21:48

[@arturlomakin3555]

It can be made easier!

[@flepooo]

والله انت هندي محترم

[@hazelcarz]

20:10

[@MohitSharma-ny8rt]

Sir you make be dot net program

[@CodAffection]

yes I do

[@MohitSharma-ny8rt]

Dotnet Mob sir you make be asp.net program

[@CodAffection]

yes : kzbin.info/aero/PLjC4UKOOcfDRJlsiMHKkGjV4st1K2jZ9E

[@MohitSharma-ny8rt]

Dotnet Mob sir you have 5 program in asp.net and make be example

Really nice tutorial but it's really hard to understand what you're saying sometimes, some words don't sound like english.

[@hardysingh198]

कोलाम

[@josearmandoblasarce359]

gg

[@tahirmehmood1735]

Bro

[@JorMorera]

omg I cant understand your indian accent, so heavy.