110,537
社区成员
发帖
与我相关
我的任务
分享
<asp:DataList runat="server" ID="newproductlist" RepeatColumns="5" RepeatDirection="Horizontal" CellSpacing="5">
<ItemTemplate>
<div class="goods_show">
<a target="_self" href="#">
<img src="image/<%Eval("Gimage") %>>" width="180" height="180" />
</a>
<div class="brief_info"><%Eval("Gname")%> <b>¥<%Eval("Gprice")%></b></div>
</div>
</ItemTemplate>
</asp:DataList>
后台除了连接数据库,还需要什么操作的?
给你一个简单的示例,读取数据库在前面GridView中显示。
后台读取数据库代码
public string connectionString = "Data Source=192.168.1.2;Initial Catalog=data;User ID=sa;password=sa;Integrated Security=False";
public string queryString = "select * from table";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataAdapter da = new SqlDataAdapter(command);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
command.Dispose();
connection.Close();
}
}
}
前台的加入控件GridView1,就可
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</form>