单击按钮即可在多个表中插入数据

I am developing project on hospital management. I am entering the data of Patien details. like

我正在开发医院管理项目。我正在输入Patien细节的数据。喜欢

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.

注意:对于DateOfJoining和PreviousDateOfVisit值来自下拉列表,对于Dates表中的值,将这些类型视为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.

以上所有信息都保存在一个页面中。我只有一个提交按钮。在我点击提交按钮后填写页面后,所有数据都应存储在相应的表中。

Please somebody help me with query......

请有人帮我查询......

1 个解决方案

#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

总结一下,你应该花一些时间来设计......比如什么数据需要进入什么表......你的程序应该是什么样的流程。个别查询的外观如何......做一些设计然后开始编码总是一个好主意