19. VSTO Data Programming

A FULL TREATMENT OF Microsoft’s ADO.NET data programming model could easily fill an entire book of its own. Therefore, this chapter starts with an example of how to use the VSTO designer to create a data-bound customized spreadsheet without writing a single line of code. After that, the chapter examines some ADO.NET features and then delves into the Word- and Excel-specific programming model.

To understand ADO.NET in all its complexity, read Shawn Wildermuth’s Pragmatic ADO.NET (Addison-Wesley, 2002) and the data binding chapters of Windows Forms Programming in C# (Addison-Wesley, 2003) by Chris Sells.

Several developer scenarios in Office development leverage data binding. If you use data binding with Windows Forms ...

Get Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.