C# Tutorial - Insert Update Delete data in Database from DataGridView | FoxLearn

[@mjkl614]

I don't know how much thanks I owe ya for this video, I noticed you have been updating the video even though keeping the title the same, this video has finally resolved my doubts about linking two data tables using entity framework and display it on a datagridview, job well done, I really owe you a beer! Cheers!

[@zerosandones7547]

Why can't I establish a relationship here @11:04? I clicked the "play" button and didn't work, I even refreshed and restarted my sql server. I am using 2019 version

[@rissoulimohammed5344]

Thank you for this video, it was very helpful, I have problem, I create inventory management system, I want to add new categories using text box in form 3 to show categories in combo box in form 2(as you do frmaddeditstudent ), textbox is connect database (categories) and combobox connect to database (stock) now when I add categories in the textbox and save it with the same method you do in the video doesn't save and combobox only show the categorie how I put them in the table as you do with city tabel 11:21 please, help me please its very importing for me.

[@andriiocheretianyi3851]

Hi man, did you figure out how to do this?

[@dhanniekristanto]

Good hands on tutorial. Everyone commenting here asked for source code. wow

[@foxlearn]

Hi, And how about you ? Have you got any difficult with the tutorial ? thanks

[@TumeloMotsoeneng]

great work. thanks...learning C# and this was helpful

[@foxlearn]

Thank you so much !

[@Aoubaker]

there is a litle problem in your tutorial: when you click the Edit button, the City's comboBox doesn't get the selected city but only the first one in the comboBox can you tell me how to fix that in this case Pls.

[@foxlearn]

Please check you ValueMember and DisplayMember. i think you miss something !

[@tkhaidarov]

How did you designate in the form frmAddEditStuident' properties AcceptButton - btnSave???

[@anagor9555]

Helpful video. Thank you!

[@monirajv]

Great Tutorial.

[@luisc1794]

Once I'm on the Student Info dialog box that I click on the address text box, the name on the city combo box disappears and when you select it doesn't let you save the record, no errors occur. Please help. thaks

[@osiris5449]

This Database I'm downloading (The up-to-date version of what you got); does it allow connections over the internet? Let's say I'm making a social app, how would I handle that kind of data between everyone? This type of Database?

[@mjkl614]

One more question, is there a way to save the cityid each time I enter into the edit screen? seems like it always defaulted to the first item, many thanks!

[@DanyXiony]

Hi nice tuto ! I have a little problem for update an line on datagridView : If I click on button update my form show and if I change value and close it directly my datagridView show the new value. Is not good I don't click on save, I click on close >_< Can you help me ? Sorry for my english.

[@johnarnoldcatedrilla4378]

I dont have navigation properties how to fix that?

[@mrkhedr]

When I go to edit form... City not initial correct always get first value. and when you choose edit row you choose row not have city .. How can I initial City value... Thank you

[@hanssss13]

db.student.Remove(dataGridView.Rows[i].dataBoundItem as Student)....... i didn't find .remove, why?

[@foxlearn]

Please check your code again, i think you missing something

[@hanssss13]

@@foxlearn ..Remove(......) like that??

[@hanssss13]

do you add 'using' ?

[@torchok19081986]

great video like always! Thanks. Only one question. How do i show icon besides Formnametext ?

[@foxlearn]

Button or Tile button?

[@JaimeChavarriaMartinez]

Nice Video. Thanks.

[@KJ4000]

Very nice, this works... All but the save button in the studentInfo form works for me. When pressed, it freezes. Very nice tutorial.

[@foxlearn]

Thank you :)

[@KJ4000]

In the area where you add { Gender = false} in the using (productinfoForm frm = new productinfoForm(new tblproduct() {})) under the Add tile.. What do i pass here? I can see it want all the properties, but do i have to wirte like int pId, string name, string , age, and so on ? :S

[@KJ4000]

