[axel]

eLliDKraM, on 29 Aug, 2007 - 07:31 AM, said:

you don't know the half of it.

this week i'm trying to get a $100,000 loan because i'm starting a bicycle shop chain in the metro.

That sounds cool. I'm sure its hard, good luck.

[eLliDKraM]

like sloth's penis when he's talking to tyler

[axel]

Everyone is so nice and friendly here. I love it.

[fooboo]

Jerk

[axel]

fooboo, on 29 Aug, 2007 - 07:45 AM, said:

Jerk

I'm a jerk? or Mark is?

I have a feeling I'm going to get in trouble for spamming or something.

[supersloth]

eLliDKraM, on 29 Aug, 2007 - 08:38 AM, said:

like sloth's penis when he's talking to tyler

to be fair, over a normal IM or on here it's just solid, but when we webcam it, like rebar.

[PsychoCoder]

Well this week I created a new report for an application I support. The SQL query took the longest, had to use dynamic SQL so I can pass a comma delimited string of parameters to the query. All the search parameters are optional so I had to tackle that.

Then then wanted the ability to export it to Excel, which was simple. I used the Microsoft.Office.Interop.Excel COM, which gave me the ability to add a "template" file for the report with all the formatting in it already, just plug the data into the template and re-save it with their name. I even created a function to ensure Excel was installed on their machine before they export the data in the DataGridView. It was fun as hell!

Now off to find something else to program

This post has been edited by PsychoCoder: 29 August 2007 - 01:19 PM

[tody4me]

Quote

Well this week I created a new report for an application I support. The SQL query took the longest, had to use dynamic SQL so I can pass a comma delimited string of parameters to the query. All the search parameters are optional so I had to tackle that.

Then then wanted the ability to export it to Excel, which was simple. I used the Microsoft.Office.Interop.Excel COM, which gave me the ability to add a "template" file for the report with all the formatting in it already, just plug the data into the template and re-save it with their name. I even created a function to ensure Excel was installed on their machine before they export the data in the DataGridView. It was fun as hell!

Now off to find something else to program smile.gif

If i would have known that you were working on the same stuff as me i would have asked you for help .
I actually had to write a Excel control quite a while ago to interact with Excel without having to import the PIA each time. The control uses Pivot Tables, Formatting of Data, and data transport. PM me if you want a copy of it, i'll post the code in the PM.

[PsychoCoder]

Thanks for the offer You can email it to me (Ill PM you with the address) and Ill look through it. I like the Interop for one reason, loading a template file with all the formatting and inputting the data into it, makes things much easier, no formatting necessary. Actually my email is my username at dreamincode.net

[Martyr2]

This week I am working more on the CMS and have a small side project of a search/filter/display a set of records for cruise ship packages. Kinda lame and sooooo beneath my skill level. Oh well. DIC keeps me on the level.

[grimpirate]

I'm working on GrimBB (a php flat file bulletin board) check my blog for more info.

[JLeo]

XSL Transformation since thuesday...

[tody4me]

Adding a couple of snippets to increase my contributions .

[Thorian]

well since I got dumped from my horse I have been working on sleeping and healing. The suck part is that since I cant drive all I can do is hobble around the house because waking on the uneven grass outside hurts to damn bad. So I have been working on super mario world. Gotta love the Wii virtual console. I also got platnum on all the games in wii play.

[techknow]

Migrating company website to .net 2

Oh yeah, and learning .net 2 ...