Re: SelectCountMethod error - looking for parameters?

Miky,

The ObjectDataSource will search for a SelectCount method with the
parameters specified in the SelectParameters collection. I know the
best possible design but...

Anyway, in your case, you are using paging and sorting so the
ObjectDataSource will automatically add the parameters for sorting and
paging later. If you don't specify the parameters in the ASPX you don't
need your SelectCount method to have those parameters. However, in your
case there is another parameter, p_PageNum that I don't know what are
you using for that will not be generated automatically by the
ObjectDataSource if you remove it.

Hope it helps,
Manuel Abadia
http://www.manuelabadia.com

miky wrote:
Hi,
I'm trying to get custom gridview paging working and I'm getting the
following error:

"ObjectDataSource 'ObjectDataSource1' could not find a non-generic
method 'count' that has parameters: p_TableName, p_OrderBy, p_MaxRows,
p_PageNum, p_StartRowIndex."

I have a gridview associated to an ObjectDataSource and the
ObjectDataSource is declared in the aspx file as follows:

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
TypeName="LookupData"
SelectCountMethod="count" SelectMethod="selectMFPSData"
MaximumRowsParameterName="p_MaxRows"
SortParameterName="p_OrderBy" EnablePaging="True"
StartRowIndexParameterName="p_StartRowIndex">
<SelectParameters>
<asp:ControlParameter ControlID="lstMFPSTABLES"
Name="p_TableName" PropertyName="SelectedValue"
Type="String" />
<asp:Parameter Name="p_OrderBy" Type="String" />
<asp:Parameter Name="p_MaxRows" Type="Int32" />
<asp:Parameter Name="p_PageNum" Type="Int32" />
<asp:Parameter Name="p_StartRowIndex" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>

The thing I don't understand is the "count" method the error refers to
is the method I've declared in the ObjectDataSource for the
SelectCountMethod property. The parameter list listed in the
declaration (in the <SelectParameters> hive) was generated when I
configured the ObjectDataSource to get a select parameter from a
control (a dropdownlist called lstMFPSTABLES).

So, a couple of questions:
1. Why is it erroring out on the count method, when the parameters are
meant for the select method?
2. Is it possible to parameterize the count method? This ability
would help in certain cases.


Thanks in advance for your help,

miky

.

Relevant Pages

  • ObjectDataSource Bind( ) on Template Column losing data on Sort
    ... allow users to select "Members" of a group, ... <SelectParameters> ... The ObjectDataSource calls my class ok, ... ...It sorts, and returns ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to programmatically access ObjectDataSource values
    ... You can access the ObjectDataSource's SelectParameters from anywhere on the page and change the DefaultValue to anything you'd like. ... you can handle the ObjectDataSource's Selecting event and then modify the parameters for that one select by adding or chaninging the ObjectDataSourceSelectingEventArgs's InputParameters. ... ObjectDataSource in our project. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SelectCountMethod error - looking for parameters?
    ... As far as I can tell you, yes, they both look to the SelectParameters, ... attributes to the methods that will be consumed by the ObjectDataSource ... miky wrote: ... declaration was generated when I ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SelectCountMethod error - looking for parameters?
    ... common in the SelectParameters hive. ... The ObjectDataSource will search for a SelectCount method with the ... Anyway, in your case, you are using paging and sorting so the ... declaration was generated when I ...
    (microsoft.public.dotnet.framework.aspnet)
  • SelectCountMethod error - looking for parameters?
    ... I'm trying to get custom gridview paging working and I'm getting the ... "ObjectDataSource 'ObjectDataSource1' could not find a non-generic ... declaration (in the <SelectParameters> hive) was generated when I ...
    (microsoft.public.dotnet.framework.aspnet)