vb如何顯示數(shù)據(jù)庫(kù)表

小億
91
2024-04-19 16:21:13

在VB中顯示數(shù)據(jù)庫(kù)表通常需要使用ADO.NET或者Entity Framework等數(shù)據(jù)訪問(wèn)技朧。以下是一個(gè)基本的示例代碼，演示如何連接數(shù)據(jù)庫(kù)并顯示表中的數(shù)據(jù)：

Imports System.Data.SqlClient

Public Class Form1
    Dim connectionString As String = "Data Source=YourServer;Initial Catalog=YourDatabase;Integrated Security=True"
    Dim sqlConnection As New SqlConnection(connectionString)

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Dim sqlQuery As String = "SELECT * FROM YourTable"
        Dim sqlCommand As New SqlCommand(sqlQuery, sqlConnection)
        
        Dim dataAdapter As New SqlDataAdapter(sqlCommand)
        Dim dataTable As New DataTable()
        
        sqlConnection.Open()
        dataAdapter.Fill(dataTable)
        sqlConnection.Close()
        
        DataGridView1.DataSource = dataTable
    End Sub
End Class

在上面的示例中，我們首先創(chuàng)建了一個(gè)數(shù)據(jù)庫(kù)連接字符串，并在Form1_Load事件處理程序中執(zhí)行了一個(gè)簡(jiǎn)單的SELECT查詢。然后使用數(shù)據(jù)適配器將查詢結(jié)果填充到一個(gè)數(shù)據(jù)表中，最后將數(shù)據(jù)表綁定到DataGridView控件上，從而顯示數(shù)據(jù)庫(kù)表中的數(shù)據(jù)。您需要根據(jù)自己的實(shí)際情況修改連接字符串和SQL查詢語(yǔ)句。

0 踩