quetion about identity, dataadapter

26 Feb 2007 9:55 AM

Felix González

Hi

I´ve 2 tables (order and order details), In my application I´ve 2 Datatable
with 2 dataadapter. The primary key of table orders it´s and Identity the
table details has foreign key with the identity of orders. How can insert in
table order and details. I more than one record on table orders and I want
to send all at time to database.

Where can I find information obout that?

thanks

26 Feb 2007 11:55 PM

William (Bill) Vaughn

Start with my article on handling Identity issues (managing an @@identity
crisis) http://www.betav.com/msdn_magazine.htm.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

Show quote

"Felix González" <felix.gonza***@gvgest.es> wrote in message
news:ux4PHwYWHHA.4720@TK2MSFTNGP04.phx.gbl...
> Hi
>
> I´ve 2 tables (order and order details), In my application I´ve 2
> Datatable with 2 dataadapter. The primary key of table orders it´s and
> Identity the table details has foreign key with the identity of orders.
> How can insert in table order and details. I more than one record on table
> orders and I want to send all at time to database.
>
> Where can I find information obout that?
>
> thanks
>