By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,326 Members | 881 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,326 IT Pros & Developers. It's quick & easy.

Seemless Interactive UI Updation

P: n/a
Dear All,

Problem:
Need to seemlessly update a DataBound Datagrid (WinApp) whenever the data in
the attached Table changes from different appDomain.

Current Solution:
Using Triggers, Extended Stored Procedure, ESP DLL, and Sockets intimate the
UI to call Refresh on Dataset.
Problem in pri sol:
In above scenario Refresh( ) doesnt remove rows (as in case of deletion of
some record)- Clear( ) is therefore required which is cumbersome.

Secondary Solution:
Using triggers , an Extra Table and a Derived DataSet for Refresh( ) -
update only the changed rows. (2 many modifications required)

P.S.
Sorry for possibly illegal Cross Posting :-(
Cant use Notification Services as they aint free.
ADO.NET 2.0 is fine but current version is preferable.
Please focus on primary problem first. :-) wud luv 2 c new sol instead of
mod in old sol

Any Ideas , Any Suggestions, Any Reference .. All's Welcome.

Thank You.
rawCoder
Nov 21 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
RawCoder,

I do not think I have an answer, however I get the idea you are making a
connected dataset. Is that the challenge? The attached Table in your message
is a "database table".

Cor
Dear All,

Problem:
Need to seemlessly update a DataBound Datagrid (WinApp) whenever the data in the attached Table changes from different appDomain.

Current Solution:
Using Triggers, Extended Stored Procedure, ESP DLL, and Sockets intimate the UI to call Refresh on Dataset.
Problem in pri sol:
In above scenario Refresh( ) doesnt remove rows (as in case of deletion of
some record)- Clear( ) is therefore required which is cumbersome.

Secondary Solution:
Using triggers , an Extra Table and a Derived DataSet for Refresh( ) -
update only the changed rows. (2 many modifications required)

P.S.
Sorry for possibly illegal Cross Posting :-(
Cant use Notification Services as they aint free.
ADO.NET 2.0 is fine but current version is preferable.
Please focus on primary problem first. :-) wud luv 2 c new sol instead of
mod in old sol

Any Ideas , Any Suggestions, Any Reference .. All's Welcome.

Thank You.
rawCoder

Nov 21 '05 #2

P: n/a
Would it work by calling Merge on the dataset instead of clearing and
filling?

"rawCoder" <ra******@hotmail.com> skrev i en meddelelse
news:eJ*************@TK2MSFTNGP11.phx.gbl...
Dear All,

Problem:
Need to seemlessly update a DataBound Datagrid (WinApp) whenever the data in the attached Table changes from different appDomain.

Current Solution:
Using Triggers, Extended Stored Procedure, ESP DLL, and Sockets intimate the UI to call Refresh on Dataset.
Problem in pri sol:
In above scenario Refresh( ) doesnt remove rows (as in case of deletion of
some record)- Clear( ) is therefore required which is cumbersome.

Secondary Solution:
Using triggers , an Extra Table and a Derived DataSet for Refresh( ) -
update only the changed rows. (2 many modifications required)

P.S.
Sorry for possibly illegal Cross Posting :-(
Cant use Notification Services as they aint free.
ADO.NET 2.0 is fine but current version is preferable.
Please focus on primary problem first. :-) wud luv 2 c new sol instead of
mod in old sol

Any Ideas , Any Suggestions, Any Reference .. All's Welcome.

Thank You.
rawCoder

Nov 21 '05 #3

P: n/a
Sorry Cor if I was not clear.

Its a simple DataBound DataGrid.

It is bound to a dataset referring to a table in the database.

When there is some data change in the DB Table -
i.e. when some row is added changed or updated in the DB Table from some
other app or form SQL Enterprise Manager
then the DataSet doesnt get updated automatically - which is natural as the
DataSet is disconnected
and hence consequently the grid doesnt get refreshed.

That was in essense the basic problem.

HTH
rawCoder

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:uU**************@TK2MSFTNGP09.phx.gbl...
RawCoder,

I do not think I have an answer, however I get the idea you are making a
connected dataset. Is that the challenge? The attached Table in your message is a "database table".

Cor
Dear All,

Problem:
Need to seemlessly update a DataBound Datagrid (WinApp) whenever the data
in
the attached Table changes from different appDomain.

Current Solution:
Using Triggers, Extended Stored Procedure, ESP DLL, and Sockets intimate

the
UI to call Refresh on Dataset.
Problem in pri sol:
In above scenario Refresh( ) doesnt remove rows (as in case of deletion

of some record)- Clear( ) is therefore required which is cumbersome.

Secondary Solution:
Using triggers , an Extra Table and a Derived DataSet for Refresh( ) -
update only the changed rows. (2 many modifications required)

P.S.
Sorry for possibly illegal Cross Posting :-(
Cant use Notification Services as they aint free.
ADO.NET 2.0 is fine but current version is preferable.
Please focus on primary problem first. :-) wud luv 2 c new sol instead of mod in old sol

Any Ideas , Any Suggestions, Any Reference .. All's Welcome.

Thank You.
rawCoder


Nov 21 '05 #4

P: n/a
Rawcoder,

I do not know the solution, in your case I would start looking to the
methods for pessimistic concurrency, I did it on MSDN and found this,
however there should be more.

http://msdn.microsoft.com/library/de...ursorlocks.asp

I hope this helps anyway something?

Cor
Nov 21 '05 #5

P: n/a
Unfortunately, this will absolutely kill any kind of scalability.

To the OP, you might as well use SQL notification services. Yes, they
are not free, but based on what you said you had to do in order to acheive
the same thing (trigger, sp, sockets, etc, etc) I would take the ease of
maintainability over the cost (whatever that might be, I can't imagine it is
that much more costly performance wise than your solution) that SQL
notification services incurs.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...
Rawcoder,

I do not know the solution, in your case I would start looking to the
methods for pessimistic concurrency, I did it on MSDN and found this,
however there should be more.

http://msdn.microsoft.com/library/de...ursorlocks.asp

I hope this helps anyway something?

Cor

Nov 21 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.