Larry,

One easy way to get the code necessary to add/update/delete records is to use the DataAdapter wizard. It will create the code which you can use or tweak to your own liking.

>thanks for the reply...
>
>can u give me easy coding for add/edit/delete of the table like this..
>
>ORDER and ORDERDETAIL
>
>using VB code
>
>tia
>
>>Hi Larry,
>>
>>The CommandBuilder is nice to use for testing on the fly but for production work I would not recommend using it. The commands are created at runtime so there is a performance penalty.
>>
>>>hi,
>>>
>>>is the commandbuilder in dataadapter is the best to use?
>>>
>>>TIA