I am using asp.net,c# and ms sql for my web application.
i have two tables
tableone
idno int identity(1,1),fullname varchar(200),mobileno varchar(200)

tabletwo code int idenity(1,1),totalpayment float, paidamount float,unpaidamount float, idno foreign key
the column idno in tableone is auto increment by one, but the idno in tabletwo should be added from tableone.
now i want to insert data at the same time to both of the tables.
but i get it hard how to insert the foreign key values
please help?