I frequently use

select * from tbl where 1 = 2

when I'm trying to figure out the columns in a table.

I actually was looking for a library that I could call directly from C#; not something where I have to go to the command prompt or run an external executable. Thanks again.

One of our vendors is sending us files via FTP and they are going to use PGP. I'm writing a C# console program to download the files from the FTP site and decrypt them. They have also give me the .asc key file. I'm having real trouble decrypting the file using the asc key. Can anybody point me in the right direction? I was going to use GnuPGDotNet but can't figure out how to tell it to use the key file. TIA - Jeff.

I'm looking for a way to have context sentitive help appear on my website when the user rolls over something. Much like a tool tip but I want more control over it. Can anybody point me to some code that will do this and look reasonable? TIA - Jeff.

Wow! I feel so special! Thanks for all of your help. Jeff.

Whoops! I found the message. It's http://www.codeproject.com/Messages/3630835/Memory-Leak-using-Flash.aspx[^] So if you are going to respond to this, please do it there..... Sorry for the confusion. Jeff.

Pete, I'm still trying to solve this. I'm using C# .Net 1.1 (Don't ask!) on a Windows App. Any help would be greatly appreciated. Jeff.

I went searching for it and couldn't find it. I am not sure if I asked it here or in the Microsoft forums. J.

I had posted a question a while ago that asked how I could destroy an object in a windows program (the Flash player) and recreate it because there's a memory leak in the player. It's not huge but if you leave it around long enough it eventually will kill the system. I got a response that said to put the player in a different application domain. Could somebody explain that please? I've read up on application domains and don't see how I would be able to use it. What about putting a window in a different process and then have it display the flash. When it's done, it could close the window and kill itself. (at least I think I could do that.) Would that solve the memory leak? TIA - Jeff.

I've got a COM object that has a memory leak. This normally wouldn't be an issue except that my program is a kiosk app so it's running continuously. Using a different COM object is not an option. This is a standard visual COM object from a very large company. Rumor has it that the next version will fix the memory leak but the memory leak has been there for a long time so I'm not hopeful. So my thought is to destroy the object after a certain amount of time so that the memory will be released and to recreate it. But I can't figure out how to destroy the object other than to close the window and reopen it. Can anybody help? Thanks. Jeff.

What do you mean by AppDomain? BTW - don't know if it matters this is a Windows App. J.

I don't understand what you mean by unload it and load a new instance. Do you mean unload the whole program? There is other stuff going on on the screen. The flash player is only part of what is visible on the screen. Jeff.

I have a program that is running on a kiosk. I'm using the Shockwave dll to play flash files. It appears as if the more complex the flash file is (more action script) there's a memory leak until eventually the program crashes. This program has the flash player on the screen and loads file after file without closing down. So if it's not really releasing all of the memory, which is what it appears to be doing, how can I clear out the memory? If need be what I would do is after playing a file, I would destroy the object, cleanup the memory and then create a new one. In looking around the web, I have not yet been able to find how to destroy the object, clean up the memory and then recreate the object. Can somebody please help? Thanks. Jeff.

Can somebody point me to web pages/books on what features Visual Studio 2010 has to work with SQL Server. I've used VS (and SQL Server) for years but never really learned the things that is will do for you with SQL. (Why do I want to define a dataset through visual studio rather than in code? Things like that.) Thanks for your help. Jeff.

So what Visual Studio Add Ons do people use? I'm using Visual Studio 2010 Premium if that makes a difference. TIA - Jeff.

Everybody thanks for the responses. I don't need a list of task to be done. I need a way to track what I actually did. So when my boss comes in to my office and says 'Why isn't this done like the schedule said it would be?' I can say - I did this, and this, and this, .... I hate to admit it but I like the idea of a paper notebook. But I'll probably try and use the Office Notes (which I have). Jeff.

I'm looking for some way to track what I've actually worked on. Does anybody have any suggestions on ways to do that (I know a really simple one would be keep Word open and just write it in there but I'm wondering about a better way to do it) Ideally it should be free. TIA - Jeff.

So I'm a programmer who's been programming for 20 years. I have written Windows services numerous times and need to do it again. There are things that my service code doesn't do (like run in console mode) that I'd like it to do. So does anybody have any code that I can steal that is the basis for a Windows service? I know I can create a new project as a Windows Service through VS2010 but was wondering if anybody has a basis I can use. Also - the premise I used was in the OnStart command, start a timer that would run a routine that would poll for things to do. The routine would never end and check, based on time, if something needs to be done. Is this still an appropriate method for doing a service or is there a better way? TIA - Jeff.

I agree also. It shows a severe lack of respect on there side. Or total incompetence. At my last job, when someone got to the gate of the parking lot, the receptionist would call me to tell me the person was there and I'd walk down to the lobby. More times than not I would be there before the person was. It's just a sign of respect. Especially if they don't even bother to tell the receptionist to tell them I'm running late. If nothing more, if you have to wait so long, unless you are a much better person than I am, you will be annoyed that they kept you waiting so long and the interview may as well not happen. Interviewing is a two way street. Does the company want the person and does the person want to work for the company? Just my two cents.... J.

Turns out you can use the Adobe ActiveX as long as the Reader is installed on the machine. Does everything I need. Thanks everybody. Jeff.