public void grdpl1_UpdateCommand(object sender, DataGridCommandEventArgs e)
 {
     String DetailId = grdpl1.DataKeys[Convert.ToInt32(e.Item.ItemIndex)].ToString();
     Whitfieldcore _dbClass = new Whitfieldcore();
     _dbClass.UPDATEMasterMaterials(Convert.ToInt32(DetailId), ((TextBox)(e.Item.FindControl("txtReference_Number"))).Text, ((TextBox)(e.Item.FindControl("txtDescription"))).Text, "", "N", ((TextBox)(e.Item.FindControl("txtComments"))).Text);
     grdpl1.EditItemIndex = -1;
     grdpl1.ShowFooter = true;
     this.DisplayGrid();
 }