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 inocgname 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 inocgname. 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.