insert data in multiple table with single button click

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

Answer 1

sumit you should spend some time designing... things like what data needs to go into what table.. what should be the flow of your program. how individual queries would look like... its always a good idea to do some designing and then start coding