Posted By

lfbarbieri on 05/09/07

Tagged

database
sql

Versions (?)

Last Edited at 05/09/07 03:24pm

Statistics

Viewed 1053 times

Favorited by 0 user(s)

Related snippets

Database Retrieve

/ Published in: C#

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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();
        }