調用資料庫 緩衝解決

寫了個頁面 由於每次調用都需要串連遠端伺服器，特別浪費資源，建立了aspx

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="HotProduct.ascx.cs" Inherits="resource_ascx_HotProduct" %>
<%@ OutputCache Duration="36000" VaryByParam="none" %>

<div class="listProduct">
<div class="listImagetop"></div>
<div class="imgProduct">
<asp:Literal ID="ltrMyResult" runat="server" />
</div>
<div class="listImageBottom"></div>
</div>

 

cs代碼

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Text;

public partial class resource_ascx_HotProduct : System.Web.UI.UserControl {
protected void Page_Load(object sender, EventArgs e) {
//擷取圖片
using (SqlConnection con1 = new SqlConnection(@"資料連線")) {
string strSql = string.Format("SELECT TOP 4 Id,name,Ext_ImageUrl1 FROM shop_Product WHERE (CategoryId = 36) ORDER BY CategoryId DESC");
SqlCommand cmd = new SqlCommand(strSql, con1);
cmd.Connection = con1;
con1.Open();

DataTable dtImg = new DataTable();
SqlDataAdapter sma = new SqlDataAdapter(cmd);
sma.Fill(dtImg);

StringBuilder tp = new StringBuilder();

for (int i = 0; i < dtImg.Rows.Count; i++) {
tp.AppendFormat("<div class='imgProduct01'><a href='http://www.jiankang800.com/shop/show_{2}' target='_blank'><img src='http://www.jiankang800.com{1}' border=0 />{0}</a></div>", dtImg.Rows[i][1], dtImg.Rows[i][2], dtImg.Rows[i][0]);
}
ltrMyResult.Text = tp.ToString();
}

}
}

 

然後寫在模板頁的：

<%@ Register Src="/resource/ascx/hotproduct.ascx" TagName="HotProduct" TagPrefix="anylen" %>   //註冊

<anylen:HotProduct runat="server" />// body部分