tablejoincode.aspx.cs

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

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;

public partial class TableJoinCode : System.Web.UI.Page
{
	SqlDataSource sqlDS;
    protected void Page_Load(object sender, EventArgs e)
    {
		//创建SqlDataSource控件
		sqlDS = new SqlDataSource();
		sqlDS.ConnectionString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
		sqlDS.SelectCommand = "SELECT top 50 Orders.OrderID, [Order Details].ProductID, Products.ProductName, Products.CategoryID, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount FROM  Orders INNER JOIN[Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN Products ON [Order Details].ProductID = Products.ProductID";
		sqlDS.ID = "dsAccount";		//设置SqlDataSource控件的ID
		sqlDS.DataSourceMode = SqlDataSourceMode.DataSet;	//设置为DataSet模式
		Page.Controls.Add(sqlDS);
		GridView1.DataSourceID = sqlDS.ID;
		GridView1.AllowSorting = true;
    }
}