title: Dynamic Data : How to bind specific column value into dropdownlist
body: <p>I'm working on a project of type "ASP.NET dynamic data LINQ to LINQ application".</p>
  
  <p>When i execute my application I'm getting all labels and DropDownLists dynamically binding.</p>
  
  <p>I'm referring <a href="http://www.shubho.net/2011/03/customizing-dynamic-data-application.html" rel="nofollow noreferrer">this</a> blog.</p>
  
  <p>Now I need to populate those DropDownList based on my criteria. Currently, it is populating all the records which is there in table for that column. How can I customize this DropDownList like I want to select only User with <code>Mak</code> name?</p>
  
  <p>I guess i need to made some linq query here when dropdown populated values? not sure</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
          {
              if (DropDownList1.Items.Count == 0)
              {
                  if (Mode == DataBoundControlMode.Insert || !Column.IsRequired)
                  {
                      DropDownList1.Items.Add(new ListItem("[Not Set]", ""));
                  }
                  PopulateListControl(DropDownList1);
              }
  
              SetUpValidator(RequiredFieldValidator1);
              SetUpValidator(DynamicValidator1);
          }
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/rHbqC.png" alt="enter image description here"></p>