order.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 order : System.Web.UI.Page
{
    BaseClass BaseClass1 = new BaseClass();

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["name"] == null)
        {
            Response.Write("<script>alert(\"请登录！\");</script>");
            Response.Redirect("default.aspx");
        }

        // 在此处放置用户代码以初始化页面
        if (!Page.IsPostBack)
        {
            string strsql = "select 产品名称,产品价格 from 产品 where 流水号 =" + Request.QueryString["id"];
            DataTable dt = new DataTable();
            dt = BaseClass1.ReadTable(strsql);
            Label1.Text = dt.Rows[0].ItemArray[0].ToString();
            Label2.Text = dt.Rows[0].ItemArray[1].ToString();
            TextBox1.Text = "1";
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string strsql;
        strsql = "insert into 订单 (产品流水号,订购数量,用户名,订购日期) values (" + Request.QueryString["id"] + "," + TextBox1.Text + ",'" + Session["name"].ToString() + "',convert(datetime,'" + DateTime.Today.ToShortDateString() + "',120))";
        BaseClass1.execsql(strsql);
        Response.Write("<script>alert(\"提交成功，您还可以选购其它商品！\");</script>");
        Response.Redirect("showpros.aspx?id=%");

    }
}