MetaEdgeDanny
Jun 23rd, 2007, 05:54 AM
[edited]
Hi, I'm a C# newbie, but I need help with the following:
Background: I am working in a group of .NET programmers and T-SQL programmers. I would like to help out our main programmer in an upcoming task. Which we need to first generate SQL codes from a report service, split the code up into different procedures so it may be viewed individually, but also need to compress (or just combine) the file up into 1 file so the users may download them all at a time.
I understand this is a long process and won't want you guys to do it all for me. Like I said, I'm a C# newbie, I only know some VB and VBA. Here's what I got
1. The server is similiar to our computer, so the generating SQL codes from a report should be as simple as extract it from Access.
2. The generated SQL codes can be saved as .doc files, opened up with Word then thru macros, it can be split up into multiple piece as either .txt or .doc.
3. With ZipFile in .NET Framework 2.0, I can combine these file in my computer
ZipFile zip= new ZipFile("MyNewZip.zip");
zip.AddDirectory("My Pictures", true);
zip.Save();
I don't have all the codes figure out yet, but I know I can do this on my computer with little bit of research. However, I was hoping if anyone know of any sites/links that have example of doing this at the server side?
My guess is that I would have to figure these codes, then I would have to input them into .ASP/html codes by calling C#/VBScripts objects within them to do these.
Can anyone at this point tell me if I would be doing this correctly? or is there a faster route? examples or anything?
Hi, I'm a C# newbie, but I need help with the following:
Background: I am working in a group of .NET programmers and T-SQL programmers. I would like to help out our main programmer in an upcoming task. Which we need to first generate SQL codes from a report service, split the code up into different procedures so it may be viewed individually, but also need to compress (or just combine) the file up into 1 file so the users may download them all at a time.
I understand this is a long process and won't want you guys to do it all for me. Like I said, I'm a C# newbie, I only know some VB and VBA. Here's what I got
1. The server is similiar to our computer, so the generating SQL codes from a report should be as simple as extract it from Access.
2. The generated SQL codes can be saved as .doc files, opened up with Word then thru macros, it can be split up into multiple piece as either .txt or .doc.
3. With ZipFile in .NET Framework 2.0, I can combine these file in my computer
ZipFile zip= new ZipFile("MyNewZip.zip");
zip.AddDirectory("My Pictures", true);
zip.Save();
I don't have all the codes figure out yet, but I know I can do this on my computer with little bit of research. However, I was hoping if anyone know of any sites/links that have example of doing this at the server side?
My guess is that I would have to figure these codes, then I would have to input them into .ASP/html codes by calling C#/VBScripts objects within them to do these.
Can anyone at this point tell me if I would be doing this correctly? or is there a faster route? examples or anything?