有这样一种情况,当GRIDVIEW中设定每页显示30行,而实际显示数据只有12行时,剩下的18行就不会显示了,这时GRIDVIEW只显示12行,当是为了让GRIDVIEW控件在用户面前显得好看一些,我们想能不能把剩下的18行用空白行显示出来,我想有一些朋友也在为这个问题犯愁吧。
我想到这里,查了一下MSDN,写出了如下的代码:
1
public
void
LoadGrid()
2
![](https://i-blog.csdnimg.cn/blog_migrate/d3d818c129c14ef3345d4f5162eb80f1.gif)
{
3
AdoSql GridSql = new AdoSql();
4
DataTable CustmTable = GridSql.GridGetSql("select * from CustmInfo order by CompanyName desc");
5![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
6
for (int i = CustmTable.Rows.Count; i < 30; i++)
7![](https://i-blog.csdnimg.cn/blog_migrate/9c2a2b66a8131a63b7d42e5b8ca5729a.gif)
{
8
DataRow TableRow = CustmTable.NewRow();
9
TableRow[0] = DBNull.Value;
10
CustmTable.Rows.Add(TableRow);
11
}
12![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
13
this.CustmGrid.DataSource = CustmTable;
14
this.CustmGrid.DataBind();
15![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
16![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
17
}
需要说明的是,代码中的GridSql.GridGetSql是我写的一个操作数据库的类,以下是操作数据库的类代码。
1
public
DataTable GridGetSql(
string
SqlStr)
2
![](https://i-blog.csdnimg.cn/blog_migrate/d3d818c129c14ef3345d4f5162eb80f1.gif)
{
3
OleDbCommand SqlCmd = new OleDbCommand();
4
SqlCmd.Connection = new OleDbConnection(ConfigurationSettings.AppSettings["OledbConnectionStr"]);
5
SqlCmd.CommandText = SqlStr;
6
SqlCmd.CommandType = CommandType.Text;
7
OleDbDataAdapter SqlAd = new OleDbDataAdapter(SqlCmd);
8
DataSet Rs = new DataSet();
9
SqlAd.Fill(Rs);
10
return Rs.Tables[0];
11
}
![](https://i-blog.csdnimg.cn/blog_migrate/3b2c7cbba4cd4b69f6230251011d7a48.gif)
2
![](https://i-blog.csdnimg.cn/blog_migrate/d3d818c129c14ef3345d4f5162eb80f1.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/20549d5ed074d3adee4e6a52bf6f55e0.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/b9878c27f79d4ad1a83e4ffcdf1d0c42.gif)
3
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
4
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
5
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
6
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
7
![](https://i-blog.csdnimg.cn/blog_migrate/9c2a2b66a8131a63b7d42e5b8ca5729a.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/7327f043dfba808fa3ad9e0c25d63fa8.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/b9878c27f79d4ad1a83e4ffcdf1d0c42.gif)
8
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
9
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
10
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
11
![](https://i-blog.csdnimg.cn/blog_migrate/74d2286e5fa4476c170465a96d51d108.gif)
12
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
13
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
14
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
15
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
16
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
17
![](https://i-blog.csdnimg.cn/blog_migrate/525dde9cd6ab29e4b92b56355c796e56.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/3b2c7cbba4cd4b69f6230251011d7a48.gif)
2
![](https://i-blog.csdnimg.cn/blog_migrate/d3d818c129c14ef3345d4f5162eb80f1.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/20549d5ed074d3adee4e6a52bf6f55e0.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/b9878c27f79d4ad1a83e4ffcdf1d0c42.gif)
3
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
4
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
5
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
6
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
7
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
8
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
9
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
10
![](https://i-blog.csdnimg.cn/blog_migrate/59b9e17a62cabb78c1e7d9416f6f2538.gif)
11
![](https://i-blog.csdnimg.cn/blog_migrate/525dde9cd6ab29e4b92b56355c796e56.gif)