showproduct.aspx.cs

shop sales computer, write asp.net code c#

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 ShowProduct : System.Web.UI.Page
{
    DataSet dataset = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack && Page.ClientQueryString!="")
        {
            string id_sp = Request.QueryString.Get("id_sp");
            ShowProductByID(id_sp);
        }
    }
    void ShowProductByID(string id_sp)
    {
        KetNoiClass kn = new KetNoiClass();
        try 
        {
            kn.MoKetNoi();
            dataset = kn.TruyVan("select * from sanpham,nhomsp,hangsx where hangsx.id_hangsx=sanpham.id_hangsx and sanpham.id_nhomsp=nhomsp.id_nhomsp and id_sp=" + id_sp + "", "detail");
            kn.DongKetNoi();
            DataList1.DataSource = dataset.Tables["detail"];
            DataList1.DataMember = "ten_sp";
            DataList1.DataMember = "gia";
            DataList1.DataMember = "mota_soluoc";
            DataList1.DataMember = "ten_hangsx";
            DataList1.DataMember = "kichthuoc";
            DataList1.DataMember = "trongluong";
            DataList1.DataMember = "baohanh";
            DataList1.DataMember = "khuyenmai";
            DataList1.DataMember = "congnghe_cpu";
            DataList1.DataMember = "tocdo_cpu";
            DataList1.DataMember = "loai_cpu";
            DataList1.DataMember = "nsx_cpu";
            DataList1.DataMember = "cache_cpu";
            DataList1.DataMember = "loaicache_cpu";
            DataList1.DataMember = "thongtin_cpu";
            DataList1.DataMember = "thongtin_main";
            DataList1.DataMember = "bus_main";
            DataList1.DataMember = "thongtin_cpu";
            DataList1.DataMember = "hotroram_main";
            DataList1.DataMember = "dungluong_ram";
            DataList1.DataMember = "congnghe_ram";
            DataList1.DataMember = "bus_ram";
            DataList1.DataMember = "dungluong_hdd";
            DataList1.DataMember = "tocdoquay_hdd";
            DataList1.DataMember = "thongtin_display";
            DataList1.DataMember = "kichthuoc_display";
            DataList1.DataMember = "thongtin_graphic";
            DataList1.DataMember = "congnghe_graphic";
            DataList1.DataMember = "chuan_sound";
            DataList1.DataMember = "thongtin_sound";
            DataList1.DataMember = "thongtin_oquang";
            DataList1.DataMember = "odia_oquang";
            DataList1.DataMember = "tinhnang_morong";
            DataList1.DataMember = "wireless_network";
            DataList1.DataMember = "chuanwireless_network";
            DataList1.DataMember = "modem_network";
            DataList1.DataMember = "thongtinmang_network";
            DataList1.DataMember = "port_network";
            DataList1.DataMember = "card_reader";
            DataList1.DataMember = "slot_reader";
            DataList1.DataMember = "thongtin_webcam";
            DataList1.DataMember = "ten_webcam";
            DataList1.DataMember = "congnghe_pin";
            DataList1.DataMember = "thongtin_pin";
            DataList1.DataMember = "thongtin_hdh";
            DataList1.DataMember = "ten_hdh";
            DataList1.DataMember = "hotro_hdh";
            DataList1.DataMember = "thongtin_phukien";
            DataList1.DataMember = "ten_phukien";
            DataList1.DataMember = "thongtin_phanmem";
            DataList1.DataMember = "caidat_phanmem";
            DataList1.DataMember = "ten_nhomsp";
            DataList1.DataMember = "url_hinh";
            DataList1.DataBind();        
        }
        catch (Exception ex) { Response.Write(ex.Message); }
    }
}