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();

          

        }

 

运行效果：