Admin.Exe is my file name.
What i am trying to do is get a name randomly from a table and insert it into an array. There should not be any duplicate records in the array. Below is my code.
Private Sub SinglesToolStripMenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SinglesToolStripMenuItem1.Click
pnlSingles.Show()
Dim i As New Integer
Dim j As New Integer
Dim k As New Integer
Dim name As String
Dim singlesArray() As String = {"a"}
Dim Table As DataTable = GetSingles()
Dim x As New Random
'get a random row...
For i = 0 To Table.Rows.Count
Dim tr As DataRow = Table.Rows(x.Next(0, Table.Rows.Count))
ReDim Preserve singlesArray(i)
'display the value of the name column...
name = tr("Name")
'singlesArray.SetValue(name, i)
'If NameNotAlreadyGenerated(singlesArray, name) Then
'singlesArray.SetValue(name, i)
'End If
For k = 0 To singlesArray.Length - 1
If singlesArray(k).Equals(name) Then
singlesArray.SetValue(name, k)
End If
Next
'Debug.WriteLine(singlesArray(i))
Next
For j = 0 To singlesArray.Length - 1
Debug.WriteLine(singlesArray(j))
Next
End Sub
Function NameNotAlreadyGenerated(ByVal singlesArray() As String, ByVal Name As String) As Boolean
If Array.IndexOf(singlesArray, Name) <> 0 Then
Return True
Else
Return False
End If
End Function
End Class
However, the array still contains duplicate records. How do I solve it? Can somebody help pls? Thanx