<body>
<form id="form1" runat="server">
<div>
<asp:RepeaterID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TransportNo") %>'></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DeleteFlag") %>'></asp:TextBox>
</ItemTemplate> </asp:Repeater>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click1" Text="Button" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AccessControlConnectionString %>"
SelectCommand="SELECT [TransportNo], [DeleteFlag], [StateID], [Maker] FROM [Export_Consignment] WHERE ([TransportNo] = @TransportNo)" UpdateCommand="UPDATE Export_Consignment SET DeleteFlag = @DEL WHERE (TransportNo = @transNo)">
<SelectParameters>
<asp:Parameter DefaultValue="GHS13040021" Name="TransportNo" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:ControlParameter ControlID="TextBox2" Name="DEL" PropertyName="Text" />
<asp:ControlParameter ControlID="TextBox1" Name="transNo" PropertyName="Text" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>问题:在updateParameters中无法获取 textbox2 和textbox1文本框,如果不用repter的话,又无法为textbox赋予数据源 怎么解决textbox
<form id="form1" runat="server">
<div>
<asp:RepeaterID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
<ItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TransportNo") %>'></asp:TextBox>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DeleteFlag") %>'></asp:TextBox>
</ItemTemplate> </asp:Repeater>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click1" Text="Button" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:AccessControlConnectionString %>"
SelectCommand="SELECT [TransportNo], [DeleteFlag], [StateID], [Maker] FROM [Export_Consignment] WHERE ([TransportNo] = @TransportNo)" UpdateCommand="UPDATE Export_Consignment SET DeleteFlag = @DEL WHERE (TransportNo = @transNo)">
<SelectParameters>
<asp:Parameter DefaultValue="GHS13040021" Name="TransportNo" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:ControlParameter ControlID="TextBox2" Name="DEL" PropertyName="Text" />
<asp:ControlParameter ControlID="TextBox1" Name="transNo" PropertyName="Text" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>问题:在updateParameters中无法获取 textbox2 和textbox1文本框,如果不用repter的话,又无法为textbox赋予数据源 怎么解决textbox
你可以在后台 cs文件中这样写
System.Data.DataSet ds = new System.Data.DataSet();
ds = library.Common.sqlhelp.getDs("select * from ws_kea where 1=1 " + sqlstr); this.Repeater1.DataSource = ds;
this.Repeater1.DataBind();
然后更新时候 执行 sqlhelp.ExeSql("updatews_kefile set ***=‘***' where 主键=" +主键值 )