PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET how modify table adapter update and insert

Reply

how modify table adapter update and insert

 
Thread Tools Rate Thread
Old 23-06-2006, 02:44 AM   #1
fanor
Guest
 
Posts: n/a
Default how modify table adapter update and insert


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.


  Reply With Quote
Old 23-06-2006, 05:26 AM   #2
Cor Ligthert [MVP]
Guest
 
Posts: n/a
Default Re: how modify table adapter update and insert

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...12-d7c12bbb3726

I hope this helps,

Cor

"fanor" <xfponce@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.
>
>



  Reply With Quote
Old 23-06-2006, 04:15 PM   #3
Fanor
Guest
 
Posts: n/a
Default Re: how modify table adapter update and insert

I'm using vs2005, c#, and access database.

"Cor Ligthert [MVP]" <notmyfirstname@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...12-d7c12bbb3726
>
> I hope this helps,
>
> Cor
>
> "fanor" <xfponce@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.
>>
>>

>
>



  Reply With Quote
Old 23-06-2006, 04:35 PM   #4
Cor Ligthert [MVP]
Guest
 
Posts: n/a
Default Re: how modify table adapter update and insert

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

"Fanor" <xreed2000@yahoo.com> schreef in bericht
news:OLDJcctlGHA.5036@TK2MSFTNGP05.phx.gbl...
> I'm using vs2005, c#, and access database.
>
> "Cor Ligthert [MVP]" <notmyfirstname@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...12-d7c12bbb3726
>>
>> I hope this helps,
>>
>> Cor
>>
>> "fanor" <xfponce@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.
>>>
>>>

>>
>>

>
>



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off