<asp:DataList ID="DataList1" runat="server" RepeatColumns="6" RepeatDirection="Horizontal"> <ItemTemplate> <table border="0"> <tr> <td> <img src='<%#DataBinder.Eval(Container.DataItem,"Product_image") %>' border="0" height="97" width="135" /> </td> </tr> </table> </ItemTemplate></asp:DataList>
img src='<%#DataBinder.Eval(Container.DataItem,"Product_image") %>'綁定圖片。建立DBConn.cs,代碼如下:
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Data.SqlClient;using System.Configuration;using System.Data;/// <summary>///DBConn 的摘要說明/// </summary>public class DBConn{ private String StrConn = string.Empty; private SqlConnection con; public DBConn() { GetConn(); } private SqlConnection GetConn() { StrConn = ConfigurationManager.ConnectionStrings["DBProductConn"].ConnectionString;//連接字符串為DBProductConn con = new SqlConnection(StrConn); return con; } public DataSet Getds() { SqlConnection con =GetConn(); SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Product", con);//tb_Product為數(shù)據(jù)庫中的表 DataSet ds = new DataSet(); sda.Fill(ds); return ds; }}
完成了初始化數(shù)據(jù)庫連接后,在Default.aspx后臺代碼Default.aspx.cs中實例化:
using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;public partial class _Default : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataBindDS(); } } private void DataBindDS() { DBConn DB = new DBConn(); DataSet ds = DB.Getds(); DataList1.DataSource = ds.Tables[0].DefaultView; DataList1.DataBind(); }}