Just a snippet of my code that works, hope it helps

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);

conn.Open();

SqlCommand command = new...