Beth Massi – Sharing the goodness that is VB : ADO.NET Data Services – Building an Excel Client
Today I want to show a simple Excel client that queries our service and allows us to edit the customers in Northwind. I’m going to use Visual Studio 2008 (VSTO) to build a document-level customization against an Excel 2007 Workbook. We’ll also build an Actions Pane that allows us to query and save customers to our ADO.NET data service. Excel’s tabular data format lends itself well to CRUD database operations when we Add, Delete and Update rows in a Sheet. (NOTE: You cannot create Office solutions in Visual Studio Express editions.)
Posted from Diigo. The rest of my favorite links are here.