Help Regarding DataTable and DataSet

Question

4.00/5 (1 vote)

See more:

I have two DataTables

One is from local database(Populated with Stored Procedure) let say datatable1

Second one is coming from Remotely(ie From a server's database) let say datatable2

Both have same table and records,but difference is of one column (named Accessible) records is that some records of this column have different values

I want to apply a check that if datatable2 accessible is NO then update datatable1 accessible to NO
I have done folowing code:

foreach(DataTableRows dr in datatable2.Rows)
{
if(dr["Accessible"].ToString() == "NO")
{
//Here i want to apply code
}
}

How can i update dynamically datatable1?

Posted 26-Mar-11 11:08am

Syed Salman Raza Zaidi

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)

Wendelius · Answer 1 · 2011-03-26T11:17:00

First you have to find the matching row in datatable1. Based on the info you provided it's impossible to say how to do that but most likely you have a key on both data tables which you could use.

You could then use for example the Select[^] method to fetch the matching row from datatable1 and compare the values.