I want to store 200 options in list and retrieve according to use

Question

I want to store 200 options in list in asp.net web and retrieve whenever use . How can i get this? Plz help me with code

Ganesan C · Answer

Hi Naveen, Store your options in database and retrieve whenever you needed. It is good option. In future if you want to add/delete/edit any ietme then you can do it DB itself.No need to modify your ASP.NET code. https://www.c-sharpcorner.com/UploadFile/0c1bb2/fill-Asp-Net-dropdown-list-from-database-table-using-Asp-Net/

Priyanka K S · Answer

Best way is to store these options in Database table and use .net ActionFilters or you can create a global list load data every time you load that page or api. Action Fliters reference : https://www.c-sharpcorner.com/article/filters-in-Asp-Net-mvc-5-0-part-twelve/

Aman Gupta · Answer

To add values use this for ( int i = 0; i { var items = bigList.Skip(i).Take(100); // Do something with 100 or remaining items } To retrieve use this For example: add this method to your ControllerClass public ReturnType GetMethod( int id) { ReturnType item = repository.Get(id); if (item == null ) { throw new HttpResponseException(HttpStatusCode.NotFound); } return item; } Hope it works

Varun Setia · Answer

You can retrieve elements through AJAX request. This will not increase load on page. You can expose the Array of elements to one Api Endpoint. the Api Endpoint will be of return type string[]/List and will show response as ["item1","item2","item3","item4",..]. Then write the HTML and JS Code below, HTML Code: "dropdownlist" id= "dropdownlist" > Javascript Code: $.ajax({ url: '/api/dropdown' , method: 'GET' success: function (response){ //Read List Values let options = '' ; for (x=0;x options+= ' +response[x]+ '"> response[x] ' ; } $( "#dropdownlist" ).html(options); } }); I hope this can help :)

Srinivasan Ramamoorthi · Answer

You can store in database and cache, refresh cache whenever new entries are added.

Asma Khalid · Answer

Store your options in either file system or in database and retrieve as needed. https://bit.ly/2D94UYX Mark answer as accepted if helpful. Thanks & Regards, Asma Khalid For more visit www.asmak9.com

I want to store 200 options in list and retrieve according to use

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)