This snippet shows you a simple way to dynamically populate a ListBox. Your SQL Select statement will determine the data that the ListBox's will display as well as its value.
//declare two variables - one for the connection string and the other for the dataset
private String cnstr;
private DataSet ds;
protected void Page_Load(object sender, EventArgs e)
// Call the method you created
protected void _source()
// Setup Connection string
cnstr= "server=type in IP address;user=type in database user;password=type in database password;"
+ "database=type in database name;";
// Create a new Sql Connection
SqlConnection cn = new SqlConnection(cnstr);
//Create the DataSet
ds = new DataSet("ds");
//Create a new Sql Data Adapter
//In your SQL Select statement, only select the columns you want to be displayed
//If you use the select all (*) it will obviously display all the columns
SqlDataAdapter da= new SqlDataAdapter("SELECT columname FROM tablename", cn);
// Fill the Data Adapter
//Set the Datasource for the Repeater equal to the DataSet
ListBox1.DataSource = ds;
//Set the ListBox's DataTextField and DataValueField to the Column you selected
ListBox1.DataTextField = "columnname";
ListBox1.DataValueField = "columnname";
//Bind your Data
*Quick Note: Don't forget to add 'using System.Data.SqlClient;' to the top of the code behind page.
In your .aspx page add the following code in between the body tags. Click on the image to view full size.
If you have any questions or there are discrepancies in the code please feel free to leave a comment and I will try to answer/fix them as soon as I can.