Daily Archives: September 25, 2005

Vermont Tourist ideas for the fall

Vermont

I shared this list of personal favorite things to do in Vermont for someone who is coming here next weekend and thought I would share. This is all focused mostly in Northern Vermont.

Some super special things I would recommend are
www.shelburnemuseum.org
 
For a GREAT drive:
 
From Burlington, drive South on 89 to Exit 10 (stowe/waterbury)
Stop at Ben & Jerry’s for a factory tour
Continue up Route 100 to Stowe. Check out Stowe, for sure.
Then drive up 108 to the top of Smuggler’s Notch and go hike around for a while.
 
 
Definitely go to downtown Burlington. Maybe do a ride on the Ethan Allen Cruises on the lake. Check out the pier. If you have kids, the ECHO Center right there is really cool. Also while downtown, take a walk on Church Street. That’s an “open mall”  – lots of great local stores with the usual Old Navy cr*p mixed in. Some fave local stores on Church Street are Frog Hollow Gallery (all excellent vermont crafts people and artists) and Apple Mountain – really nice and not cheesy (well, except for the cheese) Vermont gifts.
 
Also, near us, Mad River Glen (and I’m sure other ski areas too) are doing fall foliage rides on their ski lifts. http://www.madriverglen.com/?Page=fall02.html
 
Those are just some ideas of personal favorites.
 
Oh and most importantly, you should go to the Lake Champlain Chocolates (note the aspx page 🙂 !) factory near downtown and stock up on seconds.
 
Also www.Vermont.org is a great resource for year-round things as well as an event calendar.
 
This sounds like so much fun, I want to come here on vacation now!
 


Don’t Forget: www.acehaid.org

Creating a DataReader from a DataTable’s original values with two new ADO.NET 2 features

ADO.NET 2

One of the fun brain teasers that was asked in my What’s new in ADO.Net 2.0 talk today at Code Camp 4 in Boston was if it was possible to create a DataReader from the original values of a DataTable using the new CreateDataReader method.

Although there isn’t a direct way to do it, I came up with a simple way to achieve this.

Basically you get a dataview of the table. Set the RowsStateFilter to OriginalRows. (That’s available in 1.x also). Then use the new DataView.ToTable method to create a new table. Lastly, use the Table.CreateDataReader to create a DataTableReader.

dim dv as DataView=myTable.DefaultView
dv.RowStateFilter = DataViewRowState.OriginalRows 
dim dtNew as DataTable=dv.ToTable()
dim dtr as DataTableReader=dtNew.CreateDataReader

Don’t Forget: www.acehaid.org