Posted By

brandonroath on 11/24/10

Tagged

Versions (?)

Last Edited at 11/24/10 02:40am

Statistics

Viewed 637 times

Favorited by 1 user(s)

Related snippets

Basic SQL access

/ Published in: C#

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

private Dictionary<string, int> Data
        {
            get
            {
                Dictionary<string, int> data = new Dictionary<string, int>();
 
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    SqlDataReader rdr = null;
 
                    conn.Open();
 
                    string query = "";
 
                    SqlCommand cmd = new SqlCommand(query, conn);
 
                    using (rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            data.Add(((DateTime)rdr["date"]).ToString("MM-yyyy"), (int)rdr["visits"]);
                        }
                    }
                }
                return data;
            }
        }