How can I set value in combo-box But no-Repeat c#

Question

I have an Excel sheet and I want to fetch some data from excel to c# but the data I have is repeated in some columns.

I need select this data in combo-box but no-repeat

OleDbDataAdapter da = new OleDbDataAdapter("SELECT  TL From [Data$]", conn);
        DataTable dt = new DataTable();
        da.Fill(dt);
        comboBox2.DataSource = dt;
        comboBox2.DisplayMember = "TL";

Please help me with this code,

Thanks for all.

Possible duplicate of [Best way to remove duplicate entries from a data table](http://stackoverflow.com/questions/4415519/best-way-to-remove-duplicate-entries-from-a-data-table) — Sinatr, Feb 16 '17 at 12:39
@Mohamed, Have you tried this "SELECT DISTINCT TL From [Data$]". Might it will help you. — Nayan Katkani, Feb 16 '17 at 12:40

score 0 · Accepted Answer · answered Feb 16 '17 at 12:44

0

Use 'DISTINCT' command in SQL query:

SELECT DISTINCT TL From [Data$]

answered Feb 16 '17 at 12:44

Ivan Kishchenko

795
4
15

How can I set value in combo-box But no-Repeat c#

1 Answers1