利用Ilist显示记录的方法

 学海无涯，每天都会有新的发现，希望每天都能充实自己。
以前都是利用datagrid控件绑定数据并且分页，但最近看了一段别人写的代码，又学了不少新的知识

当然，以下代码是从程序里摘出来的，仅供参考

1. //去掉了大量不必要的代码
3. public IList list=null;
4. public IList dislist = new ArrayList();
5.         #region 帮顶表格
6.         /// <summary>
7.         /// 帮顶表格
8.         /// </summary>
9.         public void BindData()
10.         {
11.             GetDownloadList("","");
13.             if(null!=dislist)dislist.Clear();
15.             int start =(CurrIndex-1)*PageSize+1;
17.             for(int i=start;i<=CurrIndex*PageSize && i<=list.Count;i++)
18.             {
19.                 TblDownload tbldown = (TblDownload)list[i-1];
20.                 dislist.Add(tbldown);
23.             }
24.         
25.         }
26.         #endregion
27.         
28.         public void GetDownloadList(string region,string popedom)
29.         {
30.             Download downloads=new Download();
31.             TblDownload tblDownload=new TblDownload();
32.             //tblDownload.Category="COMMUNION";
33.             tblDownload.Region = downloads.GetAgtRegion(strAgentID);
34.             if(tblDownload.Region =="S1")   //总部地区
35.                 tblDownload.Region = "TJ";  //总部
36.             strAgentType  = promoteStandard.GetPromoteType(strAgentLevel);
37.             tblDownload.Popedom=strAgentType;
38.             list=downloads.GetTop5FileList(tblDownload);
39.             Rectotal=list.Count;
40.         }

1.         /// <summary>
2.         /// 说明：下载文件
3.         /// </summary>
4.         /// <param name="tblDownload">下载对象</param>
5.         /// <returns>
6.         /// 返回文件列表
7.         /// </returns>
8.         public IList GetTop5FileList(TblDownload tblDownload)
9.         {
10.             IList list = new ArrayList();
11.             string SqlString = "select top 5 * from tblDownLoad where filepath <> '0' order by tblDownload.fileId desc";
13.             SqlConnection connection = new SqlConnection( ConfigurationGlobals.ConnectionSqlString);
14.             SqlCommand command = new SqlCommand(SqlString,connection);
15.             SqlDataReader reader = null;
16.             try
17.             {
18.                 connection.Open();
19.                 reader = command.ExecuteReader(CommandBehavior.CloseConnection);
20.                 while(reader.Read())
21.                 {
22.                     TblDownload tbldownload = TblDownload.GetModel( reader );
23.                     list.Add(tbldownload);
24.                 }
25.             }
26.             catch(Exception e)
27.             {
28.                 throw new DataAccessException(e.Message);
29.             }
30.             finally
31.             {
32.                 if(reader != null)
33.                     reader.Close();
34.             }
35.             return list;
36.         }
37.         #endregion 

前台的代码

1.                                     <table height="44" cellSpacing="0" cellPadding="0" width="760" border="0">
2.                                         <tr>
3.                                             <td width="239">
4.                                                 <table height="22" cellSpacing="0" cellPadding="0" width="752" border="0">
5.                                                     <%  
6.                                         foreach (TblDownload item in dislist )
7.                                         {
8.                     
9.                                     %>
10.                                                     <tr>
11.                                                         <td class="bg-bottom" width="5%" background="/images/z7_21.gif"><IMG height="11" src="/images/z5_22.gif" width="12"></td>
12.                                                         <td class="bg-bottom" width="95%" background="/images/z7_21.gif" height="22"><a 
13.                         href="<%=URL+DownFile+item.FilePath%>" target=_blank 
14.                         ><%=item.Remark%></a>
15.                                                             <%TimeSpan dts = DateTime.Now-item.PublicDate;%>
16.                                                             <%if(dts.Days<=30)%>
17.                                                             <IMG src="/images/new.gif"></td>
18.                                                     </tr>
19.                                                     <%}%>
20.                                                 </table>
21.                                             </td>
22.                                         </tr>
23.                                     </table>