how to find changes between two lists?

Question

0.00/5 (No votes)

See more:

i have two lists...the first list from database(olddata) and the second list from browser(newdata)..i need to compare that the two lists and save changes into the database..how it is possible?
thankyou........

Posted 17-Jan-16 22:39pm

User-11630313

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)

Herman<T>.Instance · Answer 1 · 2016-01-17T22:55:00

Solution 1

You can use LINQ keyword EXCEPT for that

C#

var differences = list1.Except(list2);

See here[^] for more information.

Posted 17-Jan-16 22:55pm

Herman<T>.Instance

v2

Comments

User-11630313 18-Jan-16 5:13am

here i need to compare each and every object element not a row..using except keyword i tried but it returns complete mismatch row...

Herman<T>.Instance 18-Jan-16 5:44am

Could you post your troublesome code?

User-11630313 18-Jan-16 5:55am

private Banks SaveBankDetails()
{
Banks obj = new Banks();
obj.Bankid = Formats.ConvertToInt(Request.QueryString["bankid"]);
obj.Bankname = txtBankName.Text;
obj.Active = Formats.ConvertStringToBool(ddlActive.SelectedItem);
obj.Userid = Session["UserId"].ToString();
List<banks> newdata = new List<banks>();
newdata.Add(obj);
List<banks> olddata = (List<banks>)Session["BankDetails"];
List<dbaudit> ChangedData = new List<dbaudit>();

in above code i need compare the two lists are
newdata and olddata...
the differences in object values should be add to changeddata list...

Herman<T>.Instance 18-Jan-16 6:02am

I have done a cast form DataRow once in the past.
My code:

var inTbl1 = procedureOne.Rows.Cast<datarow>();
var inTbl2 = procedureTwo.Rows.Cast<datarow>();
var tblNameDiffT1 = inTbl1.Select(x => x["Name"]);
if (procedureOne.Rows.Count > procedureTwo.Rows.Count)
{
var tblNameDiffT2 = inTbl2.Select(x => x["Name"]);
var DiffByNameT1T2 = tblNameDiffT1.Except(tblNameDiffT2);
ProcedureOne and Two are DataTables

User-11630313 18-Jan-16 6:09am

thankyou for responding...yeah your code is wright but it represents complete tablerow i think...

Herman<T>.Instance 18-Jan-16 6:17am

true

Herman<T>.Instance 18-Jan-16 6:18am

don't you change by GridViewRow?

User-11630313 18-Jan-16 5:59am

simply...i have two lists..first list is existing data in the database..and the second list is client modifies data...i have to find what changes made by client?