DataTable Update Problem

See more:

C#

ASP.NET

I have two DataTables

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

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

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

int i=0;
            foreach (DataRow dtrow in dt2.Rows)
            {
                i++;
                if (dtrow["Accessible"].ToString().ToUpper() == "NO")
                {
                    dt1.Rows[i]["Accessible"] = "NO";
                }
            }

How can i check on specific row of Drow for value NO