How to I detect possible changes in the data exported from excel to database table

Question

0.00/5 (No votes)

See more:

I have an MVC application in which i have a screen from that screen user can insert some data in the database table, user can fill the textboxes or there is option to upload the data from excel file also. some other user also can view that data and can update also.
my problem is
Today there is no indication and no way to know whether or not data that is loaded from a excel file is modified by the user letter.
Some kind of system I has to be put in place in order to detect those possible changes and inform users about it.

Please let me know the possible solution.

What I have tried:

.......................................

Posted 5-Apr-18 19:52pm

Arvind Singh Baghel

Updated 5-Apr-18 21:21pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2018-04-05T21:23:00

If i understand you correctly, you've used MS Excel file as a "database". This Excel file is shared between users, who can make some changes through your application...

Forget about Excel in multi user environment! This is not proper "database"! Use MS SQL Server, Oracle, PostgreSql, MySql or any other RDBMS[^], which is more powerful, because provide functionality to detect data changes. For starters, please read:
Using SqlDependency for data change events[^]
Query Notification using SqlDependency and SqlCacheDependency[^]