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
@khushbujoshi73564 жыл бұрын
your skill talents shows everything...your speech is too good.don't think too much on that.keep it up.👍👍👍
@valeriusmegamozg5 жыл бұрын
It's a very helpful video! Thank you very much, you've just closed all points in 30 minutes much better than my lecturer in 1 week. Thank you!
@CodAffection5 жыл бұрын
thanks for the wonderful feedback!.
@Brianseb2 жыл бұрын
Gracias Maestro, 5 años tiene el video y sos el único que en todo internet que sabe enseñar como hacer un Update en Entity.
@shifasvn32562 жыл бұрын
you helped me to begin my learning of winforms and i have learned it in one day.i have 2 years experience in .net core and entity framework.this helped me to posses knowledge about winforms ,it was necessary for me because the new company which i got a new offer needed winforms.
@samsamry91793 жыл бұрын
Superb one, Really worked very well and made easier I'm looking forward to seeing search btton function additionally
@hazelannmacaraig81553 жыл бұрын
Hi sir .Thank you for this tutorial. I would like to ask how if one of the columns in database was integer not string . is it possible to run without any convertion? if not can how can i insert data to the sql that have different data types? Hope to hear from you soon. Thanks in advance
@TIAGO5432114 жыл бұрын
this channel is the better one, im not even a fluent english speaker but i understand better than people teaching from my own country, i really appreciate your channel bro!!
@CodAffection4 жыл бұрын
thanks for your wonderful feedback.
@tohidulislam50412 жыл бұрын
I use C# winform for 7 years and used parameterized query and never tried EF of fear of learning. After seeing this video all fears gone and feel interested on it. From now for my new project I will try to use EF.
@user-pw9mp6uk1t3 ай бұрын
Thank You.
@khizerhussain83132 жыл бұрын
Very Helpful Video! Thank You
@waqarahmadqureshi69483 жыл бұрын
thankyou... its helpful
@PalashBansal4 жыл бұрын
very concise and to the point. Thanks :)
@CodAffection4 жыл бұрын
Glad it was helpful!
@bejanniku5 жыл бұрын
Dude, your English is perfect. But that TABL instead of table really cracks me up! good work tho
@2005Azm6 жыл бұрын
Such a elegance in your code sir ! Clean , and clear, complexity made simple !
@CodAffection6 жыл бұрын
Thanks Man.
@alikemalkulful2 жыл бұрын
Perfect explanation. Very clear, Thanks a lot
@ga78535 жыл бұрын
Thank you so much, that was so clear and understood, I appreciate your efforts for making this great video, Thanks again
@username-dh4tq2 жыл бұрын
π :
@KhalidAfridi13 жыл бұрын
Thumbs Up bro. Excellent explanation of CRUD operation of using Entity Framework. You saved a lot of my time. Thanks
@CodAffection3 жыл бұрын
Great to hear!
@INDIANSinghX3 жыл бұрын
Dude u did great job ,thanks a lot dear
@atakantekoglu55204 жыл бұрын
Thank you very much. It is so educational for me. You are a very brilliant instructor. Keep going!
@CodAffection4 жыл бұрын
Thanks for your wonderful feedback. let me know your topic suggestion for future tutorials.
@atakantekoglu55204 жыл бұрын
@@CodAffection Nowadays, I try to learn .Net MVC. Maybe, you can focus on it and also, it is better to create full blog project or etc. with MVC. Thank you.
@KL-gc2hx3 жыл бұрын
Thank you very much! Learn a lot from your video!
@user-gu3kj6gy8q5 жыл бұрын
Oh man! Thank you very much for this tutorial. Sorry of my english. I'm from Russia)
@alirezakazemi53184 жыл бұрын
This was very easy to follow and practical. Thanks so much!
@CodAffection4 жыл бұрын
Glad it was helpful!
@bishangiri6772 жыл бұрын
Guru is it possible to sync sql database to web server in c sharp desktop app
@stevenyaga4 жыл бұрын
Very very helpful video
@christosioannou73594 жыл бұрын
Best video ever seriously!!! THank you very much
@skillshared32493 жыл бұрын
Thank you so much. This is great tutorial.
@tusharkantidas46224 жыл бұрын
Awesome job sir...
@just_kidding_kid Жыл бұрын
Thanks Helped Regards from Ukraine
@CodAffection Жыл бұрын
Happy Coding. Stay Safe.
@just_kidding_kid Жыл бұрын
@@CodAffection thanks ❤
@manojrathore852 жыл бұрын
Excellent video
@mustaphaELHOURA Жыл бұрын
very helpful thank you so much
@nsh82550044 жыл бұрын
it was super perfect tutorial. waiting more from you. thanks alot.
@phattainguyen75453 жыл бұрын
Thanks for video. Do i can use db.Entry(model).State = System.Data.Entity.EntityState.Deleted; and saveChanges() to delete without using Detached and Attach(model) ? Thank you for reading.
@odehanas3 жыл бұрын
Thanks for the video .. it's very helpful i followed and every thing is fine but in the delete function i have got this message if possible to help solving it.. "The entity type Boolean is not part of the model for the current context.'" thanks again ..
@kavindutharaka22735 жыл бұрын
very clear explanation. Thank you very much.
@mikolajsemeniuk85743 жыл бұрын
Very helpful !
@traderasapassion77603 жыл бұрын
It's really helpful
@pocomomo3103 жыл бұрын
It was so helpful!! Thank you very much. Much appreciated.
@arslanjappa43356 жыл бұрын
sir you always just made crud operaition on text boxes.ur videos will get more appericiation if you include picture,radioboxes combobox and time in crud.bcz i have nt seen such kind of crud operation on youtube.
@CodAffection6 жыл бұрын
thanks for the suggestion, that's coming up next week.
@cholemoore57336 жыл бұрын
Thanks. Great video! Well explained. Only wish that I found this video earlier for my assignment.
@CodAffection6 жыл бұрын
glad you found the video helpful.
@elegeblege16185 жыл бұрын
That rooster in the background is killing me 29:41 However, thank you so much for tutorial !!
@denzoV25 жыл бұрын
you dead or alive?
@skillshared32493 жыл бұрын
What do you fetch the entity from the database for edit ? You can get it from the grid itself.
@PabloPellegrini5 жыл бұрын
Perfect explication!! Thank you from Argentina! ♥
@CodAffection5 жыл бұрын
glad you found the video helpful.
@2005Azm6 жыл бұрын
Great tutorial as always !! sir can please make an example with more than on table ? like a relational database..?
@CodAffection6 жыл бұрын
that's coming up next week.
@kumaresha33484 жыл бұрын
Great video Brother. Please create video using MySQL for the same Entity. It is very interesting to learn C# Windows Application.
@theethicalh37074 жыл бұрын
thank you very much bro
@akramtester52495 жыл бұрын
Hi mr. I viewed your video twice, actually very nice, when you using new way to make connection in page load. actually I always use sqldatasource tool to make connection and get data to another toll(gride view ot ditails view), am trying to mix your method with mine,..thanks
@CodAffection5 жыл бұрын
Glad you found the video helpful.
@BahawalTV4 жыл бұрын
Why can't you bind the entity directly to the form controls?
@tjensen5295 жыл бұрын
Excellent video. Thanks much!
@UBOINIK_TanksBlitz3 жыл бұрын
Большое спасибо! Ваше видео очень помогло мне!
@mjkl6146 жыл бұрын
I can hear chicken clucking in the background, you must woke up real early and made these videos, great job, keep up the good work!
@CodAffection6 жыл бұрын
:)
@mscamarade34134 жыл бұрын
Thanks, very mach! Very useful video
@abadd0n2974 жыл бұрын
Who's the man? You're the man! :D
@ThumbIKR6 жыл бұрын
Owwww, really great tutorial sir, thanks :)
@edvardpotapenko5 жыл бұрын
Thank you very much, that was very helpful!
@TheThinker-ug3wr5 жыл бұрын
great tutorial and its worked good
@nvidiapersy5 жыл бұрын
what visual studio did you use ?
@amirhamzasabuz79774 жыл бұрын
Thank you
@jaberramadandabash29735 жыл бұрын
waiting for printing reports operation :D
@muhammadafzal2372 жыл бұрын
How to calculate sum of a column values?
@osempo5 жыл бұрын
Cool video, easy to follow.
@danilobastos61825 жыл бұрын
I have a problema when I do a double-click to update the row. Appears a message saying that don't find the column with the name 'CustomerID', but the column name is correct. Somebody passed through for the same thing?
@fabiofocking3825 жыл бұрын
Wonderfull, this video save my projetc! thank you for this tutorial.
@CodAffection5 жыл бұрын
thanks for sharing your comment.
@sanianaqvi49873 жыл бұрын
Thanks a lot
@mrgonzolla5 жыл бұрын
Thank you for this video. I found it very helpful!
@CodAffection5 жыл бұрын
glad you found the video description.
@jeffsonic3 жыл бұрын
great job
@rafaelramos82206 жыл бұрын
That was a good video, I'm coming back to code world and it helped me a lot.
@CodAffection6 жыл бұрын
you are welcome.
@robertmcdonough10845 жыл бұрын
Awesome video! This helped me so much
@mazkaibil91086 жыл бұрын
Hello, very good tutorial. Is there any video showing how to do this application with two related tables? please advise.
@CodAffection6 жыл бұрын
not yet.
@whopawan83844 жыл бұрын
Thanks, Man very helpful
5 жыл бұрын
thanks very much Ad
@Trakai20096 жыл бұрын
Great video! But how to sort on, for example by Lastname, by code?
@Gus-px7hd6 жыл бұрын
Very useful, Thank you.
@sathishchowdary83466 жыл бұрын
Its so helpful. Can you develop a sample library application using ASP.NET MVC with different books count and the count should be reduced if any one borrows book. If you do that , It will be great.
@peteandalie Жыл бұрын
Do your own homework.
@ga78535 жыл бұрын
Thank you so much for this wonderful efforts, and thank you again for the source code, you have made easy for us. Grateful.
@username-dh4tq2 жыл бұрын
× :π•√ .jam π
@username-dh4tq2 жыл бұрын
_ #flash :
@papamagueye60905 жыл бұрын
It is so clear... nice job
@CodAffection5 жыл бұрын
thanks for the comment.
@johnsimbe9916 жыл бұрын
Helpful video, thank u sir!
@blazept5676 жыл бұрын
Thank you very much, Sir!
@altaymahmudi63854 жыл бұрын
can you tell me how we can use Trim with datetimepicker? i am getting error and it is really annoying
@johnpaolodelrosario67926 жыл бұрын
would like to ask why the state of var entry become detached?
@ronaldkiefer35655 жыл бұрын
Boom Thanks video tutorial was very helpful so far
@CodAffection5 жыл бұрын
glad you found the video helpful.
@learncodego17242 жыл бұрын
big like for you
@hajerjalloul73116 жыл бұрын
good !! it's helpful
@talithasouza12983 жыл бұрын
simples e muito bom, ajuda muito
@NguyenLuan-xn4ym4 жыл бұрын
So Useful, Thank to u 😃
@CodAffection4 жыл бұрын
Welcome 😊
@humayunnasir62615 жыл бұрын
VERY GOOD VIDEO THANKS ALOT
@militoelynea6 жыл бұрын
I LOVE YOU!
@mballo35164 жыл бұрын
wonderfull ! Thank you very much !
@CodAffection4 жыл бұрын
thank you, let me know if you have any topic suggestion for future videos.
@zerosandones75474 жыл бұрын
Can you do something like this but it has a one-to-many relationship? you teach so well! liked and subbed :D
@nelpro5 жыл бұрын
Bro, you're the best!
@CodAffection5 жыл бұрын
thanks man.
@waseembaltistani6 жыл бұрын
If you would added "Search" function also then it will be definitely helpful for the viewers.
@orthodoxx366 Жыл бұрын
mantap gaan
@heinoplaatjies53345 жыл бұрын
That was a great clean example, i have tried to do a similar exercise but with an extra field, called section, i used data binding to bind the combobox to a table called sectionTable, when you click on the combobox it dropsdown with a list of all the sections, which is displaying the "Display members", and the "value member" = sect_id. but trying to add a new user to the users table, it gives me an Entity Framwork validation error. System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entites here is my code: private void btn_AddUser_Click(object sender, EventArgs e) { users.Name = txt_userName.Text.Trim(); users.Surname = txt_userSurname.Text; users.Email = txt_userEmail.Text; users.CellNo = Convert.ToInt32(txt_userCell.Text); users.OfficeNo = Convert.ToInt32(txt_userOffice.Text); users.LicNo = Convert.ToString(txt_userLicNo.Text); users.ID_No = Convert.ToInt32(txt_userID.Text); users.Role_id = cbox_RoleName.SelectedIndex; users.Sect_id = cbox_SectionName.SelectedIndex; users.Username = txt_userUsername.Text; users.Password = BCrypt.Net.BCrypt.HashString(txt_userPassword.Text); using (BookingVEHEF ef = new BookingVEHEF()) { ef.Users.Add(users); ef.SaveChanges(); };
@qurbansaberi4796 жыл бұрын
Hi bro Can make video about how to insert picture into database how update and how to convert jpg file into bytes
@daniela43346 жыл бұрын
What is dgcCustomers on 20:03 video...I am doing these steps in wpf forms and dont get it for what it stands for
@akashasuri6 жыл бұрын
That's dgvCustomers. data grid view Customers ID.
@AaBb-nn9pl3 жыл бұрын
it is a pity that it is not in Russian, thank you man, I am from Russia
@Babaelow3 жыл бұрын
19:30 how the refresh of the view is done
@shashanktiwari81804 жыл бұрын
Void PopulateDataGridView() { using (DBEntities db = New DBEntities ()) {dgvCustomer.DataSource = db.Customers.ToList(); } } Error on( dgvCustomer ) Error is The name is 'dgvCustomer' does not exist in the current context . Please help
@Roshan_Panwar4 жыл бұрын
It's showing Error Configuration Exception Un handled The entry dbentities have already been added
@mstemper73454 жыл бұрын
Did you fix yours? Mee too same problem
@Roshan_Panwar4 жыл бұрын
I removed the DB model and used some other way but used the same design... I'll give you link wait..
Can you explain to me about code-lines: if (model.CustomerID == 0)//Insert { db.Customers.Add(model); } else //Update { db.Entry(model).State = System.Data.Entity.EntityState.Modified; } Thanks a lot!