1<%...@ Page Language="C#" %>
 2<%...@ Import Namespace="System.Data.OleDb" %>
 3
 4
 5<script runat="server">...
 6    //显示几条数据在指定的位置
 7    /// <summary>
 8    /// <script   type="text/javascript" src="Files/ShowFileItems.aspx?Num=8&TypeID=2"></sscript>
 9    ///Num 条数
10    ///TypeID 类型的ID
11    /// </summary>
12
13    
14    private void Page_Init(object sender, EventArgs e)
15    ...{
16        Int32 iTypeID = 0;//类型的ID
17        Int32 iNum = 8;//显示的条数
18        string strShowTime = "";//是否显示时间
19        if ( Request.QueryString["Num"] == null)
20        ...{
21            Response.Write("参数错误!");
22            return;
23        }
24        iNum = Int32.Parse(Request.QueryString["Num"].ToString());
25        if (Request.QueryString["ShowTime"] != null)
26        ...{
27            strShowTime = Request.QueryString["ShowTime"].ToString();
28        }
29        if (Request.QueryString["TypeID"] != null)
30        ...{
31            
32            iTypeID = Int32.Parse(Request.QueryString["TypeID"].ToString());
33        }
34        
35        CsharpBean cb = new CsharpBean();
36        OleDbConnection ConnAcc = new OleDbConnection(cb.MyConn); //OleDb链接类的实例化
37        ConnAcc.Open();//打开数据库
38        string strSQL = "";//SQL语句
39        if (iTypeID > 0)
40        ...{
41            strSQL = "SELECT Top " + iNum + " Title,Url,InputTime FROM FileList Where TypeID=" + iTypeID + "  Order by InputTime DESC";
42        }
43        else
44        ...{
45            strSQL = "SELECT Top " + iNum + " Title,Url,InputTime FROM FileList   Order by InputTime DESC";
46        }
47        OleDbCommand cmd = new OleDbCommand(strSQL, ConnAcc);//创建Command命令对象
48        OleDbDataReader dr = cmd.ExecuteReader();//创建DataReader对象，并调用ExecuteReader从数据源检索行
49
50        try
51        ...{
52            Response.Write("document.write('<table width=100% border=0 cellspacing=0 cellpadding=0>');");
53
54            while (dr.Read())//启动阅读器的Read方法，返回行的每一列
55            ...{
56                Response.Write("document.write('<tr > ');");
57                Response.Write("document.write('<td width=5% height=25><img src=/images/red_dian.gif alt=List width=3 height=3></td> ');");
58                //string str = "<td height=25><span style=FONT-SIZE: 12px><a href=~/Files/" + dr["Url"].ToString() + " target=_blank> " + dr["Title"].ToString() + "</a></span></td>";
59                //Response.Write("document.write('" + str + "');");
60                Response.Write("document.write('<td height=25><span style=FONT-SIZE: 12px><a href=/Files/" + dr["Url"].ToString() + " target=_blank>" + dr["Title"].ToString() + "</a></span></td>');");
61                if (strShowTime == "YES")
62                ...{
63                    Response.Write("document.write('<td width=22% height=25><span style=FONT-SIZE: 12px>[ " + DateTime.Parse(dr["InputTime"].ToString()).ToShortDateString() + " ]</span></td> ');");
64                }
65                Response.Write("document.write('</tr> <tr >');");
66                Response.Write("document.write(' <td height=1 background=images/title_dotted.gif></td>');");
67                Response.Write("document.write('<td height=1 background=images/title_dotted.gif></td> ');");
68                if (strShowTime == "YES")
69                ...{
70                    Response.Write("document.write('<td height=1 background=images/title_dotted.gif></td> ');");
71                }
72                Response.Write("document.write('</tr> ');");
73                //Response.Write("document.write(' ');");
74
75            }
76            //..数据读取,格式为 dr["列名"]
77            Response.Write("document.write('</table>');");
78            Response.Write("document.write('<br>');");
79        }
80        catch (Exception ex)
81        ...{
82            Response.Write("错误，错误原因：" + ex.Message);
83            Response.End();
84        }
85        finally
86        ...{
87            dr.Close();//关闭阅读器
88            ConnAcc.Close();//关闭数据库 
89        }
90    }
91</script>
92