Using SELECT DISTINCT for an already created DataTable?

Question

I have an already created DataTable object that I use for my girdview (asp.net), I also need to bind the column of this object to DropDownList. The column contains the correct information in the column, but the column contains more than one name in the column, so I would just like to make some SELECT DISTINCT on the datatable and copy it to the new datatable for use with the drop down list.

This will allow me to save resources by making another trip to the database.

Here is an example, the current datatable has a column named items and in this column has the following entries

1
1
1
1
5
5
6

And of course, I only need unique elements to bind to my drop-down list, so I need the following data

1
5
6

, ,

, ? db?

Answer 1

DataTable dt = new DataTable(); dt = dsMobileInfo.Tables [0].DefaultView.ToTable(true, "ColumnName" );

// dvResult, Grid (int = 0; i

, .

Answer 2

ToTable() ( , ) true, , :

DataTable distinctTable = originalTable.DefaultView.ToTable(true);