VB.NET Programmers

[GeorgeS]

I am using the 05 version since there are still non-depreciated commands. Over the next few weeks I'll dip deeper in the syntax, although in all honesty, I'm leaning towards C++

Does anyone have the mysql connection syntax (i.e an example)?


GeorgeS

[Andrew80k]

Originally Posted by GeorgeS

I am using the 05 version since there are still non-depreciated commands. Over the next few weeks I'll dip deeper in the syntax, although in all honesty, I'm leaning towards C++

Does anyone have the mysql connection syntax (i.e an example)?


GeorgeS

Try here, George.

http://tangentsoft.net/mysql++/doc/html/refman
and
http://tangentsoft.net/mysql++/doc/h...man/index.html

might at least get you started...

[LordRathgil]

Actually, I think c#.net would be a better choice for database apps, I have had great success with it in the past and it is far far easier to work with as well.

[sesmar]

I would recommend C# as well.

As for an example of how to use the MySql.Net Connector:

I have one posted here using C#, if you would like something in VB.net I can convert it over; however, since they are both .Net the object structure and design is all the same only the syntax changes.

[nosfentora]

Hey GeorgeS,

Once you have MySQL Connector.Net 5.1.6 installed,
add a reference to it (MySQL.Data)

Imports MySql.Data.MySqlClient
Public Class MyClass

    Private mydb As New MySqlConnection()
    Private con_str As String = ""
    Private reader As MySqlDataReader

    Public Sub New()
        con_str = "server=SERVER_IP;Port=3306;user id=root;password=PASSWORD_HERE;database=DATABASE_NAME;persist security info=True"
        mydb.ConnectionString = con_str

        mydb.Open()

        Dim sql_cmd as String = "SELECT * FROM variables"
        Dim cmd As New MySqlCommand(sql_cmd, mydb)

        reader = cmd.ExecuteReader
        While reader.Read
            For i As Integer = 0 To reader.FieldCount - 1
                debug.WriteLine(reader.Item(i).ToString)
            Next
        End While
        reader.Close()
        reader = Nothing
        mydb.Close()
        mydb.Dispose()

    End Sub
End Class

[nosfentora]

I have a transactional database interface class that i wrote, that if you're comfortable with array lists, then it'll probably be a big help.

[Kayot]

I'm really happy that theres posting going on in my little corner of the Forum, but since it's in regard to GeargeS's tools; could all posts for GeargeS please be placed in GeargeS's section. I'm sure that would make his day.

Also, C#, J#, and VB.net are all the same engine. Anything done in one can be done in the others so long as there is a library for that particular syntax. Other wise the programmer would need to make a wrapper class which is a pain and why I only have three 3D engines available.

As for C++, enjoy Windows API and long compile times. I use VB.net because it's easy for me to read (Though I wish I could use C#/C++ comment methods, /* */ is cool for block comment.) and all the .net compile at a sickinly fast pace.