asp.net 关于前后台传值问题

[bujing921]

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" OnPageIndexChanged="GridView1_PageIndexChanged" AllowSorting="True" ForeColor="#333333" GridLines="None" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<div>评论人：<%# DataBinder.Eval(Container.DataItem,"UserName") %>      评论时间：<%# DataBinder.Eval(Container.DataItem,"InDate") %></div>
<%# DataBinder.Eval(Container.DataItem,"Content") %></div>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerStyle BorderColor="#FFC080" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="select a.*,b.UserName from tb_LawyerArticle_Critique a left join tb_Users b on a.UserID=b.ID">
</asp:SqlDataSource>
</ContentTemplate>
</asp:UpdatePanel>
<asp:UpdateProgress ID="UpdateProgress1" runat="server" AssociatedUpdatePanelID="UpdatePanel1">
<ProgressTemplate>
<div style="background-color:Red;color:#fff;width:64px">Loading...</div>
</ProgressTemplate>
</asp:UpdateProgress>

请看一下红色的那个地方，现在在后台代码那里有一个 iID 值，想传到前台，但是我加 where 的时候出错误

[wudao0501]

也可以不用SqlDataSource呀，后台用DataSource，然后绑定就行了。

[皓月明]

干嘛那么写

[peng_weida]

你用的参数啊

[CeleryZeng]

你在配置sqldatasource的时候就要加上where条件啊··然后选择要查询的条件的字段

[wudao0501]

<asp:SqlDataSource ID="sqldsCAddressListDetail" runat="server" ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:MySql %>" DeleteCommand="DELETE FROM [tongxunlu] WHERE [id] = @original_id AND [name] = @original_name AND [company] = @original_company AND [addr] = @original_addr AND [phone1] = @original_phone1 AND [phone2] = @original_phone2 AND [mobile] = @original_mobile AND [fax] = @original_fax AND [email] = @original_email AND [post] = @original_post AND [beizu] = @original_beizu AND [birthday] = @original_birthday AND [wangzan] = @original_wangzan"
            InsertCommand="INSERT INTO [tongxunlu] ([name], [company], [addr], [phone1], [phone2], [mobile], [fax], [email], [post], [beizu], [birthday], [wangzan],[sf_public]) VALUES (@name, @company, @addr, @phone1, @phone2, @mobile, @fax, @email, @post, @beizu, @birthday, @wangzan,'yes')"
            OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [id], [name], [company], [addr], [phone1], [phone2], [mobile], [fax], [email], [post], [beizu], [birthday], [wangzan] FROM [tongxunlu] where id = @paramID"
            UpdateCommand="UPDATE [tongxunlu] SET [name] = @name, [company] = @company, [addr] = @addr, [phone1] = @phone1, [phone2] = @phone2, [mobile] = @mobile, [fax] = @fax, [email] = @email, [post] = @post, [beizu] = @beizu, [birthday] = @birthday, [wangzan] = @wangzan WHERE [id] = @original_id" OnInserted="sqldsCAddressListDetail_Inserted">
            <DeleteParameters>
                <asp:Parameter Name="original_id" Type="Int32" />
                <asp:Parameter Name="original_name" Type="String" />
                <asp:Parameter Name="original_company" Type="String" />
                <asp:Parameter Name="original_addr" Type="String" />
                <asp:Parameter Name="original_phone1" Type="String" />
                <asp:Parameter Name="original_phone2" Type="String" />
                <asp:Parameter Name="original_mobile" Type="String" />
                <asp:Parameter Name="original_fax" Type="String" />
                <asp:Parameter Name="original_email" Type="String" />
                <asp:Parameter Name="original_post" Type="String" />
                <asp:Parameter Name="original_beizu" Type="String" />
                <asp:Parameter Name="original_birthday" Type="String" />
                <asp:Parameter Name="original_wangzan" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="company" Type="String" />
                <asp:Parameter Name="addr" Type="String" />
                <asp:Parameter Name="phone1" Type="String" />
                <asp:Parameter Name="phone2" Type="String" />
                <asp:Parameter Name="mobile" Type="String" />
                <asp:Parameter Name="fax" Type="String" />
                <asp:Parameter Name="email" Type="String" />
                <asp:Parameter Name="post" Type="String" />
                <asp:Parameter Name="beizu" Type="String" />
                <asp:Parameter Name="birthday" Type="String" />
                <asp:Parameter Name="wangzan" Type="String" />
                <asp:Parameter Name="original_id" Type="Int32" />
            </UpdateParameters>
            <SelectParameters>
                <asp:QueryStringParameter Name="paramID" QueryStringField="id" />
            </SelectParameters>
            <InsertParameters>
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="company" Type="String" />
                <asp:Parameter Name="addr" Type="String" />
                <asp:Parameter Name="phone1" Type="String" />
                <asp:Parameter Name="phone2" Type="String" />
                <asp:Parameter Name="mobile" Type="String" />
                <asp:Parameter Name="fax" Type="String" />
                <asp:Parameter Name="email" Type="String" />
                <asp:Parameter Name="post" Type="String" />
                <asp:Parameter Name="beizu" Type="String" />
                <asp:Parameter Name="birthday" Type="String" />
                <asp:Parameter Name="wangzan" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>

添加，修改，查看都有了

[bujing921]

SelectCommand="SELECT [id], [name], [company], [addr], [phone1], [phone2], [mobile], [fax], [email], [post], [beizu], [birthday], [wangzan] FROM [tongxunlu] where id = @paramID"

@paramID 是什么呀

[wudao0501]

做查询是用到的条件
<SelectParameters>
<asp:QueryStringParameter Name="paramID" QueryStringField="id" />
</SelectParameters>

[陈杰2028]

我想问的是怎样在后台中post另外一个页面