两张数据表联合查询mysql_两个数据库中两个表进行联合查询的步骤

1:  using System;2:  using System.Collections.Generic;3:  using System.ComponentModel;4:  using System.Data;5:  using System.Drawing;6:  using System.Text;7:  using System.Windows.Forms;8:  using System.Data.SqlClient;9:  using System.Linq;10:  namespace LinkTwoData11:  {12:publicpartial class Form1 : Form13:      {14:publicForm1()15:          {16:              InitializeComponent();17:          }18:stringstrcon1=@"Data Source=FENG-PC\SQLEXPRESS;Initial Catalog=test1;User ID=sa;PassWord=sa2008";19:stringstrcon2=@"Data Source=FENG-PC\SQLEXPRESS;Initial Catalog=test2;User ID=sa;PassWord=sa2008";20:privatevoid Form1_Load(objectsender, EventArgs e)21:          {22:              SqlDataAdapter sda1=newSqlDataAdapter("select * from stu1",strcon1);23:              SqlDataAdapter sda2=newSqlDataAdapter("select * from stu1", strcon2);24:              DataSet ds=newDataSet();25:              sda1.Fill(ds,"stu1");26:              sda2.Fill(ds,"stu2");27:28:              var query=from stu in ds.Tables["stu1"].AsEnumerable()29:                          from sc in ds.Tables["stu2"].AsEnumerable()30:                          where stu.Field("sc")==sc.Field("sc")31:selectnew32:                          {33:                              sno=stu.Field("sno",DataRowVersion.Original),34:                              sname=stu.Field("sname",DataRowVersion.Original),35:                              sage=stu.Field("sage", DataRowVersion.Original),36:                              scname=sc.Field("scname", DataRowVersion.Original)37:                          };38:39:              DataTable dt=newDataTable();40:              dt.Columns.Add("sno", typeof(int));41:              dt.Columns.Add("sname", typeof(string));42:              dt.Columns.Add("sage", typeof(string));43:              dt.Columns.Add("scname", typeof(string));44:              foreach (var item in query)45:              {46:                  DataRow newRow=dt.NewRow();47:                  newRow["sno"]=item.sno;48:                  newRow["sname"]=item.sname;49:                  newRow["sage"]=item.sage;50:                  newRow["scname"]=item.scname;51:                  dt.Rows.Add(newRow);52:              }53:              dataGridView1.DataSource=dt.DefaultView;54:          }55:      }56:  }