Home All Groups Group Topic Archive Search About

how modify table adapter update and insert

Author
23 Jun 2006 1:44 AM
fanor
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.

Author
23 Jun 2006 4:26 AM
Cor Ligthert [MVP]
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.
>
>
Author
23 Jun 2006 3:15 PM
Fanor
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.
>>
>>
>
>
Author
23 Jun 2006 3:35 PM
Cor Ligthert [MVP]
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.
>>>
>>>
>>
>>
>
>

AddThis Social Bookmark Button