using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace MengXianhui
{
 /// <summary>
 /// UltraGrid 的摘要說明。本例子演示了如何創建可排序、可拖放、可調整寬度的XP風格的DataGrid。
 /// 出自：【孟憲會之精彩世界】
 /// </summary>
 public class _default : System.Web.UI.Page
 {
  protected System.Web.UI.HtmlControls.HtmlGenericControl gridRow;
  protected System.Web.UI.WebControls.Literal RowItem;
  protected System.Web.UI.HtmlControls.HtmlGenericControl coolUltraGrid1;
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此處放置用戶代碼以初始化頁面
   coolUltraGrid1.Attributes.Add("class","coolUltraGrid");
   coolUltraGrid1.Attributes.Add("style","WIDTH: 100%; HEIGHT: 400");
   coolUltraGrid1.Attributes.Add("borderStyle","2");
   coolUltraGrid1.Attributes.Add("altRowColor","oldLace");
   coolUltraGrid1.Attributes.Add("selectionStyle","1");

   /// 請根據你的數據庫的設置，修改這里的數據庫連接字符串和查詢語句。其它不要修改。
   OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("Web.mdb") );
   cn.Open();
   OleDbCommand cmd = new OleDbCommand("SELECT  id, Title As 文檔標題,CreateDate as 發布時間,Author AS 作者 FROM Document ORDER BY id DESC",cn);
   OleDbDataReader dr;
   dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);
   ///
   ///組合表頭
   ///
   int FieldNumber = dr.FieldCount;
   int ColWidth,Tmp = 0;
   if(FieldNumber == 0)
    Response.End();
   ColWidth = (int)100/FieldNumber;
   string TableHeader = "";
   for(int i=0;i<FieldNumber;i++)
   {
    if(dr.Read())
    {
     if(i==FieldNumber-1)
      TableHeader +="<span width='"+(100-Tmp).ToString()+"%'>"+dr.GetName(i).ToString()+"</span>";
     else
      TableHeader +="<span width='"+ColWidth.ToString()+"%'>"+dr.GetName(i).ToString()+"</span>";
     Tmp+=ColWidth;
    }
   }
   gridRow.InnerHtml=TableHeader;
   int RowNumber = 1;
   TableHeader = "<div class='gridBody'>";
   while(dr.Read())
   {
    TableHeader += "<div  class='gridRow'  id='row"+RowNumber.ToString()+"'>";
    for(int i=0;i<FieldNumber;i++)
    {
     TableHeader +="<span>"+dr.GetValue(i).ToString()+"</span>";
    }
    TableHeader += "</div>";
    RowNumber++;
   }
   TableHeader += "</div>";
   RowItem.Text=TableHeader;
   cn.Close();
  }
#region Web Form Designer generated code
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }

  /// <summary>
  /// 設計器支持所需的方法 - 不要使用代碼編輯器修改
  /// 此方法的內容。
  /// </summary>
  private void InitializeComponent()
  {
   this.Load += new System.EventHandler(this.Page_Load);

  }
#endregion
 }
}