'我的表格一共3637行,我想实现随机抽取十行,抽取八组,并在表格中显示,为避免随机数重复应该如何调整
For i As Integer = 0 To 7
Dim ids As String
Dim lst As new List(of String)
Dim cnt As Integer = DataTables("订单客户列表").DataRows.Count
Do
Dim Id As Integer = rand.Next(0,cnt)
id = DataTables("订单客户列表").DataRows(id)("_Identify")
If lst.Contains(id) =False Then
lst.Add(id)
Output.Show(id - 2)
End If
ids = ids & id & ","
Loop While lst.count < 10 '10是要抽取的行数
Tables("订单客户列表").Filter = "[_Identify] In (" & ids.Trim(",") & ")"
MessageBox.Show("下一轮")
Output.Show("下一轮")
Next
[此贴子已经被作者于2020/9/16 18:19:34编辑过]