private void btnDelete_Click(object sender, EventArgs e)
 {
     if (listView1.SelectedItems.Count == 1)
      {
          try
          {
              App_Data.PisDataSetTableAdapters.HistoryTableAdapter myHstAd = new App_Data.PisDataSetTableAdapters.HistoryTableAdapter();
              myHstAd.DeleteByIdQuery(Convert.ToInt32(comboBox1.Items[listView1.FocusedItem.Index].ToString()));
              App_Data.PisDataSet.HistoryDataTable myHstTbl = new App_Data.PisDataSet.HistoryDataTable();
              myHstAd.FillHistoryBy(myHstTbl, Classes.publicClass.PatientID);
              comboBox1.Items.Clear();
              listView1.Items.Clear();
              WriteListView(myHstTbl);
              MessageBox.Show("Record Deleted Successfully!");
          }
          catch (Exception exc)
          {
              MessageBox.Show(exc.Message);
          }
      }
      else
      {
          MessageBox.Show("Make sure you have selected history item to be deleted");
      }
 }
        private void history_Load(object sender, EventArgs e)
        {
            App_Data.PisDataSetTableAdapters.HistoryTableAdapter HDa = new App_Data.PisDataSetTableAdapters.HistoryTableAdapter();
            App_Data.PisDataSet.HistoryDataTable myHsttable = new App_Data.PisDataSet.HistoryDataTable();

            HDa.FillHistoryBy(myHsttable, Classes.publicClass.PatientID);
            WriteListView(myHsttable);
        }
        private void button1_Click(object sender, EventArgs e)
        {
            try
             {
                 App_Data.PisDataSetTableAdapters.HistoryTableAdapter HDa = new App_Data.PisDataSetTableAdapters.HistoryTableAdapter();
                 App_Data.PisDataSet.HistoryDataTable myHsttable = new App_Data.PisDataSet.HistoryDataTable();
                 HDa.InsertHistoryQuery(Convert.ToDateTime(Convert.ToDateTime(txtDate.Text).ToShortDateString()), txtDescription.Text, Convert.ToInt32(txtCharges.Text), Convert.ToInt32(txtPaid.Text), Convert.ToInt32(txtBalance.Text), Classes.publicClass.PatientID);
                 HDa.FillHistoryBy(myHsttable, Classes.publicClass.PatientID);
                 listView1.Items.Clear();
                 comboBox1.Items.Clear();
                 WriteListView(myHsttable);

             }
             catch (Exception exc)
             {
                 MessageBox.Show("Verify Input " + exc.Message);
             }
        }