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>
