如何将变量传递给SqlDataSource的SelectCommand?无法正常工作，请帮忙 [英] How to pass variable to SelectCommand of SqlDataSource? Not Working Please help

问题描述

代码

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"

                    DataSourceID="SqlDataSource1" AllowPaging="True" AllowSorting="True">
                    <Columns>
                        <asp:BoundField DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" />
                        <asp:BoundField DataField="Question" HeaderText="Question" SortExpression="Question" />
                        <asp:TemplateField>
                            <ItemTemplate>
                                <asp:RadioButtonList AutoPostBack="true" ID="rbl" runat="server" Enabled="true" SelectedIndex='<%#Convert.ToInt32(DataBinder.Eval(Container.DataItem , "Discontinued"))%>'

                                    OnSelectedIndexChanged="rbl_SelectedIndexChanged">
                                    <asp:ListItem Value="0">No</asp:ListItem>
                                    <asp:ListItem Value="1">Yes</asp:ListItem>
                                </asp:RadioButtonList>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:studentConnectionString %>"



                    SelectCommand="SELECT * FROM [AddQustSrvs] where [Category]='Food' and [UserId]= @userId "

                    UpdateCommand="UPDATE [AddQustSrvs] SET [Discontinued] = @Discontinued WHERE [id] = @id">
                    <SelectParameters>
                        <asp:Parameter DefaultValue="'<%= userid %>'" Name="userId" DbType="String" />
                    </SelectParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="Discontinued" Type="Boolean" />
                        <asp:Parameter Name="id" Type="Int32" />
                    </UpdateParameters>
                </asp:SqlDataSource>

传递值''<％= userid％>''


userid = Session ["kill"].ToString();

passing Value ''<%=userid%>''


userid = Session["kill"].ToString(); code behind

推荐答案

ConnectionStrings:studentConnectionString ％> " SelectCommand =" UpdateCommand =" > < SelectParameters > < asp:Parameter 默认值 =" < ;％ = userid ％> '" 名称 userId" DbType 字符串" / > < /SelectParameters > < UpdateParameters > < asp:Parameter 名称 =" 类型 布尔" / < asp:Parameter 名称 =" 类型 Int32 " / < /UpdateParameters > < /asp:SqlDataSource >

ConnectionStrings:studentConnectionString %>" SelectCommand="SELECT * FROM [AddQustSrvs] where [Category]='Food' and [UserId]= @userId " UpdateCommand="UPDATE [AddQustSrvs] SET [Discontinued] = @Discontinued WHERE [id] = @id"> <SelectParameters> <asp:Parameter DefaultValue="'<%= userid %>'" Name="userId" DbType="String" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="Discontinued" Type="Boolean" /> <asp:Parameter Name="id" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource>

传递值''<％= userid％>''


userid = Session ["kill"].ToString();

passing Value ''<%=userid%>''


userid = Session["kill"].ToString(); code behind

>如何传递代码SqlDataSource的SelectCommand变量? [ ^ ]

这篇关于如何将变量传递给SqlDataSource的SelectCommand?无法正常工作，请帮忙的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！