truck_open.aspx.cs

来自「网站开发与实例,提供完整的电子商务网站源代码。」· CS 代码 · 共 40 行

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 System.Data.SqlClient;
public partial class Truck_open : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Truck where id=" + Request.QueryString["id"], strcon);
            DataSet ds = new DataSet();
            sda.Fill(ds, "tb_Truck");
            DataRowView rowview = ds.Tables["tb_Truck"].DefaultView[0];
            this.LBLTruckType.Text = rowview["TruckType"].ToString();
            this.LBLTruckNumber.Text = rowview["TruckNumber"].ToString();
            this.LBLTruckWeight.Text = rowview["TruckWeight"].ToString();
            this.LBLTruckPrice.Text = rowview["TruckPrice"].ToString();
            this.LBLTruckDate.Text = rowview["TruckDate"].ToString();
            this.LBLStart.Text = rowview["Start"].ToString();
            this.LBLWhither.Text = rowview["Whither"].ToString();
            this.LBLLinkman.Text = rowview["Linkman"].ToString();
            this.LBLTel.Text = rowview["Tel"].ToString();
            this.LBLBewrite.Text = rowview["Bewrite"].ToString();
            ds.Clear();
            strcon.Close();
        }

    }
}