VB/MySQL.com

Nice articles, thanks! really helped me!

Testing out a new app… got program working just how i want it… only problem is if the end user has .net already installed they have to select either “repair” or “remove” any idea on how i could check to see if they have .net and give them the right file reguardless?

mike

I can’t connect to my database. It says that it can’t connect, which is true because it’s trying to connect to my ip instead of the one I specified.

The reference to the MySQL client library doesn’t work, because the reference is an absolute path (and you can’t make it relative).

Nevermind. It happened to be some images that I was loading in at runtime.

Thank you for this tutorial, it was a great series. The only thing I don’t see in this is the installation of mysql and then creating the database with tables and any data that might be in the database. Is there another tutorial here at vbmysql.com that explains how to do that. I think I can figure out how to install mysql with the InnoSetup script but the creating the database and the tables is a little to much for me at this point in my education. Any help in this would be appreciated.

Thanks
Jamie

About the creating the database: you have to make another program that creates the databases and tables and run it before the installation ends. That’s how i am doing with the updates of the programs, but should work just fine and with the creation, or manual create them.

Is there a tutorial on how to go about doing that? Are you talking about a vb.net program to do that? And do I have to run the mysql 5.0 installation first?

Thanks for the help.
Jamie

Good tutorial, thnks a lot!!!!

For Jamie Holcom: i don’t know if there is a tutorial about how to do that, but it can be done, and yes, with a vb.net program or directly in your program – i have done one that . here’s some code
Dim conn1 = New MySqlConnection()
conn1.ConnectionString = “server=localhost;” & _
“user id=root;” & _
“password=” & ********
‘”;
‘Try
Dim myCommand As New MySqlCommand
Dim mySQLstr As String
Dim nume As String
Dim dialog As New OpenFileDialog
If dialog.ShowDialog = System.Windows.Forms.DialogResult.OK Then

nume = dialog.FileName.ToString
Dim fileContents As String
fileContents = My.Computer.FileSystem.ReadAllText(nume)
Try
mySQLstr = fileContents
conn1.Open()
myCommand.Connection = conn1
myCommand.CommandText = mySQLstr
myCommand.ExecuteNonQuery()
conn1.Close()
MsgBox(“Baza de date a fost creata!”)
Catch myerror As MySqlException
MsgBox(“Eroare: ” & myerror.Message)
Finally
If conn1.State ConnectionState.Closed Then conn1.Close()
End Try
End If

it will open a dialog to chose the sql file containing the structure
of course it can be automated.
ATTENTION: Do not specify the database in the connection string.

I am working at an installation that installs everything – without user interaction – like instantrails (google it), it’s not such a big deal but helps deploying applications made with mysql.

great tutorial.. really help me for my projekt.. i’m working with vb.net since 2weeks and i had really problems with mysql.. thx for this

I haven’t had a complete chance to read all the way through, but it seems very complete. My question is how different is it to connect to a MySQL on an external web server? I would like to build an application which needs a db, and there are constant updates. I would like to just update the db, and have the users always have the most up to date info without needing to download. So my plan is to create a VB.net 2k5 app with a MySQL on my website. Hopefully I am not dreaming.

itsamemario – to use mysql remotely for updates you will need to use the root account. What you want to do it can be done good luck!

Thanks for the tutorial, however, one major problem is when developing the application, a certain password is used with the root account, and that is what is available in the code. So how can mysql be installed together with the custom password to the root account?

if my aplication does have crystal reports and needs dlls that are in the common files. when developing in others pcs dont work do yo know what i must do ?

Hello all . . .

I need some help . . .

I have create a database in MySQL and I’m using the VB.NET 2005 to manage my data

When i try to input or update some records in the database tables instead of Greek characters that I’m writing I’m getting back question marks (?)

I have change the table and the column character sets and still the problem is there ? ? ?

What can i do for that ? ? ?

Thanks a lot . . .

Awesome articles, thank you for being so comprehensive in your writing.

