Load Drop Down List From Data Row

Published On Thursday June 4, 2020 Reading Time: < 1 minute

Creating a dynamic drop down list from DataRow returning from database i.e automatically binding the asp drop-down list field with the data returned from the database.

Returning Dictionary From Database:

public Dictionary<string, string> LoadDropDownList() {
 var dictionary = new Dictionary<string, string> ();
 DataTable res = new DataTable();
 if (res.Rows.Count > 0) {
  foreach(DataRow dr in res.Rows) {
   dictionary.Add(dr["value"].ToString(), dr["text"].ToString());
  }
 }
 return dictionary;
}

Call DDL Function:

PopulateDdl(ref ddlField, Dictionary);

PopulateDdl Function Description:

private void PopulateDdl(ref DropDownList ddl, Dictionary < string, string > dic, string selectedValue = null) {
 List < ListItem > list = new List < ListItem > ();
 
 foreach(var item in dic) {
  if (selectedValue != null && item.Value.ToLower().Equals(selectedValue.ToLower())) {
   list.Add(new ListItem {
    Text = item.Value, Value = item.Key, Selected = true
   });
  } else {
   list.Add(new ListItem {
    Text = item.Value, Value = item.Key
   });
  }
 }
 ddl.DataTextField = "text";
 ddl.DataValueField = "value";
 string hasval = "";
 if (selectedValue != null) {
  dic.TryGetValue(selectedValue, out hasval);
  if (hasval != "") {
   ddl.SelectedValue = selectedValue;
  }
 }
 ddl.DataSource = list;
 ddl.DataBind();
}

Post Views: 1,355

0 0 votes

Article Rating

Load Drop Down List From Data Row

Categories

Recent Posts

Adding Google Authentication In .Net Core Application Without Identity The Basics

Using AutoFac On ASP.Net 5 (A Thirdparty Inversion of Control Container)

Entity Framework Core For Beginners In Asp.Net Core – Code First Approach

Role Based Authorization Using Jwt Token In Asp.Net Core Web Api

JWT Authentication In Asp.Net Core Web Api

Load Drop Down List From Data Row

More On The Topic

Categories

Recent Posts

Adding Google Authentication In .Net Core Application Without Identity The Basics

Using AutoFac On ASP.Net 5 (A Thirdparty Inversion of Control Container)

Entity Framework Core For Beginners In Asp.Net Core – Code First Approach

Role Based Authorization Using Jwt Token In Asp.Net Core Web Api

JWT Authentication In Asp.Net Core Web Api