how to select distinct values from a database

Question

0.00/5 (No votes)

See more:

ASP.NET

query of how to select distinct values from a database.

Posted 6-Apr-14 21:15pm

Member 10578683

Add a Solution

4 solutions

Solution 1

Use distinct keyword. Give more details if you want explicit example or code.

Posted 6-Apr-14 21:16pm

ArunRajendra

Comments

Member 10578683 7-Apr-14 3:21am

string qry = "select distinct * from Products";
DataSet ds = du.GetDataSet(qry);
gdvProducts.DataSource = ds;
gdvProducts.DataBind();

Member 10578683 7-Apr-14 3:21am

here distinct keyword is not working

ArunRajendra 7-Apr-14 3:24am

If distinct work on combination of fields. Since you have given * it take all the fields from products table and build distinct. If you want distinct of specific field or fields then mention the field names.

ArunRajendra 7-Apr-14 3:24am

If you could give your requirement and data modal. We can try to build the query.

Member 10578683 7-Apr-14 4:04am

I have an gridview with two columns ID Product. and a Products database. These are the data of database. I want to populate only distinct product value in gridview.
2 Mouse
3 SMPS
4 Motherboard
5 RAM
6 HDD
7 Processor
8 Monitor (TFT)
9 Mouse Pad
11 Laptop Screen
12 Monitor (CRT)
14 joystick
15 Baterry
21 RAM
22 RAM
NULL NULL

ArunRajendra 7-Apr-14 4:15am

If you want only product name then mention select distinct name from products. If you include ID in query then it will give you duplicates.

Member 10578683 7-Apr-14 5:23am

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'. error is coming. if i select only product

Ajith K Gatty 7-Apr-14 4:12am

I think Member 10578683 is getting output.since the query is involved with 2 fields it is not giving distinct values. values are getting repeated.

Member 10578683 7-Apr-14 3:27am

I have two fields ID and Product. I wrote the code Select distinct ID, Product from Products but still it is not working

Member 10378142 7-Apr-14 5:09am

use group by clause

Solution 2

Refer: sql_distinct[^]

Posted 6-Apr-14 21:29pm

Peter Leow

Comments

Member 10578683 7-Apr-14 3:44am

As in my gridview i have used both ID and Product. How will i use distinct keyword to get distinct product

Member 10378142 7-Apr-14 5:10am

use
select * from table_name group by ID,product

then you will get a distinct values

Solution 3

Refer

http://www.w3resource.com/sql/select-statement/queries-with-distinct-multiple-columns.php[^]

Posted 6-Apr-14 22:43pm

vsrikanth87

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravindba · Accepted Answer · 2014-04-06T22:46:00

Solution 4

Hi
Try this

SQL

Select Distinct Product from Products ORDER BY Product

Regards
Aravind

Posted 6-Apr-14 22:46pm

Aravindba

Updated 6-Apr-14 22:50pm

v4

Comments

Member 10578683 7-Apr-14 5:22am

I did like this but an error is coming
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Member 10578683 7-Apr-14 5:37am

now it is working.Thanks all for helping me

how to select distinct values from a database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

how to select distinct values from a database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us