DATAGRID

  public void dg_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   dg.EditItemIndex=-1;
   dg.DataSource=dst;
   dg.DataBind();
  }

  public void dg_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string code=e.Item.Cells[1].Text;
   
   SqlParameter[] ArrParam={ new SqlParameter("@code",SqlDbType.VarChar) };
   ArrParam[0].Value=code;

            DB.db db=new DB.db();
   try
   {
    db.ExecuteSql("DelLabCatalog",ArrParam);
   }
   catch(Exception Err)
   {
    Response.Write("<script language='javascript'>alert(/"ﾊｾﾝﾉｾｳﾊｧｰﾜ//n"+Err.Message+"/")</script>");
   }

   myDataBind();

   if(dst.Tables[0].Rows.Count<=0)
   {
    dg.Visible=false;
    string js=@"<script language='javascript'>MessageNoData('myDiv');";
    js+="</script>";
    if(!this.IsStartupScriptRegistered("Startup"))
     this.RegisterStartupScript("Startup", js);
    return;
   }
   //dg.DataSource=dst;
   dg.DataBind();
  }

  public void dg_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   dg.EditItemIndex=e.Item.ItemIndex;
   myDataBind();
   dg.DataBind();

   string js=@"<script language='javascript'>function EditDgData()";
   js+="{ ";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').maxLength=10;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').size=6;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').style.color='#00836A';";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[2].Controls[0].UniqueID + "').focus();";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[3].Controls[0].UniqueID + "').maxLength=20;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[3].Controls[0].UniqueID + "').size=35;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[3].Controls[0].UniqueID + "').style.color='#00836A';";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[4].Controls[0].UniqueID + "').maxlength=10;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[4].Controls[0].UniqueID + "').size=6;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[4].Controls[0].UniqueID + "').style.color='#00836A';";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[5].Controls[0].UniqueID + "').maxlength=15;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[5].Controls[0].UniqueID + "').size=15;";
   js+="document.all('" + dg.Items[e.Item.ItemIndex].Cells[5].Controls[0].UniqueID + "').style.color='#00836A';";
   js+="}";
   js+="setTimeout(EditDgData,1);</script>";

   if (!IsClientScriptBlockRegistered("clientScript"))
   {
    RegisterClientScriptBlock("clientScript", js);
   }

  }

  public void dg_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string code=e.Item.Cells[1].Text.Trim();
 
   TextBox txtxcode=(TextBox)e.Item.Cells[2].Controls[0] ;
   string xcode=txtxcode.Text.Trim();

   TextBox txtname=(TextBox)e.Item.Cells[3].Controls[0];
   string name=txtname.Text.Trim();

   TextBox txtunit=(TextBox)e.Item.Cells[4].Controls[0];
   string unit=txtunit.Text.Trim();

   TextBox txtgg=(TextBox)e.Item.Cells[5].Controls[0];
   string gg=txtgg.Text.Trim();
           
   SqlParameter[] arr={ new SqlParameter("@code",SqlDbType.VarChar),
         new SqlParameter("@xcode",SqlDbType.VarChar),
         new SqlParameter("@name",SqlDbType.VarChar),
            new SqlParameter("@gg",SqlDbType.VarChar),
         new SqlParameter("@unit",SqlDbType.VarChar)
        };
   arr[0].Value=code;
   arr[1].Value=xcode;
   arr[2].Value=name;
   arr[3].Value=unit;
   arr[4].Value=gg;
   
   updateData("UpdataLabInf",arr);
   dg.EditItemIndex=-1;
   myDataBind();
   dg.DataBind();
  }

  private void dg_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  {
   dg.CurrentPageIndex=e.NewPageIndex;
   myDataBind();
            dg.DataBind();
  }

  private void dg_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   if (e.Item.ItemIndex != -1)
   { 
    LinkButton del = (LinkButton)e.Item.Cells[e.Item.Cells.Count-1].Controls[0];
    del.Attributes["onclick"] = "return confirm('ﾈｷｶｨﾒｪﾉｾｳｸﾃﾌﾇﾂｼﾂｿ');";
   }
  }