[VB.Net] 連接資料庫並將資料顯示在DataGride中

   連接資料庫並將資料顯示在DataGride中 

Imports System.Data.SqlClient
Public Class Form1

    Private connectionString As String = "Server=YOUR_SERVER;Database=YOUR_DATABASE;User Id=YOUR_USER;Password=YOUR_PASSWORD;"

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Using conn As New SqlConnection(connectionString)
            conn.Open()
            Dim query As String = "SELECT TOP 10 * FROM YourTable"
            Dim cmd As New SqlCommand(query, conn)
            Dim reader As SqlDataReader = cmd.ExecuteReader()

            ' 直接將 DataReader 轉為 DataSource'
            Dim dt As New DataTable()
            dt.Load(reader)
            DataGridView1.DataSource = dt
        End Using
    End Sub
End Class

參考網址: 

By Hao★