table with automaticily refreshtable with automatically refresh

  • Thread starter Thread starter Tobias Wobben
  • Start date Start date
T

Tobias Wobben

Hi,

short description of my problem:
I wanna open a dataset round about 30000 records on a SQL 2005.
This is not the problem ;-)
30 users are updating the data on the server.
I need an idea, if the data on the server is changed, that I'll get the
update on my local dataset. Re-filling the dataset is not acceptable.....
This takes to long.
Any ideas ? Doesn't matter what technologies

best regards
Tobias Wobben
 
Tobias,

I will refrain from giving you the standard advice that retriving 30000 rows
into a dataset for the user to work with is almost always a bad design
decision.

I will point you to a new feature of SQL Server 2005, notification services.

Kerry Moorman
 
Hi Tobias!

As variant you can use special timestamp column and update it when user
changes column.
So periodically you can select rows with changed timestamps (of cource
using stored procedures and temporary table to store old timestamps)
and then change data in your dataset.

Best regards,
Michael Milonov
http://www.snotratech.com
 
Thx,

you "brought" me on the right way. I'm now trying to solve the Problem
with "Query Notification".

thx
Tobias
 
Back
Top