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?

*******(*)*******

__________________
*******(*)*******