Unmatched records from DataTables
-
I have two resultset comes from two datatable For example Datatable1 ---------- Id description -- ----------- 100 Home 101 Office 102 Practice 103 Training Centre Datatable2 ---------- Id description -- ----------- 100 Home 102 Practice I want to compare the above datatables and bind the unmatched records in the GridView The result should be Id description -- ----------- 101 Office 103 Training Centre how can i get the above result? My code -------- DataSet dsFetchAddress = null; DataSet dsFetchAddressType = null; DataTable dtFetchAddress; dsFetchAddress = m_Profile.FetchFacultyAddress(m_factultyKey); dsFetchAddressType = m_Profile.FetchAddress(); dtFetchAddress = dsFetchAddressType.Tables[0].Select("Id! ='dsFetchAddress.Tables[0].Select("Id")'"); I don't the exact syntax. pls give the solution.