How to get only non matched data from 2 datatable

DataTable dt3=new DataTable ();
dt3.Columns.Add("Name");
for (int i = 0; i < dt1.Rows.Count; i++)
{
for (int j = 0; j < dt2.Rows.Count; j++)
{
if (dt1.Rows[i][0].ToString() == dt2.Rows[j][0].ToString())
{

}
else
{
DataRow dr = dt3.NewRow();
dr["Name"] = dt1.Rows[i][0].ToString();
dt3.Rows.Add (dr);
}
if (dt2.Rows[i][0].ToString() == dt1.Rows[j][0].ToString())
{

}
else
{
DataRow dr = dt3.NewRow();
dr["Name"] = dt2.Rows[i][0].ToString();
dt3.Rows.Add(dr);
}
}
}




you will get all your data in datatable dt3

This example identifies values that are missing from either table instead of values that are missing from just one table. To select only items that are missing from Table_1, change the word Full to Left.

Find mismatched

With CTE (C1,C2) As
 (
 SELECT T1.Col1 As C1,T2.Col1 As C2 FROM Table_2 T2  full join Table_1 T1 On T2.Col1=T1.Col1
 ) 
 Select ISNULL(C1,C2) As Col1 from CTE where C1 Is Null Or C2 Is Null Order By ISNULL(C1,C2)

Results

Col1
E
F

Create test data

CREATE TABLE [dbo].[Table_1](
    [col1] [nchar](10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Table_2](
    [col1] [nchar](10) NULL
) ON [PRIMARY]
GO
insert into table_1 values ('A');
insert into table_1 values ('B');
insert into table_1 values ('C');
insert into table_1 values ('D');
insert into table_1 values ('F');

insert into table_2 values ('A');
insert into table_2 values ('B');
insert into table_2 values ('C');
insert into table_2 values ('D');
insert into table_2 values ('E');