Health Care Support Worker & Acute Site Orientation
This presentation by Fraser Health covers the establishment of the Health Career Access Program, roles of health care support workers, obligations, schooling requirements, and payment details. Learn about the HCSW position, acronyms, and why the program was created to support acute care employers.
Download Presentation

Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Connecting to SQLServer Without using the Wizard Brief Introduction
The database I am using is DonorDB.mdf. The code on the next page will show how I set it up in code.
I commented out currpath and it worked fine. connStr is used to point to the data that is stored in the bin/debug (see previous page) sqlStr is the select to get what you need using SQL dataAdapter relates the connStr and the sqlStr and is used to declare the fill of donorDT which was defined as New DataTable The Sub FillTextBoxes() is where the data is taken from the database table and put into the next boxes. The btnNext moves through the records and restarts when they have all been shown.
The name of the grid I dragged to the screen is dgdBasic12.
In this example, I used a dataset rather than a table so since there is the possibility of more than one table, I used the dataset name.Tables(0) to indicate the first table. Note the SELECT which combines information from two tables.