productdetailscode.aspx.cs

来自「《圣殿祭司的ASP.NET 2.0开发详解——使用C#》光盘内容.包含了书籍所含」· CS 代码 · 共 54 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


public partial class ProductDetailsCode : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		if (!IsPostBack)
		{
			Session["sourceUrl"] = Context.Request.UrlReferrer;	//读取来源URL
		}
		sqldsNorthwind.ConnectionString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;

		sqldsNorthwind.SelectCommand = "select * from Products where ProductName=@paramProductName and CategoryID=@paramCategoryID and SupplierID=@paramSupplierID";

		//建立参数
		//较为正式的声明语法
		//QueryStringParameter productParameter = new QueryStringParameter();
		//productParameter.Name = "paramProductName";
		//productParameter.Type = TypeCode.String;
		//productParameter.DefaultValue = Request.QueryString["ProductName"];
		//简洁写法，其同等于上面分别声明的语法
		QueryStringParameter productParameter = new QueryStringParameter("paramProductName", TypeCode.String, "ProductName");
		sqldsNorthwind.SelectParameters.Add(productParameter);

		QueryStringParameter categoryidParameter = new QueryStringParameter("paramCategoryID", TypeCode.String, "CategoryID");
		sqldsNorthwind.SelectParameters.Add(categoryidParameter);

		QueryStringParameter supplieridParameter = new QueryStringParameter("paramSupplierID", TypeCode.String, "SupplierID");
		sqldsNorthwind.SelectParameters.Add(supplieridParameter);

		dviewProduct.DataSourceID = sqldsNorthwind.ID;
    }

	//回上一页
	protected void btnBack_Click(object sender, EventArgs e)
	{
		if (Session["sourceUrl"] != null)
		{
			Response.Redirect(Session["sourceUrl"].ToString());
		}
	}
}