VB.NET Programmers

[GeorgeS]

Just tried the 08 version and the syntax to write and read text files is entirely different, and very hard. Is this something that's different in 08 over the 05 version? Can't believe it's that different. Might as well start learning VC++

GeorgeS

[EvoZak]

Originally Posted by GeorgeS

Just tried the 08 version and the syntax to write and read text files is entirely different, and very hard. Is this something that's different in 08 over the 05 version? Can't believe it's that different. Might as well start learning VC++

GeorgeS

George, congratulations on picking up .Net!

Coming from VB you'll have a bit of a learning curve, but once you're past that you'll be good. MSFT has plenty of stuff out there to get you up to speed coming from VB.

As a side note, if you really don't want to leave VB6, isn't MSFT continuing support for the foreseeable future?

Good luck either way!

[sesmar]

Originally Posted by GeorgeS

Just tried the 08 version and the syntax to write and read text files is entirely different, and very hard. Is this something that's different in 08 over the 05 version? Can't believe it's that different. Might as well start learning VC++

GeorgeS

Reading and writing files is not that hard and is done the same way in 08 as 05.

Writing to a simple text file is as easy as:

Dim oWriter As StreamWriter 

oWriter = File.AppendText(Filename)
oWriter.WriteLine(Message)

oWriter.Close()

You will need to add:

Imports System.IO

to you the top of your file if it is not already there as well.

As for accessing MySql you will need to download the MySql.Net connector from http://www.mysql.com

This connector functions exactly like any ADO.Net connector so any tutorial on ADO.Net will give you how it works, you just need to change the varaible types to the appropriate MySql connector types such as:

MySqlDataReader
MySqlDataAdapter

as opposed to:

SqlDataReader
SqlDataAdapter

DataTables and DataSets are all the same whether you use MySql or any other DB.

[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