userorder.aspx.cs

包含了几个由sql server2005开发的典型程序

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 GROUP.Manage;

public partial class userorder : System.Web.UI.Page
{
    BaseClass BaseClass1 = new BaseClass();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["name"] != null)
        {
            string strsql = "select  订单.流水号,产品.产品名称,订单.订购数量,订单.订购日期,订单.处理标志 from 订单,产品 where 订单.产品流水号=产品.流水号 and 订单.用户名='" + Session["name"].ToString() + "' order by 订单.流水号 desc";
            DataTable dt = BaseClass1.ReadTable(strsql);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }
        else
        {
            Response.Redirect("default.aspx");
        }


    }
}