combine 2 rows into 1

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Dave
    #1

    combine 2 rows into 1

    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



    Tags: None
    • gnewsgroup
      #2
      Re: combine 2 rows into 1

      On Feb 18, 9:44 am, "Dave" <D...@ihatepsam .comwrote:
      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
      But, you should handle the display layout in the presentation layer.

        Comment

        • Dave
          #3
          Re: combine 2 rows into 1

          how coud I handle this on the presentation layer?

          "gnewsgroup " <gnewsgroup@gma il.comwrote in message
          news:a79149b5-93ac-499b-85ac-42ab722692be@s3 7g2000prg.googl egroups.com...
          On Feb 18, 9:44 am, "Dave" <D...@ihatepsam .comwrote:
          >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
          >
          But, you should handle the display layout in the presentation layer.

            Comment

            • gnewsgroup
              #4
              Re: combine 2 rows into 1

              On Feb 18, 9:57 am, "Dave" <D...@ihatepsam .comwrote:
              how coud I handle this on the presentation layer?
              >
              "gnewsgroup " <gnewsgr...@gma il.comwrote in message
              >
              news:a79149b5-93ac-499b-85ac-42ab722692be@s3 7g2000prg.googl egroups.com...
              >
              On Feb 18, 9:44 am, "Dave" <D...@ihatepsam .comwrote:
              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
              >
              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.

                Comment

                • Dave
                  #5
                  Re: combine 2 rows into 1

                  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?



                  "gnewsgroup " <gnewsgroup@gma il.comwrote in message
                  news:7995a189-857d-4840-8690-39b08d3fa314@u1 0g2000prn.googl egroups.com...
                  On Feb 18, 9:57 am, "Dave" <D...@ihatepsam .comwrote:
                  >how coud I handle this on the presentation layer?
                  >>
                  >"gnewsgroup " <gnewsgr...@gma il.comwrote in message
                  >>
                  >news:a79149b 5-93ac-499b-85ac-42ab722692be@s3 7g2000prg.googl egroups.com...
                  >>
                  On Feb 18, 9:44 am, "Dave" <D...@ihatepsam .comwrote:
                  >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
                  >>
                  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.

                    Comment

                    • gnewsgroup
                      #6
                      Re: combine 2 rows into 1

                      On Feb 18, 10:09 am, "Dave" <D...@ihatepsam .comwrote:
                      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?
                      >
                      "gnewsgroup " <gnewsgr...@gma il.comwrote in message
                      >
                      news:7995a189-857d-4840-8690-39b08d3fa314@u1 0g2000prn.googl egroups.com...
                      >
                      On Feb 18, 9:57 am, "Dave" <D...@ihatepsam .comwrote:
                      how coud I handle this on the presentation layer?
                      >
                      "gnewsgroup " <gnewsgr...@gma il.comwrote in message
                      >
                      >news:a79149b 5-93ac-499b-85ac-42ab722692be@s3 7g2000prg.googl egroups.com...
                      >
                      On Feb 18, 9:44 am, "Dave" <D...@ihatepsam .comwrote:
                      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
                      >
                      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.
                      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

                        Comment

                        • Eliyahu Goldin
                          #7
                          Re: combine 2 rows into 1

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

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

                          http://usableasp.net



                          "Dave" <Dave@ihatepsam .comwrote in message
                          news:ekbAQzjcIH A.1188@TK2MSFTN GP04.phx.gbl...
                          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
                          >
                          >
                          >

                            Comment

                            • Dave
                              #8
                              Re: combine 2 rows into 1

                              I got it working actually with using a gridview.


                              "Eliyahu Goldin" <REMOVEALLCAPIT ALSeEgGoldDinN@ mMvVpPsS.orgwro te in
                              message news:uXSwvPkcIH A.4684@TK2MSFTN GP06.phx.gbl...
                              Consider using a DataList control that is capable of rendering several
                              items in a row.
                              >
                              --
                              Eliyahu Goldin,
                              Software Developer
                              Microsoft MVP [ASP.NET]
                              http://msmvps.com/blogs/egoldin

                              http://usableasp.net

                              >
                              >
                              "Dave" <Dave@ihatepsam .comwrote in message
                              news:ekbAQzjcIH A.1188@TK2MSFTN GP04.phx.gbl...
                              >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
                              >>
                              >>
                              >>
                              >
                              >

                                Comment

                                Previous template Next
                                Working...