Repeater display and layout of the example code _ Practical Tips

Front desk

Copy Code code as follows:

<div>
<table>
<tr>
<asp:repeater id= "Repeater1" runat= "Server" onitemdatabound= "Repeater1_itemdatabound" >
<ItemTemplate>
<td>
<table>
<tr>
&LT;TD colspan= "2" >
'/>
</td>
</tr>
<tr>
&LT;TD colspan= "2" >
<asp:label id= "Label1" runat= "server" text= ' <% #Eval ("Foodname")%> ' ></asp:Label>
</td>
</tr>
<tr>
<td>
<asp:label id= "Label2" runat= "server" text= ' <% #Eval ("Foodprice")%> ' ></asp:Label>
</td>
<td>
<input type= "image" Src= "Images/product_add.png" onclick= "Product_add ()"/>
<%--<asp:imagebutton id= "ImageButton1" runat= "Server" imageurl= "Images/product_add.png"/>--%>
<asp:textbox id= "TextBox1" text= "1" runat= "Server" width= "15px" readonly= "True" ></asp:TextBox>
<input type= "image" Src= "Images/product_reduce.png" onclick= "product_reduce ()"/>
<%--<asp:imagebutton id= "ImageButton2" runat= "Server" imageurl= "Images/product_reduce.png"/>--%>
</td>
</tr>
<tr>
<th colspan= "2" >
<asp:imagebutton id= "ImageButton3" imageurl= "images/btn_order.gif" runat= "Server"/>
</th>
</tr>
</table>
</td>
</ItemTemplate>
</asp:Repeater>
</tr>
</table>
</div>

Background

Copy Code code as follows:

public int i = 1;

protected void Page_Load (object sender, EventArgs e)

{

String sqlstr = @ "Data source=pc-lenove\sqlexpress;initial CATALOG=KFC; USER Id=sa; Password=abing520 ";

SqlConnection con = new SqlConnection (SQLSTR);

SqlCommand cmd = new SqlCommand ();

Cmd.commandtext = "SELECT * from Foods";

Cmd. Connection = con;

SqlDataAdapter adapter = new SqlDataAdapter (cmd);

DataTable dt = new DataTable ();

Adapter. Fill (DT);

Cmd. Dispose ();

Con. Dispose ();

This. Repeater1.datasource = DT;

This. Repeater1.databind ();

}

protected void Repeater1_itemdatabound (object sender, RepeaterItemEventArgs e)

{

if (i% 4 = 0)//4 is a row showing the number of columns

{

E.item.controls.add (New LiteralControl ("</tr><tr>"));

}

i++;

}