Inserting data in multiple table with one submit button

Question

Hi all, I am developing project on hospital management. I am entering the data of Patien details. like PatientsProfile: Id,Name,Age, Address, ContactNo PatientRelativeProfile: Admittername,Age,Address,ContactNo, Relationship Patients Defect Profile: Injury_Accident, Murder_Attempt, Cancer, Other Previous Treatment References: Hospitalname, Doctorname, TestDone Dates: DateOfJoining, PreviousDateOfVisit, Numberofvisit, ReferredDepartment. Note: For DateOfJoining and PreviousDateOfVisit values are taking from dropdownlist, for that in Dates table those type taken as DateTime. All the above information are kept in one single page. I have only one submit button. After filling the page once i click on submit button all the data should be stored in corresponding tables. Pls somebody help me with query...... Thanks, Sumit