reapter用法

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>