tableconfig.cs

可以实现任意数据库之间的数据互导,可以实现任意数据库之间的数据互导

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Collections;

namespace LC_DataIO
{
    public partial class TableConfig : Form
    {
        public static string SourceReadyTable,DesReadyTable;
        public TableConfig()
        {
            InitializeComponent();
        }

        private void TableConfig_Load(object sender, EventArgs e)
        {

            init();
            
        }
        public void init()
        {
            this.sourctables_lbx.Items.Clear();
            this.destables_lbx.Items.Clear();
            ArrayList temp = HeadPage.ConverterXml.getAllSourceTable();
            for (int i = 0; i < temp.Count; i++)
            {
                this.sourctables_lbx.Items.Add(temp[i].ToString());
            }

            temp = HeadPage.XmlConverter.getAllDesTable();
            for (int i = 0; i < temp.Count; i++)
            {
                this.destables_lbx.Items.Add(temp[i].ToString());
            }
        }
        private void sourcetableselect_btn_Click(object sender, EventArgs e)
        {
            if (this.sourctables_lbx.SelectedIndex != -1)
            {
                this.sreadytable_lbx.Items.Clear();
                this.sreadytable_lbx.Items.Add(this.sourctables_lbx.SelectedItem.ToString());
                SourceReadyTable = this.sourctables_lbx.SelectedItem.ToString();
            }
            else
            {
                MessageBox.Show("还没有选择要转化的表");
            }
        }

        private void deseslecttable_Click(object sender, EventArgs e)
        {
            if (this.destables_lbx.SelectedIndex != -1)
            {
                this.desreadytable_lbx.Items.Clear();
                this.desreadytable_lbx.Items.Add(this.destables_lbx.SelectedItem.ToString());
                DesReadyTable = this.destables_lbx.SelectedItem.ToString();
            }
            else
            {
                MessageBox.Show("还没有选择要转化的表");
            }
        }

        private void pre_btn_Click(object sender, EventArgs e)
        {

            WizardFrm.wizard.choseWizard("数据库连接编辑");
        }

        private void next_btn_Click(object sender, EventArgs e)
        {
            WizardFrm.wizard.choseWizard("字段选择编辑");
            WizardFrm.wizard.fc.init();
        }
    }
}