Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / February 2008

Tip: Looking for answers? Try searching our database.

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

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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.