This has been the most thorough tutorial I have ever come across.
You have provided everything that I needed to get me started, and this last article has helped to close the loop.

Thank you very much!

Mike

great tutorial! thanks! hope there will be more!

Thank you very much, thank you, thank you, thank you for putting time and effort in this brilliant hands on real world tutorial.
I will go develop some applications now

Hello, Mike

This is just to add my congratulation for this great tutorial.
Despite I have purchased many books only now I can understand how VS + MySQL work together.

I don´t know how many thanks should be wrote on the end of this message. There is no space enough here.

hello!!!! thank you very much for a very wonderful tutorial.. I will recommend this to all my friends who are interested in learning VB.Net and MySQL.

Question about structure and joins:

I am attempting to create a database for storing data logger files. The files contain extremely redundant information in most of the fields I am parsing out of .csv lines; TAGNAME, DATE, TIME, Milliseconds, and PV (the actual process data).

I created 7 tables to handle the relational aspects: (all ID fields are medium int, 8 digits, auto incremented in the primary tables, not in the join tables

Primary Table 1 : TAG, containing fields TagName and TagID, TagID is the primary key, auto incremented and indexed…

Join Table : Tag_Date, containing fields TagID and DateID, TagID and DateID are both primary keys, not auto incremented, but indexed…

Primary Table 2 : DATE, containing fields DateStamp and DateID, DateID is the primary key, auto incremented and indexed…

Join Table : Date_Time containing fields DateID and TimeID, DateID and TimeID are both primary keys, not auto incremented, but indexed…

Primary Table 3 : TIME containing fields TimeStamp and TimeID, TimeID is the primary key, auto incremented and indexed…

Join Table : Time_Event containing fields TimeID and EventID, TimeID and EventID are both primary keys, not auto incremented, but indexed…

Primary Table 4 : EVENT containing fields Ms (milliseconds), PV, and EventID, EventID is the primary key, auto incremented and indexed, Ms and PV are both indexed…

The TagName, DateStamp, and TimeStamp data repeat many thousand rows, which is why I am attempting to reduce the total size of the data sets (the raw .csv can have upwards of 2.6 million rows)

I wrote a routine that basically:

1: See if TagName already exists in TAG; if yes, get TagID, if no, write record, retrieve record, get TagID (auto increment)
2: See if DateStamp already exists in DATE; if yes, get DateID, if no, write record, retrieve record, get DateID (auto increment)
3: See if TimeStamp already exists in TIME; if yes, get TimeID, if no, write record, retrieve record, get TimeID (auto increment)
4: See if Ms and PV already exists in Event; if yes, get EventID, if no, write record, retrieve record, get EventID (auto increment)
5: See if values stored for TagID and DateID already exist in join table Tag_Date, if yes, move on, if no, write values stored for TagID and DateID
6: See if values stored for DateID and TimeID already exist in join table Date_Time, if yes, move on, if no, write values stored for DateID and TimeID
7: See if values stored for TimeID and EventID already exist in join table Date_Time, if yes, move on, if no, write values stored for TimeID and EventID

Step 4 above is probably not necessary since very few EVENT records will contain duplicate data across fields Ms and PV, but since some actually do, I figured that I might as well eliminate those duplicates as well.

Unless I missed something, this structure should connect any valid Ms/PV to the chain of field rows pointed to by each join table, the one with the largest number of ~unique records being EVENT, using INNER joins between:

Primary Table : TAG.TagID
Join Table : [TAG_DATE.TagID--TAG_DATE.DateID]
Primary Table ATE.DateID
Join Table :[DATE_TIME.DateID--DATE_TIME.TimeID]
Primary Table :TIME.TimeID
Join Table :[TIME_EVENT.TimeID--TIME_EVENT.EventID]
Primary Table :EVENT.EventID

So, the parser successfully stores records pared down to one instance of each recored for TagName, Date, and Time, and very few duplicates in Ms/PV.

MySQL stored a test file parsed from a .csv having 450,000+ lines in just under 15 minutes, but I have been having trouble making MySQL retrieve a record set containing ~10,000 rows in less than an hour using a query that selects my TagName, DateStamp, TimeStamp, Ms, and PV from their tables using inner joins except for the EVENT table, which uses a Left Outer join (I’ve tried it with an inner join as well), where TagName = and DateStamp = ordered by TimeStamp and Ms.

I have made some fundamental errors in either my structure, indices, or query, or I have created too complex a structure for my intended purpose. (or I just don’t understand SQL well enough to tackle this sort of project)

Do you see any better way to accomplish fast queries with the data I need to extract?

Ideally, I could perform a query asking for record sets based on:

1: Date
2: Time Range
3: Tag Name

Sort the result set by TimeStamp and Milliseconds (Ms), and then quickly read these out to a charting routine. I assumed that a database engine would be the way to go since it could handle the selection and sorting, saving me from writing the routines myself in another programming langiuage.

Looks like my post stripped out some characters I included for illustration…

Hello. Is the mysql database included in the installer?

Thanks.

Недвижимость Швейцария . Продажа недвижимости в Швейцарии: участки под застройку, шале, апартаменты , аренда недвижимости в Швейцарии
инвестиции, получение вида на жительство в Швейцарии. Создание компании в кантоне Вале . swissinvest.su

thanks for this great tutorial

i would like to ask if there is a way to bundle mysql server in the installer. thanks for reading my query

Thank you, this has been the best tutorial I have ever gone through. If, after going through these tutorials, you can’t get VB and MySQL working together maybe you need to look at another career choice.
Thanks so much.

I don’t know whether the author is still reading all these comments, but I have no other choices, I couldn’t find any help from google, some I choose to ask my question here. This is a great tutorial, however, how do I detect whether the target machine already have mysql installed and if the target machine doesn’t have mysql install, how do I install it automatically? Hope that you will be able to help me on this, thank you.

i want to know how to add mysql server 4.0 with the installer package and the database script file with the installer
that will be install at the time of the installation and the script of the database is automatically install at the time of the installation

How to run an install program without copy this installer to temp, because the size of installer is 300 mb. Any help?

thanks alot for these articles.

i’ve read them all in one time, i couldn’t stop reading.

working on some programs of myself now.

Hi there!

Dude, you’re such an Ace on these things!

I rode all the VBMySQL tuto, and it’s amazing. Everything is clear now for me.

But I have a problem with a project:

How can I insert and update data from MySQL Tables from a VB2008 Interface? I have the proper connector for the current version of MySQL. I have a group of TextBoxes, and the main idea is, when the user types the information required, and click the button “Save”, the data typed in the TextBoxes, should be saved in the proper tables. I’ve done the MySQL query in Navicat and MySQL Maestro (very good DB developing tools) and it’s correct, but I can’t do the saving data thing.

Can you help me, please? If you need code, I can send it to you.

Thank you very much and congratulations for this webpage, is very usefull!

Regards from Mexico City!

A fantastic tutorial. I wish there were more.

It would be great if there was an explanation as to how to use innodb to install an instance of mysql, create a database and populate it.

I have made this tutorial and is working.
Errors:
1. when i try to add a custom message and i hit update i get the following error: Parameter ‘?UserID’ has already been defined. how to resolve that?
2. in my version in the cboMessage is have two times the message “No Message” why? how can i modify not to show “No Message”?

Please help me.
This is what i made: http://www.filefactory.com/file/b32hhcg/n/MySql.rar

Many thanks for this very excellent tutorial. I’ve got a little problem running my programm under Windows 7: It seems, that under Windows 7 the file ‘MySql.Data.dll’ in my installation-directory cannot be found during execution-time: a File-Not-Found Exception occurrs. Any helpful suggestions are very appreciated. Thanks in advance

Nice post.Thank you for taking the time to publish this information very useful!