.net 1- getting unque values for a column from datatable/dataview
<p>We are using .net 1 ,i know we should switch to higher but not
 in my hand.
I am trying to show unque values of a column returned from stored proc &amp; putting in data tabel. rest of the column need to show all the values.</p>

<p>i googled and found below which seems not working in this version-
new DataView(myTable).ToTable(true, new string[]{"channel"});   </p>

<p>Do we have any other simple method. i dont like to use for loop to iterate all the values and put in arraylist.</p>

<p>my code is as below=</p>

<pre><code>    cmd = New SqlCommand("web_RetrieveClient", conn)
    cmd.CommandType = CommandType.StoredProcedure

    param = cmd.Parameters.Add("@ClientKey", SqlDbType.Int, 4)
    param.Value = lClientKey
    param.Direction = ParameterDirection.Input

    adapter.SelectCommand = cmd![enter image description here][1]
    adapter.Fill(dt)
    conn.Close()
</code></pre>

<p>please see the result data of proc in image.
I need unique channelids.</p>

<p>thanks for the help in advance.
navya</p>
