Member Avatar for wewehalim

Hi, i am developing a software using microsoft visual studio basic 2010.
I set up a connection string to my server and take the data from there.
I am using gridcontrolview and put my "product" table in here.
It contain 4 column: systemid, system, actualid, description.
I want to display only system column (it's easy, just hide the others column)
But, In "system" column, there are a lot of similar data, i want to display only distinct data from this column in the grid

example, the column consist:
STSTEM
topaz
topaz
topaz
emerald
emerald
emerald
emerald
gold
gold

i want it to be displayed as:
SYSTEM
topaz
emerald
gold


i try to user "add query", buat if i get rid of the other 3 column, there will be error message like "the output is different with the schema"

can someone help me, or maybe suggest me another solution?

thanks

  • 2 Contributors
  • 1 Reply
  • 99 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Don't include four columns (i.e you don't want to display).

select distinct column1 from TableName.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.