附加信息：无效的对象名称信息“vb.net

Question

请帮忙指教我刚开始写

我使用SQL Server Management Studio中2012 表名是dbo.info

Imports System.Data 
Imports System.Data.SqlClient 

Public Class Form1 

    Dim SQLCon As New SqlConnection("Data Source=SECURITY;Integrated Security=False;User ID=sa;Password=Rapoo;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False") 
    Dim cmd As New SqlCommand 

    Private Sub btmSave_Click(sender As Object, e As EventArgs) Handles btmSave.Click 
     If txtStaff.Text <> "" And txtName.Text <> "" Then 
      SQLCon.Open() 
      cmd.CommandText = "insert into info (Club,Staff,Name,Age,Gender,Mobile,Mail,Remark) values ('" & lblClub.Text & "','" & txtStaff.Text & "','" & txtName.Text & "','" & txtAge.Text & "','" & txtGender.Text & "','" & txtMobile.Text & "','" & txtMail.Text & "','" & txtRemark.Text & "')" 
      cmd.ExecuteNonQuery() 
      SQLCon.Close() 

     End If 
     Clear() 
    End Sub 

的错误是

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll 

Additional information: Invalid object name 'info'. 

Answer 1

在您的连接字符串缺少部分
数据库= yourDa tabaseName;
或
Initial Catalog = yourDatabaseName;

没有这个键查询执行对那里没有INFO表