(#61) Get and save dropdown data in database | Asp.Net Core tutorial

Asp.net core tutorial: We will get the data of dropdown from the database and will save the value of the selected option to the database in asp.net core. By now in this tutorial, we were using hardcoded values for dropdowns now we will make it dynamic.
To get the dropdown data from database we will add a new table, will map it to the main table, and finally using entity framework core we will get the data.
#DynamicDropdown #DropdownWithDatabase #Nitish
Join this channel to get access to perks:
/ @webgentle
GitHub Repo: github.com/web...
Subscribe WebGentle: goo.gl/PJr1pN
Visit Our Website: webgentle.com
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
For business inquiry contact: [e-mail]
Follow us on
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Facebook - bit.ly/36yZuQN
Linkedin - bit.ly/2N6Onqk
Twitter - bit.ly/2uv04AP
Popular free courses from WebGentle
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Jira tutorial - bit.ly/jiratuto...
Asp.Net Core Tutorial: bit.ly/aspnetco...
Azure DevOps tutorial - bit.ly/azuredev...
.NET Core 3.0 fundamentals - bit.ly/dotnetcore3
MVC5 tutorial - bit.ly/mvcbynitish
LINQ Tutorial - bit.ly/linqbyni...
Non generic collection in c# - bit.ly/nongener...

[@vaishalinarayan2919]

Super, Just finished all the videos and you are amazing!..Simple, detailed, short explanation. Thanks alot.
Egarly waiting for next videos!

[@deepro__]

Thank you very much sir, this video really helpful for me .

[@priyanshpatel9850]

ThankYou Sir For this Playlist It help me alot for my study and project

[@HexArtificer]

Hello! So in the previous video, you removed multi-select to use enums and you've carried on using single-select. In the video that you covered multi-select, you didn't cover how to send that new data to the database- the database was still receiving the singular string value. Would you be happy to cover that?

[@vinaydeveloper1369]

This video very helpful sir ji 🙏🙏🙏

[@ayan.kemel7]

Hello, please help me. There was such an error :
An unhandled exception occurred while processing the request.
NullReferenceException: Object reference not set to an instance of an object.
Webgentle.BookStore.Controllers.BookController.AddNewBook(bool isSuccess, int bookId) in BookController.cs, line 46
NullReferenceException: Object reference not set to an instance of an object.
Webgentle.BookStore.Controllers.BookController.AddNewBook(bool isSuccess, int bookId) in BookController.cs
+
ViewBag.Language = new SelectList(await _languageRepository.GetLanguages(), "Id","Name");
lambda_method(Closure , object )

[@studytoexcel6647]

Great job for the good work. After watching and implement this lesson i continue to get this error when adding new book
SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Books_Language_LanguageId". The conflict occurred in database "BookStore", table "dbo.Language", column 'LanguageId'. The statement has been terminated.

[@azizpatel5842]

Hey, I was getting a similar error when I was trying to add a migration for the table. I fixed this by removing any existing data in the tables then adding a new migration and updating the database.

[@deonandanoraon3511]

Hi Nitish, your videos are very helpful and informative. can you please upload video on Bind DropDownList and DropDownList based on another DropDownList selected value in ASP.NET CORE 3.1

[@SaurabhKumar-om2gz]

Is it fine to Change Model Randomly also instead of using multiple model for different Operation Can we use ViewModel. Its very informative but implementation is bit Complicated.

[@Narendra471]

HI Nitish sir you video very information and useful but sir I have one question
edit mode cascading dropdownlist in asp.net core mvc
exam dropdown1 value 1 and dropdown2 how can be set from database

[@ammadkhan2352]

i Have followed every step and getting below error plz reproduce and guide why i am getting this
NullReferenceException: Object reference not set to an instance of an object.
Microsoft.AspNetCore.Mvc.Rendering.MultiSelectList.GetListItemsWithValueField()

[@xcaliber125]

really good

[@Brombrom41]

Please cover Dropdown using ViewModel instead of using ViewData or ViewBag also.

[@WebGentle]

Instead of using viewbag you can pass the data in model property and use your model property on view in asp-items attribute. Rest everything will be same.

[@pourianayeb1063]

Master Nitish are you going to add globalization to this app? that would be awesome.

[@WebGentle]

Good idea. Definitely will try

[@Mahesh-ox6sn]

Hi Nitish, your videos are very helpful and informative. can you please upload video on Azure SSO ( single sign on). and how to configure SSO from visual studio?

[@WebGentle]

Will try

[@tungthanh8750]

Why 14:57 Id = 0 without error while my code returns view

[@keshavkoirala2427]

It shows BookStore.models.BookLanguage in all the drop drown items instead of languages . why ?

[@keshavkoirala2427]

Problem solved . I forget to pass second and third parameter in SelectList()

[@putinninovacuna8976]

repository concept is a such hard thing to learn

[@dabanabdulla9916]

System.NullReferenceException: 'Object reference not set to an instance of an object.'
Bookstore.Data.Book.language.get returned null when getaallbooks
in getallbook methos I had too add this line to fix it
book.language =await _db.langtable.Where(x => x.id == book.languageId).FirstOrDefaultAsync();

[@ammadkhan2352]

I am getting same error in Droplist binding don't know what is the issue

[@syedmuhammadali7406]

This method is too tough kindly use it as to make it easy ,

[@samuelseverua]

useless, Greate concepts but 0 following potential