View Single Post
  #1 (permalink)  
Old September 23rd, 2004, 07:04 PM
Arsi Arsi is offline
Authorized User
Points: 457, Level: 7
Points: 457, Level: 7 Points: 457, Level: 7 Points: 457, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2004
Location: Burbank, CA, USA.
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Arsi
Default Visual Studio Tools for Office

Hello,

I need some help with VSTO. I am trying automate an Excel workbook using a SQL Server Database. I have been able to display the data using C# code (no macros), but I cannot Update because I keep getting the error: "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information." The database contains 1 table, the workbook has 3 worksheets+. I cannot find a solution for my problem because there isn't much about it. Can someone point me in the right direction? Where can I find more information and examples on VSTO?

*******(*)*******
__________________
*******(*)*******
Reply With Quote