combine 2 rows into 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 18 Feb 2008 14:44 GMT

Is it possible to create 2 rows of output from SQL into 1 row for display
purposes?

My output looks like this

row1 1 2 3
row2 4 5 6

is it possible to combine them into 1 row so it looks like this

row1 1 2 3 row2 4 5
6

Reply to this Message

gnewsgroup - 18 Feb 2008 14:54 GMT

> Is it possible to create 2 rows of output from SQL into 1 row for display
> purposes?
[quoted text clipped - 8 lines]
> row1 1 2 3 row2 4 5
> 6

But, you should handle the display layout in the presentation layer.

Reply to this Message

Dave - 18 Feb 2008 14:57 GMT

how coud I handle this on the presentation layer?

>> Is it possible to create 2 rows of output from SQL into 1 row for display
>> purposes?
[quoted text clipped - 10 lines]
>
> But, you should handle the display layout in the presentation layer.

Reply to this Message

gnewsgroup - 18 Feb 2008 15:04 GMT

> how coud I handle this on the presentation layer?
>
[quoted text clipped - 12 lines]
>
> > But, you should handle the display layout in the presentation layer.

It depends on what control you use. Or you can simply output the HTML
elements of a table.

Reply to this Message

Dave - 18 Feb 2008 15:09 GMT

I'm new to this .NET thing so I'm not sure what controls would work for
this.
do you have an example of something that could show this format?

>> how coud I handle this on the presentation layer?
>>
[quoted text clipped - 17 lines]
> It depends on what control you use. Or you can simply output the HTML
> elements of a table.

Reply to this Message

gnewsgroup - 18 Feb 2008 15:14 GMT

> I'm new to this .NET thing so I'm not sure what controls would work for
> this.
[quoted text clipped - 25 lines]
> > It depends on what control you use. Or you can simply output the HTML
> > elements of a table.

You may wanna try the Table control. There are many examples on the
web. One of them is here:

http://samples.gotdotnet.com/quickstart/aspplus/samples/webforms/ctrlref/webctrl
/table/doc_table.aspx

Reply to this Message

Eliyahu Goldin - 18 Feb 2008 15:34 GMT

Consider using a DataList control that is capable of rendering several items
in a row.

Signature

Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

> Is it possible to create 2 rows of output from SQL into 1 row for display
> purposes?
[quoted text clipped - 7 lines]
>
> row1 1 2 3 row2 4 5 6

Reply to this Message

Dave - 18 Feb 2008 17:16 GMT

I got it working actually with using a gridview.

> Consider using a DataList control that is capable of rendering several
> items in a row.
[quoted text clipped - 11 lines]
>> row1 1 2 3 row2 4 5
>> 6

Reply to this Message

combine 2 rows into 1

Free Magazines