checkBoxList

// C#
private void Page_Load(object sender, System.EventArgs e)
{
   if (! this.IsPostBack)
   {
      sqlConnection1.Open();
      sqlCommand1.CommandText = "Select au_id, au_lname from authors";
      ListBox1.DataSource = sqlCommand1.ExecuteReader();
      ListBox1.DataTextField = "au_lname";
      ListBox1.DataValueField = "au_id";
      ListBox1.DataBind();
      sqlConnection1.Close();
   }
}