主题：[求助]将筛选的数据填入到临时表

我自己解决了：

Dim dtb As New DataTableBuilder("标签表")
dtb.AddDef("箱号", Gettype(String), 50)
dtb.AddDef("起始档号", Gettype(String), 50)
dtb.AddDef("终止档号", Gettype(String), 50)
dtb.Build()

Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.CommandText = "select 存放地点 as 箱号, min(档号) as 起始档号 , max(档号) as 终止档号 from [S1室藏案卷] where [分类号] = '2.1' and [全宗号] = '023' group by 存放地点"
dt = cmd.ExecuteReader()
For Each dr As DataRow In dt.Datarows
   Dim dr1 As DataRow = DataTables("标签表").AddNew()
       dr1("箱号") = dr("箱号")
       dr1("起始档号") =dr("起始档号")
       dr1("终止档号") = dr("终止档号")
Next

谢谢！！