insert data in to all table in one form

Question

 i am a newbie to SQL programming, i have created a database which has 6 tables connected to each other by foreign keys.

my problem is how do i insert data into all the tables at once considering the foreign keys they have.

i just need a sample script which shows how to insert data into all the six tables at once..

thank you for your in advance.

i need a sample with
sqlcommand AND dataset AND linq
you can Supposed northwind db for samplev