|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
MAking a bound form from a queryI 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 Reidar,
The term "query" is not an unique term, can you explain it a little bit more? Cor Show quoteHide quote "reidarT" <rei***@eivon.no> schreef in bericht news:ub1YIztyGHA.3464@TK2MSFTNGP03.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 > 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 Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> skrev i melding news:e7DwDAzyGHA.3632@TK2MSFTNGP03.phx.gbl... > Reidar, > > The term "query" is not an unique term, can you explain it a little bit > more? > > Cor > > "reidarT" <rei***@eivon.no> schreef in bericht > news:ub1YIztyGHA.3464@TK2MSFTNGP03.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 >> > > 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. -- Show quoteHide quoteDennis 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]" <notmyfirstn***@planet.nl> skrev i melding > news:e7DwDAzyGHA.3632@TK2MSFTNGP03.phx.gbl... > > Reidar, > > > > The term "query" is not an unique term, can you explain it a little bit > > more? > > > > Cor > > > > "reidarT" <rei***@eivon.no> schreef in bericht > > news:ub1YIztyGHA.3464@TK2MSFTNGP03.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 > >> > > > > > > > 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 Show quoteHide quote "reidarT" <rei***@eivon.no> schreef in bericht news:OuD9XK5yGHA.3440@TK2MSFTNGP06.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]" <notmyfirstn***@planet.nl> skrev i melding > news:e7DwDAzyGHA.3632@TK2MSFTNGP03.phx.gbl... >> Reidar, >> >> The term "query" is not an unique term, can you explain it a little bit >> more? >> >> Cor >> >> "reidarT" <rei***@eivon.no> schreef in bericht >> news:ub1YIztyGHA.3464@TK2MSFTNGP03.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 >>> >> >> > > 
Other interesting topics
Timer driving me nuts
OK, new registry question vfp oledbcommand [Fail] validating textbox Resource and Time consuming stuff Virtual desktop makes .NET modal dialog panels disappear looking for tree/outline control that allows in-place editing AND will expand as I type How do I add a c++ library to my vb.net project? Looping through data adapter Jet error message when trying to create a DS from Excel |
|||||||||||||||||||||||
