tanmoy13 / Hospital-Management-System-ASP.net

2 stars 6 forks source link

database #2

Open ghost opened 5 years ago

ghost commented 5 years ago

could you share thıs database please

tanmoy13 commented 5 years ago

This worked fine for me. But now I have lost my db script. But I can provide you the database table info. There are 4 tables are required for this project. Their description is as below-

This table is used for storing user information who can book appointment

Table 1 name: signuplogin
Fields: username, password, email

This table is used to store doctors information whom are available in hospital

Table 2 name: Doctorinfo
Fields: id, Doctorsname, Qualification, Department, Specialization, Contact, ImageData

This talbe is used for website admins. You need to insert entity manually on this table from your database management system.

Table 3 name: admin
Fields: username, password

This table is used to store appointment information booked by user on the site.

Table 4 name: app
Fields: FirstName, LastName, Email, Nationality, Gender, Contact, Problem, Doctor

You can create tables and respective fields using the above information. Create tables and fields with the same name with considering case sensitivity for names. I think it will work fine for you also. And don't forget to change the database information from the Web.config file (in line no 29 and 30)-

<add name="mycon" connectionString="server=DESKTOP-SLN3MGD\SQLEXPRESS; Database = depression; User Id = 1307006; password = 122211;" />
    <add name="depressionConnectionString" connectionString="Data Source=DESKTOP-SLN3MGD\SQLEXPRESS;Initial Catalog=depression;Persist Security Info=True;User ID=1307006;Password=122211"

And be careful with the name "mycon". Don't cahange it.

ghost commented 5 years ago

Thank you tanmoy i will create a new one 😊

Windows 10 için Postahttps://go.microsoft.com/fwlink/?LinkId=550986 ile gönderildi


Gönderen: Tanmoy Tapos Datta notifications@github.com Gönderildi: Sunday, December 9, 2018 7:13:10 PM Kime: tanmoy13/Hospital-Management-System-ASP.net Bilgi: caglaralpi; Author Konu: Re: [tanmoy13/Hospital-Management-System-ASP.net] database (#2)

This worked fine for me. But now I have lost my db script. But I can provide you the database table info. There are 4 tables are required for this project. Their description is as below-

This table is used for storing user information who can book appointment

Table 1 name: signuplogin Fields: username, password, email

This table is used to store doctors information whom are available in hospital

Table 2 name: Doctorinfo Fields: id, Doctorsname, Qualification, Department, Specialization, Contact, ImageData

This talbe is used for website admins. You need to insert entity manually on this table from your database management system.

Table 3 name: admin Fields: username, password

This table is used to store appointment information booked by user on the site.

Table 4 name: app Fields: FirstName, LastName, Email, Nationality, Gender, Contact, Problem, Doctor

You can create tables and respective fields using the above information. Create tables and fields with the same name with considering case sensitivity for names. I think it will work fine for you also. And don't forget to change the database information from the Web.config file (in line no 29 and 30)-

<add name="depressionConnectionString" connectionString="Data Source=DESKTOP-SLN3MGD\SQLEXPRESS;Initial Catalog=depression;Persist Security Info=True;User ID=1307006;Password=122211"

And be careful with the name "mycon". Don't cahange it.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/tanmoy13/Hospital-Management-System-ASP.net/issues/2#issuecomment-445550066, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AgbfwnUrCgOjRI0hJQ8YiUvd3YaoAzgcks5u3TaWgaJpZM4ZKLbs.