I have a Cusomer table that contains customer info.
I also have a Prescription table that contains Drug Prescriptions info.
My current set up and logic are that a user wants to transfer his or her prescriptions to our pharmacy, the user completes a form, providing his or her personal information, the name and telephone number of the pharmacy s/he is transferring his or her prescriptions
from, and prescriptions s/he wishes to transfer (up to 6 prescriptions at one time).
The code below helps accomplish these things described above.
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim s As String
Dim sql As String
Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;data source=" & Server.MapPath("App_Data\GCP.accdb")
Try
SetRowData()
Dim table As DataTable = TryCast(ViewState("CurrentTable"), DataTable)
If table Is ...
Go to the complete details ...