I created a function in one of my application that allows to generate an image (in WPF) by getting the 'source path' from the database that I am using:

    public void ShowImageThumb() 
    {
        try {
            cn = new MySqlConnection();
            cn.ConnectionString = ConfigurationManager.AppSettings["MyConnection"];
            cn.Open();
            MySqlCommand cmd = new MySqlCommand();
            cmd.Connection = cn;
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = "SELECT thumb FROM album WHERE thumbNo=1";
            MySqlDataAdapter adp = new MySqlDataAdapter();
            adp.SelectCommand = cmd;

            DataTable dt = new DataTable();
            adp.Fill(dt);
            MySqlDataReader r = cmd.ExecuteReader();
            while (r.Read())
            {
                BitmapImage bmi1 = new BitmapImage(new Uri(r[0].ToString(), UriKind.Relative));
                image1.Source = bmi1;

            }
            r.Close();
            cn.Close();

        }

        catch (Exception err){
            System.Windows.MessageBox.Show(err.Message);
        }

        finally { }

    }

Take a look on my SQL statement. I put a WHERE thumbNo=1 which allows the function to get 1 record. You see, I do have at least 10 records - file paths listed in that table.

I just wanna ask if there's a possible way to make my SQL statement something like this:

SELECT thumb FROM album;

while having this piece of code inserted in my function:

BitmapImage bmi2 = new BitmapImage(new Uri(r["second record?"].ToString(), UriKind.Relative));
                image2.Source = bmi2; //something like this

BitmapImage bmi3 = new BitmapImage(new Uri(r["third record?"].ToString(), UriKind.Relative));
                image3.Source = bmi3; //something like this

and so on and so forth, without ending up creating 10 different functions for 10 records.

ShowImageThumb2();
.
. // will not do this
.
ShowImageThumb10(); 

Sorry for the lengthy post. I hope somebody could answer back. Thanks!