Search:

OK, this is pretty much done and here is how.

I have two solutions because it's easier to keep them separate. I had one solution with 4 projects and I somehow managed to mess up code I hadn't...

@AxControls2 or @FunkyDexter, if you guys are still listening...
I now have 3 projects in my Visual Studio solution - the original CMS App application and the original CMS App Setup application...

@Axcontrols2 - I do believe I want to implement your method. I need some holes filled in.

1. How does launcher.exe initially get installed on every user's computer.
2. What does launcher.exe...

Thanks, Zvoni. Not sure I need any help after all. I am going to test with more data today and will mark as solved when I know I am all set.

I believe my answer is this:

select
P.order_no,

-- We want C.item_desc when its class_id = 4 but C.item_id when it's not otherwise
c.item_id,
CASE
WHEN C.class_id4 = 'EQ'
THEN...

Hi, I am looking for help with a query I need to write.

I have created a temp table with some sample data. There is a parent/child relationship which I need to use to group rows into sets.
(I...

@Axcontrols2 - I like this. I am asking my boss to get her blessing. Thanks.

Thanks, @FD, I believe I took care of that since posting when I was testing:


string currentVersion;
using (dms1DataSetTableAdapters.QueriesTableAdapter qry = new...

Good morning. No one made a direct comment to post #13 whether they agree or disagree. Especially, Olaf who I thought would have something to say about it as I believe his point in post #7 changes...

Also, peeps - I was curious about Rental so I queried the Trips table and there are only 6 records of type Rental in the 781k. That trip type has been marked soft deleted with a boolean...

I took so long composing that post, I cross-posted with Zvoni. My apologies.

Wait, Olaf Schmidt's right!



Right?
Our Trips table has 781,000 records which is a pretty good test set.
I llike to start small and build things up. So I took the original query and built it...

That was my issue. I also was getting a superfluous feeling. The background on this is the application was originally coded in VB6 with the queries in sql. I converted the app to C# but still used...

No one is running it from a USB stick. The application is internal to our company and only used by employees on their laptops.

@Zvoni - very cool. Thanks. :cool:

Hello. I am having difficulty trying to read this query to myself regarding what rows it's actually going to select/reject.

We have a Trips table where a trip can be a certain status and a trip...

We considered it and decided not to use it for this particular program.
The feedback I received from the engineer here who sometimes wears a developers hat, is that the code I wrote is fine so I'm...

Yeah, I considered it. I guess I will consider it some more. Thanks.

I wrote a WinFomrs application that my users install using setup.exe and an msi file.
When the user starts the application I want it to recogize when there's a newer version so the user can update....

@Delaney - thank you for the info! Renting a car looks like the best idea as there will be 3 of us and r/t train fare for 3 can be costly. And thanks for the tip on the navigation system inside the...

Hi. You guys are the only international forum I belong to.
I live in the US. I am going to Germany and staying in Berlin. I want to take a side trip to Störtebeker Festspiele. It's 3 hours...

No problem. It's resolved as in post #2.
Thanks.

How do I know what path-to-file is? The user has control over the destination folder when he installs.

I am all set. Here is my code.

private void GetCMSAppVersionCurrentlyInstalled()
{
RegistryKey baseRegistryKey = Registry.LocalMachine;

string subKey...

Good morning. I have a C# application in which I would like to get this same information that is displayed in Windows Settings Add/Remove program. Both these applications are my own, which I...

I have a pretty good solution to this. I will explain more later, just didn't want anyone posting back when I think I'm good. What I did is released and is being tested so we shall see how well it...

Might be the wrong forum but my app is coded in C# so I'll start here. The app is a click-once deployment windows program that is internal to employees at our company; however, we have technicians...

Yaassss! Avoid DISTINCT at all costs! (But never say "never"!)

Well, I will probably run it "regularly" like once a week and then as I see no new rows being returned, indicating the bug is fixed, maybe just once a month so I think I will pass on the view but...

@zvoni - looks like you've helped me in the past; I tried to add to your reputation but I have to "spread it around" first!
@szlamany - you've helped me tons in the past but I was able to add to...

Thanks to you both! I tweaked and/or slightly modified both queries so I could run them and it's nice that I am getting the same results from each!


Select *
From Jobs
Where...

I can't state this problem succinctly enough to put it into an search engine and find a solution so I am posting here because you guys let me ramble on :D
We have a table called Jobs and a table...

Yes, I understand. Obviously when you are double-clicking a row it's really a cell that the cursor is in!
All set, thank you!

Hi. Five years ago I ported our company's customer service application from VB6 to .NET. It turns out I missed a routine so when users were double-clicking a row in a grid, the new .NET code...

To anyone who is interested in the outcome of this problem, Dell took a look at it and discovered there was water damage. I do not remember ever spilling water on my PC but I will certainly remember...

Yes, thank you tg. It took a couple tries (but it's 6:49 pm so I have the liberty of screwing up all I want) but I finally got it. What I had said at 1:58 PM wasn't the whole story. I put the file...

I am going to try this: imageNorcomBlue = Image.FromFile(@"Resources\NorcomBlue.bmp"); I just have to make sure no one updates the application while I'm testing it deployed. Will keep you posted. ...

Hi. I have a click-once WinForms application that I've been deploying for years. Recently I enhanced my code to get a custom color out of a bmp file. That is, I have several labels on a form that...

I did not know about the warranty until my supervisor said so. I would have kept going troubleshooting because that's how I am, but he said stop because they would get me a temporary loaner and get...

My laptop is under warranty with Dell so they are going to take a look at it. If I determine what they did, I will post that back as a solution. The support I've gotten from my in-house people...