Default.aspx.cs

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

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 Default : System.Web.UI.Page
{
    public string htmls = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlData da = new SqlData();
            string strEconomic = "select top 6 * from tb_News where Categories='美容养生热点' order by issueDate desc";
            SqlDataReader sdrEco = da.ExecuteRead(strEconomic);
            dlstEconomic.DataSource = sdrEco;
            dlstEconomic.DataKeyField = "id";
            dlstEconomic.DataBind();
            sdrEco.Close();

            var sql = @"select top 4 * from Book order by intime desc";
            var dt = da.datesetExecute(sql, "234");
            var i = 0;
            foreach (DataRow item in dt.Tables[0].Rows)
            {
                if (i == 0)
                {
                    htmls += " <div class=\"lb-item active\" >";
                }
                else
                {
                    htmls += " <div class=\"lb-item\">";
                }
                htmls += "           <a href = \"bookDet.aspx?id=" + item["barcode"] + "\"  >";
                htmls += "             <img src = \"admin/"+item["photo"] +"\" alt = \"picture loss\" >";
                htmls += "               <span> " + item["bookname"] + " </span>";
                htmls += "             </a >";
                htmls += "         </div> ";
                i++;
            }
        }
    }

    protected void dlstEconomic_ItemCommand(object source, DataListCommandEventArgs e)
    {
        int id = Convert.ToInt32(dlstEconomic.DataKeys[e.Item.ItemIndex].ToString());
        Response.Redirect("NewsDetail.aspx?id=" + id + "");
    }
}