WEB开发网
开发学院WEB开发Jsp DataGrid Web Control 基本操作 阅读

DataGrid Web Control 基本操作

 2008-01-05 11:07:45 来源:WEB开发网   
核心提示:dgCategory是用于显示类别表的DataGrid自动分页:AllowPaging= TRUE!!!!PRivate void dgCategory_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventA

  dgCategory是用于显示类别表的DataGrid
  
  自动分页:AllowPaging= TRUE!!!!
  
  PRivate void dgCategory_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
  
  {
  
  dgCategory.CurrentPageIndex=e.NewPageIndex;
  
  dgCategory.DataBind();
  
  }
  
  排序:默认按“PKId”排序
  
  private void dgCategory_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
  
  {
  
  string SortOrder=e.SortEXPression.ToString();
  
  BindData(SortOrder);
  
  }
  
  private void BindData(string SortOrder)
  
  {
  
  ProdUCtSystem productSys=new ProductSystem();//底层数据接口
  
  CategoryData categorySet=productSys.GetCategories(1); //底层数据接口,返回ID为1的Category
  
  DataView   categoryView=categorySet.Tables[CategoryData.CATEGORIES_TABLE].DefaultView;
  
  categoryView.Sort=SortOrder;
  
  lblTitle.Text="按"+SortOrder+"排序";
  
  dgCategory.DataSource=categoryView;
  
  dgCategory.DataBind();
  
  }
  
  private void Page_Load(object sender, System.EventArgs e)
  
  {
  
  BindData("PKId");
  
  }
  
  编辑,更新,取消:
  
  private void dgCategory_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  
  {
  
  dgCategory.EditItemIndex=e.Item.ItemIndex;
  
  BindData("PKId");
  
  }
  
  private void dgCategory_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  
  {
  
  dgCategory.EditItemIndex=-1;
  
  BindData("PKId");
  
  }
  
  private void dgCategory_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  
  {
  
  string strUpdate="";
  
  strUpdate+="PKId='"+((TextBox)e.Item.Cells[1].Controls[0])。Text+"'";
  
  strUpdate+="ParentId='"+((TextBox)e.Item.Cells[2].Controls[0])。Text+"'";
  
  strUpdate+="Description='"+((TextBox)e.Item.Cells[3].Controls[0])。Text+"'";
  
  strUpdate+="IsLeaf='"+((TextBox)e.Item.Cells[4].Controls[0])。Text+"'";
  
  try
  
  {
  
  CagegorySet.ExecuteUpdate(strUpdate);//需要后台提供更新的接口
  
  dgCategory.EditItemIndex=-1;
  
  }
  
  catch
  
  {
  
  Response.Write("<;script language='javascript'>alert('未能完成更新,请…………')<;/script>");
  
  }
  
  BindData("PKId");
  
  }
  
  private void dgCategory_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  
  {
  
  //获得要害字,使用DataKeys集合访问数据列表控件中每个记录的键值(显示为一行)
  
  //使得用户可以存储键字段而无需在控件中显示它
  
  string PKId=dgCategory.DataKeys[e.Item.ItemIndex];
  
  CategorySet.ExecuteDelete(PKId);
  
  }*/

Tags:DataGrid Web Control

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接