reapter用法

    protected void Page_Load(object sender, EventArgs e)
    {
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        //创建数据库连接
        SqlConnection cn = new SqlConnection(settings);
        //打开数据库连接
        cn.Open();

        string strsql = "select contract_detail.*,customer.Custom_name,product.Product_name,contract.* from contract_detail,customer,product,contract where contract_detail.Contract_id=@id and contract_detail.Contract_id=contract.Contract_id and contract.Custom_id=customer.Custom_id and contract_detail.Product_id=product.Product_id";
        SqlCommand cm = new SqlCommand(strsql, cn);
        cm.Parameters.Add(new SqlParameter("@id", SqlDbType.Char, 10));
        cm.Parameters["@id"].Value = Request.QueryString["Contract_id"];
        //cn.Open();
        SqlDataReader dr = cm.ExecuteReader();
        Rp_detail.DataSource = dr;
        Rp_detail.DataBind();
        cn.Close();

    <table border="0" cellpadding="0" cellspacing="0" style="width: 100%; heihgt: 100%">
            <tr>
                <td style="width: 176px; height: 14px" valign="top">
                    <uc1:menu ID="Menu1" runat="server" />
                </td>
                <td style="height: 14px; width: 777px;" valign="top">
                    <table id="Table1" border="1" cellpadding="1" cellspacing="1" style="width: 539px;
                        height: 248px">
                        <tr>
                            <td style="width: 534px; height: 31px; background-color: #cccccc">
                                <p>
                                    <strong>合同明细表</strong></p>
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 534px; height: 189px" valign="middle">
                                <asp:Repeater ID="Rp_detail" runat="server">
                                    <ItemTemplate>
                                        <table id="AutoNumber1" border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse;
                                            width: 100%;">
                                            <tr>
                                                <td colspan="4" style="width: 100%">
                                                    <p>
                                                    </p>
                                                    <i style="color: #0000FF; font-size: 14px">合同<%#DataBinder.Eval(Container.DataItem,"Contract_id")%></i>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>客户名称：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Custom_name")%>
                                                </td>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>产品名称：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Product_name")%>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>订货数量：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Product_book")%>
                                                </td>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>已发货数量：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Product_send")%>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>单价：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Product_price")%>
                                                </td>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>签署日期：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Contract_start")%>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>发货日期：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Contract_send")%>
                                                </td>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>完成日期：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Contract_finish")%>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>经办人：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Contract_person")%>
                                                </td>
                                                <td style="width: 25%">
                                                    <p style="text-align: right">
                                                    </p>
                                                    <i>总金额：</i>
                                                </td>
                                                <td style="width: 25%">
                                                    <%#DataBinder.Eval(Container.DataItem,"Contract_price")%>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="4" style="font-size: 14px; color: #ff0000">
                                                    <p style="text-align: center">
                                                    </p>
                                                    合同状态：<%#DataBinder.Eval(Container.DataItem,"Contract_state")%>
                                                </td>
                                            </tr>
                                        </table>
                                    </ItemTemplate>
                                </asp:Repeater>
                                <br />
                                <span style="color: #ff0000">合同状态：0－签署态，1－发货态，2－完成态</span><br />
                            </td>
                        </tr>
                        <tr>
                            <td style="width: 534px; background-color: #cccccc">
                                <asp:Button ID="Btn_back" runat="server" OnClick="Btn_back_Click" Text="返回" /></td>
                        </tr>
                    </table>
                </td>
            </tr>
        </table>

转载于:https://www.cnblogs.com/modernsky2003/archive/2008/01/28/1056384.html