Hi, I have a simple page:

One ObjectDataSource
One TableAdapter
One Gridview
a button and a textbox to hold my between dates parameters

I have simple SQL, select count(*) as total from employees where
startdate between @start and @end

In my tableadapter I have the sql and when I preview it it works
fine.  When I drop the objectdatasource on the webpage and configure
it it does not give me the option for the select tab to get that
method that would return the scalar value (my count).

How do I get that count and put it in a gridview?  Please.

Thank you for any help.