Hi all

I use datagrids bound to Objectdatasources in turn bound to datatables

Every thing works Ok, but I'm curious on how it actually works.

I have a view in my SQL Server 2000 database. i.e. vw_KPITurnAround

I connect to the view via a XSD data table with something like

SELECT     ... FROM   vw_KPITurnAround

If I want to filter the data then within the data table I add a table
adapter i.e.

SELECT   ...FROM         dbo.vw_KPITurnAround WHERE     (InspectionDate
BETWEEN @StartDate AND @EndDate)

and pass the startDate and endDate parameters via my business code.

What I would like to know is

is the string in the table adapter passed to the SQL server and the
processing takes place there

e.g. SELECT   ...FROM         dbo.vw_KPITurnAround WHERE     (InspectionDate
BETWEEN @StartDate AND @EndDate)  ->@StartDate AND @EndDate passed to
Database server

or

is all the data in the table brought back in one hit to my application,

i.e.
SELECT     ... FROM   vw_KPITurnAround

and the processing between dates done here?

thanks for any info

Andy