Best/easist way to store and access patient information?

Posted on 2004-11-20
Medium Priority
Last Modified: 2010-04-23
I'm new to .net and pretty frustrated...  I want to create a program that allows patient information to be entered at the front desk and then be accessed from another computer in the office to automatically fill in information in a simple billing program.  My problem is where / how to store the data... Should I set up a Access Database and program a front end for it, a random access file system which seems to be frowned upon in .net, or something I don't know about???  If possible an example of how to store the data from textboxes would be of great value to me.
Thanks in advance,

Question by:JGutches
  • 2

Accepted Solution

The_Biochemist earned 375 total points
ID: 12636614
Personally when I started out I used access quite a lot for similar things but as the database grows the faults start to grow. I did a similar project for private patient billing in a hospital laboratory.

It all really depends on scale... Access is good for small databases but can be clumsy to program. MSDE is a free version of SQL server 2000 (from Microsoft) and gives you the functionality of a full licence of SQL server 2000 but limited to 50 simultanious connections or so (i think). It will also give you the added advantage of being able to use stored procedures whch make programming and maintenance much simpler. You can also upgrade to a full SQL server installation if the need arises without having to change your code at all.

As far as .Net goes the system.data.SQLclient namespace and classes are highly optimised for SQL server making transactions much faster as opposed to being more generic for other data namespaces such as ODBC or OLEdb.

The basic outline is quite simple:

Basic Stored procedures:

* Get_Data (Select statement)
* Write _Data (Insert statement)
* Update_Data (Update statement)
* Delete_Data (Delete Statement)

getting data:
* create a connection to the database
* create a record set to accept your incoming data
* run a stored procedure such as a select statement thereby filling the record set
* close the connection
* populate your textboxes by iterating through the recordset

Write / Update / Delete situations:
* create a connection
* Run appropriate stored procedure
* Close connection

Hope this points you in the right direction... if you want more detail then just ask.

Author Comment

ID: 12647724
Thank you Biochemist.  I will take a look at SQL server however the database would probably be well within the capabilities of access.  I'm starting my first clinic as a chiropractor and would like to keep overhead low (few staff) with this application.  I will likely seek you advice more as I progress.  Thanks again.  -Jason

Expert Comment

ID: 12648155
Glad to be of help!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question