SqlCommand 类

https://docs.microsoft.com/zh-cn/dotnet/api/system.data.sqlclient.sqlcommand?view=dotnet-plat-ext-3.1

构造函数

属性

方法

Imports System.Data.SqlClientPublic Class Form1    Dim conn As SqlConnection    Dim da As SqlDataAdapter    Dim ds As DataSet    Private Function GetConnection() As SqlConnection        Return New SqlConnection(My.Settings.SalesConnectionString)    End Function    Private Sub displayData1(ByVal str As String)        conn = GetConnection()        conn.Open()        Dim comm As New SqlCommand(str, conn)        Dim dr As SqlDataReader        dr = comm.ExecuteReader        Dim dt As New DataTable        dt.Load(dr)        DataGridView1.DataSource = dt        conn.Close()    End Sub    Private Sub displayData2(ByVal str As String)        conn = GetConnection()        conn.Open()        Dim comm As New SqlCommand(str, conn)        Dim dr As SqlDataReader        dr = comm.ExecuteReader        '区别在这里        Dim bs As New BindingSource        bs.DataSource = dr        DataGridView1.DataSource = bs        conn.Close()    End Sub    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click        '可以输入：select * from grade where 姓名 like '%张%'        displayData2(TextBox1.Text)    End Sub    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load        displayData1("Select * from grade")    End SubEnd Class