OrderDetail.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;


public partial class OrderDetail : System.Web.UI.Page
{
    protected void Page_Load(object sender, System.EventArgs e)
    {

        if (Session["name"] == null)
        {
            Response.Redirect("Jump.aspx");
        }
        string oproid = Request["oproid"].ToString();
        DataTable dt;
        string sql;
        sql = "SELECT * FROM tProduct WHERE ID=" + oproid;
        dt = MyDB.GetDataTable(sql);
        Label1.Text = dt.Rows[0]["productname"].ToString();
        Label2.Text = dt.Rows[0]["productprice"].ToString();

        sql = "SELECT * FROM tUser WHERE username = '" + Session["name"].ToString() + "'";
        dt = MyDB.GetDataTable(sql);
        DataGrid1.DataSource = dt;
        DataGrid1.DataBind();
    }
    protected void Button1_Click(object sender, System.EventArgs e)
    {
        string sql = "INSERT INTO tOrder (opid,opnum,ouser,otime,isdeal) VALUES(" + Request["oproid"].ToString() + "," + TextBox1.Text + ",'" + Session["name"].ToString() + "','" + System.DateTime.Now.ToString() + "','否')";
        MyDB.ExecuteSql(sql);
        Response.Redirect("OrderList.aspx");
    }
}