Hey, no problem. VSTO is pretty huge -- there are many API's for each of the Microsoft Office applications, particularly Word and Excel. As a tip, I've found one is better off using Google or some other web search engine to ask questions about VSTO API's and how to do things. Programmers frequently post questions about VSTO workings, and the programmers' forums on the web (including CodeProject!) are often a much better resource than the Microsoft documentation. VSTO is an interop assembly for the long term established COM interface to Office, it has been under development for a long, long, time, and it is enormous.

I think we've established that you're getting an Microsoft SQL Server syntax error on an insert, right? Did you check the actual insert statement string in the debugger? That date format is valid for MS SQL, and it's fine with a date-only without time for a DATETIME. At this point without more info (some code), my best guess would be the usual suspects: columns in INSERT statement out of order or a need to quote the fields. Try backquote.

Oh, it's a database insert issue. What database are you using? MySQL? If MySQL, try yyyy-MM-dd.

C# is easier to type if you are left handed or one of these new "script kiddie" programmers that never wrote in C and thinks assembler was something Neanderthals wrote in. Who the heck said C# is any better than Java? The fact Microsoft is behind it and Windows dominates and C# is most powerful in .NET, and .NET most efficient on Windows these days, is the only reason you're even investigating it and I spend so much time writing in it. After 30+ years in this game starting with most everything assembler and going through too many C variants, it all looks darn near identical to me except for the quality of the tools and the time frames involved in turning out quality software. Those really have nothing to do with the language. There hasn't been a really significant invention in computer languages since C++, and frankly if Niklaus Wirth had been a principal engineer at Microsoft (which didn't exist then), we'd all still be writing in Modula 2. Stroustrup's work extending the hack Kernigan and Ritchie put together to port Unix and Modula 2 are the only truly significant language designs since assemblers beat out paper tape and switches. C is just a syntax shortcut, and it's invention happened to birth the "compiler." Everything since of any merit is just another re-design of what was proven with those three. Why don't you do a presentation on how C# is better than APL? Now THAT would be an interesting presentation that would challenge you to put together. I wonder if one could still find an APL keyboard on eBay? If you really think pointers are something one simply cannot use, try out APL -- no such concept.

I use TreeView extensively. It is a rather "unique" control with a lot of pitfalls. I strongly suggest you expend the effort and write custom code around your TreeView controls. Otherwise, if you really want to just use binding, refer to this article on CodeProject: Data Binding TreeView in C#[^]

The nmost likely API set you want is the VSTO interface from Microsoft. It's a .NET Interop Assembly to the MS Office COM API's. It is an enormous set of API's, a COM wrapper with all the COM pitfalls plus the myriad versions of MS Office, so test thoroughly. There is a ton of information on using VSTO you can find on the web. Here is a starting point: http://msdn.microsoft.com/en-us/vsto/dd164295.aspx[^] -- Christo

I just wrote a quickie C# WinForms application duplicating your code, and it works fine. Ditto with a console app. Is this an ASP.NET app you are working on?