ADO.NET DataSets as a DataSource

Can I use a ADO dataset as a datasource for a report using Reporting Services
2000? Or will I have to implement a custom data extension. Does anyone know?You have to implement an extension until version 2, then there will be new
web and winform controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aparna" <Aparna@.discussions.microsoft.com> wrote in message
news:819219C0-B02D-470D-BA74-D15A72DD014C@.microsoft.com...
> Can I use a ADO dataset as a datasource for a report using Reporting
Services
> 2000? Or will I have to implement a custom data extension. Does anyone
know?

ado datasets

hi

i am using older ado datasets in a borland 6 program.

i need to retrieve the data per record count....

example is that i need all 1000 records but i only want to retrieve them 100 at a time....

how will i accomplish this?

This may give you some usable ideas.

Paging Queries
www.aspfaq.com/2120

ADO - Resync datasets

I want my users to see each others committed changes immediately.
Is there a way automatically resync Client Datasets?
Can i make a trigger (or something similar) to send a signal to my application telling a record has been updated?

I'm using SQL Server 2000 and Borland Delphi 7 with ADO 2.7.Yes you can esely create a trigger that can send you an allert to your application.
I'm not working with Delphi for a long time but i think that it's possible.
Send more details in order to give you some usefull help.

Paulo

Originally posted by Olivier_Peter
I want my users to see each others committed changes immediately.
Is there a way automatically resync Client Datasets?
Can i make a trigger (or something similar) to send a signal to my application telling a record has been updated?

I'm using SQL Server 2000 and Borland Delphi 7 with ADO 2.7.|||My question is:
- how should the trigger look like in SQL Server.
- how do i catch it in delphi

I've done this before with interbase:

CREATE TRIGGER "T_ORDER_AI" FOR "T_ORDER"
ACTIVE AFTER INSERT POSITION 0
AS
BEGIN
POST_EVENT 'ORDER_UPDATE';
END

When IBEvents Triggers

procedure TFrmRestaurantMain.IBEventsEventAlert(Sender: TObject;
EventName: String; EventCount: Integer; var CancelAlerts: Boolean);
begin
if EventName = 'ORDER_UPDATE' then begin
...
end;
end;
end;