?? 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 news
{
/// <summary>
/// _Default 的摘要說明。
/// </summary>
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(Object sender, EventArgs e)
{
//頁面初始化
if(!IsPostBack)
{
//創建數據庫連接,讀取新聞信息
string strDBPath = System.Configuration.ConfigurationSettings.AppSettings["DBPath"];
string strConn = System.Configuration.ConfigurationSettings.AppSettings["Connection"] + Server.MapPath(strDBPath);
OleDbConnection myConnection = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("select top 10 * FROM News WHERE typeid=1 order by DTime desc", myConnection);
OleDbDataAdapter myCommand1 = new OleDbDataAdapter("select top 10 * FROM News WHERE typeid=2 order by DTime desc", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "News");
myCommand1.Fill(ds, "Type");
//為DataGrid綁定數據源
MyList.DataSource = ds.Tables["News"].DefaultView;
MyList1.DataSource = ds.Tables["Type"].DefaultView;
MyList.DataBind();
MyList1.DataBind();
myCommand.Dispose();
myCommand1.Dispose();
}
}
//格式化字符串
protected string FormatString(string str)
{
str=str.Replace(" "," ");
str=str.Replace("<","<");
str=str.Replace(">",">");
str=str.Replace('\n'.ToString(),"<br>");
return str;
}
#region Web 窗體設計器生成的代碼
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -