当前位置: 动力学知识库 > 问答 > 编程问答 >

c# - Id in Database what datatype use?

问题描述:

I am working with Access database for a C# winform application.I want to create software, which stores the patient's details.I have assigned a patient_Id for each patient, Patient_Id is of "AutoNumber" datatype so that it will automatically increment. My problem is when same patient comes again then New Patient_Id automatically generated to store his new current data, but for same patient I want only one ID.

网友答案:

Use some unique data as a field in your patient table (such as social security) and when a patient comes, look up this unique number and determine if he is a new patient or a returning one. This is a simple SELECT query something like:

"SELECT patient_Id FROM tPatients WHERE [email protected]"
分享给朋友:
您可能感兴趣的文章:
随机阅读: