protected void PopulateListBox() { ListBoxUsers.Items.Clear(); //Clears any old items from the ListBox string sCommand = "SELECT * FROM Users order by LastName, " + "FirstName, UserName"; //Modify the path if your database is in a different place string sConn = "Provider=Microsoft.JET.OLEDB.4.0;" + "data source=C:\\Documents and Settings\\Administrator\\" + "My Documents\\TopSecret.mdb"; dbConnection = new OleDbConnection(sConn); dataAdapter = new OleDbDataAdapter(); commandBuilder = new OleDbCommandBuilder(dataAdapter); dataAdapter.SelectCommand = new OleDbCommand(sCommand, dbConnection); ds = new DataSet(); dataAdapter.Fill(ds); int iRowNumber = 0; DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { ListItem listItem = new ListItem(); listItem.Value = "" + iRowNumber++; listItem.Text = dr["LastName"] + ", " + dr["FirstName"] + ": " + dr["Username"]; ListBoxUsers.Items.Add(listItem); } }