Wow, I can't believe someone gave me 1 point because I didn't put the codes up. Isn't this a C# question anyways?

If you're programming under .NET, I would suggest to use Microsoft's Reporting Technology (I think Crystal Report is a little more complicated, but that's just my personal opinion). It's easy--all you have to do is to design a report (Add new item -> Report), create an instance with parameters and attach it to your program. You don't have to worry about print margins or layout. They can be set by changing some variables, unlike HTML, which you'd have to mess with CSS. This is especially useful when you have to print labels. Plus, The Reporting Technology and Crystal Report comes with VS2005. If you're programming .NET you should have them installed already.

You grab your data from strConnection and stored it in the DataSet dsEWEtmp. Now go ahead and open up strConnection2 and insert the data. I'm pretty sure you can find how to insert from dataset very easily from this site.

Hmm... Can't I can't say much, the code looks pretty good. If you haven't tried it, a print on Sql and see if your connection or logic is correct.

This sounds like a homework problem

What do the code to your command object looks like? Maybe you're not connecting to the file correctly. Do a select * for one of the table and see if you get results.