?? default.aspx.cs
字號:
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
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -