Use this as sample reference:
using System.Linq;
using System.Data;
using System.Collections.Generic;
using System;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
DataTable dtMysql = new DataTable();
dtMysql = GetDataFromMysqlSource();
DataTable dtSQL = new DataTable();
dtSQL = GetDataFromSQLSource();
List<EntityMySQL> lstMySQL = new List<EntityMySQL>();
foreach (DataRow row in dtMysql.Rows)
lstMySQL.Add(new EntityMySQL() { Employee_ID = Convert.ToInt32( row["Employee_ID"]), Name = row["name"].ToString(), manager_code = row["manager_code"].ToString() });
List<EntitySQL> lstSQL = new List<EntitySQL>();
foreach (DataRow row in dtSQL.Rows)
lstSQL.Add(new EntitySQL() { manager_fullname = row["manager_fullname"].ToString(), manager_code = row["manager_code"].ToString() });
var data = lstMySQL.Join(lstSQL, (k => k.manager_code), (k => k.manager_code), (mysql, sql) => new { employee_id = mysql.Employee_ID, name = mysql.Name, manager_fullname = sql.manager_fullname }).ToList();
GridView1.DataSource = data;
GridView1.DataBind();
}
}
public class EntityMySQL
{
public int Employee_ID { get; set; }
public string Name { get; set; }
public string manager_code { get; set; }
}
public class EntitySQL
{
public string manager_code { get; set; }
public string manager_fullname { get; set; }
}
}