62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
<HeaderTemplate>
HeaderTemplate
</HeaderTemplate>
<ItemTemplate>
<tr>
<td width="20%" rowspan="3">
<%# Eval("TID")%>
<asp:RadioButtonList ID="RadioButtonList1" runat="server" DataSource='<%#GetTer(Eval("TID")) %>' DataTextField="Ttitle" DataValueField="TID">
</asp:RadioButtonList>
</td>
<td width="80%">
<%# Eval("Ttitle")%>
</td>
</tr>
<tr>
<td height="300">
<%# Eval("Tinfo")%>
</td>
</tr>
<tr>
<td>
<%# Eval("Cinfo")%>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>FooterTemplate</FooterTemplate>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}
void Bind()
{
DataTable dt = Class1.GetCs("select * from message order by TID");
Repeater1.DataSource = dt;
Repeater1.DataBind();
i = Convert.ToInt32(dt.Compute("count(TID)", ""));
}
protected DataTable GetTer(object id)
{
DataTable dt = Class1.GetCs(string.Format("select * from message where TID='{0}'", id));
return dt;
}
public static DataTable GetCs(string strsql)
{
using (SqlConnection sqlcon = new SqlConnection(WebConfigurationManager.ConnectionStrings["sqlcs"].ConnectionString))
{
sqlcon.Open();
SqlDataAdapter da = new SqlDataAdapter(strsql, sqlcon);
DataTable dt = new DataTable("bbs");
da.Fill(dt);
return dt;
}
}
<asp:TemplateField HeaderText="Category">
<EditItemTemplate>
<asp:DropDownList
id="ddlCategory"
DataSourceID="srcMovieCategories"
DataTextField="Name"
DataValueField="Id"
SelectedValue='<%# Bind("CategoryId") %>'
Runat="server" />
</EditItemTemplate>
</asp:TemplateField>
<asp:SqlDataSource
id="srcMovieCategories"
ConnectionString='<%$ ConnectionStrings:Movies %>'
SelectCommand="SELECT Id, Name FROM MovieCategories"
Runat="server" />