Best/easist way to store and access patient information?

Posted on 2004-11-20
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
    LVL 6

    Accepted Solution

    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 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

    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
    LVL 6

    Expert Comment

    Glad to be of help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Article by: jpaulino
    XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String ( Literal, only instead of starting and ending with w…
    A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now