Please Help! error: Cannot create a child list for field myData
i've been trying to run this code but this error always pops up!
here's my line of code
VB Code:
Dim myData As New DataSet
Dim conn As New MySqlConnection
Dim cmd As New MySqlCommand
Dim myAdapter As New MySqlDataAdapter
DataGrid1.DataSource = myData
conn.ConnectionString = "server=localhost; uid=root; database=test"
Try
conn.Open()
cmd.CommandText = "SELECT * from user"
cmd.Connection = conn
myAdapter.SelectCommand = cmd
myAdapter.Fill(myData)
DataGrid1.DataMember = "myData.Tables(0)"
Catch ex As Exception
MessageBox.Show(ex.Message, "Report could not be created", MessageBoxButtons.OK)
End Try