1PRivatevoidBindData()2{3DataTable dt = DAO.RunSQLReturnDt(this.getsql());4intdtcount =dt.Rows.Count;5if(dtcount ==0)6{7dt.Rows.Add(dt.NewRow());8}9DataView dv =dt.DefaultView;10//对用于分页的类的引用11PagedDataSource pds =newPagedDataSource();12pds.DataSource = dv;//设置数据源(DataTable类型)13pds.AllowPaging =true;14//每页显示的行数15pds.PageSize =20;16aspNetPager1.RecordCount =dv.Count;17pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex -1;18pds.PageSize =AspNetPager1.PageSize;19GridView1.DataSource =pds;20GridView1.DataBind();21if(dtcount <=0)22{23intcolnumcount =dt.Columns.Count;24GridView1.Rows[0].Cells.Clear();25GridView1.Rows[0].Cells.Add(newTableCell());26GridView1.Rows[0].Cells[0].ColumnSpan =colnumcount;27GridView1.Rows[0].Cells[0].Text ="没有相关记录";28GridView1.Rows[0].Cells[0].Style.Add("color","red");29}303132}
页面正常显示
1<asp:GridView ID="GridView1"runat="server"AutoGenerateColumns="False"CSSClass="tablelist"GridLines="None"DataKeyNames="C_ID"OnRowDataBound="GridView1_RowDataBound">2<Columns>3<asp:BoundField DataField="C_AppNum"HeaderText="入库编号"SortExpression="C_AppNum">4<ItemStyle HorizontalAlign="Center"/>5</asp:BoundField>678<asp:BoundField DataField="C_AppDate"HeaderText="申请时间"SortExpression="C_AppDate">9<ItemStyle HorizontalAlign="Center"/>10</asp:BoundField>11<asp:TemplateField HeaderText="申请部门">12<ItemTemplate>13<%# XC.Depart.GetDepartName(Eval("C_AppDepartID").ToString()) %>14</ItemTemplate>15<ItemStyle HorizontalAlign="Center"/>16</asp:TemplateField>17<asp:TemplateField HeaderText="申请人">18<ItemTemplate>19<%# XC.User.GetUserName(Eval("C_AppUserID").ToString())%>20</ItemTemplate>21<ItemStyle HorizontalAlign="Center"/>22</asp:TemplateField>23<asp:BoundField DataField="C_Status"HeaderText="状态"SortExpression="C_Status">24<ItemStyle HorizontalAlign="Center"/>25</asp:BoundField>26<asp:BoundField DataField="C_AuditState"HeaderText="审核状态"SortExpression="C_AuditState">27<ItemStyle HorizontalAlign="Center"/>28</asp:BoundField>2930</Columns>31<HeaderStyle HorizontalAlign="center"/>32</asp:GridView>
效果
[flash=500,400]http://s1.knowsky.com/20160211/22capbd2wsn19.png[/flash]