摘要：mutablegridlayout是一个功能强大的java界面网格布局。
基本的布局为n行m列，行间距和列间距为xgap,ygap，可以通造构造方法 new mutablegridlayout(int cols,int rows,int xgap,int xgap)来进行构造。
每行（列）的宽度（高度）可以通过setwidth(int num,double value)(setheight(i......
摘要：create function [dbo].[f_num_chn] (@num numeric(14,2))returns varchar(100) with encryptionasbegin--版权所有：pbsql declare @n_data varchar(20),@c_data varchar(100),@n_str varchar(10),@i int
set @n_data=r......
为DataGrid自定义分页添加自定义导航和分页信息为datagrid自定义分页添加自定义导航与分页信息
在上一篇文章中我讲到了对datagrid实行自定义分页,这可以避免为了显示一页数据而获取整个数据记录集,从而提高分页效率,不过使用的导航还是datagrid自带的数字连接或简单的上一页,下一页,而且看不到总页数.总记录数之类的信息.下面就为他增加我们所需要的部分. 【程序编程相关:
Delphi控件的停靠功能】
郑 佐 2004-10-29 【推荐阅读:
Delphi默认窗体随想】
【扩展信息:
Delphi常用快捷键】
先来看看修改后的分页显示,截图如下:
（图一）
使用的数据源同上一篇文章（asp.net中datagrid控件的自定义分页）相同,都是访问northwind库,为了独立开来这里还是把存储过程列了一下,
create procedure [getcustomersdatapage]
@pageindex int,
@pagesize int,
@recordcount int out,
@pagecount int out
as
select @recordcount = count(*) from customers
set @pagecount = ceiling(@recordcount * 1.0 / @pagesize)
declare @sqlstr nvarchar(1000)
if @pageindex = 0 or @pagecount <= 1
set @sqlstr =n´select top ´+str( @pagesize )+
´ customerid, companyname,address,phone from customers order by customerid desc
else if @pageindex = @pagecount - 1
set @sqlstr =n´ select * from ( select top ´+str( @recordcount - @pagesize * @pageindex )+
´ customerid, companyname,address,phone from customers order by customerid asc ) temptable order by customerid desc´
else
set @sqlstr =n´ select top ´+str( @pagesize )+´ * from ( select top ´+str( @recordcount - @pagesize * @pageindex )+
´ customerid, companyname,address,phone from customers order by customerid asc ) temptable order by customerid desc´
exec (@sqlstr)
go
下面就就把代码贴了一下,
aspx文件代码如下:
<%@ page language="c#" codebehind="datagridcustompaging.aspx.cs" autoeventwireup="false" inherits="zz.aspnetpaging.datagridcustompaging" %>
<!doctype html public "-//w3c//dtd html 4.0 transitional//en" >
<html>
<head>
<title>datagridpaging</title>
<meta content="microsoft visual studio .net 7.1" name="generator">
<meta content="c#" name="code_language">
<meta content="javascript" name="vs_defaultclientscript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetschema">
</head>
<body>
<form id="form1" method="post" runat="server">
<table id="table1" style="font-size: 9pt" cellspacing="1" cellpadding="1" width="450" align="center"
border="1">...
下一页 摘要：create function [dbo].[f_num_eng] (@num numeric(15,2))returns varchar(400) with encryptionasbegin--all rights reserved. pbsql declare @i int,@hundreds int,@tenth int,@one int declare @thousand int,@mi......
