邪恶八进制信息安全团队技术讨论组 » 常用数据库类{ Database Security } » [转载]GridView&ObjectDataSource新特性小记 懒人篇 [查看完整版本]

ring04h 2006-5-13 11:45

[转载]GridView&ObjectDataSource新特性小记 懒人篇

<p>信息来源: <a id="ArticleTitle1_ArticleTitle1_AuthorLink" href="/user/linqingfeng">linqingfeng</a> Blog </p><p>懒"序;<br /> Visual Studio 2005推广的时间不算短了,它为我们带来的很多新特性使得开发更加高效和有趣.相信众多VS开发者抢鲜体验过并为此激动不已了.不论是IDE的格局还是 FrameWork的改进,都十分令人赏心悦目.在微软公布的诸多新特性里面,最为让我关注的部分,就是数据绑定.有过经验的朋友一定知道,在 FrameWork1.0甚至更早时期的版本,数据绑定控件和数据源提供的可选功能相当薄弱,为实现一个较为复杂的数据显示或操作需要而coding,都 是一件颇为恐怖的事情.VS2003中的DataGrid曾凭借其良好的功能集成,与SqlDataSource配合,为我们减轻了一定的负担,一直成为 数据绑定的首选.虽然它提供了相应的事件接口,但仍需要大量的代码才得以完成.微软的产品一向是助长开发者们的惰性的.自VS2005推出以来, GridView作为DataGrid不二的继承人,逐渐显露它的强大,慢慢为像我们这样的懒人接受并打算长期使用.加上有FrameWork2.0新品 ObjectDatasource的无缝支持,它俩简直就是数据绑定界天造地设的一对,使用非常省心,就一个词:"Perfection"...<br /></p><p>"懒"归正传:<br /> 最近开场废话是多了点(可能是参加会议太多闹的.. ^_^!!).马上请出GridView & ObjectDataSource.<br />下面我将逐步展现一个分页的案例.</p><p>案例环境: WindowsXP SP2, VS2005 Team Suite,SqlServer2005(没有比这更糟的了....)<br />要求: 了解数据绑定控件的结构,数据源的运行机制,以及简单的绑定控件设计实现(那些内容足够再写一篇教程了,这里不再多叙.)<br />参 考: MSDN中提到,ObjectDataSource是唯一支持界面分页的数据源(除非自己来继承造一个,汗!),但示例仍 然是用SqlDataSource做数据源介绍的GirdView绑定.难道MS这么小气???(ps:打死俺也不说).</p><p>那好,就从那句介绍开始,咱们自己动手整出一个来.<br />按照常规,先准备一张表和一些存储过程,如下:<br /></p><p></p><div style="BORDER-RIGHT: rgb(204,204,204) 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: rgb(204,204,204) 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: rgb(204,204,204) 1px solid; WIDTH: 98%; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(204,204,204) 1px solid; BACKGROUND-COLOR: rgb(238,238,238)"><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: rgb(0,0,255)">Table</span><span style="COLOR: rgb(0,0,0)">:MyUsers<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" />UserID(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">int</span><span style="COLOR: rgb(0,0,0)">,</span><span style="COLOR: rgb(0,0,255)">primary</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">key</span><span style="COLOR: rgb(0,0,0)">,</span><span style="COLOR: rgb(255,0,255)">identity</span><span style="COLOR: rgb(0,0,0)">)</span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">自动增加字段,用户ID标识列</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)">UserName(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">nvarchar</span><span style="COLOR: rgb(0,0,0)">(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">50</span><span style="COLOR: rgb(0,0,0)">),</span><span style="COLOR: rgb(128,128,128)">not</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">null</span><span style="COLOR: rgb(0,0,0)">)</span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">用户名</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)">Description(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">nvarchar</span><span style="COLOR: rgb(0,0,0)">(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">50</span><span style="COLOR: rgb(0,0,0)">),</span><span style="COLOR: rgb(128,128,128)">not</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">null</span><span style="COLOR: rgb(0,0,0)">)</span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">备注</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">Procedure</span><span style="COLOR: rgb(0,0,0)">:<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">CREATE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">PROCEDURE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">dbo</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)">.</span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">AddUser</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">增加一个用户</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@UserName</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">nvarchar</span><span style="COLOR: rgb(0,0,0)">(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">50</span><span style="COLOR: rgb(0,0,0)">),<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">@Description</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">nvarchar</span><span style="COLOR: rgb(0,0,0)">(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">50</span><span style="COLOR: rgb(0,0,0)">)<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">AS</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">BEGIN</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">SET</span><span style="COLOR: rgb(0,0,0)">NOCOUNT</span><span style="COLOR: rgb(0,0,255)">ON</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">insert</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">into</span><span style="COLOR: rgb(0,0,0)">MyUsers(UserName,Description)<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">values</span><span style="COLOR: rgb(0,0,0)">(</span><span style="COLOR: rgb(0,128,0)">@UserName</span><span style="COLOR: rgb(0,0,0)">,</span><span style="COLOR: rgb(0,128,0)">@Description</span><span style="COLOR: rgb(0,0,0)">)<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">if</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,128,0)">@@error</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(128,128,128)"><></span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">0</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">rollback</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">end</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">else</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">commit</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">end</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">END</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">CREATE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">PROCEDURE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">dbo</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)">.</span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">DeleteUserByUserID</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">删除一个用户</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@UserID</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">int</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">AS</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">BEGIN</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">SET</span><span style="COLOR: rgb(0,0,0)">NOCOUNT</span><span style="COLOR: rgb(0,0,255)">ON</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">Begin</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">Transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">delete</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">from</span><span style="COLOR: rgb(0,0,0)">MyUsers</span><span style="COLOR: rgb(0,0,255)">where</span><span style="COLOR: rgb(0,0,0)">UserID</span><span style="COLOR: rgb(128,128,128)">=</span><span style="COLOR: rgb(0,128,0)">@UserID</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">if</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,128,0)">@@error</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(128,128,128)"><></span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">0</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">rollback</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">end</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">else</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">commit</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">end</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">END</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">CREATE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">PROCEDURE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">dbo</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)">.</span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">UpdateUser</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">修改用户姓名或备注</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@UserID</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">int</span><span style="COLOR: rgb(0,0,0)">,<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">@UserName</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">nvarchar</span><span style="COLOR: rgb(0,0,0)">(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">50</span><span style="COLOR: rgb(0,0,0)">),<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">@Description</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">nvarchar</span><span style="COLOR: rgb(0,0,0)">(</span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">50</span><span style="COLOR: rgb(0,0,0)">)<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">AS</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">BEGIN</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">SET</span><span style="COLOR: rgb(0,0,0)">NOCOUNT</span><span style="COLOR: rgb(0,0,255)">ON</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">update</span><span style="COLOR: rgb(0,0,0)">MyUsers<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">set</span><span style="COLOR: rgb(0,0,0)">UserName</span><span style="COLOR: rgb(128,128,128)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@UserName</span><span style="COLOR: rgb(0,0,0)">,<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" />Description</span><span style="COLOR: rgb(128,128,128)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@Description</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">where</span><span style="COLOR: rgb(0,0,0)">UserID</span><span style="COLOR: rgb(128,128,128)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@UserID</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">if</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,128,0)">@@error</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(128,128,128)"><></span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(128,0,0)">0</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">rollback</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">end</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">else</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">begin</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">commit</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">transaction</span><span style="COLOR: rgb(0,0,0)">t<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">end</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">END</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">CREATE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">PROCEDURE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">dbo</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)">.</span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">GetUsers</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,128)">--</span><span style="COLOR: rgb(0,128,128)">得到用户列表,注意这里的参数</span><span style="COLOR: rgb(0,128,128)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@RowIndex</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">int</span><span style="COLOR: rgb(0,0,0)">,<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">@RecordCount</span><span style="COLOR: rgb(0,0,0)"></span><span style="FONT-WEIGHT: bold; COLOR: rgb(0,0,0)">int</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">AS</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">BEGIN</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">SET</span><span style="COLOR: rgb(0,0,0)">NOCOUNT</span><span style="COLOR: rgb(0,0,255)">ON</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">With</span><span style="COLOR: rgb(0,0,0)">VUsers</span><span style="COLOR: rgb(0,0,255)">as</span><span style="COLOR: rgb(0,0,0)">(<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">select</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(128,128,128)">*</span><span style="COLOR: rgb(0,0,0)">,row_number()</span><span style="COLOR: rgb(0,0,255)">over</span><span style="COLOR: rgb(0,0,0)">(</span><span style="COLOR: rgb(0,0,255)">order</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">by</span><span style="COLOR: rgb(0,0,0)">UserID</span><span style="COLOR: rgb(0,0,255)">desc</span><span style="COLOR: rgb(0,0,0)">)</span><span style="COLOR: rgb(0,0,255)">as</span><span style="COLOR: rgb(0,0,0)">RowNum<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">from</span><span style="COLOR: rgb(0,0,0)">MyUsers<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" />)<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">select</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(128,128,128)">*</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">from</span><span style="COLOR: rgb(0,0,0)">VUsers<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">where</span><span style="COLOR: rgb(0,0,0)">RowNum</span><span style="COLOR: rgb(128,128,128)">></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,128,0)">@RowIndex</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(128,128,128)">and</span><span style="COLOR: rgb(0,0,0)">RowNum</span><span style="COLOR: rgb(128,128,128)"><=</span><span style="COLOR: rgb(0,0,0)">(</span><span style="COLOR: rgb(0,128,0)">@RowIndex</span><span style="COLOR: rgb(128,128,128)">+</span><span style="COLOR: rgb(0,128,0)">@RecordCount</span><span style="COLOR: rgb(0,0,0)">)<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">END</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">CREATE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">PROCEDURE</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">dbo</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)">.</span><span style="COLOR: rgb(255,0,0)">[</span><span style="COLOR: rgb(255,0,0)">GetUsersCount</span><span style="COLOR: rgb(255,0,0)">]</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">AS</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">BEGIN</span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">SET</span><span style="COLOR: rgb(0,0,0)">NOCOUNT</span><span style="COLOR: rgb(0,0,255)">ON</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">select</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(255,0,255)">count</span><span style="COLOR: rgb(0,0,0)">(UserID)</span><span style="COLOR: rgb(0,0,255)">from</span><span style="COLOR: rgb(0,0,0)">MyUsers<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">END</span></div><p><br />这里详细说明一下倒数两个存储过程,GetUsers的参数RowIndex,不是页码(传说中的PageIndex),而是行索引,且从 0开始.这点特别要注意,因为要让ObjectDataSource自动取得当前需要的数据(界面级分页意味着当前需要显示多少数据只向数据库取多少,并 不会像其他数据源全总取出消耗性能.),依据也就是行索引和增量.GetUsersCount这个存储过程是为ObjectDataSource分页提供 总数的,它与分页的存储过程要保持一致.特别指的是有分页条件的情况,本人经常忘记(^_^||).否则GridView显示会不正常.</p><p>在WebSite新建一个DAL,假定类名为DataManager,给出代码片段如下:</p><p></p><div style="BORDER-RIGHT: rgb(204,204,204) 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: rgb(204,204,204) 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: rgb(204,204,204) 1px solid; WIDTH: 98%; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(204,204,204) 1px solid; BACKGROUND-COLOR: rgb(238,238,238)"><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Data;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Data.SqlClient;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Configuration;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Web;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Web.Security;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Web.UI;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Web.UI.WebControls;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Web.UI.WebControls.WebParts;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Web.UI.HtmlControls;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Collections;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">using</span><span style="COLOR: rgb(0,0,0)">System.Collections.Generic;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><br /><img id="Codehighlighter1_326_374_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_326_374_Open_Text.style.display='none'; Codehighlighter1_326_374_Closed_Image.style.display='inline'; Codehighlighter1_326_374_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align="top" /><img id="Codehighlighter1_326_374_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_326_374_Closed_Text.style.display='none'; Codehighlighter1_326_374_Open_Image.style.display='inline'; Codehighlighter1_326_374_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif" align="top" /></span><span id="Codehighlighter1_326_374_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)">/**/</span><span id="Codehighlighter1_326_374_Open_Text"><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)">DataAccessLayer<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"></summary></span><span style="COLOR: rgb(128,128,128)"></span></span><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: rgb(0,0,255)">public</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">class</span><span style="COLOR: rgb(0,0,0)">DataManager<br /><img id="Codehighlighter1_400_3482_Open_Image" style="DISPLAY: inline" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_400_3482_Open_Text.style.display='none'; Codehighlighter1_400_3482_Closed_Image.style.display='inline'; Codehighlighter1_400_3482_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif" align="top" /><img id="Codehighlighter1_400_3482_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_400_3482_Closed_Text.style.display='none'; Codehighlighter1_400_3482_Open_Image.style.display='inline'; Codehighlighter1_400_3482_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif" align="top" /></span><span id="Codehighlighter1_400_3482_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_400_3482_Open_Text" style="DISPLAY: inline"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">private</span><span style="COLOR: rgb(0,0,0)">SqlConnectioncon</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">null</span><span style="COLOR: rgb(0,0,0)">;</span><span style="COLOR: rgb(0,128,0)">//</span><span style="COLOR: rgb(0,128,0)">连接对象</span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">private</span><span style="COLOR: rgb(0,0,0)">SqlCommandcmd</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">null</span><span style="COLOR: rgb(0,0,0)">;</span><span style="COLOR: rgb(0,128,0)">//</span><span style="COLOR: rgb(0,128,0)">command执行对象</span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">private</span><span style="COLOR: rgb(0,0,0)">SqlDataAdapterda</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">null</span><span style="COLOR: rgb(0,0,0)">;</span><span style="COLOR: rgb(0,128,0)">//</span><span style="COLOR: rgb(0,128,0)">适配器对象</span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_548_596_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_548_596_Open_Text.style.display='none'; Codehighlighter1_548_596_Closed_Image.style.display='inline'; Codehighlighter1_548_596_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_548_596_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_548_596_Closed_Text.style.display='none'; Codehighlighter1_548_596_Open_Image.style.display='inline'; Codehighlighter1_548_596_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_548_596_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)">/**/</span><span id="Codehighlighter1_548_596_Open_Text"><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)">DAL对象构造<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"></summary></span><span style="COLOR: rgb(128,128,128)"></span></span><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">public</span><span style="COLOR: rgb(0,0,0)">DataManager()<br /><img id="Codehighlighter1_620_671_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_620_671_Open_Text.style.display='none'; Codehighlighter1_620_671_Closed_Image.style.display='inline'; Codehighlighter1_620_671_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_620_671_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_620_671_Closed_Text.style.display='none'; Codehighlighter1_620_671_Open_Image.style.display='inline'; Codehighlighter1_620_671_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_620_671_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_620_671_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">//</span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">//</span><span style="COLOR: rgb(0,128,0)">TODO:Addconstructorlogichere<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,128,0)">//<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(0,0,0)">}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img id="Codehighlighter1_678_726_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_678_726_Open_Text.style.display='none'; Codehighlighter1_678_726_Closed_Image.style.display='inline'; Codehighlighter1_678_726_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_678_726_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_678_726_Closed_Text.style.display='none'; Codehighlighter1_678_726_Open_Image.style.display='inline'; Codehighlighter1_678_726_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_678_726_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)">/**/</span><span id="Codehighlighter1_678_726_Open_Text"><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)">打开数据库连接<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"></summary></span><span style="COLOR: rgb(128,128,128)"></span></span><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">private</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">void</span><span style="COLOR: rgb(0,0,0)">OpenConnection()<br /><img id="Codehighlighter1_765_1179_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_765_1179_Open_Text.style.display='none'; Codehighlighter1_765_1179_Closed_Image.style.display='inline'; Codehighlighter1_765_1179_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_765_1179_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_765_1179_Closed_Text.style.display='none'; Codehighlighter1_765_1179_Open_Image.style.display='inline'; Codehighlighter1_765_1179_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_765_1179_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_765_1179_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">try</span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_787_1073_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_787_1073_Open_Text.style.display='none'; Codehighlighter1_787_1073_Closed_Image.style.display='inline'; Codehighlighter1_787_1073_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_787_1073_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_787_1073_Closed_Text.style.display='none'; Codehighlighter1_787_1073_Open_Image.style.display='inline'; Codehighlighter1_787_1073_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_787_1073_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_787_1073_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">string</span><span style="COLOR: rgb(0,0,0)">conString</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">ConfigurationManager.ConnectionStrings[</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">localDB</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">].ConnectionString;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />con</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">SqlConnection(conString);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">if</span><span style="COLOR: rgb(0,0,0)">(ConnectionState.Closed</span><span style="COLOR: rgb(0,0,0)">==</span><span style="COLOR: rgb(0,0,0)">con.State)<br /><img id="Codehighlighter1_1001_1063_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1001_1063_Open_Text.style.display='none'; Codehighlighter1_1001_1063_Closed_Image.style.display='inline'; Codehighlighter1_1001_1063_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1001_1063_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1001_1063_Closed_Text.style.display='none'; Codehighlighter1_1001_1063_Open_Image.style.display='inline'; Codehighlighter1_1001_1063_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1001_1063_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1001_1063_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />con.Open();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">catch</span><span style="COLOR: rgb(0,0,0)">(SqlExceptionex)<br /><img id="Codehighlighter1_1115_1173_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1115_1173_Open_Text.style.display='none'; Codehighlighter1_1115_1173_Closed_Image.style.display='inline'; Codehighlighter1_1115_1173_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1115_1173_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1115_1173_Closed_Text.style.display='none'; Codehighlighter1_1115_1173_Open_Image.style.display='inline'; Codehighlighter1_1115_1173_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1115_1173_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1115_1173_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">throw</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">Exception(</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">数据库无法访问</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">,ex);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img id="Codehighlighter1_1186_1234_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1186_1234_Open_Text.style.display='none'; Codehighlighter1_1186_1234_Closed_Image.style.display='inline'; Codehighlighter1_1186_1234_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1186_1234_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1186_1234_Closed_Text.style.display='none'; Codehighlighter1_1186_1234_Open_Image.style.display='inline'; Codehighlighter1_1186_1234_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1186_1234_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)">/**/</span><span id="Codehighlighter1_1186_1234_Open_Text"><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)">关闭数据库连接<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"></summary></span><span style="COLOR: rgb(128,128,128)"></span></span><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">private</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">void</span><span style="COLOR: rgb(0,0,0)">CloseConnection()<br /><img id="Codehighlighter1_1274_1536_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1274_1536_Open_Text.style.display='none'; Codehighlighter1_1274_1536_Closed_Image.style.display='inline'; Codehighlighter1_1274_1536_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1274_1536_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1274_1536_Closed_Text.style.display='none'; Codehighlighter1_1274_1536_Open_Image.style.display='inline'; Codehighlighter1_1274_1536_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1274_1536_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1274_1536_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">if</span><span style="COLOR: rgb(0,0,0)">(ConnectionState.Open</span><span style="COLOR: rgb(0,0,0)">==</span><span style="COLOR: rgb(0,0,0)">con.State)<br /><img id="Codehighlighter1_1331_1530_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1331_1530_Open_Text.style.display='none'; Codehighlighter1_1331_1530_Closed_Image.style.display='inline'; Codehighlighter1_1331_1530_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1331_1530_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1331_1530_Closed_Text.style.display='none'; Codehighlighter1_1331_1530_Open_Image.style.display='inline'; Codehighlighter1_1331_1530_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1331_1530_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1331_1530_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">try</span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_1361_1404_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1361_1404_Open_Text.style.display='none'; Codehighlighter1_1361_1404_Closed_Image.style.display='inline'; Codehighlighter1_1361_1404_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1361_1404_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1361_1404_Closed_Text.style.display='none'; Codehighlighter1_1361_1404_Open_Image.style.display='inline'; Codehighlighter1_1361_1404_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1361_1404_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1361_1404_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />con.Close();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">catch</span><span style="COLOR: rgb(0,0,0)">(SqlExceptionex)<br /><img id="Codehighlighter1_1454_1520_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1454_1520_Open_Text.style.display='none'; Codehighlighter1_1454_1520_Closed_Image.style.display='inline'; Codehighlighter1_1454_1520_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1454_1520_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1454_1520_Closed_Text.style.display='none'; Codehighlighter1_1454_1520_Open_Image.style.display='inline'; Codehighlighter1_1454_1520_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1454_1520_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1454_1520_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">throw</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">Exception(</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">数据库无法关闭</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">,ex);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img id="Codehighlighter1_1543_1719_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1543_1719_Open_Text.style.display='none'; Codehighlighter1_1543_1719_Closed_Image.style.display='inline'; Codehighlighter1_1543_1719_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1543_1719_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1543_1719_Closed_Text.style.display='none'; Codehighlighter1_1543_1719_Open_Image.style.display='inline'; Codehighlighter1_1543_1719_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1543_1719_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)">/**/</span><span id="Codehighlighter1_1543_1719_Open_Text"><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)">取得用户列表<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"></summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><paramname="rowIndex"></span><span style="COLOR: rgb(0,128,0)">行索引</span><span style="COLOR: rgb(128,128,128)"></param></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><paramname="recordCount"></span><span style="COLOR: rgb(0,128,0)">页显示量(增量)</span><span style="COLOR: rgb(128,128,128)"></param></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><returns></span><span style="COLOR: rgb(0,128,0)">用户列表数据集</span><span style="COLOR: rgb(128,128,128)"></returns></span><span style="COLOR: rgb(128,128,128)"></span></span><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">public</span><span style="COLOR: rgb(0,0,0)">DataSetGetUsers(</span><span style="COLOR: rgb(0,0,255)">int</span><span style="COLOR: rgb(0,0,0)">rowIndex,</span><span style="COLOR: rgb(0,0,255)">int</span><span style="COLOR: rgb(0,0,0)">recordCount)<br /><img id="Codehighlighter1_1783_2852_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1783_2852_Open_Text.style.display='none'; Codehighlighter1_1783_2852_Closed_Image.style.display='inline'; Codehighlighter1_1783_2852_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1783_2852_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1783_2852_Closed_Text.style.display='none'; Codehighlighter1_1783_2852_Open_Image.style.display='inline'; Codehighlighter1_1783_2852_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1783_2852_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1783_2852_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />OpenConnection();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">try</span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_1831_2678_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1831_2678_Open_Text.style.display='none'; Codehighlighter1_1831_2678_Closed_Image.style.display='inline'; Codehighlighter1_1831_2678_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_1831_2678_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_1831_2678_Closed_Text.style.display='none'; Codehighlighter1_1831_2678_Open_Image.style.display='inline'; Codehighlighter1_1831_2678_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_1831_2678_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_1831_2678_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">SqlCommand();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.Connection</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">con;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.CommandType</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">CommandType.StoredProcedure;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.CommandText</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">GetUsers</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />SqlParameterspRowIndex</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">SqlParameter(</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">@RowIndex</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">,SqlDbType.Int,</span><span style="COLOR: rgb(0,0,0)">4</span><span style="COLOR: rgb(0,0,0)">);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />spRowIndex.Direction</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">ParameterDirection.Input;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />SqlParameterspRecordCount</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">SqlParameter(</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">@RecordCount</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">,SqlDbType.Int,</span><span style="COLOR: rgb(0,0,0)">4</span><span style="COLOR: rgb(0,0,0)">);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />spRecordCount.Direction</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">ParameterDirection.Input;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.Parameters.Add(spRowIndex);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.Parameters.Add(spRecordCount);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />spRowIndex.Value</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">rowIndex;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />spRecordCount.Value</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">recordCount;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />da</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">SqlDataAdapter(cmd);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />DataSetds</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">DataSet();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />da.Fill(ds,</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">MyUsers</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">return</span><span style="COLOR: rgb(0,0,0)">ds;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">catch</span><span style="COLOR: rgb(0,0,0)">(SqlExceptionex)<br /><img id="Codehighlighter1_2720_2779_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2720_2779_Open_Text.style.display='none'; Codehighlighter1_2720_2779_Closed_Image.style.display='inline'; Codehighlighter1_2720_2779_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_2720_2779_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2720_2779_Closed_Text.style.display='none'; Codehighlighter1_2720_2779_Open_Image.style.display='inline'; Codehighlighter1_2720_2779_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_2720_2779_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_2720_2779_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">throw</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">Exception(</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">无法取得有效数据</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">,ex);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">finally</span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_2805_2846_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2805_2846_Open_Text.style.display='none'; Codehighlighter1_2805_2846_Closed_Image.style.display='inline'; Codehighlighter1_2805_2846_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_2805_2846_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2805_2846_Closed_Text.style.display='none'; Codehighlighter1_2805_2846_Open_Image.style.display='inline'; Codehighlighter1_2805_2846_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_2805_2846_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_2805_2846_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />CloseConnection();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><br /><img id="Codehighlighter1_2859_2938_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2859_2938_Open_Text.style.display='none'; Codehighlighter1_2859_2938_Closed_Image.style.display='inline'; Codehighlighter1_2859_2938_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_2859_2938_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2859_2938_Closed_Text.style.display='none'; Codehighlighter1_2859_2938_Open_Image.style.display='inline'; Codehighlighter1_2859_2938_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_2859_2938_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)">/**/</span><span id="Codehighlighter1_2859_2938_Open_Text"><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)">取得用户总数<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"></summary></span><span style="COLOR: rgb(0,128,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" /></span><span style="COLOR: rgb(128,128,128)">///</span><span style="COLOR: rgb(0,128,0)"></span><span style="COLOR: rgb(128,128,128)"><returns></span><span style="COLOR: rgb(0,128,0)">用户总数</span><span style="COLOR: rgb(128,128,128)"></returns></span><span style="COLOR: rgb(128,128,128)"></span></span><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">public</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">int</span><span style="COLOR: rgb(0,0,0)">GetUsersCount()<br /><img id="Codehighlighter1_2974_3481_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2974_3481_Open_Text.style.display='none'; Codehighlighter1_2974_3481_Closed_Image.style.display='inline'; Codehighlighter1_2974_3481_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_2974_3481_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_2974_3481_Closed_Text.style.display='none'; Codehighlighter1_2974_3481_Open_Image.style.display='inline'; Codehighlighter1_2974_3481_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_2974_3481_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_2974_3481_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />OpenConnection();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">try</span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_3022_3307_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_3022_3307_Open_Text.style.display='none'; Codehighlighter1_3022_3307_Closed_Image.style.display='inline'; Codehighlighter1_3022_3307_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_3022_3307_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_3022_3307_Closed_Text.style.display='none'; Codehighlighter1_3022_3307_Open_Image.style.display='inline'; Codehighlighter1_3022_3307_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_3022_3307_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_3022_3307_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">SqlCommand();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.Connection</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">con;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.CommandType</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">CommandType.StoredProcedure;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />cmd.CommandText</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">GetUsersCount</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">int</span><span style="COLOR: rgb(0,0,0)">count</span><span style="COLOR: rgb(0,0,0)">=</span><span style="COLOR: rgb(0,0,0)">Convert.ToInt32(cmd.ExecuteScalar().ToString());<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">return</span><span style="COLOR: rgb(0,0,0)">count;<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">catch</span><span style="COLOR: rgb(0,0,0)">(SqlExceptionex)<br /><img id="Codehighlighter1_3349_3408_Open_Image" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_3349_3408_Open_Text.style.display='none'; Codehighlighter1_3349_3408_Closed_Image.style.display='inline'; Codehighlighter1_3349_3408_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_3349_3408_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_3349_3408_Closed_Text.style.display='none'; Codehighlighter1_3349_3408_Open_Image.style.display='inline'; Codehighlighter1_3349_3408_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_3349_3408_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_3349_3408_Open_Text"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">throw</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">new</span><span style="COLOR: rgb(0,0,0)">Exception(</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">无法取得有效数据</span><span style="COLOR: rgb(0,0,0)">"</span><span style="COLOR: rgb(0,0,0)">,ex);<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)">finally</span><span style="COLOR: rgb(0,0,0)"><br /><img id="Codehighlighter1_3434_3475_Open_Image" style="DISPLAY: inline" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_3434_3475_Open_Text.style.display='none'; Codehighlighter1_3434_3475_Closed_Image.style.display='inline'; Codehighlighter1_3434_3475_Closed_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" /><img id="Codehighlighter1_3434_3475_Closed_Image" style="DISPLAY: none" onclick="function anonymous()
{
this.style.display='none'; Codehighlighter1_3434_3475_Closed_Text.style.display='none'; Codehighlighter1_3434_3475_Open_Image.style.display='inline'; Codehighlighter1_3434_3475_Open_Text.style.display='inline';
}" src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif" align="top" /></span><span id="Codehighlighter1_3434_3475_Closed_Text" style="BORDER-RIGHT: rgb(128,128,128) 1px solid; BORDER-TOP: rgb(128,128,128) 1px solid; DISPLAY: none; BORDER-LEFT: rgb(128,128,128) 1px solid; BORDER-BOTTOM: rgb(128,128,128) 1px solid; BACKGROUND-COLOR: rgb(255,255,255)"><img src="http://www.cnblogs.com/Images/dot.gif" /></span><span id="Codehighlighter1_3434_3475_Open_Text" style="DISPLAY: inline"><span style="COLOR: rgb(0,0,0)">{<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/InBlock.gif" align="top" />CloseConnection();<br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top" />}</span></span></span></div><p></p><p>对DAL也有几项说明,DataManager.GetUsers(int rowIndex, int recordCount)方法的参数<strong>只能</strong>有两个,<br />参数名可以随意,但意义却要与调用的存储过程GetUsers要一致,rowIndex必须是行索引,recordCount必须是页显示量.<br />OK！接下来在页面上放上一个GridView和一个ObjectDataSource,设置代码片段如下:<br /></p><div style="BORDER-RIGHT: rgb(204,204,204) 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: rgb(204,204,204) 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: rgb(204,204,204) 1px solid; WIDTH: 98%; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(204,204,204) 1px solid; BACKGROUND-COLOR: rgb(238,238,238)"><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">asp:GridView</span><span style="COLOR: rgb(255,0,0)">ID</span><span style="COLOR: rgb(0,0,255)">="gvMyUsers"</span><span style="COLOR: rgb(255,0,0)">runat</span><span style="COLOR: rgb(0,0,255)">="server"</span><span style="COLOR: rgb(255,0,0)">AllowPaging</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">CellPadding</span><span style="COLOR: rgb(0,0,255)">="4"</span><span style="COLOR: rgb(255,0,0)">DataSourceID</span><span style="COLOR: rgb(0,0,255)">="objMyUsers"</span><span style="COLOR: rgb(255,0,0)">ForeColor</span><span style="COLOR: rgb(0,0,255)">="#333333"</span><span style="COLOR: rgb(255,0,0)">GridLines</span><span style="COLOR: rgb(0,0,255)">="None"</span><span style="COLOR: rgb(255,0,0)">AutoGenerateDeleteButton</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">AutoGenerateEditButton</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">AutoGenerateColumns</span><span style="COLOR: rgb(0,0,255)">="False"</span><span style="COLOR: rgb(255,0,0)">DataKeyNames</span><span style="COLOR: rgb(0,0,255)">="UserID"</span><span style="COLOR: rgb(255,0,0)">PageSize</span><span style="COLOR: rgb(0,0,255)">="10"</span><span style="COLOR: rgb(0,0,255)">></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">FooterStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="#507CD1"</span><span style="COLOR: rgb(255,0,0)">Font-Bold</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">ForeColor</span><span style="COLOR: rgb(0,0,255)">="White"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">RowStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="#EFF3FB"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">EditRowStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="#2461BF"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">SelectedRowStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="#D1DDF1"</span><span style="COLOR: rgb(255,0,0)">Font-Bold</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">ForeColor</span><span style="COLOR: rgb(0,0,255)">="#333333"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">PagerStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="#2461BF"</span><span style="COLOR: rgb(255,0,0)">ForeColor</span><span style="COLOR: rgb(0,0,255)">="White"</span><span style="COLOR: rgb(255,0,0)">HorizontalAlign</span><span style="COLOR: rgb(0,0,255)">="Center"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">HeaderStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="#507CD1"</span><span style="COLOR: rgb(255,0,0)">Font-Bold</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">ForeColor</span><span style="COLOR: rgb(0,0,255)">="White"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">AlternatingRowStyle</span><span style="COLOR: rgb(255,0,0)">BackColor</span><span style="COLOR: rgb(0,0,255)">="White"</span><span style="COLOR: rgb(255,0,0)"></span><span style="COLOR: rgb(0,0,255)">/></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"></</span><span style="COLOR: rgb(128,0,0)">asp:GridView</span><span style="COLOR: rgb(0,0,255)">></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"><</span><span style="COLOR: rgb(128,0,0)">asp:ObjectDataSource</span><span style="COLOR: rgb(255,0,0)">ID</span><span style="COLOR: rgb(0,0,255)">="objMyUsers"</span><span style="COLOR: rgb(255,0,0)">runat</span><span style="COLOR: rgb(0,0,255)">="server"</span><span style="COLOR: rgb(255,0,0)">EnablePaging</span><span style="COLOR: rgb(0,0,255)">="True"</span><span style="COLOR: rgb(255,0,0)">MaximumRowsParameterName</span><span style="COLOR: rgb(0,0,255)">="recordCount"</span><span style="COLOR: rgb(255,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" />SelectCountMethod</span><span style="COLOR: rgb(0,0,255)">="GetUsersCount"</span><span style="COLOR: rgb(255,0,0)">SelectMethod</span><span style="COLOR: rgb(0,0,255)">="GetUsers"</span><span style="COLOR: rgb(255,0,0)">StartRowIndexParameterName</span><span style="COLOR: rgb(0,0,255)">="rowIndex"</span><span style="COLOR: rgb(255,0,0)">TypeName</span><span style="COLOR: rgb(0,0,255)">="DataManager"</span><span style="COLOR: rgb(0,0,255)">></span><span style="COLOR: rgb(0,0,0)"><br /><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /></span><span style="COLOR: rgb(0,0,255)"></</span><span style="COLOR: rgb(128,0,0)">asp:ObjectDataSource</span><span style="COLOR: rgb(0,0,255)">></span></div><p>指定每页显示最大数据量(页显示量)的参数:<br />MaximumRowsParameterName="recordCount" <br />指定取得数据总数方法:<br />SelectCountMethod="GetUsersCount" <br />指定分页方法:<br />SelectMethod="GetUsers" <br />指定起始行参数:<br />StartRowIndexParameterName="rowIndex"<br />指定前面方法所属类名(全限定名):<br />TypeName="DataManager<br />这几个设置是必须的,一定要对应.<br /><br />现在轻轻的点击一下运行吧(什么什么?还没写事件?...我说老铁,都啥年月了,懒人还有用那玩儿吗?).到这里,一个最快速的分页其实已经做完了.<br /><br />前面的步骤都是必须的,但仍然可以有一些变化.比如,若你已经按以往的办法写好了一个类似于</p><div style="BORDER-RIGHT: rgb(204,204,204) 1px solid; PADDING-RIGHT: 5px; BORDER-TOP: rgb(204,204,204) 1px solid; PADDING-LEFT: 4px; FONT-SIZE: 13px; PADDING-BOTTOM: 4px; BORDER-LEFT: rgb(204,204,204) 1px solid; WIDTH: 98%; PADDING-TOP: 4px; BORDER-BOTTOM: rgb(204,204,204) 1px solid; BACKGROUND-COLOR: rgb(238,238,238)"><img src="http://shouzheng.cnblogs.com/Images/OutliningIndicators/None.gif" align="top" /><span style="COLOR: rgb(0,0,255)">Create</span><span style="COLOR: rgb(0,0,0)"></span><span style="COLOR: rgb(0,0,255)">