ASP.NET中利用DataGrid控件显示图片以及在图片和文字上加超链接

数据表：

界面代码：

<asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" BorderWidth="0px"PageSize="5" ShowHeader="False" Width="760" AllowPaging="True" OnPageIndexChanged="DataGrid2_PageIndexChanged">
<Columns>
<asp:TemplateColumn>
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" height="110" width="760">
<tr>
<td runat="server" align="center" rowspan="2" style="border-bottom: #9ec9eb 1px solid"
valign="middle" width="140">
<a href='shangPin.aspx?id=<%#DataBinder.Eval(Container.DataItem,"name")%>'>
<img border="0" height="90" src='../upImg/<%#DataBinder.Eval(Container.DataItem,"pic")%>'
width="120"></a></td>
<td runat="server" height="40" width="260" align="center">
<a href='shangPin.aspx?id=<%#DataBinder.Eval(Container.DataItem,"name")%>'>
<%#DataBinder.Eval(Container.DataItem,"name")%>
</a>
</td>
<td runat="server" align="center" height="40" width="120">
￥<%#DataBinder.Eval(Container.DataItem,"price")%></td>
<td runat="server" align="center" height="40" width="120">
<%#DataBinder.Eval(Container.DataItem,"status")%>
</td>

</tr>
<tr align="center">
<td runat="server" colspan="4" height="70" style="border-bottom: #9ec9eb 1px solid"
valign="middle" width="620">
<%#DataBinder.Eval(Container.DataItem,"desn")%>
</td>
</tr>
</table>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>

后台代码：

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Data Source=.;User ID=sa;Password=123;Initial Catalog=kxjm_DB";

conn.Open();

if (conn.State == ConnectionState.Open)

{

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandText = "select name,price,pic,desn,status from goods ";

SqlDataAdapter dap = new SqlDataAdapter();

dap.SelectCommand = cmd;

DataSet ds1 = new DataSet();

dap.Fill(ds1, "goods");

DataGrid1.DataSource = ds1.Tables[0];

DataGrid1.DataBind();

}

运行效果：