How to show distinct values in to Combo Box from data base

Question

Hi sir,

Here i am writing display distinct values into combo Box from data base

SqlDataAdapter da = new SqlDataAdapter("Select distinct ino,cgname from pdetails1", con);

like this i am writing i am not getting distinct values ...

please give me the ans...

Sandeep Singh Shekhawat · Answer

IF COLUMN NAME is cgname SqlDataAdapter da = new SqlDataAdapter("Select distinct cgname from pdetails1", con); OR IF COLUMN NAME is chname SqlDataAdapter da = new SqlDataAdapter("Select distinct chname from pdetails1", con);

Kunal Vaishya · Answer

Dear , if you want to both column then do like this Select Distinct EmpId , Employee_Name From Employee Group By Employee_Name ,EmpID

Sivaraman Dhamodaran · Answer

Yes. Go with Sandeep Shekhawat

sri · Answer

Here i don't want ino... i want only chname only. is it possible..??

Sivaraman Dhamodaran · Answer

The distinct is including both the columns ino,cgname. So the query will ensure that the returned values will not have duplicate on ino, cgname. Consider the result below (Without distinct): ino, chname 1 A 1 B 1 C 2 B 2 A 2 C 1 A 1 B Note that , the distinct usage in the query will remove duplicates from the returned result. You asked to display two columns. So the result will be: ino, chname 1 A 1 B 1 C 2 B 2 A 2 C Do not expect that ino alone should be dinstinct. It is applied for returned result.

How to show distinct values in to Combo Box from data base

Answers (5)