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
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.
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?
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
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
(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?
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!
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?
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?
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.
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
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
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..
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.
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.
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?
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.
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.
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.
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;
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
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
what if we use only one table ex. Employee table oly, how do we populate the combo box for cbxPosition?
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.
Thanks for your kind words.
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.
I'm happy to hear it helped!
Excellent and easy of understanding explanations. I hope you continue to do .this.() kind of work. I'll buy your book. God blass you.
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.
You're a very good teacher. Really excellent.
Great video, very straightforward and easy to follow. Got my inventory system interface up and running with no problems. :)
Thank you!! Love your teaching approach.
challenge accepted, challenge completed. ty for your Input.Keep it up!
Very well done explanation. Appreciate your effort.
glad you found the video helpful.
Amazing video mate, works pretty well with MySql too
Cool, thanks
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?
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
Excellent video tutorial. Thanks!!!!
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
Great work.Thank you for sharing your talent. Do you have same project using a Mysql database.
yes, there are.
th-cam.com/users/CodAffectionsearch?query=mysql
(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?
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!
Simply awesome
bro you are good teacher
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?
This is gold. Thank you very much!
very helpfull video! Thanks!
Glad it was helpful!
finally thank you very much!
Thank very much teacher
Thank you for tutorial!
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?
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?
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
good job.... i really liked the way of demonstration. keep up the good work... try, catch, finally (subscribed )...lol
it makes sense :)
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.
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
what about searching through a grid view?
Thanks a lot. This was very helpful.
How will set Enter key imstead of tab for moving to next cell in grid?
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#
hy i want to do insert function on a button click.so can plzz tell me
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
Primary Key Identity Column is auto increment during Insert Operation
yes.
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
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.
greate video and learned a lot
thanks,I like your video
Thank you so much!
i Don't have cell value changes, Control in DataGridView Controls
can you do one without creating a procedure as mysql procedure is not working properly for me.
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..
i am using VS 2012 , i didn't have UserDeletingRow Option in Grid properties
which version you using
Thanks a lot Teacher
You are welcome.
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.
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.
Excellent.
Can you create a video for Access Database?
please let me know how to display multiple columns in combobox, thanks. combobox .DisplayMember = "FirstName"; combobox .DisplayMember = "LastName"
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?
what about plain sql query with parameters.
thanks keep it up good work
Awesome! Glad to hear it helped.
What happens if the user selects multiple rows in the DataGrid and then presses DEL?
Didn't try, did you?
Coud have implemented the feature with a checkbox on each row.
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.
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.
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.
I'm following same process but delete , edit it's not happening
Any suggestions ??
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;
Sir my I know that how can multiply two cells and set the calculated value in the third cell in this grid view please
same thing I want to know ha
Does not save the changes for me, nothing happens
By running program and u must check the code of mine bt I don't know hw to send unless I get Ur mail
Dotnet Mob same.rror
Sir the data entry of same row is done multiple times according to this event
???????????
i wll wait for ur repy sir
i have send mails to you
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
Split records into multiple pages.
21:48
It can be made easier!
20:10
والله انت هندي محترم
Sir you make be dot net program
yes I do
Dotnet Mob sir you make be asp.net program
yes : th-cam.com/play/PLjC4UKOOcfDRJlsiMHKkGjV4st1K2jZ9E.html
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.
Bro
कोलाम
gg
omg I cant understand your indian accent, so heavy.