[nilesh7136]

Hello There,,

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::
Ex:
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...
Code ::

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)

Thanks,,
@Nilesh

[modi123_1]

You want to use 'DISTINCT'.

[Atli]

Depending on the database structure, you may also want to separate the brand names out of that table. Ideally there would be a "brands" table listing all the brands, which would then be referenced in the price list table to link each item to it's brand. Something like:

Table: brands
+----+----------+
| id | name     |
+---------------+
|  1 | Soni     |
|  2 | Videocon |
+----+----------+

Table: price_list
+----+----------+------+-------+
| id | brand_id | size | price |
+----+----------+------+-------+
|  1 |        1 |   21 | 10000 |
|  2 |        2 |   21 | 20000 |
|  3 |        1 |   22 | 25000 |
+----+----------+------+-------+

[nilesh7136]

modi123_1, on 18 March 2013 - 11:02 AM, said:

You want to use 'DISTINCT'.

Can you Explain Me??
How to write query Using "DISTINCT"...??


@nilesh

[nilesh7136]

modi123_1, on 18 March 2013 - 11:02 AM, said:

You want to use 'DISTINCT'.

Ohh Thanks Dear, Its Done, i have write "SELECT DISTINCT Size FROM tblHosePriceList ORDER BY Size", its work,

Thanks Again
@nilesh

[JackOfAllTrades]

And this is posted in PHP, WHY exactly?

I'll move this to Databases instead.