Hello everone, I am a newbie and I have a recordset that returns the values

XXXXMain
XXXX1
XXXX2
XXXX3
XXXX4
XXXX5
XXXX6
YYYY1
YYYY2
YYYY3
YYYY4
YYYY5
YYYY6
ZZZZMain
ZZZZ1
ZZZZ2
ZZZZ3
ZZZZ4

but I would like the show the results in a tabular format according to the
first 4 charactes such as XXXX, then YYYY, and finally ZZZZ.

XXXXMain YYYYMain ZZZZMain
XXXX1 YYYY1 ZZZZ1
XXXX2 YYYY2 ZZZZ2
XXXX3 YYYY3 ZZZZ3
XXXX4 YYYY4 ZZZZ4
XXXX5 YYYY5
XXXX6 YYYY6

The select statement is sorting the result set. This result set is
populating a Datatable so I was thinking about somehow while looping through
the result set comparing the first 4 string values and creating a new cell
everytime the string values changes.

Hopefully I explained my intentions clearly.
Thanks In Advance
kw
Thanks in Advance for your assistance.

You can use while loop and if to compare the 1st character. VB.NET should
use Dataset than Recordset.

chanmm

"kw_uh97" <(E-Mail Removed)> wrote in message
news:B7835623-EEFB-47E4-88CC-(E-Mail Removed)...
> Hello everone, I am a newbie and I have a recordset that returns the
> values
>
> XXXXMain
> XXXX1
> XXXX2
> XXXX3
> XXXX4
> XXXX5
> XXXX6
> YYYY1
> YYYY2
> YYYY3
> YYYY4
> YYYY5
> YYYY6
> ZZZZMain
> ZZZZ1
> ZZZZ2
> ZZZZ3
> ZZZZ4
>
> but I would like the show the results in a tabular format according to the
> first 4 charactes such as XXXX, then YYYY, and finally ZZZZ.
>
> XXXXMain YYYYMain ZZZZMain
> XXXX1 YYYY1 ZZZZ1
> XXXX2 YYYY2 ZZZZ2
> XXXX3 YYYY3 ZZZZ3
> XXXX4 YYYY4 ZZZZ4
> XXXX5 YYYY5
> XXXX6 YYYY6
>
> The select statement is sorting the result set. This result set is
> populating a Datatable so I was thinking about somehow while looping
> through
> the result set comparing the first 4 string values and creating a new cell
> everytime the string values changes.
>
> Hopefully I explained my intentions clearly.
> Thanks In Advance
> kw
> Thanks in Advance for your assistance.
>
>
>
>
>
>

Thanks chanmm! Some syntax would be helpful also. I will look into the while
loop in the meantime. I am using C# and using DataSet sorry for the incorrect
usage. But an example would be very helpful!

kw

"chanmm" wrote:

> You can use while loop and if to compare the 1st character. VB.NET should
> use Dataset than Recordset.
>
> chanmm
>
> "kw_uh97" <(E-Mail Removed)> wrote in message
> news:B7835623-EEFB-47E4-88CC-(E-Mail Removed)...
> > Hello everone, I am a newbie and I have a recordset that returns the
> > values
> >
> > XXXXMain
> > XXXX1
> > XXXX2
> > XXXX3
> > XXXX4
> > XXXX5
> > XXXX6
> > YYYY1
> > YYYY2
> > YYYY3
> > YYYY4
> > YYYY5
> > YYYY6
> > ZZZZMain
> > ZZZZ1
> > ZZZZ2
> > ZZZZ3
> > ZZZZ4
> >
> > but I would like the show the results in a tabular format according to the
> > first 4 charactes such as XXXX, then YYYY, and finally ZZZZ.
> >
> > XXXXMain YYYYMain ZZZZMain
> > XXXX1 YYYY1 ZZZZ1
> > XXXX2 YYYY2 ZZZZ2
> > XXXX3 YYYY3 ZZZZ3
> > XXXX4 YYYY4 ZZZZ4
> > XXXX5 YYYY5
> > XXXX6 YYYY6
> >
> > The select statement is sorting the result set. This result set is
> > populating a Datatable so I was thinking about somehow while looping
> > through
> > the result set comparing the first 4 string values and creating a new cell
> > everytime the string values changes.
> >
> > Hopefully I explained my intentions clearly.
> > Thanks In Advance
> > kw
> > Thanks in Advance for your assistance.
> >
> >
> >
> >
> >
> >
>
>
>