Comments by Gordon Kushner

Gordon Kushner 18-Apr-12 9:41am View

Add the DISTINCT keyword.

SELECT DISTINCT S.SchoolName,S.City,S.Suburb,S.Description, SPC.SchoolCourseName

Gordon Kushner 7-Nov-10 17:41pm View

Geez. I'm not doing anything to raise my reputation. What a rude assumption. No need to be snarky. If you are an admin, then just delete my comment. Otherwise, shove off.

Gordon Kushner 6-Oct-10 4:46am View

You could make the application an MDI (multiple document) so that the container form has the menu and you actually load and unload child forms. If you make the child forms maximized, they appear to be part of the main form. Just a thought.

Gordon Kushner 1-Sep-10 9:01am View

I'm sorry but I haven't had any experience working with Linq so I don't know if it will work for you. However, I've updated my reply with some code for the Stored Procedure. Hope it helps.

Gordon Kushner 6-Jul-10 15:52pm View

I posted a code sample. But I noticed how you want to actual sort to work. I'm at the office and have already used up a couple hours of their time. If this were up to me, I'd move the sorting/grouping logic up to the application level and do recursion there. (It's much easier to me in .NET)

Gordon

Gordon Kushner 26-Jun-10 10:59am View

If you do start another thread, drop me a line at my site's contact page. http://www.realworldtechnology.com.

Thanks for the rating! Be well.

Gordon Kushner 25-Jun-10 11:12am View

I'm very glad to help. Been there, needed that. :). Using a class would not bloat you code, but it wouldn't really add much at this point. If you take that approach, You might encapulate the array and the host name and put that into a .NET collection class like a List. see http://visualbasic.about.com/od/usingvbnet/a/genericlist.htm

Class HostVars
Private hostName As String
Private hostValues As List(Of Boolean)

... (lots of clever code to do the same thing you're already doing)

End Class

One small thing, move everything except the loop into the Form_Load event. You only need to execute that once, not every time the combo box changes.

Gordon Kushner 24-Jun-10 20:09pm View

Don't give up man! You're nearly there. You're right that the control can be cast as a checkbox (since it is one).

Look into CType(control, CheckBox).Checked. I think that'll do it. I'm a little rusty in VB and the parameters may be switched.

Wow Assembly? Yeah, it's changed a bit, but under the hood, it's all basically the same thing. Except for the cool colorful IDE's

Gordon Kushner 23-Jun-10 8:08am View

OK, how about when the combo box value changes, you set a module level variable that corresponds to the index of the 2-d array you set up?

(On combobox_change)
hostIndex = ComboBox1.SelectedIndex

Then you could change this line:
CBool(HostArray(control.Tag))
to this:
CBool(arrAccounts(hostIndex, control.Tag))

Comments by Gordon Kushner (Top 9 by date)