如何在一个gridview中绑定两个不同的服务器数据库表 [英] How to bind two different server database table in one gridview

问题描述

我有两个不同的服务器



服务器1 ：192.168.99.111 - MySQL

Employee_id，姓名，地址，manager_code - 表格人员

服务器2 ：192.168.99.112 - SQL

manager_code，Manager_fullname - 表经理





现在，我想在gridview中显示两个表与不同服务器的信息。

喜欢：

employee_id，name，manager_fullname。





任何帮助我来解决这个问题。

I have Two Different Server

server 1 : 192.168.99.111 - MySQL
Employee_id,name,address,manager_code - Table person
Server 2 : 192.168.99.112 - SQL
manager_code, Manager_fullname - Table Manager


Now, I want to display the information of two tables with different server in my gridview.
Like:
employee_id,name,manager_fullname.


Anyone help me to solve this Issue.

推荐答案

使用它作为样本参考：

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(); //your code
 

            DataTable dtSQL = new DataTable();
            dtSQL = GetDataFromSQLSource();  // your code
            
            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; }
    }


}

这篇关于如何在一个gridview中绑定两个不同的服务器数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！