Welcome to MSDN Blogs Sign in | Join | Help

.NET4Office

A blog by Eric Carter
MSDN Webcast on Data and Databinding in VSTO 2

A member of my team, Muhammad Arrabi, is giving an MSDN webcast tomorrow on VSTO 2.  

http://go.microsoft.com/fwlink/?LinkId=25936 

Go give him a hard time for me J 

MSDN Webcast: Data and Databinding with Visual Studio Tools for Office Version 2 - Level 200
April 06, 2004
11:00 AM - 12:30 PM Pacific Time
Muhammad Arrabi, Program Manager, Microsoft Corporation
The Visual Studio® Tools for the Microsoft® Office Systems in Whidbey provides a rich data programming model for automating Word and Excel documents. This webcast will showcase some of these features, such as databinding to Office controls, caching data in the document for offline use, and integrating the data model with the new Office 2003 XML features. 

Posted: Tuesday, April 06, 2004 3:20 AM by Eric Carter

Comments

Arian Kulp said:

In this webcast Muhammad demonstrated dragging elements from the XML Maps pane onto a worksheet. In his demo the elements came over as NamedRange's. Whenever I try this I get DataList controls instead. Is this due to the schema itself or some setting I need to change? I would like to try the MoveNext/Previous part of his demo but I need one record at a time for that.

Thanks!

By the way: schema is roughly:
Contacts (root)
Contact (unbounded)
name (max 1)
phone (max 1)
/Contact (max 1)
/Contacts
# June 1, 2004 2:17 PM

Eric Carter said:

This is Eric posting for Muhammad--This is Muhammad's response:

The schema must be for 1 record instead of many to produce fields and not lists. Excel makes that decision. Here's how to change the schema:
Contacts (root)
Contact (max 1)
name (max 1)
phone (max 1)
/Contact (max 1)
/Contacts
# June 1, 2004 3:33 PM

Arian Kulp said:

Thanks! Now I have fields instead of lists. There must be something else I'm doing wrong though, because each field I drop onto the worksheet creates its own data connector. So after dropping the first and last name I see ContactsFirstNameConnector and ContactsLastNameConnector. Shouldn't it only be ContactsContactConnector so I can move between Contact records easily? And if I've specified max 1 for Contact how can I have multiple records?
# June 2, 2004 6:26 AM

Muhammad Arrabi said:

Creating a connector for every field is a bug in build 40315 of VSTO. It's fixed in later builds. If you can get a newer community build (TechEd PD5 build) or wait for Beta 1, then this will be fixed.

BTW, the webcast link has changed to: http://go.microsoft.com/fwlink/?LinkId=25869
# June 2, 2004 12:08 PM
New Comments to this post are disabled
Page view tracker