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]

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

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

Ray

 

[Lloyd Sheen]

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

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