添加where 字段=对应session

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:LabelEasyConnectionString2 %>"
            SelectCommand="SELECT [MOrderType], [MSessionID], [MMemberID] FROM [OrderView] WHERE ([MMemberID] = @MMemberID)">
            <SelectParameters>
                <asp:SessionParameter Name="MMemberID" SessionField="MemberID" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>

转载于:https://www.cnblogs.com/luyongqun/archive/2007/03/28/691214.html