k, this thing was giving a freaking headache this morning but I finally figured out the fix. You need to add the line:

SqlDataSource1.InsertParameters.Clear();

This will obviously clear the InsertParameters collection and you will no longer get the error. Here's the full code, first from my ASPX page, then my code behind:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TheSolConnectionString %>"
                SelectCommand="SELECT [ItemId], [ListId], [ListItem], [ItemComment], [ItemRank], [ItemDeleted], [ItemDateCreated], [ItemCompleted], [ItemDateUpdated] FROM [list_Items]"
                InsertCommand="INSERT INTO list_Items(ListId, ListItem, ItemComment, ItemRank, ItemDeleted, ItemDateCreated, ItemCompleted) VALUES(@ListId, @ListItem, @ItemComment, @ItemRank, @ItemDeleted, @ItemDateCreated, @ItemCompleted)"
            >
</asp:SqlDataSource>

SqlDataSource1.InsertParameters.Add("ListId", TypeCode.Int32, ListId.ToString());
SqlDataSource1.InsertParameters.Add("ListItem", dr[1].ToString());
SqlDataSource1.InsertParameters.Add("ItemComment", dr[2].ToString());
SqlDataSource1.InsertParameters.Add("ItemRank", dr[0].ToString());
SqlDataSource1.InsertParameters.Add("ItemDeleted", TypeCode.Int32, "0");
SqlDataSource1.InsertParameters.Add("ItemDateCreated", TypeCode.DateTime, Convert.ToString(DateTime.Now));
SqlDataSource1.InsertParameters.Add("ItemCompleted", TypeCode.Int32, "0");
SqlDataSource1.Insert();
SqlDataSource1.InsertParameters.Clear();

 
On November 11th, on Sunday morning at ~7:15am the Crowne Plaza was imploded to make way for a new Texas Children's Maternity Center that will be run by the wonderful Texas Children's Hospital. Their goal is to be delivering babies by 2010. (Thanks for the info Cara!)

I had never seen a live building demolition, so I reserved a room at the Holiday Inn next door and woke up early to capture both a movie and some pictures. It did not disappoint! The explosions happened in a quick succession and the glass in my hotel room was constantly vibrating from the blast concussions. It was HELLA cool.

I've posted my pictures on Flickr and there is also a series of pictures from the other side of the building.

Enjoy! 

The Houston Cellar Classic 2007 hosted by the Tasting Room (in Uptown, they have many locations) was freaking awesome. I volunteered for the event and didn't really know exactly what to expect but I knew it would be a great experience and hella fun. I was not let down. Everyone I met was nice and anyone that worked for the Tasting Room was very appreciative of the volunteers. I met a lot of very cool people including Dana, Christian, Amelia, Christina, Quinn, Alberto, Paula, Richard, Rolando, Catherine and Lori.

After I finished my shift in the Retail Room I got to go around and do the wine/food tasting. I tasted many wines, I think over 15 of them. My favorites were the St. Supery Elu and the Inwood Estates Cornelious (a Texas winery... I was shocked). The food was absolutely fabulous too. Max's Wine Dive, Shade, Glass Wall, Olivette and many more restaurants were there feeding the masses. Olivette served a mini chocolate ginger muffin and I think the dab of frosting on top was a cream cheese frosting along with a slice of candied ginger. WOW!

In addition to all that, I was in the VIP room and tasted a 1998 Chateax Margaux ($400), 1998 Veuve Clicquot la Grand Dame ($170), MV Krug Grande Cuvee ($170), 2002 Silver Oak Napa Cabernet ($100), and the 2003 Coppola Rubicon ($130). AMAZING!!!

Anyway, it was a blast and I look forward to volunteering for more events!  I also took my camera and snapped a few shots when I could. Check them out here: http://picasaweb.google.com/hgreerii/HoustonCellarClassic2007