use excel file to fill dropdownlist in c#?
<p>I have an excel file that I want To use one of it's column to fill dropdown list ,I do it but I can't Remove Duplicate data.How Can I distinc datat table before that? Or How Can I Access to each coulmn of excel in c#?</p>

<p>Or how can I write in two sheet of excel ? and read from each sheet to fill dropdownlist with one sheet and fill another sheet to fill gridview in c#?</p>
