member/show2.aspx.cs

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

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class member_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack && Session["lname"] != null)
        {
            chushi();
        }
    }
    /// <summary>
    /// 初始化
    /// </summary>
    protected void chushi()
    {
        //判断url传递的id是否为null
        if (Request.QueryString["id"] != null)
        {
            string sql = "";
            sql = "select * from ordersMore a left join orders b on a.oid=b.oid left join products c on a.pid=c.pid left join members d on b.lname=d.lname where id=" + Request.QueryString["id"] ;
            //根据编号得到相应的记录
            SqlDataReader sdr = DbHelperSQL.ExecuteReader(sql);
            if (sdr.Read())
            {
                lbloid.Text = sdr["oid"].ToString();
                lblmname.Text = sdr["mname"].ToString();
                lbltel.Text = sdr["tel"].ToString();
                lbladdress.Text = sdr["address"].ToString();
           
                lbladdress.Text = sdr["address"].ToString();
                lblpname.Text = sdr["pname"].ToString();
                lblmname.Text = sdr["mname"].ToString();
                lbltel.Text = sdr["tel"].ToString();
                lblemail.Text = sdr["email"].ToString();
                lbladdress.Text = sdr["address"].ToString();
                if (sdr["pic"].ToString() != "" && sdr["pic"].ToString().Length > 3)
                {
                    imgpic.ImageUrl = "../uploads/" + sdr["pic"].ToString();
                }

                lbloprice.Text = sdr["oprice"].ToString();
                lblquantity.Text = sdr["quantity"].ToString();

            }

        }
    }

 
}