MySqlException未处理 [英] MySqlException was unhandled

问题描述

这些是我的代码： -

These Are my codes :-

Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient

Public Class Form1
    Dim mySqlConnection As MySqlConnection
    Dim myadapter As New MySqlDataAdapter
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        mySqlConnection = New MySqlConnection
        mySqlConnection.ConnectionString = "Server=db4free.net;port=3306; user id=       ; password=      ; database= visualbasic_1906"

        mySqlConnection.Open()
        Dim myData As MySqlDataReader
        Dim sqlquary = " SELECT * From dataonline where location = 'westport'"

        Dim command As New MySqlCommand
        command.Connection = mySqlConnection
        command.CommandText = sqlquary
        myData = command.ExecuteReader
        myData.Read()
        
        TextBox1.Text = myData.GetValue(0)
        TextBox2.Text = myData.GetValue(1)
        TextBox3.Text = myData.GetValue(2)
        TextBox4.Text = myData.GetValue(3)
        Dim myadapter As New MySqlDataAdapter

    End Sub
End Class

我在db4free.net上创建了一个在线数据库，数据库名称是visualbasic_1906

但是，当我执行这个程序时，在这句话中（myData = command.ExecuteReader）我收到的错误是表'visualbasic_1906.dataonline'不存在

请帮我解决这个问题

I have created a Online Database in db4free.net, Databse Name is visualbasic_1906
But, When i'm executting this program, In this sentence(myData = command.ExecuteReader) I'm getting an error that is Table 'visualbasic_1906.dataonline' doesn't exist
Please help me out in this problem

推荐答案

错误非常明确：

The error is pretty explicit:

Table 'visualbasic_1906.dataonline' doesn't exist

这意味着其中一个是错误：

Which means that one of these is wrong:

mySqlConnection.ConnectionString = "Server=db4free.net;port=3306; user id= ; password= ; database= visualbasic_1906"
...
Dim sqlquary = " SELECT * From dataonline where location = 'westport'"

这是第一行中的错误数据库，或第二个错误的表名......

Either it's the wrong DB in the first line, or the wrong table name in the second...

这篇关于MySqlException未处理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！