Visual Basic

HurricaneDan29-Jun-07 5:00

29-Jun-07 5:00

Dave,

The reason behind I was building another table is that I did not know any better.

I have gone in and cleaned up the code to look like this:

<br />
'Disease List<br />
        Dim strSQLDiseaseList As String = "Select DieaseName, DiseaseCode, SurveillaneFormFlag, 24HrReportFlag, CausativeOrganismFlag, SerotypeFlag, SiteOfInfectionFlag From Disease"<br />
        Dim daDisease As New OleDbDataAdapter(strSQLDiseaseList, connectionString)<br />
        Dim dtDisease As New DataTable("Disease")<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 />

But I am getting the following error when I build the project:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

It occurs on the line: daDisease.Fill(dtDisease)

Also, let me see if I understand this. If I create a data adapter and a data table, I do not need a data set...if I fill the data table with data obtained throught he data adapter. Is that right? I was under the impression that I would have to have a data set to fill the data table, almost as a go between for the data adapter and the data table.

Thanks for the help so far,

Dan

Dave Kreskowiak29-Jun-07 7:24

29-Jun-07 7:24

HurricaneDan wrote:
Also, let me see if I understand this. If I create a data adapter and a data table, I do not need a data set...if I fill the data table with data obtained throught he data adapter. Is that right? I was under the impression that I would have to have a data set to fill the data table, almost as a go between for the data adapter and the data table.

A DataSet is a collection of one or more DataTables and any DataRelation objects. If you're just filling a single table, then a DataTable is all you need.

HurricaneDan wrote:
But I am getting the following error when I build the project:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

It occurs on the line: daDisease.Fill(dtDisease)

What does the Message, or InnerException property of this exception say? It looks like it's complaining about some problem with the SQL statement.

A guide to posting questions on CodeProject[^]

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

HurricaneDan29-Jun-07 7:32

29-Jun-07 7:32

In fact it was the SQL statement. I was just coming to update my post. I had misspelled two words in the SQL statement.

I am running into a syntax error when I am running the SQL statement with this column, 24HRReportFlag. I have changed it in my SQL statement to [24HRReportFlag]. I guess it did not like the number at the beginning of the column name.

Dave, you have been a great help so far and I am grateful. What about the fact that I have to populate the 7 combo boxes? Do you have a better recommendation or would you also put them all into a single sub or function?

Thanks again,

Dan

Dave Kreskowiak29-Jun-07 7:45

29-Jun-07 7:45

Yep, it's a bad idea to have column names start with a non-letter character.

HurricaneDan wrote:
Dave, you have been a great help so far and I am grateful. What about the fact that I have to populate the 7 combo boxes? Do you have a better recommendation or would you also put them all into a single sub or function?

If it were me writing this, I'd have a seperate sub to fill each combobox, fetching only the columns of data that each needs. If you need to refresh all the ComboBox's, you can create another sub that calls all of the ComboBox refresh subs.

A guide to posting questions on CodeProject[^]

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

HurricaneDan29-Jun-07 9:04

29-Jun-07 9:04

Dave,

I went ahead and changed my database table to have the column name TwentyFourHourReportFlag so as to not have to use a work around.

I appreciate your time today,

Dan

kubben29-Jun-07 8:01

kubben

29-Jun-07 8:01

I have written some subs where you pass in the dropdown, the dataset, the table name and the columns. Then you can re-use the sub for loading any dropdown.

Ben

HurricaneDan29-Jun-07 8:26

how can I deploy a vb.net application that is connecting to database?

29-Jun-07 8:26

Thanks for that idea and including what is needed to be passed.

Dan

akramicoooo29-Jun-07 3:50

akramicoooo

29-Jun-07 3:50

I need to build a desktop vb.net application that requires database connectivity. I used to write applications that connects to sql servers installed on separate machines. In this application i need to make the whole application mobile (the application and the database).. How can I do that?
Can the database be included in a setup file with the application its self?

Akram..

