OrderInfo.aspx.cs

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

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

public partial class OrderInfo : System.Web.UI.Page
{
    string str = System.Configuration.ConfigurationManager.AppSettings["str_con"].ToString(); //连接数据库
    SqlConnection con = null;
    SqlCommand cmd = null;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack) {
            bind();
        }
    }
    public void bind()
    {
        con = new SqlConnection(str);
        string str_cmd = "select * from [dbo].[OrderInfo] where  UserName='" + Session["login"] + "'";
        con.Open();
        SqlDataAdapter dr = new SqlDataAdapter(str_cmd, con);
        cmd = new SqlCommand(str_cmd, con);
        if (cmd.ExecuteScalar() != null)
        {
            SqlDataReader read = cmd.ExecuteReader();
            read.Read();
            label.Font.Size = 18;  /*Label字体大小*/
            label2.Font.Size = 18;  /*Label字体大小*/
             label2.Text  = "订单编号： "+read["订单ID"].ToString();
             label.Text  = "下单时间： "+read["订购日期"].ToString();
            read.Close(); 
        }
        DataSet ds = new DataSet();
        dr.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        con.Close();
    }
}