How do I get the return value of a scalar and display it?

[jm]

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.

 

[David Wier]

how about something like:
label1.text=YourObject.ExecuteScalar


David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup

 

[jm]

how about something like:
label1.text=YourObject.ExecuteScalar

David Wierhttp://aspnet101.comhttp://iWritePro.com- One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup











- Show quoted text -

I can't use the drag and drop and properties like with a regular
select, insert, and update statement?