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




Reply With Quote