ObjectDataSource - Select - Nullable parameter

[rbrowning1958]

Hello,

Have an objectdatasource with a method much like this:

public SomeDataSet.MyDataTable getMyDataTable(int? pkID)
{
if (pkID == null)
return adapater.GetMyTable("ALL")
else
return adapter.GetMyTable("SING")
}

When I configure the objectdatasource I tell it to call this method
for the select. In the define parameters if I give it a value of 1, or
2, or some other integer works fine. If I tell it to use null as the
default value, at run time I get an error "Input string was not in
correct format". Any ideas anyone?

Thanks

Ray

[rbrowning1958]

For anyone interested I solved this. You just leave the parameter
empty - don't try typing in null doh!

Ray

[Lloyd Sheen]

"rbrowning1958" <RBrown...@gmail.com> wrote in message
news:6b42e885-a03b-47af...@b64g2000hsa.googlegroups.com...

If I may make a suggestion. Create an enum with each value for GetMyTable
and then use a switch statement to do the correct GetMyTable. In case you
have to get another table this would be much more flexable and
understandable later.

LS