DataGrid常见操作

一：为DataGrid添加简单的风格

                            <asp:datagrid id="dgRecord" runat="server" Width="100%" AutoGenerateColumns="False" HorizontalAlign="Center"
                                Font-Names="宋体" Font-Size="9pt">
                                <AlternatingItemStyle CssClass="tr_color"></AlternatingItemStyle>
                                <HeaderStyle Font-Size="9pt" Font-Names="宋体" HorizontalAlign="Center" Height="20px" VerticalAlign="Middle"
                                    BackColor="#A3C2D1"></HeaderStyle>

二：为DataGrid网格添加一"选择"列       

                                <asp:TemplateColumn HeaderText="选择">
                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
                                    <ItemTemplate>
                                        <asp:CheckBox id="cbSelect" runat="server"></asp:CheckBox>
                                    </ItemTemplate>
                                </asp:TemplateColumn>

        处理"选择"列的通用函数：
       

        //取得DataGrid中所有所选的记录集
        DataGrid#region DataGrid
        public static ArrayList GetDataGridSelectedKeys( DataGrid dg,string checkboxName)
        {
            ArrayList arr = new ArrayList();
            int recordCount = dg.Items.Count;
            DataGridItem dgi;
            System.Web.UI.WebControls.CheckBox cb;
            for (int i=0; i<recordCount; i++) 
            {
                dgi = dg.Items[i];

                cb = (CheckBox)dgi.FindControl(checkboxName);
                if (cb.Checked)
                {                    
                    arr.Add(dg.DataKeys[i].ToString());                    
                }
            }
            return arr;
        }
        #endregion

三：为DataGrid网格添加"修改/删除"按钮

                                                <asp:TemplateColumn HeaderText="修改">
                                                    <HeaderStyle HorizontalAlign="Center" Width="30px"></HeaderStyle>
                                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
                                                    <ItemTemplate>
                                                        <asp:ImageButton id="BtnEdit" runat="server" ImageUrl="..\images\button_edit.gif" CommandName="BtnEdit"></asp:ImageButton>
                                                    </ItemTemplate>
                                                </asp:TemplateColumn>
                                                <asp:TemplateColumn HeaderText="删除">
                                                    <HeaderStyle HorizontalAlign="Center" Width="30px"></HeaderStyle>
                                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
                                                    <ItemTemplate>
                                                        <asp:ImageButton id="BtnDel" runat="server" ImageUrl="..\images\button_del.gif" CommandName="BtnDel"></asp:ImageButton>
                                                    </ItemTemplate>
                                                </asp:TemplateColumn>

       处理"修改/删除"按钮事件:
     

        private void dgRecord_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            string btn=e.CommandName;
            int companyID;
            switch(btn)
            {
                case "BtnEdit":
                    companyID=int.Parse(e.Item.Cells[0].Text.Trim());
                    clsCompanyInfo companyInfo = CompanyInfoController.GetCompanyInfoByID(companyID);
                    LoadRecord(companyInfo);
                    
                    ViewState["CompanyID"] = companyID;
                    ibtnAdd.Visible = false;
                    ibtnSave.Visible = true;
                    
                    break;
                case "BtnDel":
                    companyID=int.Parse(e.Item.Cells[0].Text.Trim());
                    CompanyInfoController.DeleteCompanyInfo(companyID);
                    SetVisibleInfo(true);
                    break;
            }
            InitDataBind(null);
        }

        private void dgRecord_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            switch(e.Item.ItemType)
            {
                case ListItemType.Item:
                case ListItemType.AlternatingItem:
                    ImageButton btn = (ImageButton)e.Item.FindControl("BtnDel");
                    btn.Attributes.Add("onclick", "return confirm('你是否确定删除这条记录？');");
                    break;    
            }
        }

四：为DataGrid网格添加"序号"列

                                                <asp:TemplateColumn HeaderText="序号">
                                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                                    <ItemStyle HorizontalAlign="Center"></ItemStyle>
                                                    <ItemTemplate>
                                                        <%# dgRecord.CurrentPageIndex*dgRecord.PageSize+dgRecord.Items.Count+1 %>
                                                    </ItemTemplate>
                                                </asp:TemplateColumn>

 五：DataGrid绑定数据时设定

        private void InitDataBind(string strCondition)
        {
            DataSet ds = CompanyInfoController.GetCompanyInfo(strCondition,null);
            dgRecord.DataSource = ds.Tables[0].DefaultView;
            dgRecord.DataKeyField = "COMPANYID";
            int pageIndex=this.dgRecord.CurrentPageIndex;
            int page_Size=dgRecord.PageSize;
            int record_Count=ds.Tables[0].Rows.Count;
            int totalPages = int.Parse(Math.Ceiling((double)record_Count/page_Size).ToString());
            if(totalPages>0)
            {
                if (pageIndex>totalPages-1) 
                    pageIndex = totalPages-1;                
            }
            else
            {
                pageIndex=0;
            }

            dgRecord.CurrentPageIndex=pageIndex;
            dgRecord.DataBind();            
        }

 六：在DataGrid中设置日期格式
         在HTML中,添加如下语句：DataFormatString = "{0:yyyy-MM-dd}"