|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
table with automaticily refreshtable with automatically refreshHi,
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 Show quote "Tobias Wobben" wrote: > 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 > Thx,
you "brought" me on the right way. I'm now trying to solve the Problem with "Query Notification". thx Tobias Kerry Moorman schrieb: Show quote > 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 > > > "Tobias Wobben" wrote: > >> 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 >> 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 Show quote > 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  |
|||||||||||||||||||||||
Other interesting topics