For some reason, the Saving via the AddEdit form does NOT work. the app just freezes. Nothing happens when i Press Save in frmAddEdit.. NO feedback but i'm unable to close the form or do anything else with the app. Can you send med the source code ? I've been trying for hours now to find the solution :(

[@KJ4000]

Wheni use forign key value from child table as displaymember or valuemember is freeze, when i set valuemember and displaymember as the foreign key, it works..

[@foxlearn]

Hi, What's your emai? thank you

[@anitasrihandayani1104]

Tutorial is very good, but i want to ask if make *"button search"* how? Continued from this tutorial

[@eythimis]

Very nice video that explains a lot! However I wanted to ask you if you begin editing a row and change one or two fields and then close the edit dialog without saving, the underlying data in binding context would have changed.Correct? And hence those data would have been displayed in the grid but not persisted in database. Is my assumption correct? Also could you send me the source code? Thanks again for the great video!

[@foxlearn]

That's right. You data don't save to database. Sent. Please check your email. Thanks

[@gennarocodagnone]

Very Good work! I have some questions... - After deleting a row, dataGridView does't update automatically. I must press the sequence: 1. Delete 2. Save 3. Refresh Doesn't better to call SaveChangesAsync() right after delete? - Why after the sqeuence: 1. Delete 2. SaveChangesAsync() I need press Refresh button? (the dataGridView doesn't refresh automatically) Sorry for my english. Thanks

[@moeinrahimi3674]

when i try to add record it says : cityName filed does not exist

[@foxlearn]

Hi, Please make sure that cityname filed exist in your table, Please check again. Thank you

[@smiljanj]

Hi! This tutorial is very good and really helpful. One question regarding editing. When you add a record, everything is ok with ComboBox data (you choose a city and its ID gets written into the record). But when you edit a record, ComboBox is not initialized with correct value from the DB, but rather set to its default value (as if you are creating a new record). What is the best practice to solve this (ComboBox being set to its correct value from the DB record when editing a record)? Many tnx for the answer. BR, Smiljan

[@foxlearn]

Hi, You need to add a binding to combobox, then set display member and value member to the combobox

[@MrNvQuy]

nice guide !

[@foxlearn]

Thank you so much !

[@fredyangelugarteportilla5163]

When click on saveValidation failed for one or more entities. See 'EntityValidationErrors' property for more details

[@johnarnoldcatedrilla4378]

same

[@Aoubaker]

Why was the only method which didn't work for me is the delete

[@foxlearn]

Please check your code again. I think you miss something. Thank you !

[@Aoubaker]

@@foxlearn yes you're right I fixed it , now with the Add form,in my case this form is for detail table, how can edit the code to put the Selected master's ID in this detail table ? and thank you for your fast reply

[@Aoubaker]

Ok I did it. Wow it's so simple, actually I really love entity framework

[@flormariaayalarondan4743]

Hi, can you tell me how did you fix the problem? the delete method doesn't work for me

[@allhaillelouchvibritannia7494]

@foxlearn I know this comment is a bit too late but I just want to know if Metro UI is compatible with visual basic?

[@foxlearn]

Yes, You can use metro framework with vb.net. I'll upload video tutorials vb.net + metro framework as soon as possible ! Thank you my friend.

[@MuhammadRizwan-cj5jo]

Fox Learn please help ... Error (Value cannot be null. Parameter name : entity) ???

[@foxlearn]

Hi, Please make sure that you set primary key is identity. Please check your code again. thanks

[@arnaudngabgna5166]

very nice thanks for this tuto. But in my own i have an error. infact i am using Nhibernate and the foreign key refused to be add

[@foxlearn]

I think you should fill all value to your object, include foreign key

[@ibuyanaamyice4579]

Thanks you Best

[@emmysmith8960]

hi sir i like ur tutorials. can p/s create a complete school management system with modern ul framework . thank u

[@foxlearn]

OK. Thank you for your suggestion !

[@AnasAbbasDev]

thanks a lot , could you pleas provide me with the metro framework dll file.

[@AnasAbbasDev]

on my email >> [e-mail] please ^_^

[@IonWP]

Thanks for tutorials. How to install ms sql server ?

[@foxlearn]

Hi, You can view this video kzbin.info/www/bejne/d4PTh42bqaajd7s (How to install SQL Sever step by step). Thanks

[@IonWP]

Thanks

[@rvsusi4046]

The video was excellent and making me to do this. But I don't have the software application both front-end and back-end. Can you please send me the apt full download link. Please

[@kumarrahul728]

BackGround Music was awesome.. please tell me the name of music :P :)

[@foxlearn]

Green Leaves, you can find in youtube background music. thanks

[@katetitzkie]

greet tutorial.. can u make the same tutorial using ADO??

[@manvitnaidu4781]

i am not able to found student in "Data source configuration wizard "

[@abdellah-ia]

That was great, BUT CAN U TRY TO EXPLAIN, a little bit, please, most of DataBase stuff were not clear at all. Seriously Bro, your tutorials are great, but this one really made me crazy, database stuff were very confusing.

[@foxlearn]

OK. Thank you for your suggestion. I'll try more

[@TM-vg2mt]

Thank you for tutorial...Can i have the source code and Metroui folder with dll please??? i hope you give me thank you...i already liked and suscribe your video

[@TM-vg2mt]

[e-mail] this my email please sent the code and library metro ui

[@abdulrahmanrefaei1023]

brilliant ! would you please send me the source code please?

[@abdulrahmanrefaei1023]

[e-mail]

[@yilmaz070]

+1

[@foxlearn]

Thank you :)

[@yilmaz070]

No problem :)

[@yilmaz070]

@@melezprens8158 anna'a koyabilirsiniz!

[@semikolon4229]

Please share the source code on github.

[@foxlearn]

Thank you for your suggestion

[@JJedai]

Done! if someone wants the code, let me know ....

[@mackenziesmith6624]

Can I have the source code please? [e-mail]

[@JokerZipon]

У меня есть предложение по видео, можно ваш e-mail !

[@foxlearn]

Yes, You can send your suggestion to my email : [e-mail] . Thank you so much :)

[@JokerZipon]

Отправил письмо. Жду одобрения. Спасибо.

[@chrzan131]

:)

[@foxlearn]

Thank you :)

[@hassanfawaz171]

ااي