Visual Basic

originSH2-Jul-07 22:42

originSH

2-Jul-07 22:42

Urgent pay attention ...

no

Paul Conrad23-Dec-07 14:56

Paul Conrad

23-Dec-07 14:56

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Colin Angus Mackay2-Jul-07 23:37

Colin Angus Mackay

2-Jul-07 23:37

goodonebond wrote:
Urgent

If you want help urgently then you should pay for a support call. If you want it free you will have to wait until someone who can answer your question has the time to help you out.

goodonebond wrote:
pay attention

You sound like a school teacher chastising a student who is day dreaming at the back of the class. That will just irritate people and they won't be inclinded to help you.

To put it simply - That subject line was just plain rude.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

Ready to Give up - Your help will be much appreciated.

My website

Corrupt VB.NET Installation??

Paul Conrad23-Dec-07 14:57

Paul Conrad

23-Dec-07 14:57

Urgent is consider rude.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

RickMagenta2-Jul-07 8:18

RickMagenta

2-Jul-07 8:18

Hello

I have created an application in VB.NET using VS2005. I wanted to do a custom installation for it (not use ClickOnce), so I looked on the internet which showed me that I need to Add a New Project, and seclect the "Setup and Deployment" on the left and choose the correct template.

However I do not have this. Whenever I choose New Project, all, I get is the following:
* Windows Application
* Class Library
* Console Application
* My Movie Collection
* Screen Saver Startewr Kit
* Search Online Templates (which does nothing!!)

I have installed everything that came on my CD, VB, C#, C++, Java, Web, SQL. Why can I not see the same New Project dialog box as everyone else!

It's hard tp exlain without showing screenshots - but I don't know how to do this on this messagebox. Sorry.
I have looked in the Settings and cannot find any settings to turn this on or off.

Any suggestions?

Thanks

Dave Kreskowiak2-Jul-07 8:21

2-Jul-07 8:21

Is this the Express edition? If so, it doesn't come with the Setup projects, nor does it support them. Express only supports ClickOnce deployment.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

RickMagenta2-Jul-07 12:03

RickMagenta

2-Jul-07 12:03

Yes it is the Express Edition. I believe it came free with a magazine!!

Assuming that it is not possible to download the template / project that is require to do the custom installations, what version of Visual Studio do I actually need?

Thanks for your prompt reply.

Dave Kreskowiak2-Jul-07 12:45

2-Jul-07 12:45

Any edition except Express. You can download the project templates all you want. They still won't work because the designer support to use them isn't in the Express editions.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Passing a DataTable to a Sub

RickMagenta3-Jul-07 7:52

RickMagenta

3-Jul-07 7:52

OK.
In that case I will browse the inerent to find the best deal for VB.NET 2005 (or maybe even try Microsofts new version).

Thankyou for your time in resolving this matter for me.

HurricaneDan2-Jul-07 7:45

2-Jul-07 7:45

I have a Public Sub that returns values from an Access database and populates a combo box. I have another sub that is called when the selected value of the combo box changes. I want the second sub to be able to access the data table that was retrieved earlier and check for a flag that may or may not be set. Can a data table be passed? Or is this not the proper method to do this?

Thanks,

Dan

Dave Kreskowiak2-Jul-07 8:22

2-Jul-07 8:22

Yes, you can pass a DataTable, but unless you're processing the data in the entire table, you should only be passing the row in question.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

HurricaneDan2-Jul-07 8:49

2-Jul-07 8:49

How about this, what I have done is passed to the other the .text value of my combo box. So my function call looks like this:

<br />
TwentyFourHourReport(cboDiseaseName.Text)<br />

And inside of my sub I have created a new SQL statement that looks for the particular row in the data base that corresponds with the above .text value and return two columns, one for the DiseaseName and the other for TwentyFourHourFlag.

Thanks again Dave

Dave Kreskowiak2-Jul-07 9:23

2-Jul-07 9:23

A combo has both value and display members. Usually, if you're going to pick something from a combo that's been populated by records from a table, you pass the value (normally the record ID) to a function that will return that record from the database.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

HurricaneDan2-Jul-07 10:08

2-Jul-07 10:08

Dave,

While in a meeting I had some time to think about this. What I am trying to do is this, I have a Sub that populates the combo box on a form -

