VB.NET连接SQL_Server实例

前端之家收集整理的这篇文章主要介绍了VB.NET连接SQL_Server实例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
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

猜你在找的VB相关文章