Example #1
0
        public void dgMeds_Delete(object sender, DataGridCommandEventArgs e)
        {
            DataTool dbTool = new DataTool();

            string SelectedRowID = dgMeds.DataKeys[e.Item.ItemIndex].ToString();

            dbTool.deleteMedication(Int32.Parse(Session["PatientID"].ToString()), Int32.Parse(SelectedRowID));
            //string strSQL = "DELETE FROM PatientMedication WHERE MedicationID = " + SelectedRowID + " AND PatientID = " + Session["PatientID"] + ";";
            //clsUtility.ExecuteSQL(strSQL);

            // refresh the lists
            setupGrid();
        } //Done...  Tested