protected void LoadData()
 {
     b                    = new BLcode();
     b.UserID             = Request.Cookies["userid"].Value;
     ds                   = b.CallSelectData();
     GridView1.DataSource = ds.Tables[1];
     GridView1.DataBind();
 }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        b = new BLcode();
        TextBox t1  = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt1");
        TextBox t2  = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt2");
        TextBox t3  = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt3");
        Label   lbl = (Label)GridView1.Rows[e.RowIndex].FindControl("lbl4");

        b.MedicineName = t1.Text;
        b.Dosage       = t2.Text;
        b.Stock        = int.Parse(t3.Text);
        b.UserID       = Request.Cookies["userid"].Value;
        b.ID           = int.Parse(lbl.Text);
        b.CallUpdateMedicines();
        b.CallSelectData();
        GridView1.EditIndex = -1;
        LoadData();
    }