|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how modify table adapter update and insertI generated using the designer the fill and GetData methods for a table,
including delete, insert, and update. I want to customize the insert and update command. How can i do that?? I tried from the designer but I couldn't figured it out. Thanks a lot guys. Fanor,
The designer generated code from version 2002/2003 and version 2005 is completely different and therefore is it at least very difficult to help you as you don't tell which version and program language and what database you are using. See here how you can create yourself insert/delete/update commands for a non generated dataset for SQLServer (OleDB is as well on our website) http://www.vb-tips.com/dbPages.aspx?ID=3405596d-4556-4aa8-be12-d7c12bbb3726 I hope this helps, Cor Show quote "fanor" <xfpo***@hotmail.com> schreef in bericht news:%23rJ3LZmlGHA.2304@TK2MSFTNGP02.phx.gbl... >I generated using the designer the fill and GetData methods for a table, >including delete, insert, and update. > > I want to customize the insert and update command. How can i do that?? > I tried from the designer but I couldn't figured it out. > > Thanks a lot guys. > > I'm using vs2005, c#, and access database.
Show quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:Oa3ApznlGHA.1552@TK2MSFTNGP04.phx.gbl... > Fanor, > > The designer generated code from version 2002/2003 and version 2005 is > completely different and therefore is it at least very difficult to help > you as you don't tell which version and program language and what > database you are using. > > See here how you can create yourself insert/delete/update commands for a > non generated dataset for SQLServer (OleDB is as well on our website) > > http://www.vb-tips.com/dbPages.aspx?ID=3405596d-4556-4aa8-be12-d7c12bbb3726 > > I hope this helps, > > Cor > > "fanor" <xfpo***@hotmail.com> schreef in bericht > news:%23rJ3LZmlGHA.2304@TK2MSFTNGP02.phx.gbl... >>I generated using the designer the fill and GetData methods for a table, >>including delete, insert, and update. >> >> I want to customize the insert and update command. How can i do that?? >> I tried from the designer but I couldn't figured it out. >> >> Thanks a lot guys. >> >> > > Did you try the sample,
The same is for OleDb on our website, I saw later on your earlier message what you was using but the difference is not that big. Cor Show quote "Fanor" <xreed2***@yahoo.com> schreef in bericht news:OLDJcctlGHA.5036@TK2MSFTNGP05.phx.gbl... > I'm using vs2005, c#, and access database. > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:Oa3ApznlGHA.1552@TK2MSFTNGP04.phx.gbl... >> Fanor, >> >> The designer generated code from version 2002/2003 and version 2005 is >> completely different and therefore is it at least very difficult to help >> you as you don't tell which version and program language and what >> database you are using. >> >> See here how you can create yourself insert/delete/update commands for a >> non generated dataset for SQLServer (OleDB is as well on our website) >> >> http://www.vb-tips.com/dbPages.aspx?ID=3405596d-4556-4aa8-be12-d7c12bbb3726 >> >> I hope this helps, >> >> Cor >> >> "fanor" <xfpo***@hotmail.com> schreef in bericht >> news:%23rJ3LZmlGHA.2304@TK2MSFTNGP02.phx.gbl... >>>I generated using the designer the fill and GetData methods for a table, >>>including delete, insert, and update. >>> >>> I want to customize the insert and update command. How can i do that?? >>> I tried from the designer but I couldn't figured it out. >>> >>> Thanks a lot guys. >>> >>> >> >> > > |
|||||||||||||||||||||||