link1.aspx.cs

来自「shop sales computer, write asp.net code 」· CS 代码 · 共 37 行

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 link1 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string id_hangsx = Request.QueryString["id_hangsx"];
        Response.Write(id_hangsx);

        string connString = "Server=HIPPOPC; Database=LAPTOPSHOP; Integrated Security=SSPI";
        SqlConnection sqlConn = new SqlConnection(connString);
        sqlConn.Open();

        string commandString = "SELECT id_sp, ten_sp FROM sanpham WHERE id_hangsx="+id_hangsx;
        SqlCommand sqlCommand = new SqlCommand();
        sqlCommand.CommandText = commandString;
        sqlCommand.Connection = sqlConn;

        SqlDataAdapter sqlDad = new SqlDataAdapter(sqlCommand);
        DataSet ds = new DataSet();
        sqlDad.Fill(ds);

        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
}