Member Avatar for saranyashanthi

hai
can any one help me to write the codings for hospital management in visual basic on basic forms of bloode donation list,admission form,etc

  • 4 Contributors
  • 3 Replies
  • 98 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by PoisonedHeart

Dani AI

Generated

Request recorded by asked for a Visual Basic hospital management app. correctly noted that helpers need specifics; asked whether the target is VB6 or VB.NET and which database; asked to see existing work. Below is a concise, practical starter plan and a minimal schema that remain useful for either legacy VB6 projects or modern VB.NET builds.

Choose the stack by scope: for new development prefer VB.NET with Visual Studio Community and SQL Server Express (or SQLite for a single-file prototype). For maintenance of old code, VB6 + ADO is workable but limits modern libraries. Use parameterized queries (ADO.NET or ADO) and transactions for critical operations; avoid Access on multi-user installs. Plan roles (clerk, nurse, admin) and an audit trail from the start.

A minimal relational schema to support patient records, admissions, donors and blood units (SQL Server style):

CREATE TABLE Patients (
  PatientID INT IDENTITY(1,1) PRIMARY KEY,
  MRN NVARCHAR(20) NOT NULL,
  LastName NVARCHAR(100),
  FirstName NVARCHAR(100),
  DOB DATE,
  Gender CHAR(1)
);

CREATE TABLE Admissions (
  AdmissionID INT IDENTITY(1,1) PRIMARY KEY,
  PatientID INT NOT NULL,
  AdmissionDate DATETIME NOT NULL,
  DischargeDate DATETIME NULL,
  Ward NVARCHAR(50)
);

CREATE TABLE Donors (
  DonorID INT IDENTITY(1,1) PRIMARY KEY,
  Name NVARCHAR(200),
  BloodGroup NVARCHAR(3),
  LastDonation DATE
);

CREATE TABLE BloodInventory (
  UnitID INT IDENTITY(1,1) PRIMARY KEY,
  DonorID INT NULL,
  BloodType NVARCHAR(3),
  Collected DATE,
  Expiry DATE,
  Status NVARCHAR(20)
);

Implement CRUD forms with field validation, server-side checks, and concurrency control (rowversion/timestamp on records used by multiple users). Secure patient data: least privilege database accounts, TLS for connections, encrypted backups, and audit logging to meet applicable privacy laws. Common pitfalls: wrong connection strings, mismatched provider versions in VB6, using Access for concurrent writes, and missing transaction boundaries—these cause most production failures.

Recommended Answers

All 3 Replies

Member Avatar for WaltP

hai
can any one help me to write the codings for hospital management in visual basic on basic forms of bloode donation list,admission form,etc

Since we aren't medical professionals, not with the information given. But we can help with the coding when you get stuck.

Member Avatar for AndreRet

As I have mentioned in the post that you had originally hijacked, give us more information.

Using VB6?
What database, sql, mysql, access?
What code thus far from your side?

etc. etc. etc.

Member Avatar for PoisonedHeart

can any one help me to write the codings for hospital management in visual basic on basic forms of bloode donation list,admission form,etc

Yes, we can help you but see to it that we can see what have you done so far with your project, if there's a thing that confuses you or don't know the "how's", then feel free to post and ask...:)

Edited by PoisonedHeart because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.