|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
VB.NET 2005 TableAdapterIn VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily code
the query and parameter query by "Query Builder". I can build a single parameter or multi parameters SQL Query by using "Query Builder" (WHERE ClientCode = @ClientCode ....etc) But how about if I wanna to build a programmatic SQL statament, say if the User select ClientCode and OrderType buttom on UI, I will processing the SQL statment as: WHERE ClientCode ... AND OrderType .....; if the User select ClientCode and OrderType and Status, the SQL statement now processing as: WHERE ClientCode ... AND OrderType .... AND Status ...... Is that anyway to code the above SQL by "Query Builder" in TableAdapter !?
Show quote
"ken" <kk> wrote in message news:uJc5oZCoGHA.2264@TK2MSFTNGP04.phx.gbl... Sure, you can build your sql statement (however, please use Parameters even > In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily code > the > query and parameter query by "Query Builder". > > I can build a single parameter or multi parameters SQL Query by using > "Query Builder" > (WHERE ClientCode = @ClientCode ....etc) > But how about if I wanna to build a programmatic SQL statament, > say if the User select ClientCode and OrderType buttom on UI, > I will processing the SQL statment as: WHERE ClientCode ... AND OrderType > ....; > if the User select ClientCode and OrderType and Status, the SQL statement > now processing as: > WHERE ClientCode ... AND OrderType .... AND Status ...... > > Is that anyway to code the above SQL by "Query Builder" in TableAdapter > !? if you're building dynamic sql b/c otherwise there's a lot of headaches associated with not using parameters) and then set the string to the TableAdapter's SelectCommand (or UpdateCommand/DeleteCommand/InsertCommand) Show quote > > >
Show quote
"W.G. Ryan eMVP" <WilliamR***@gmail.com> ¼¶¼g©ó¶l¥ó·s»D:OTaOkEGoGHA.1***@TK2MSFTNGP02.phx.gbl... for example, I wanna to use daynamic SQL condition, say @Condition,> > "ken" <kk> wrote in message news:uJc5oZCoGHA.2264@TK2MSFTNGP04.phx.gbl... >> In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily code >> the >> query and parameter query by "Query Builder". >> >> I can build a single parameter or multi parameters SQL Query by using >> "Query Builder" >> (WHERE ClientCode = @ClientCode ....etc) >> But how about if I wanna to build a programmatic SQL statament, >> say if the User select ClientCode and OrderType buttom on UI, >> I will processing the SQL statment as: WHERE ClientCode ... AND OrderType >> ....; >> if the User select ClientCode and OrderType and Status, the SQL statement >> now processing as: >> WHERE ClientCode ... AND OrderType .... AND Status ...... >> >> Is that anyway to code the above SQL by "Query Builder" in TableAdapter >> !? > Sure, you can build your sql statement (however, please use Parameters > even if you're building dynamic sql b/c otherwise there's a lot of > headaches associated with not using parameters) and then set the string to > the TableAdapter's SelectCommand (or > UpdateCommand/DeleteCommand/InsertCommand) sometimes I only search with ClientCode, sometimes I search with 3 or 4 criteria... " Select * from TABLE1 WHERE @Condition " how can it works? for now, I can only use Query Builder in TableAdapter, build the parameterize SQL statement one by one, can I only make 1 wildcard SQL statement instead of build many of them!? thx
Show quote
"ken" <kk> wrote in message news:eqRSRyGoGHA.4352@TK2MSFTNGP02.phx.gbl... -With the Visual tools you can only do one at a time. However nothing is > > "W.G. Ryan eMVP" <WilliamR***@gmail.com> > ¼¶¼g©ó¶l¥ó·s»D:OTaOkEGoGHA.1***@TK2MSFTNGP02.phx.gbl... >> >> "ken" <kk> wrote in message news:uJc5oZCoGHA.2264@TK2MSFTNGP04.phx.gbl... >>> In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily >>> code the >>> query and parameter query by "Query Builder". >>> >>> I can build a single parameter or multi parameters SQL Query by using >>> "Query Builder" >>> (WHERE ClientCode = @ClientCode ....etc) >>> But how about if I wanna to build a programmatic SQL statament, >>> say if the User select ClientCode and OrderType buttom on UI, >>> I will processing the SQL statment as: WHERE ClientCode ... AND >>> OrderType ....; >>> if the User select ClientCode and OrderType and Status, the SQL >>> statement now processing as: >>> WHERE ClientCode ... AND OrderType .... AND Status ...... >>> >>> Is that anyway to code the above SQL by "Query Builder" in TableAdapter >>> !? >> Sure, you can build your sql statement (however, please use Parameters >> even if you're building dynamic sql b/c otherwise there's a lot of >> headaches associated with not using parameters) and then set the string >> to the TableAdapter's SelectCommand (or >> UpdateCommand/DeleteCommand/InsertCommand) > > for example, I wanna to use daynamic SQL condition, say @Condition, > sometimes I only search with ClientCode, sometimes I search with 3 or 4 > criteria... > " Select * from TABLE1 WHERE @Condition " > how can it works? > > for now, I can only use Query Builder in TableAdapter, build the > parameterize SQL statement > one by one, can I only make 1 wildcard SQL statement instead of build many > of them!? stopping you from creating the command (I'd actually advise using the DataAccess Application Block or Enterprise LIbrary since they have a nice way of handling parameters) Show quote > > thx > > >
Show quote
"W.G. Ryan eMVP" <WilliamR***@gmail.com> ¼¶¼g©ó¶l¥ó·s»D:eTjJL5ToGHA.1***@TK2MSFTNGP05.phx.gbl... thx Ryan,> > "ken" <kk> wrote in message news:eqRSRyGoGHA.4352@TK2MSFTNGP02.phx.gbl... >> >> "W.G. Ryan eMVP" <WilliamR***@gmail.com> ¼¶¼g©ó¶l¥ó·s»D:OTaOkEGoGHA.1***@TK2MSFTNGP02.phx.gbl... >>> >>> "ken" <kk> wrote in message >>> news:uJc5oZCoGHA.2264@TK2MSFTNGP04.phx.gbl... >>>> In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily >>>> code the >>>> query and parameter query by "Query Builder". >>>> >>>> I can build a single parameter or multi parameters SQL Query by using >>>> "Query Builder" >>>> (WHERE ClientCode = @ClientCode ....etc) >>>> But how about if I wanna to build a programmatic SQL statament, >>>> say if the User select ClientCode and OrderType buttom on UI, >>>> I will processing the SQL statment as: WHERE ClientCode ... AND >>>> OrderType ....; >>>> if the User select ClientCode and OrderType and Status, the SQL >>>> statement now processing as: >>>> WHERE ClientCode ... AND OrderType .... AND Status ...... >>>> >>>> Is that anyway to code the above SQL by "Query Builder" in TableAdapter >>>> !? >>> Sure, you can build your sql statement (however, please use Parameters >>> even if you're building dynamic sql b/c otherwise there's a lot of >>> headaches associated with not using parameters) and then set the string >>> to the TableAdapter's SelectCommand (or >>> UpdateCommand/DeleteCommand/InsertCommand) >> >> for example, I wanna to use daynamic SQL condition, say @Condition, >> sometimes I only search with ClientCode, sometimes I search with 3 or 4 >> criteria... >> " Select * from TABLE1 WHERE @Condition " >> how can it works? >> >> for now, I can only use Query Builder in TableAdapter, build the >> parameterize SQL statement >> one by one, can I only make 1 wildcard SQL statement instead of build >> many of them!? > -With the Visual tools you can only do one at a time. However nothing is > stopping you from creating the command (I'd actually advise using the > DataAccess Application Block or Enterprise LIbrary since they have a nice > way of handling parameters) >> I just wonder can I use the embedded tools keep it simple, instead of written SQL and Command by myself. I will try to build my own SQL data access component. Last question, do you have any suggestion free license/ coding example about DataAccess Block whether I can find on internet ? Microsoft's Enterprise Library is free to use so it's probably your best
bet. Show quote "ken" <kk> wrote in message news:%23ZU4lbdoGHA.2112@TK2MSFTNGP04.phx.gbl... > > "W.G. Ryan eMVP" <WilliamR***@gmail.com> > ¼¶¼g©ó¶l¥ó·s»D:eTjJL5ToGHA.1***@TK2MSFTNGP05.phx.gbl... >> >> "ken" <kk> wrote in message news:eqRSRyGoGHA.4352@TK2MSFTNGP02.phx.gbl... >>> >>> "W.G. Ryan eMVP" <WilliamR***@gmail.com> >>> ¼¶¼g©ó¶l¥ó·s»D:OTaOkEGoGHA.1***@TK2MSFTNGP02.phx.gbl... >>>> >>>> "ken" <kk> wrote in message >>>> news:uJc5oZCoGHA.2264@TK2MSFTNGP04.phx.gbl... >>>>> In VB.NET 2005, the ADO.NET provide TableAdapter for Developer eaily >>>>> code the >>>>> query and parameter query by "Query Builder". >>>>> >>>>> I can build a single parameter or multi parameters SQL Query by using >>>>> "Query Builder" >>>>> (WHERE ClientCode = @ClientCode ....etc) >>>>> But how about if I wanna to build a programmatic SQL statament, >>>>> say if the User select ClientCode and OrderType buttom on UI, >>>>> I will processing the SQL statment as: WHERE ClientCode ... AND >>>>> OrderType ....; >>>>> if the User select ClientCode and OrderType and Status, the SQL >>>>> statement now processing as: >>>>> WHERE ClientCode ... AND OrderType .... AND Status ...... >>>>> >>>>> Is that anyway to code the above SQL by "Query Builder" in >>>>> TableAdapter !? >>>> Sure, you can build your sql statement (however, please use Parameters >>>> even if you're building dynamic sql b/c otherwise there's a lot of >>>> headaches associated with not using parameters) and then set the string >>>> to the TableAdapter's SelectCommand (or >>>> UpdateCommand/DeleteCommand/InsertCommand) >>> >>> for example, I wanna to use daynamic SQL condition, say @Condition, >>> sometimes I only search with ClientCode, sometimes I search with 3 or 4 >>> criteria... >>> " Select * from TABLE1 WHERE @Condition " >>> how can it works? >>> >>> for now, I can only use Query Builder in TableAdapter, build the >>> parameterize SQL statement >>> one by one, can I only make 1 wildcard SQL statement instead of build >>> many of them!? >> -With the Visual tools you can only do one at a time. However nothing is >> stopping you from creating the command (I'd actually advise using the >> DataAccess Application Block or Enterprise LIbrary since they have a >> nice way of handling parameters) >>> > > thx Ryan, > > I just wonder can I use the embedded tools keep it simple, instead of > written SQL and Command by myself. > I will try to build my own SQL data access component. Last question, do > you have any suggestion > free license/ coding example about DataAccess Block whether I can find on > internet ? >  |
|||||||||||||||||||||||
Other interesting topics