get column in Dataset

[Guest]

Hi,

I ve loaded my database into a dataset.
I want to get the string in one of the column name "MyCategory".
Some of my rows have the same category as the others.
For example, there are some in CategoryA, some in CategoryB...etc..

Let's say i do not know the name of the Category in the database, i just
want to store the different name in column "MyCategory" into a string array.

so that myStringArray will have something like [CategoryA,CategoryB....] but
none of them are repeated inside the array....if u know what i mean..

How should I do that?

many thanks,
jon

 

[Cor Ligthert]

Jonathan,

You can read them directly from the database using the Distinct option in
your Select statement or use a routine like this. In this case it is a
complete datatable, when it is only one column you can do that as well
however with an array.

http://groups.google.com/groups?selm=uE#[email protected]

I hope this helps?

Cor

 

[Guest]

Thanks Cor.

but is there any other method apart from using select distinct?
because i have my database in a table already.
thanks.

 

[Cor Ligthert]

Jonathan,

That link gives a sample I once made

Cor