snippetsmania.com
Post and share your code snippets

try
{
// Create and open a connection object
conn = new SqlConnection(configurationConnString);
conn.Open();

// Set Stored Proc
SqlCommand cmd = new SqlCommand("spGetConfigSettingsByApplication", conn);
cmd.CommandType = CommandType.StoredProcedure;

// Set Parameters
cmd.Parameters.Add(new SqlParameter("@applicationName", SqlDbType.NVarChar, 50));
cmd.Parameters["@applicationName"].Value = "FTU";

// execute the command
rdr = cmd.ExecuteReader();

// iterate through results, printing each to console
while (rdr.Read())
{
configSettings.Add(rdr["AppKey"], rdr["AppValue"]);
}
}
finally
{
if (conn != null) conn.Close();
if (rdr != null) rdr.Close();
}

source