link.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 Link : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string connString = "Server=HIPPOPC; Database=LAPTOPSHOP; Integrated Security=SSPI";
        SqlConnection sqlConn = new SqlConnection(connString);
        sqlConn.Open();

        string commandString = "SELECT * FROM hangsx";
        SqlCommand sqlCommand = new SqlCommand();
        sqlCommand.CommandText = commandString;
        sqlCommand.Connection = sqlConn;

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

        DataList1.DataSource = ds.Tables[0];
        DataList1.DataMember = "id_hangsx";
        DataList1.DataMember = "ten_hangsx";
        DataList1.DataBind();
    }
}