index > Visual Studio Tools for Office > Share single dataset across worksheets

Share single dataset across worksheets

Hi,

I need to connect multiple worksheets to the same dataset instance; so I have tried passing the dataset around using the Globals class but the databindings go weird. One page binds right while another sheet does not bind at all. Also I tried creating and filling the dataset in the ThisWorksheet class and got the same effect.

How should I pass the same instance around inorder to get everything to work right?

Thanks,

blair

Blair

I fixed it. Turns out I needed to move where the SetBindings call occurred so that it occurs just after the filling in of the dataset. I had it occurring before the dataset was filled.

blair

Blair
reply 2

You can use google to search for other answers

 

More Articles

• I cannot get Add-in object instance in Outlook VBScript
• Problem deleting excel sheets
• Select worksheet explicitly
• basic mailmerge function
• Outlook Deployment ala ClickOnce
• Comments color in Word
• Ambiguity between 'Microsoft.Office.Interop.Word._Application.New...
• Unable to cast COM object of type 'System.__ComObject' error
• MS Word
• URGENT-VSTO compatibility info...
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• Using VSTO to Process data in a word doc
• Moving Items in the Outlook Calender and
• URGENT: Cannot Install VSTO June 2006 CTP!
• Using VB with Office XP Excel and Viso 2
• VSTO Serious Deployment Problem. NamedRa
• Word Macro for changing document comment
• Help! How to identify nodes of Infopath2
• NEWBIE question about Excel within VSTO
• VSTO for Excel Deployment kit
• VSTO 2005 Upgrade did not install Visual
• auto_close addin unload
• Exporting HTML Data to PowerPoint. Is th
• Msdn help for Microsoft.Office.Interop.O
• Word XML Document Question
• VSTO Deployment

Hot Articles

• Shutdown word application forcefully
• VS2005, office projects do NOT appear, e
• Announcing "Cypress" - fully s
• why i can't see "office" proje
• Implement Intellisense in MS Word
• Access Denied starting MS Outlook from W
• Print to upper tray in Access
• Excel SaveAs() method
• VSTO Deployment Installation
• Calendar Date Range
• Strange problem with the plugin...
• how i can translate word from english to
• Creating new templates
• Excel Designer cannot be activated
• Seroius error while having combobox into

Recommend Articles

• Excel macro question - ref: sheets (hope
• outlooK 2003 WITH sp2
• Is it possible to over-ride Word numberi
• InterOp COM error - C# 2.0 - Office 2003
• Recommendation for Office 2007 developme
• Outlook Add-in configuration
• Modifying the Office 2007 Ribbon
• VSTO Installation included in Visual Stu
• Desperate - please help (KB 907417 &
• Using Computer.Clipboard And Excel
• Security and permissions on a VSTO server
• Visual Studio 2005 for Office over VS St
• Excel Fixed horizonal and vertical panes
• Oh Happy Day!
• Connecting and working with Access 2003