how to insert one Parent and Multiple child records into SQL Serve

#1

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#2

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#3

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#4

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#5

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#6

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#7

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#8

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#9

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

#10

I guess I don't understand. You have the new OrderID and you're using it to
populate another table already. Why can't you use it for all the other
populations as well?
Are you returning the new OrderID back to C#? Because that's your answer.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com

"Hezal" wrote:

Quote:

Hi,
I have created 2 tables, Orders and Order Items. Using C# I am able to add
a single order and use that order's ID as an input for OrdersItems table to
insert one record within a Transaction.
But I need to have multiple order items for one order.

Please help, as I urgently need to solve my problem...
Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to insert one Parent and Multiple child records into SQL Serve

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

how to insert one Parent and Multiple child records into SQL Serve - 04-15-2008 , 10:34 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM

RE: how to insert one Parent and Multiple child records into SQL Serve - 05-23-2008 , 09:52 AM