请教：关于GridView控件自动生成select语句的问题

[soft_wsx]

大家好：
我用GridView控件自动生成select语句,但是没有加条件，

SelectCommand="SELECT [spbh], [spmch], [shpgg], [sccj], [dw], [lshj], [huiyj],
 [spid], [flid], [picture4], [picture3], [picture2], [picture1], 
[picture], [picture5] FROM [spinfo] WHERE ([ClassBH] LIKE '%'+@ClassBh+'%')" 

现在我需要的就是在where 后台加条件，

条件是Resquest.Querystring["Class"].ToString();

我不知道怎么将语句加到where后面，请大哥哥帮了忙，小弟感谢

[xupeihuagudulei]

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:XMES_DEVELOPConnectionString %>" 
        DeleteCommand="DELETE FROM [XMES_ASSEMBLY] WHERE [ASSEMBLY_ID] = @ASSEMBLY_ID" 
        InsertCommand="INSERT INTO [XMES_ASSEMBLY] ([ASSEMBLY_ID], [ASSEMBLY_NAME], [DESCRIPTION], [IS_ACTIVE], [IS_SYSTEM], [EDIT_BY_USER], [LAST_EDIT_TIME]) VALUES (@ASSEMBLY_ID, @ASSEMBLY_NAME, @DESCRIPTION, @IS_ACTIVE, @IS_SYSTEM, @EDIT_BY_USER, @LAST_EDIT_TIME)" 
        SelectCommand="SELECT * FROM [XMES_ASSEMBLY] WHERE ([ASSEMBLY_ID] = @ASSEMBLY_ID)" 
        UpdateCommand="UPDATE [XMES_ASSEMBLY] SET [ASSEMBLY_NAME] = @ASSEMBLY_NAME, [DESCRIPTION] = @DESCRIPTION, [IS_ACTIVE] = @IS_ACTIVE, [IS_SYSTEM] = @IS_SYSTEM, [EDIT_BY_USER] = @EDIT_BY_USER, [LAST_EDIT_TIME] = @LAST_EDIT_TIME WHERE [ASSEMBLY_ID] = @ASSEMBLY_ID">
        <SelectParameters>
            <asp:ControlParameter ControlID="Label1" Name="ASSEMBLY_ID" PropertyName="Text" 
                Type="String" />
        </SelectParameters>
        <DeleteParameters>
            <asp:Parameter Name="ASSEMBLY_ID" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="ASSEMBLY_NAME" Type="String" />
            <asp:Parameter Name="DESCRIPTION" Type="String" />
            <asp:Parameter Name="IS_ACTIVE" Type="Boolean" />
            <asp:Parameter Name="IS_SYSTEM" Type="Boolean" />
            <asp:Parameter Name="EDIT_BY_USER" Type="String" />
            <asp:Parameter Name="LAST_EDIT_TIME" Type="DateTime" />
            <asp:Parameter Name="ASSEMBLY_ID" Type="String" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="ASSEMBLY_ID" Type="String" />
            <asp:Parameter Name="ASSEMBLY_NAME" Type="String" />
            <asp:Parameter Name="DESCRIPTION" Type="String" />
            <asp:Parameter Name="IS_ACTIVE" Type="Boolean" />
            <asp:Parameter Name="IS_SYSTEM" Type="Boolean" />
            <asp:Parameter Name="EDIT_BY_USER" Type="String" />
            <asp:Parameter Name="LAST_EDIT_TIME" Type="DateTime" />
        </InsertParameters>
    </asp:SqlDataSource>

希望你能明白。

[ym_pang_pang]

楼上经典……