MAking a bound form from a query

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

    MAking a bound form from a query

    I have a dataset with 2 tables. I have madee a query of theese 2 tables.
    When I look at the datasources the query is not shown.
    How do I make a form with the query as source?
    reidarT


    Tags: None
    • Cor Ligthert [MVP]
      #2
      Re: MAking a bound form from a query

      Reidar,

      The term "query" is not an unique term, can you explain it a little bit
      more?

      Cor

      "reidarT" <reidar@eivon.n oschreef in bericht
      news:ub1YIztyGH A.3464@TK2MSFTN GP03.phx.gbl...
      >I have a dataset with 2 tables. I have madee a query of theese 2 tables.
      When I look at the datasources the query is not shown.
      How do I make a form with the query as source?
      reidarT
      >

        Comment

        • reidarT
          #3
          Re: MAking a bound form from a query

          When I am in the dataset designer, I can right click an get the options
          DataTable, TableAdapter and Query when I click Add.
          I have made a query and I want to use this query in fom.
          reidarT

          "Cor Ligthert [MVP]" <notmyfirstname @planet.nlskrev i melding
          news:e7DwDAzyGH A.3632@TK2MSFTN GP03.phx.gbl...
          Reidar,
          >
          The term "query" is not an unique term, can you explain it a little bit
          more?
          >
          Cor
          >
          "reidarT" <reidar@eivon.n oschreef in bericht
          news:ub1YIztyGH A.3464@TK2MSFTN GP03.phx.gbl...
          >>I have a dataset with 2 tables. I have madee a query of theese 2 tables.
          >When I look at the datasources the query is not shown.
          >How do I make a form with the query as source?
          >reidarT
          >>
          >
          >

            Comment

            • Dennis
              #4
              Re: MAking a bound form from a query

              You might want to look at the DataView Class to filter the DataTables then
              bind the DataView to a DataGrid, etc. However, I'm not sure you can filter
              two DataTables in a DataView but maybe you can investigate joining the tables
              first.
              --
              Dennis in Houston


              "reidarT" wrote:
              When I am in the dataset designer, I can right click an get the options
              DataTable, TableAdapter and Query when I click Add.
              I have made a query and I want to use this query in fom.
              reidarT
              >
              "Cor Ligthert [MVP]" <notmyfirstname @planet.nlskrev i melding
              news:e7DwDAzyGH A.3632@TK2MSFTN GP03.phx.gbl...
              Reidar,

              The term "query" is not an unique term, can you explain it a little bit
              more?

              Cor

              "reidarT" <reidar@eivon.n oschreef in bericht
              news:ub1YIztyGH A.3464@TK2MSFTN GP03.phx.gbl...
              >I have a dataset with 2 tables. I have madee a query of theese 2 tables.
              When I look at the datasources the query is not shown.
              How do I make a form with the query as source?
              reidarT
              >
              >
              >
              >

                Comment

                • Cor Ligthert [MVP]
                  #5
                  Re: MAking a bound form from a query

                  Reidar,

                  In my idea is that Query as it is a Select returning a whole table with the
                  GetBy.

                  That table you can than bind to your datagridview in the same way as you did
                  it with a fill.

                  Just a guess,

                  Cor

                  "reidarT" <reidar@eivon.n oschreef in bericht
                  news:OuD9XK5yGH A.3440@TK2MSFTN GP06.phx.gbl...
                  When I am in the dataset designer, I can right click an get the options
                  DataTable, TableAdapter and Query when I click Add.
                  I have made a query and I want to use this query in fom.
                  reidarT
                  >
                  "Cor Ligthert [MVP]" <notmyfirstname @planet.nlskrev i melding
                  news:e7DwDAzyGH A.3632@TK2MSFTN GP03.phx.gbl...
                  >Reidar,
                  >>
                  >The term "query" is not an unique term, can you explain it a little bit
                  >more?
                  >>
                  >Cor
                  >>
                  >"reidarT" <reidar@eivon.n oschreef in bericht
                  >news:ub1YIztyG HA.3464@TK2MSFT NGP03.phx.gbl.. .
                  >>>I have a dataset with 2 tables. I have madee a query of theese 2 tables.
                  >>When I look at the datasources the query is not shown.
                  >>How do I make a form with the query as source?
                  >>reidarT
                  >>>
                  >>
                  >>
                  >
                  >

                    Comment

                    Previous template Next
                    Working...