VB.NET连接SQL_Server实例
发布时间:2020-12-17 07:28:56 所属栏目:百科 来源:网络整理
导读:Imports System.Data.SqlClientPublic Class Form1 REM Public conn1 As SqlConnection = New SqlConnection("server=.; Integrated Security=False;Initial Catalog= mydatabase1; User ID= sa;password") Dim cn As SqlConnection Dim da As SqlDataAdapte
Imports System.Data.SqlClient Public Class Form1 REM Public conn1 As SqlConnection = New SqlConnection("server=.; Integrated Security=False;Initial Catalog= mydatabase1; User ID= sa;password") Dim cn As SqlConnection Dim da As SqlDataAdapter Dim ds As DataSet Private Sub Form1_Load(sender As Object,e As EventArgs) Handles MyBase.Load Dim cnStr As String = "Data Source=(local);Initial Catalog=mydatabase1;Integrated Security=False;User ID=sa;[email?protected];" cn = New SqlConnection(cnStr) da = New SqlDataAdapter("select * from mydatabase1.dbo.db_book",cn) ds = New DataSet() da.Fill(ds,"mydatabase1.dbo.db_book") DataGridView1.DataSource = ds.Tables("mydatabase1.dbo.db_book") End Sub End Class (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |