<div>
Minor alteration: had to take square brackets out to get it to work<br />
&nbsp; Dim dTemp As DataTable = xSQLTable_Accounts.Default<wbr />View.ToTab<wbr />le(True, &quot;Segment 1 Desc&quot;)<br />
Thanks again!
</div>


Minor alteration: had to take square brackets out to get it to work
  Dim dTemp As DataTable = xSQLTable_Accounts.DefaultView.ToTable(True, "Segment 1 Desc")
Thanks again!

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I usually use the following SQL statement coupled with a reader to populate an ASP.net DropDownList. In my latest solution I am trying to read the same items using a filter.<br />
I'm not quite sure how to use Distinct or create get unique items from the following code &nbsp; <br />
How would I adjust the following line marked XXXX &nbsp;?<br />
<br />
&nbsp; xSQLTable_Accounts.Default<wbr />View.RowFi<wbr />lter = &quot;[Segment 1 Desc]=*&quot; &nbsp;'XXXX<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; With Me.Category1.Items<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Clear()<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; For i As Integer = 0 To xSQLTable_Accounts.Default<wbr />View.Count<wbr /> - 1<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .Add(xSQLTable_Accounts.De<wbr />faultView.<wbr />Item(i).It<wbr />em(&quot;Segmen<wbr />t 1 Desc&quot;))<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Next<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; End With
</div>
</div>


Hi

I usually use the following SQL statement coupled with a reader to populate an ASP.net DropDownList. In my latest solution I am trying to read the same items using a filter.
I'm not quite sure how to use Distinct or create get unique items from the following code   
How would I adjust the following line marked XXXX  ?

  xSQLTable_Accounts.DefaultView.RowFilter = "[Segment 1 Desc]=*"  'XXXX

                With Me.Category1.Items
                    .Clear()
                    For i As Integer = 0 To xSQLTable_Accounts.DefaultView.Count - 1
                        .Add(xSQLTable_Accounts.DefaultView.Item(i).Item("Segment 1 Desc"))
                    Next
                End With

ASP.net filter on a data table to read unique items

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,