<br />
Public Sub DiseaseList(ByVal connectionString As String)<br />
        'Disease List<br />
        Dim strSQLDiseaseList As String = "Select DiseaseName, DiseaseCode, SurveillanceFormFlag, TwentyFourHRReportFlag, CausativeOrganismFlag, SerotypeFlag, SiteOfInfectionFlag From Disease"<br />
        Dim daDisease As New OleDbDataAdapter(strSQLDiseaseList, connectionString)<br />
        Dim dtDisease As New DataTable("Disease")<br />
<br />
        Try<br />
            daDisease.Fill(dtDisease)<br />
        Catch ex As Exception<br />
            MessageBox.Show(ex.Message)<br />
        End Try<br />
<br />
        'daDisease.Fill(dtDisease)<br />
<br />
        With cboDiseaseName<br />
            .DropDownStyle = ComboBoxStyle.DropDownList<br />
            .DataSource = dtDisease<br />
            .DisplayMember = "DiseaseName"<br />
            .ValueMember = "DiseaseCode"<br />
            .SelectedIndex = cboDiseaseName.FindStringExact("")<br />
        End With<br />
        'End Disease List<br />
    End Sub<br />

Then I have an event for SelectedValueChanged -

<br />
Private Sub cboDiseaseName_SelectedValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboDiseaseName.SelectedValueChanged<br />
        Dim strDiseaseName As String<br />
<br />
        TwentyFourHourReport(cboDiseaseName.Text, StrConnectionToDatabase())<br />
    End Sub<br />

I will eventually have 4 function calls in the above Sub to test for flags set in the database.

In the function (which I am still in the middle of writing) will test to see if the flag is set, if it is then it will display a label informing the user of a 24 hour reporting criteria.

Having read your most recent reply I was thinking that I could actually query the DataTable that I filled with the first Sub to find out if the TwentyFourHRReportFlag is set. This way I am not making another call to the database when I should have the data in a DataTable already.

Also, if I place a message box in the cboDiseaseName_SelectedValueChanged Sub I will get that message box to pop up about 4 times before the form actually loads. I think it is due to database calls for the other combo boxes but I am not sure. Is there a better way than SelectedValueChanged to be the event to check for changed criteria?

Thanks,

Dan

Dave Kreskowiak2-Jul-07 10:13

2-Jul-07 10:13

HurricaneDan wrote:
This way I am not making another call to the database when I should have the data in a DataTable already

Great! Why make another round trip if you already have the data. All you have to do if Filter the datatable by the DiseaseCode and you should get a single row returned.

HurricaneDan wrote:
Also, if I place a message box in the cboDiseaseName_SelectedValueChanged Sub I will get that message box to pop up about 4 times before the form actually loads.

SelectedValue will get fired once after the combo is bound to the data. If you have a MsgBox in each combobox's SelectedValueChanged event, this is why you're getting 4 Message Boxs.

No, there is no "better method" of doing this.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

HurricaneDan2-Jul-07 14:41

2-Jul-07 14:41

Right now I only have the MsgBox in the one Sub but it calls it multiple times. I have something I will try when I get into work tomorrow and see if this works.

I have also been reading some various posts on CP and I have noticed that you are one of the most active posters. I have also seen some of your posts to people in answer to some crazy questions. Your patience is pretty good. Did you ever find out what the hell >.< means? It looks like a set of mouse whiskers.

Thanks again,

Dan

Dave Kreskowiak3-Jul-07 2:01

Get serial number of monitor

3-Jul-07 2:01

HurricaneDan wrote:
have also been reading some various posts on CP and I have noticed that you are one of the most active posters. I have also seen some of your posts to people in answer to some crazy questions. Your patience is pretty good.

After doing this for 4 years, you can really tell the difference between the newbies who want their hjomework done for them and the people who actually have a question! Big Grin | :-D

HurricaneDan wrote:
Did you ever find out what the hell >.< means?

Nope.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

ctlqt122-Jul-07 7:08

ctlqt12

2-Jul-07 7:08

Hi all,

How to get serial number of monitor?
I think that's difficult, because in our system environment variables, serial number of monitor is not record.

If you have any ideas, please tell me.

Thank you

Re: Get serial number of monitor

Dave Kreskowiak2-Jul-07 8:32