i have a created an application, is it for price listing, automatically list down the price of Particular Brand, now i have a combobox, in the combobox i have fetched value from the database, there is a multiple value in multiple form, but i dont want to display duplicate, so is there any idea for that??
Just Display only one Time in Combobox::
Brand Size Price
Soni 21 10000
Videocon 21 20000
Soni 22 25000
There two time Soni, so in combobox its display two time, but i want only one time display...
Dim da As New SqlDataAdapter Dim ds As New DataSet Dim str As String = ("SELECT Brand FROM tblHosePriceList ORDER BY Brand") da.SelectCommand = New SqlCommand(str, conn) da.Fill(ds) comboHoseBrand.ValueMember = "ID" comboHoseBrand.DisplayMember = "Brand" comboHoseBrand.DataSource = ds.Tables(0)