且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用组合框查询数据库

更新时间:2023-11-27 10:08:34

您可以使用以下代码在datagridview中简单地创建一个过滤器

You can Simply make a filter in your datagridview using following code

Dim column As String = 'Your weekday column Name in Datagridview
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged

    Dim rows = ds.Tables(0).Select("Convert(" & column & ", 'System.String') LIKE '*" + ComboBox1.SelectedItem + "*'")

    Try
        DGTimeTable.DataSource = rows.CopyToDataTable
    Catch ex As Exception
    End Try
End Sub