Connecting to a mySQL server and filling tables with VB - simple help!

red_ice

yo! I've got my program to connect to a mysql server - woop!

heres the stuff

Dim conn As MySqlConnection
Dim sql As String
Dim da As New MySqlDataAdapter
Dim ds As DataSet

conn = New MySqlConnection()
conn.Open()

sql = "SELECT * FROM tblEvents"
da = New MySqlDataAdapter(sql, conn)
da.Fill(ds, "ClanStuff") <

---

This gives error!
conn.Close()

It says 'Value cannot be null parameter name dataset'

Does that mean that i have null data in my DB and its not able to produce it in the program? I've filled a row of data in the DB and that end of stuff looks grand.

Any help would be great! Cheers

OfflerCrocGod

This is a total guess on my part but you may need to initialise ds

Dim ds As DataSet

red_ice

Dim ds As DataSet becomes Dim ds As New DataSet

urgh.

OfflerCrocGod

red_ice wrote:

Dim ds As DataSet becomes Dim ds As New DataSet

urgh.

That fixed it? I haven't a clue tbh never seen a line of VB code in my life - must say I don't like it much