DataTable达到横向显示数据

 1         /// <summary>
 2         /// 生成行业排名前台页面用的DataTable
 3         /// </summary>
 4         /// <param name="s">如果是"1"就是全部行业的排名,如果不是则是前20名的分类排名</param>
 5         /// <returns></returns>
 6         public DataTable TradeKeyWord(string s)
 7         {
 8             string sss = "http://www.search.hc360.com/cgi-bin/ls";
 9             OracleDataReader dR01, dR02;
10             DataTable dt = new DataTable();
11             DAL.Charts.ChartsRead CR = new DAL.Charts.ChartsRead();
12             string sqlsql="";
13             if (s == "1")
14             {
15                 sqlsql += sql022;
16             }
17             else
18             {
19                 sqlsql += sql022 + " where rownum<21";
20             
21             }
22             dR02 = CR.dRead(sqlsql);
23             //"0"是datatable中的行业名称那一列,
24             string[] aryField = { "0", "1", "2", "3", "4", "5", "6", "7" ,"8"};
25             for (int i = 0; i < aryField.Length; i++)
26             {
27                 dt.Columns.Add(new DataColumn(aryField[i], typeof(string)));
28             }
29             while (dR02.Read())
30             {
31                 DataRow dr = dt.NewRow();
32                 string sql = sql011 + dR02["TRTRADECLASS"].ToString() + "' order by TRDATETIME desc,to_number(TRNUMBER) desc) where rownum<10";
33                
34                 string qq = "select count(*) from (" + sql + ")";
35                 int mm = Convert.ToInt32(base.DataReaderSingle(qq)[0].ToString());
36                 dR01 = CR.dRead(sql);
37                 for (int i = 0; i < mm; i++)
38                 {
39                     
40                     if (i == 0)
41                     {
42 
43                         dr["0"] = "<strong>" + dR02["TRTRADECLASS"].ToString() + "</strong>";
44                         //dt.Columns.Add(new DataColumn(dR02["TRTRADECLASS"].ToString(), typeof(string)));
45                     }
46                     else
47                     {
48                         dR01.Read();
49                         //System.Web.HttpContext.Current.Response.Write(dR01["TRKEYWORD"].ToString());
50                         //if (dR01["TRKEYWORD"] == null)
51                         //{
52 
53                         //}
54                         //else
55                         //{
56                         //    keyword += dR01["TRKEYWORD"].ToString();
57                         //}
58                         dr[i.ToString()] = "<a href='" + sss + "?c=供应信息&w=" + dR01["TRKEYWORD"].ToString() + "&i=" + dR02["TRTRADECLASS"].ToString() + "' target='_blank'>" + dR01["TRKEYWORD"].ToString() + "</a>";
59                         //dt.Columns.Add(new DataColumn(dR01["TRKEYWORD"].ToString(), typeof(string)));
60                     }
61                 }
62                 dt.Rows.Add(dr);
63                 ////aryField.Add(dR02["TRTRADECLASS"].ToString());
64                 //dt.Rows.Add(new (dR02["TRTRADECLASS"].ToString(), typeof(string)));
65             }
66 
67             CR.dClose();
68             return dt;
69         }
70 
71 //使用datatable可以达到横向显示数据的效果