Re: how can I deploy a vb.net application that is connecting to database?

kubben29-Jun-07 3:53

kubben

29-Jun-07 3:53

You might want to look at using sql express. It is a local sql server engine that is free. You could add it to your install and everything would be local.

Hope that helps.
Ben

Re: how can I deploy a vb.net application that is connecting to database?

Dave Kreskowiak29-Jun-07 4:40

Save file from PDA to remote computer

29-Jun-07 4:40

You can use either SQL Express or Access as the database. You do NOT need Access installed to use the database. Just the MDAC components need to be installed.

A guide to posting questions on CodeProject[^]

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

k.giannis_198029-Jun-07 3:05

k.giannis_1980

29-Jun-07 3:05

Hallo
I am dealing with a problem in my project. I am using Visual Basic 2005. I am able to create a .txt file in my PDA but i don't know how to save it to a network drive. The idea is to press a SAVE button in the form (PDA) and the file to be saved in a network drive (e.g. c:\output.txt). I know how to do it only from a network computer to another, using a mapped network drive. Is there something like <<dim out="" as="" streamwriter="New" streamwriter("\\192.168.0.10\c\output.txt")="">> or <<\\computer_name\c\output.txt>> ????

Any given code sample or link to the necessary reading ( e.g socket? ) would be much appreciated!

Thank you in advance for your time

Re: Save file from PDA to remote computer

Dave Kreskowiak29-Jun-07 4:38

Re: Save file from PDA to remote computer

29-Jun-07 4:38

k.giannis_1980 wrote:
Is there something like <<dim out="" as="" streamwriter="New" streamwriter("\\192.168.0.10\c\output.txt")="">> or <<\\computer_name\c\output.txt>> ????

Yes. What you described are the UNC paths to the server, share name, and file system path to a file. Saving the file is no different than if the path was C:\something. The code is exactly the same, just a different way of describing the filepath.

    \\servername\sharename\folder\folder\filename
or
    \\ipAddress\sharename\folder\folder\filename

A guide to posting questions on CodeProject[^]

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

k.giannis_198029-Jun-07 5:51

k.giannis_1980

29-Jun-07 5:51

Thank you so much!
It worked perfectly.
Thank you again for your fast reply Smile | :)

DateTime.Parse fails at VB2005

TotalTops197229-Jun-07 2:55

TotalTops1972

29-Jun-07 2:55

I have an application that has worked happily for many years under VB2003.
Today I upgraded it to VB2005 with no upgrade issues or changes.

The following line now fails

dim datestr as string = "7thNovember1993"
dim datedate as date

datedate = System.DateTime.Parse(datestr)

VB2005 throws
The string was not recognized as a valid DateTime. There is a unknown word starting at index 1.

TOPSie

Dave Kreskowiak29-Jun-07 4:36

Re: DateTime.Parse fails at VB2005 [modified]

29-Jun-07 4:36

You now have to use DateTime.ParseExact[^] and supply the format string that describes the format in which it should expect the date. Read the link I supplied, near the bottom, for an in-depth description of how ParseExact works and creating custom format strings to tell the parser what to expect.

A guide to posting questions on CodeProject[^]

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

TotalTops197229-Jun-07 5:40

TotalTops1972

29-Jun-07 5:40

Thanks for this - what a giant leap - backwards.
If I understand this then 7 November 1993 has a format string of "d MMMM YYYY"

But all my dates (and the data has LOTS of them) are in the format
7th November 1993. I can find nothing in your link that shows me a format to cope with "th" (or "st" or "rd"). I presume I am going to have to strip these out of the input string myself - being careful with AuguST etc.

As I said a great leap forward - one line of code turns in to 10 or more!!!

STOP PRESS

The original error was in DateTime.Parse coping with "7th November 1993"
Following your link I tried ParseExact with a format string of "d MMMM YYYY"
after stripping the "th" out. But ParseExact returned an error.
However going back to just Parse with no "th" in the date string now seems to work.
Thanks again

