How do I loop through SQL table to set global variables

See more:

C#

Hi All

I have a table tblFlags with 3 columns UniqID, FlagName,FlagValue

This table is used for storing app settings ie DataPathBackup

What i would like to do is loop through this table to set public static strings upon startup

ie public static string "FlagName" = "FlagValue"
this should return : public static string DataPathBackup = z:\AppBackup\


How would i be able to achieve this?

What I have tried:

I have set some default values
ie
public static String DataPathBackup= @"Z:\AppBackup\";

then i call FillFlags()

From below;
j returns the correct FlagName and k returns the correct FlagValue


so i would like to have something like
public static string "j" = "k"

this will then overide my default setting if it was found in this table

public void FillFlags()
{
    string connectionString = null;
    SqlConnection cnn,cnn2;
    connectionString = CString;
    cnn = new SqlConnection(connectionString);
    cnn2 = new SqlConnection(connectionString);
    SqlDataReader dr,dr2;

        SqlCommand comm = new SqlCommand("SELECT [FlagName],[FlagValue] from tblFlags");

    comm.Connection = cnn;
        cnn.Open();
        dr = comm.ExecuteReader();

        while (dr.Read())
        {
            string j = dr["FlagName"].ToString();
           
            SqlCommand comm1 = new SqlCommand("SELECT [FlagValue] from tblFlags WHERE FlagName='"+ j +"'");
            comm1.Connection = cnn2;
            cnn2.Open();
            dr2 = comm1.ExecuteReader();
            MessageBox.Show(j);
            while (dr2.Read())
            {
                
                string k=dr2["FlagValue"].ToString();
                //j = k;
               
                MessageBox.Show(k);
            }
            dr2.Close();
            dr2.Dispose();
            cnn2.Close();
        }
        dr.Close();
        dr.Dispose();

        cnn.Close();
}