两个数据库有一个相同的表，将A中的a表复制到B中的b表

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

using System.Configuration;

 

namespace copy数ºy据Y库a中D的Ì?表À¨ª

{

    public partial class Form1 : Form

    {

        publicForm1()

        {

            InitializeComponent();

        }

 

        privatevoid button1_Click(objectsender, EventArgs e)

        {

          

 

            SqlConnectionconn = new SqlConnection();

            conn.ConnectionString = "server=LENOVO-PC\\SQLEXPRESS;IntegratedSecurity=true; Initial Catalog=MyFirst";

            SqlCommandcomm = new SqlCommand();

            comm.Connection = conn;

            conn.Open();

            comm.CommandText = "insert into grda select * fromJMDA.dbo.T_GRDA";

            comm.ExecuteNonQuery();

            MessageBox.Show("导Ì?入¨?成¨¦功|！ê?！ê?！ê?");

            comm.CommandText = "select * from grda";

            comm.ExecuteNonQuery();

            SqlDataAdapteradapter = new SqlDataAdapter(comm);

            DataTabledt = new DataTable();

            adapter.Fill(dt);

            if(dt.Rows.Count > 0)

            {

                this.dataGridView2.DataSource= dt;

            }

            conn.Close();

        }

 

        privatevoid Form1_Load(objectsender, EventArgs e)

        {

            // TODO: 这a行D代䨲码?将?数ºy据Y加¨®载?到Ì?表À¨ª“¡ãmyFirstDataSet.grda”¡À中D。¡ê您¨²可¨¦以°?根¨´据Y需¨¨要°a移°?动¡¥或¨°删¦?除y它¨¹。¡ê

            this.grdaTableAdapter.Fill(this.myFirstDataSet.grda);

            // TODO: 这a行D代䨲码?将?数ºy据Y加¨®载?到Ì?表À¨ª“¡ãjMDADataSet.T_GRDA”¡À中D。¡ê您¨²可¨¦以°?根¨´据Y需¨¨要°a移°?动¡¥或¨°删¦?除y它¨¹。¡ê

            this.t_GRDATableAdapter.Fill(this.jMDADataSet.T_GRDA);

 

        }

    }

}