ASPxGridView使用大全

  1、ASPxGridView动态绑定数据库

DataTable dt = new DataTable(); ASPxGridView1.DataSource =dt ; ASPxGridView1.DataBind();

 

注意：绑定方法不可以放到 if (!Page.IsPostBack){}中，否则自动拖拽等功能都不可以使用

---

 

 2、默认分组并对分组数据进行统计

      <Columns> 

           <dx:GridViewDataTextColumn Caption="协议书" VisibleIndex="4" FieldName="Class" GroupIndex="0">
           </dx:GridViewDataTextColumn>

       </Columns> 

      <GroupSummary>
                <dx:ASPxSummaryItem FieldName="XH" SummaryType="Count" />
        </GroupSummary>

---

     

3、某一列执行js

            <dx:GridViewDataColumn Caption="查看详细/审核" VisibleIndex="23" Width="80px" Visible="false">
                 <DataItemTemplate>
                     <a href="javascript:void(0);" onclick="OnMoreInfoClick(this, '<%# Container.KeyValue %>')">查看</a>
                 </DataItemTemplate>
             </dx:GridViewDataColumn>

---

4、导出数据

  aspx页面

    <!--导出按钮--> <table cellpadding="0" cellspacing="0"> <tr> <td style="padding-right: 4px" mce_style="padding-right: 4px"> <dx:ASPxButton ID="btnPdfExport" runat="server" Text="导出PDF" UseSubmitBehavior="False" OnClick="btnPdfExport_Click"> </dx:ASPxButton> </td> <td style="padding-right: 4px" mce_style="padding-right: 4px"> <dx:ASPxButton ID="btnXlsExport" runat="server" Text="导出XLS" UseSubmitBehavior="False" OnClick="btnXlsExport_Click"> </dx:ASPxButton> </td> <td style="padding-right: 4px" mce_style="padding-right: 4px"> <dx:ASPxButton ID="btnRtfExport" runat="server" Text="导出RTF" UseSubmitBehavior="False" OnClick="btnRtfExport_Click"> </dx:ASPxButton> </td> <td> <dx:ASPxButton ID="btnCsvExport" runat="server" Text="导出CSV" UseSubmitBehavior="False" OnClick="btnCsvExport_Click"> </dx:ASPxButton> </td> </tr> </table> <!--导出按钮--> <dx:ASPxGridViewExporter ID="gridExport" runat="server" GridViewID="ASPxGridView1"> </dx:ASPxGridViewExporter>

CS页面

//导出数据 protected void btnPdfExport_Click(object sender, EventArgs e) { gridExport.WritePdfToResponse(); } protected void btnXlsExport_Click(object sender, EventArgs e) { gridExport.WriteXlsToResponse(); } protected void btnRtfExport_Click(object sender, EventArgs e) { gridExport.WriteRtfToResponse(); } protected void btnCsvExport_Click(object sender, EventArgs e) { gridExport.WriteCsvToResponse(); }