'用于接收查找结果的DataRowDim drSearch() As DataRowdrSearch = dt.Select("ccode='" & TextBox1.Text & "'")If drSearch.Length = 0 ThenMsgBox("没有符合的记录")ElseMsgBox("找到个" & drSearch.Length & "记录")End If'创建一个新的DataTable来接收查找结果Dim dtNew As DataTable = New DataTable'将之前的DataTable结构复制到新的DataTabledtNew = dt.CloneDim i As Integer'将查找结果逐条添加到DataTableFor i = 0 To drSearch.Length - 1dtNew.ImportRow(drSearch(i))Next'设置显示DataGridView1.DataSource = dtNewEnd Sub
将DataTable中执行Select(\"条件\")后的结果显示在DataGridView
最新推荐文章于 2018-04-11 09:12:30 发布