TOPSie

-- modified at 13:25 Friday 29th June, 2007

TOPSie

Dave Kreskowiak29-Jun-07 7:33

29-Jun-07 7:33

TotalTops1972 wrote:
Thanks for this - what a giant leap - backwards.

Not really. This method is more flexible than what it used to be.

TotalTops1972 wrote:
But all my dates (and the data has LOTS of them) are in the format
7th November 1993.

This is a really bad format. Sure it's human readable, but it makes it a PITA to use in automated data processing. Forget searching the database between date ranges. This is a string of characters that looks like a date. It's not actually a date value.

A guide to posting questions on CodeProject[^]

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

TotalTops197229-Jun-07 7:43

TotalTops1972

29-Jun-07 7:43

I appreciate your reply, it is a human format. This is raw data which originates from written documents, once upon a time they were handed copied, then scanned, now I get it electronically, but it from a printed document intended to be read by real people!
My program is reading this raw data and immediately converting it into a useful computer format so I can use it - but I have to take the original data in the format it is written.
Thanks to your help I have now got this initial conversion code working in at least one path - just hit another, but now I know how to fix it then it is just a slog to spot all the conversion paths..

My step backwards remark is aimed at Microsoft - backwards compatibility is something they often don't rate too highly.

Thanks again....

TOPSie

Dave Kreskowiak29-Jun-07 7:46

29-Jun-07 7:46

I'd look into using a Regular Expression to get the date string at least partially normalized so ParseExact has a better shot at it.

A guide to posting questions on CodeProject[^]

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

TwoFaced29-Jun-07 14:23

TwoFaced

29-Jun-07 14:23

I found a way to cope with 'th', 'st', 'nd' and 'rd'. It's not that pretty but if you wrap it up into a function you've got a workable solution. It would be nice if you could just ignore characters, then you could use something like "d##MMMMyyyy" where # would be a character that's ignored. However, I couldn't find anything in the documentation that would lead me to believe that's possible. Anyway here you go.

' Valid date formats
Dim validFormats As String() = {"d'st'MMMMyyyy", "d'nd'MMMMyyyy", "d'rd'MMMMyyyy", "d'th'MMMMyyyy"}
Dim myDate As Date = Date.ParseExact("1stDecember1993", validFormats, Globalization.CultureInfo.CurrentCulture, Globalization.DateTimeStyles.None)

Your original post showed no spaces for the date...it was 7thNovember1993. If that's not the case just add appropriate spaces into the formatting strings and it should work.

Custom Attribute

Navneet Hegde29-Jun-07 2:55

Navneet Hegde

29-Jun-07 2:55

Hi All,
I have made my custom textbox with different Properties,
I have in that Readonly Backcolor , Onfocus Backcoolor and so on. Also ReadOnly Forecolor, Onfocus Backcoolor and so on all such different Properties.
Now I want
BackColor--->
------------>OnFocus
------------>ReadOnly
------------>Normal
------------>Disabled

Now i want this to be under + sign , same as we have Font and with it we have
Font--->
------------>Bold
------------>Size
------------>Italics
------------>Family

How can I achieve this ??please help

Regards & Wishes
Navneet Hegde
Nashik(City Of Pilgrimage)

Develop2Program & Program2Develop

Re: Custom Attribute

Dave Kreskowiak29-Jun-07 4:31

How to Read the Content from MS Word and Excel File

29-Jun-07 4:31

How to make custom property editors, here[^].

A guide to posting questions on CodeProject[^]

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

Thirukumar29-Jun-07 2:50

Thirukumar

29-Jun-07 2:50

Hi,
I am using VS2005.I want to Read the Content from MS Word and MS Excel with out the help of
Word Object Library or Excel Object Library and Display to the Windows form in VB.Net.
Help me to Read the Content..

Thirukumar.

Re: How to Read the Content from MS Word and Excel File

Dave Kreskowiak29-Jun-07 4:09