Cache Cow Syndication Thu, 23 May 2013 19:56:47 +0000 admin@dreamincode.net (Dream.In.Code) IP.Blog 60 http://www.dreamincode.net/forums/blog/1693/entry-4472-more-xml-to-excel-tricks/ Export your data table to Excel the quick way (via XML)...]]> Thu, 23 May 2013 16:02:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-4472-more-xml-to-excel-tricks/ http://www.dreamincode.net/forums/blog/1693/entry-4299-getting-and-setting-the-expansion-state-in-a-treeview-in-vbnet/ If any of you readers are like me, you are sitting here looking at the TreeView and wondering how you are going to maintain the expansion state of each node. I tested out several possible methods for getting the expansion states and setting them and finally settled on a method which has worked pretty well for me. (I am using .NET framework... Fri, 16 Nov 2012 22:23:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-4299-getting-and-setting-the-expansion-state-in-a-treeview-in-vbnet/ http://www.dreamincode.net/forums/blog/1693/entry-4295-sample-stored-procedure-and-associated-calls-from-vbnet/ Thu, 15 Nov 2012 20:28:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-4295-sample-stored-procedure-and-associated-calls-from-vbnet/ http://www.dreamincode.net/forums/blog/1693/entry-4177-export-your-data-table-to-excel-the-quick-way-via-xml/ A while back I wrote about the way I had come up with to export data to Excel. This worked for me for a little while, but I am always looking for ways to speed up the execution of my code. When I started working with framework 4.0 and the accompanying Excel interop COM library (v14 i think it is) the execution of saving some 50 columns and 300... Thu, 30 Aug 2012 16:17:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-4177-export-your-data-table-to-excel-the-quick-way-via-xml/ http://www.dreamincode.net/forums/blog/1693/entry-3925-maintain-datatype-when-exporting-rdlc-report-to-excel/
The other day, a customer asked me to write a small application for him which would compile a bunch of information in a...]]> Thu, 23 Feb 2012 16:40:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-3925-maintain-datatype-when-exporting-rdlc-report-to-excel/ http://www.dreamincode.net/forums/blog/1693/entry-3893-using-stored-procedures-with-vbnet-and-sql-server/
What I am using:...]]> Fri, 27 Jan 2012 20:36:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-3893-using-stored-procedures-with-vbnet-and-sql-server/ http://www.dreamincode.net/forums/blog/1693/entry-3877-using-excel-and-xml-data-in-vbnet-and-sql-server/ Fri, 13 Jan 2012 20:09:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-3877-using-excel-and-xml-data-in-vbnet-and-sql-server/ http://www.dreamincode.net/forums/blog/1693/entry-3667-are-you-a-nerd-a-geek-or-an-artist/ Wed, 24 Aug 2011 16:34:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-3667-are-you-a-nerd-a-geek-or-an-artist/ http://www.dreamincode.net/forums/blog/1693/entry-3646-stuck-in-net-excel-hell/ Fri, 12 Aug 2011 16:32:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-3646-stuck-in-net-excel-hell/ http://www.dreamincode.net/forums/blog/1693/entry-3536-microsoft-needs-more-people-like-scott-hanselman/ article by Scott the other day and I started to think how great this guy is...of course, I didn't realize that this is the same guy that had me rolling on the floor laughing at his presentation at the Portland Code Camp I recently attended. I do remember a detail about Scott that may have many people wondering if he actually...]]> Wed, 29 Jun 2011 15:59:00 +0000 http://www.dreamincode.net/forums/blog/1693/entry-3536-microsoft-needs-more-people-like-scott-hanselman/