authorlist.ascx.cs

RSS新闻订阅浏览系统

namespace WebNews.UserControl
{
	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using System.Data.SqlClient;
	using System.Net;
	using System.Text;

	/// <summary>
	///		AuthorList 的摘要说明。
	/// </summary>
	public class AuthorList : System.Web.UI.UserControl
	{
		protected string userName;
		protected System.Web.UI.WebControls.DataList Datalist1;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			DataBindDataList();

		}

		private void DataBindDataList()
		{

			SqlConnection con = new SqlConnection();

			//con.ConnectionString="server=127.0.0.1;database=northwind;user id=sa;password=111";  	
			con.ConnectionString = App_Data.ClassConnection.CONN_STRING;

			con.Open();
			SqlDataAdapter da=new SqlDataAdapter("select authorID,authorName from author",con);
			DataSet ds=new DataSet();
			da.Fill(ds,"author");

			Datalist1.DataKeyField="authorID";
			Datalist1.DataMember="author";
			Datalist1.DataSource=ds;
			Datalist1.DataBind();

			for(int i=0;i<ds.Tables["author"].Rows.Count;i++)
			{
				this.userName = ds.Tables["author"].Rows[i][1].ToString();
				//Server.UrlEncode(userName);
				HttpUtility.UrlEncode(userName,Encoding.UTF8);

				Response.Write(userName);
				Response.Write("<br>");
				Response.Write(Server.UrlEncode("汇编")); 
				Response.Write("<br>");
				Response.Write(HttpUtility.UrlEncode("汇编",Encoding.UTF8));
			}
		}

		public string urlencode(string url)
		{
			string newUrl;
			newUrl = HttpUtility.UrlEncode(url,Encoding.UTF8);
			return newUrl;
		}

		#region Web 窗体设计器生成的代码
		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
	}
}