Subscribe to Cache Cow        RSS Feed
- - - - -

A Few String Parsing Functions in SQL Server

Icon Leave Comment
While working on one of my projects at work today, I came to the realization that database programming languages handle strings much differently than do those programming languages that are not database-centric (i.e. C#, Java, C++). I know, you may be thinking "well...duh!", but think about it for a second. A person who has spent...
- - - - -

More XML to Excel Tricks

Icon Leave Comment
In a previous blog (Export your data table to Excel the quick way (via XML)...
- - - - -

Getting and Setting the Expansion State in a TreeView in VB.NET

Icon Leave Comment
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...
- - - - -

Sample Stored Procedure and Associated Calls From VB.NET

Icon Leave Comment
A while back, I wrote a simple blog on how to call a SQL Server stored procedure from VB.NET. I was asked by a reader to generate a more detailed "Hello World" style stored procedure so they could more easily identify exactly what was going on. In this tutorial, you will find just such a stored procedure and the associated VB.NET...
- - - - -

Export your data table to Excel the quick way (via XML)

Icon Leave Comment
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...
- - - - -

Maintain Datatype When Exporting RDLC Report to Excel

Icon Leave Comment
If you are like me, you have to use the Reportviewer object quite often in your .NET development. If that is the case, you have also found that there isn't a whole lot of help out there with reference to said reports.

The other day, a customer asked me to write a small application for him which would compile a bunch of information in a...
- - - - -

Using Stored Procedures with VB.NET and SQL Server

Icon 3 Comments
I thought about writing some insightful message that would, eventually, lead up to my version of how to execute a stored procedure in SQL Server from a VB.NET application. After giving it some thought, I decided to just get right down to what everyone cares about...the code. So here it is:

What I am using:...
- - - - -

Using Excel and XML data in VB.NET and SQL Server

Icon Leave Comment
I had a customer come to me the other day and ask if I could put together some data for him. It was only 18 months worth of shipped products so I naturally said "Sure! That won't be too hard. What database is it in?" He replied, "Well, we don't have the data stored in a database...what we have is all of the pallets of...
- - - - -

Are you a "Nerd", a "Geek", or an "Artist"?

Icon 2 Comments
It seems that there is this stereotype floating around that "Computer Guys" are these socially awkward, introverted, live in their parents basement types. We've all seen it. You go to the code camps and hear people call themselves "nerds" or "geeks", you see the websites out there that incorporate the name (like...
- - - - -

Stuck in .NET Excel Hell?

Icon Leave Comment
Recently, I had a customer request to send a bunch of data to a single Excel file. Normally, this would not be an issue if I were using VB6 or VBA, but I'm not. I am a VB.NET developer (I have finally overcome my phobia of actually calling myself a "developer"). I work with .NET FW 3.5 in VS2010. There just isn't a lot of...

  • (2 Pages)
  • +
  • 1
  • 2

April 2014

S M T W T F S
  12345
6789101112
13141516171819
20 212223242526
27282930   

Search My Blog

0 user(s) viewing

0 Guests
0 member(s)
0 anonymous member(s)

Categories