---
title: "binding dropdownlist"  
description: "binding dropdownlist"  
author: "Anonymous User"  
published: 2014-09-05  
updated: 2014-09-05  
canonical: https://www.mindstick.com/forum/2246/binding-dropdownlist  
category: "asp.net"  
tags: ["asp.net"]  
reading_time: 1 minute  

---

# binding dropdownlist

I have a [Class](https://www.mindstick.com/blog/165/generic-class-in-c-sharp) in the App_code folder that contain [Method](https://www.mindstick.com/forum/166/webservice-method) like this:

```
public static  GetAllCustomers(){    string conn = ConfigurationManager.ConnectionStrings["ConnectToDB"].ConnectionString;    using (SqlConnection connection= new SqlConnection(conn))    {        using (SqlCommand cmd = new SqlCommand())        {            cmd.CommandText = "select C_ID,L_ID,C_Name from Customer";            cmd.Connection = connection;            connection.Open();        }    }    return;
```

## Replies

### Reply by Sumit Kesarwani

Hi Ankit,\

You can return a System.Data.DataTable and use column names for datatextfield and datavaluefield.


---

Original Source: https://www.mindstick.com/forum/2246/binding-dropdownlist

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.