在C#中工作,但在Visual Basic中不工作,我使用Visual Studio 2017 [英] Works in C# but not in Visual Basic, I use Visual Studio 2017
问题描述
这不适用于基本
This does not work in Basic 公开 类 Form1 私有 M_cnADONetConnection PrivateM_cnADONetConnection
AsNewOleDb.OleDbConnection()
私人 < span style ="color:#0000ff; font-size:small"> Sub PrivateSubForm1_Load(sender
AsObject,
e AsEventArgs)
HandlesMyBase.Load   ; M_cnADONetConnection.ConnectionString = M_cnADONetConnection.ConnectionString =
"提供商=(的LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Doug\Documents\Visual工作室2017\Projects\DatabaseTest-3\的 DatabaseTest-3 \Database.mdf; Integrated "Provider=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Doug\Documents\Visual Studio 2017\Projects\DatabaseTest-3\DatabaseTest-3\Database.mdf;Integrated
Security=True" M_cnADONetConnection.Open() M_cnADONetConnection.Open()
结束 Sub 结束 Class 这适用于C# 名称空间 DatabaseTest_3InC { public partial class Form1 : publicpartialclassForm1:
Form ; { { public Form1() publicForm1() { { InitializeComponent(); InitializeComponent(); } } SqlConnection con = SqlConnection con = new SqlConnection( " Data newSqlConnection("Data
Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=\"|DataDirectory|\\DatabaseTest - 3\\Database.mdf\";Integrated Security=True;Connect Timeout=30"); &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;的SqlCommand Cmd的; SqlCommand Cmd; &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; SqlDataReader的博士; SqlDataReader dr; private void Form1_Load( 对象 发件人, privatevoidForm1_Load(objectsender,
EventArgs e) &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; {&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; {
} }
private void GetData() privatevoidGetData() { { con.Open(); con.Open(); string syntax = stringsyntax =
"";   ; Cmd = Cmd = new SqlCommand(syntax,con) ; newSqlCommand(syntax,con); &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; DR = Cmd.ExecuteReader(); dr = Cmd.ExecuteReader(); &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ; } } } } } 这是C#和Visual Basic中的相同程序,但仅适用于C#。 This is the same program in both C# and Visual Basic, but only works in C#. 为什么 谢谢 你好doug_army, Hi doug_army, 我建议您可以使用SqlConnection而不是OleDbConnection,如下所示: I would suggest that you could use SqlConnection instead of OleDbConnection, like this: 祝你好运, 张龙 这篇关于在C#中工作,但在Visual Basic中不工作,我使用Visual Studio 2017的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
作为 新 OleDb.OleDbConnection()
作为 对象 ,
e As EventArgs)
句柄 MyBase 。加载
Security = True" b $ b
表格
Source =(LocalDB)\\MSSQLLocalDB; AttachDbFilename = \" | DataDirectory | \\DatabaseTest - 3 \\Database.mdf \" ; Integrated Security = True; Connect Timeout = 30" );
EventArgs e )
"" ; 推荐答案
Imports System.Data.SqlClient
Public Class Form1
Private M_cnADONetConnection As New SqlConnection()
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
M_cnADONetConnection.ConnectionString = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\Database\NormalTable.mdf;Integrated Security=True"
M_cnADONetConnection.Open()
End Sub
End Class