Button

foreach (int item in tempProfil.Funktioner)
        {

            Button myButton = new Button();
            myButton.Visible = true;
            myButton.Width = 100;
            myButton.Height = 50;
            myButton.ID = profil.Rolle;
            myButton.Text = "Click";
            myButton.Text = "My Button";
            myButton.Click += new EventHandler(myButton_Click);

            this.Controls.Add(myButton);

            Response.Write("<br />" + myButton +item.ToString());

using(SqlConnection connection = new Sqlconnection(youconenctionstring))
using(SqlCommand command = connection.Createcommand())
{
    command.Commandtext = "yourProcName";
    command.CommandType = CommandType.StoredProcedure;
    command.Paramters.Add("@yourparam",yourparamvalue);
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();
    List<string> buttonTextList = new List<string>();
    while(read.Read())
    {
        buttonTextList.Add((string) read["FieldName"]);
    }
}