C#

private void get_staff_info()

{

this.Cursor = Cursors.WaitCursor;

sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=ssis_database;integrated security=true;");

sql_connection.Open();

sql_command = new SqlCommand("sp_get_staff_info_by_id", sql_connection);

sql_command.CommandType = CommandType.StoredProcedure;

sql_command.Parameters.Add("@staff_id", SqlDbType.Int).Value = staff_id;

sql_reader = sql_command.ExecuteReader();

if (!sql_reader.HasRows)

{

MessageBox.Show("staff not found!!", "error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);

}

else

{

if (sql_reader.Read())

{

lblCPR.Text = sql_reader["staff_cpr"].ToString();

lblFullName.Text = sql_reader["staff_name"].ToString();

lblBirthday.Text = Convert.ToDateTime(sql_reader["staff_birthday"]).ToString("dd-MMM-yyyy");

TimeSpan age = DateTime.Now - Convert.ToDateTime(sql_reader["staff_birthday"]);

int years = age.Days / 365;

int months = (age.Days - (years * 365)) / 30;

string strAge = String.Format("{0}y", years);

lblBirthday.Text += " [" + strAge + "]";

lblGender.Text = sql_reader["gender_name"].ToString();

lblNationality.Text = sql_reader["country_name"].ToString();

lblFlat.Text = sql_reader["staff_address_flat"].ToString();

lblBuilding.Text = sql_reader["staff_address_building"].ToString();

lblRoad.Text = sql_reader["staff_address_road"].ToString();

lblBlock.Text = sql_reader["staff_address_block"].ToString();

lblTelephoneHome.Text = sql_reader["staff_telephone_home"].ToString();

lblTelephoneMobile.Text = sql_reader["staff_telephone_mobile"].ToString();

lblTelephoneMobile2.Text = sql_reader["staff_telephone_mobile2"].ToString();

lblEmailAddress.Text = sql_reader["staff_email_address"].ToString();

lblGrade.Text = sql_reader["grade_name"].ToString();

lblStep.Text = sql_reader["step_name"].ToString();

lblSalary.Text = Convert.ToDecimal(sql_reader["staff_salary"]).ToString("BD #,###,##0.000");

lblBank.Text = sql_reader["bank_name"].ToString();

lblBankAccount.Text = sql_reader["staff_bank_account"].ToString();


sql_reader.Close();

}

}

this.Cursor = Cursors.Default;

}

public partial class frmSearchArtists : Form
    {
        OleDbConnection musLibConn = new OleDbConnection();
        utility util = new utility();
        string artist;
        int i = 0;

        public frmSearchArtists()
        {
            InitializeComponent();
            musLibConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\GeneSys\Library.mdb";
            musLibConn.Open();

            OleDbCommand selLib = new OleDbCommand("SELECT DISTINCT Artist FROM Library ORDER BY Artist", musLibConn);
            OleDbDataReader drLib = selLib.ExecuteReader();
            int idxArtist = drLib.GetOrdinal("Artist");
            Button btn;

            while(drLib.Read())
            {
                
                btn = new Button();
                btn.Text = drLib.GetValue(idxArtist).ToString();
                artist = drLib.GetValue(idxArtist).ToString();
                btn.Name = artist;
                btn.ForeColor = Color.White;
                btn.Size = new System.Drawing.Size(120, 60);
                btn.BackColor = Color.MidnightBlue;
                btn.Font = new Font("Arial Black", 10, FontStyle.Bold);
                btn.Click += new System.EventHandler(this.btnArtist_click);
                flp.Controls.Add(btn);
                i++;
            }
        }

        private void btnArtist_click(object sender, EventArgs e)
        {
            util.setArtist(artist);
            frmArtist frmArtist = new frmArtist();
            frmArtist.Show();
        }
    }