distinct values in dataset

[arkiboys]

I have populated a dataset with one table.
The data in the table looks as follows:
Index1Name Index2Name City Value
Indexk Indexk city1 2
Indexk Indexk city1 3
Indexk Indexd city1 2
Indexk Indexy city1 1
Indexy Indexk city1 1
Indexx Indexk city1
Indext Indexq city1 5
Indexs Indexs city1 6

Now I would like to have an array which gets populated from the distinct values in columns of Index1Name and Index2Name
So the array should contain something like:
Indexd Indexk Indexy Indexx Indext Indexs Indexq

Thanks

[stimbo]

How did you populate the dataset?

[arkiboys]

SqlDataAdapter oDA = new SqlDataAdapter(comm);

DataSet dsData = new DataSet();

oDA.Fill(dsData, "datavalues");

[stimbo]

Not exactly what i meant. I presume you had a SQL statement to select values?
Something like:

SELECT * FROM tableName

What you could do is to use the DISTINCT keyword in SQL to get distinct records which would save you lots of trouble.

[arkiboys]

Ok, thanks

[arkiboys]

Assuming I now have a dataset with the column values being distinct, how can I populate an array with the values please?

[stimbo]

I would have a way to do it but really doubt it's the correct way. Just change the column name/value below

'Get number of results/rows returned by the dataset
Dim numResults As Integer = dsData.Tables("dataValues").Rows.Count - 1
Dim myResults(numResults) As String  'Dimension the array? Should this be +1
 
Dim Drow As DataRow
 
For i As Integer = 0 To numResults  'Go through each row
    Drow = dsData.Tables("dataValues").Rows(i)    'assign current row
    myResult(i) = Drow("Column").ToString          'Change column to your name
Next

My advice - wait until someone who knows about SQL stuff replies - I've only started it. It's most likely either badly flawed or really slow.


Edit: I found this example on the web. Kind of the same approach -

Dim arData() As String
Dim ds As New DataSet
' Fill your dataset in your own way here
 
ReDim arData(ds.Tables(0).Rows.Count)  'Is this correct? 
 
For intCounter As Integer = 0 To ds.Tables(0).Rows.Count - 1
       arData(intCounter) = ds.Tables(0).Rows(intCounter).Item(0).ToString
 
Next

[jmcilhinney]

Is there a particular reason that you need the values in an array rather than just using then directly from the DataTable?