//frmAddMedicalTreatments.aspx
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using MySql.Data.MySqlClient;

public partial class frmAddMedicalTreatments : System.Web.UI.Page
{
    CDatabase con = new CDatabase();
    protected void Page_Load(object sender, EventArgs e)
    {
        LoadGrid();
        if (!Page.IsPostBack)
        {
            Apply();
            EditMedicalDetails();
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string getMedicaldetails = "select * from medicaltreatmentdetails where InpatientId='" + txtPatientId.Text + "'";
        MySqlDataReader dr = con.SqlReaderQuery(getMedicaldetails);
        if (dr.Read())
        {
            string updatemedicaldetails = "update  medicaltreatmentdetails set MedicineId='" + txtMedicineId.Text + "',quantity='" + txtQuantity.Text + "',total='" + txtTotal.Text + "' where Inpatientid='" + txtPatientId.Text + "' ";
            if (CDatabase.ExecuteSQL(updatemedicaldetails))
            {
                this.ClientScript.RegisterStartupScript(this.GetType(), "", "