使用odbc连接mysql问题，odbc连接mysql

使用odbc连接mysql问题，odbc连接mysql

Dim MyConnection As New Odbc.OdbcConnection

        MyConnection.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=test; User=root;Password=1234;Option=3;"

        Dim cmd As New Odbc.OdbcCommand("select * from test")

        Dim adapter As New Odbc.OdbcDataAdapter

        MyConnection.Open()

        Dim tbl As New DataTable

        adapter.Fill(tbl)

        DataGridView1.DataSource = tbl

        MyConnection.Close()

 

出现错误The SelectCommand property has not been initialized before calling 'Fill'.

你好

很高興問題已經解決了

如果再有其實有關programming 的問題歡迎在MSDN 論壇上發問

大家一起研究研究

Have a good day