Excel和数据库数据互相转换

心已赠人 2022-08-27 10:44 169阅读 0赞

# 说明 #

支持Mysql和SQL Server的表内的数据转换成Excel，也可以把Excel的数据导入到二者数据库中，Oracle没有测试过。

开发环境Visual Studio2010

开发语言C\#

# 注意 #

在VS中使用Mysql，需要在VS中引用一个Mysql.Data.dll文件，具体请自行搜索

# 代码 #

## sqlBase.cs ##

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Data;
    using System.Data.SqlClient;
    using System.Data.OleDb;
    
    namespace Excel2Database
    {
        class sqlBase
        {
            #region 数据库的连接
            static SqlConnection conn;
            //static MySqlConnection 
            static string database;
            static string user;
            static string password;
            static string IPaddress;
            
            public static bool sqlConnect(string IPaddress1,string database1,string user1,string password1)
            {
                IPaddress = IPaddress1;
                database = database1;
                user = user1;
                password = password1;
                string str = "Data Source=" + IPaddress + ";Initial Catalog =" + database + "; User ID=" + user + "; Password=" + password + "; Connection Timeout=3";
                conn = new SqlConnection(str);
                try
                {
                    conn.Open();
                }
                catch
                {
                    return false;
                }
                return true;
            }
            #endregion
    
            public static void sqlDisconnect()
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
    
            #region 读取出数据库内所有的表名称
            public static void SetTableNames()
            {
                DataTable tablenames;
                OleDbConnection cn = new OleDbConnection();
                cn.ConnectionString = "Provider=SQLOLEDB;Data Source=" + IPaddress + ";User ID=" + user + ";Password=" + password + ";Initial Catalog=" + database;
                try
                {
                    cn.Open();
                    tablenames = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new Object[] { null, null, null, "TABLE" });
                    Form1.GetTableNames(tablenames);
                }
                catch (SqlException ex)
                {
                    throw new Exception(ex.ToString());
                }            
            }
            #endregion
    
            #region 将DataTable中的数据导入数据库
            public static void CreateNewTable(string tableName,DataTable dt)
            {
                string sqlPhrase = "CREATE TABLE " + tableName + "(";
                foreach (DataColumn dc in dt.Columns)
                {
                    //sqlPhrase = sqlPhrase + dc.ColumnName + " CHAR(" + Convert.ToString(dc.ColumnName.ToString().Length + 3) + "),";        
                    sqlPhrase = sqlPhrase + dc.ColumnName + " TEXT,";
                }
                sqlPhrase = sqlPhrase.Substring(0, sqlPhrase.Length - 1);
                sqlPhrase = sqlPhrase + ")";
                ExeSQL(sqlPhrase);
                foreach (DataRow dr in dt.Rows)
                {
                    sqlPhrase = "insert into " + tableName + " values(";
                    foreach (object ob in dr.ItemArray)
                    {
                        sqlPhrase = sqlPhrase + "'"+ob.ToString() + "',";
                    }
                    sqlPhrase = sqlPhrase.Substring(0, sqlPhrase.Length - 1);
                    sqlPhrase += ")";
                    ExeSQL(sqlPhrase);
                }
    
            }
            #endregion
    
            #region 执行SQL语句并返回一个表
            public static DataTable ExeSQLdt(string sql)
            {
                try
                {
                    SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    return dt;
                }
                catch (SqlException ex)
                {
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    conn.Close();
                }
            }
            #endregion
    
            #region  执行SQL语句
            public static int ExeSQL(string sql)
            {
                if (conn.State != ConnectionState.Open)
                    conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                try
                {
                    cmd.ExecuteNonQuery();
                    return 0;
                }
                catch (SqlException ex)
                {
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    cmd.Dispose();
                    conn.Close();
                }
            }
            #endregion
        }
    }

## mysqlBase.cs ##

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Data;
    using System.Data.OleDb;
    using MySql.Data.MySqlClient;
    
    namespace Excel2Database
    {
        class mysqlBase
        {
            static MySqlConnection conn;
            static string database ;
            static string user ;
            static string password ;
            static string IPaddress;
    
            public static bool sqlConnect(string IPaddress1,string database1, string user1, string password1)
            {
                IPaddress = IPaddress1;
                database = database1;
                user = user1;
                password = password1;
                string str = "Server=" + IPaddress + ";Database=" + database + ";Uid=" + user + ";Pwd=" + password + ";";
                conn = new MySqlConnection(str);
                try
                {
                    conn.Open();
                }
                catch
                {
                    return false;
                }
                return true;
            }
    
            public static void sqlDisconnect()
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
    
            public static void SetTableNames()
            {
                string str = "select table_name from information_schema.tables where table_schema='"+database+"' and table_type='base table';";
                Form1.GetTableNames(ExeSQLdt(str));
            }
    
            public static void CreateNewTable(string tableName, DataTable dt)
            {
                string sqlPhrase = "CREATE TABLE " + tableName + "(";
                foreach (DataColumn dc in dt.Columns)
                {    
                    sqlPhrase = sqlPhrase + dc.ColumnName + " TEXT,";
                }
                sqlPhrase = sqlPhrase.Substring(0, sqlPhrase.Length - 1);
                sqlPhrase = sqlPhrase + ")";
                ExeSQL(sqlPhrase);
                foreach (DataRow dr in dt.Rows)
                {
                    sqlPhrase = "insert into " + tableName + " values(";
                    foreach (object ob in dr.ItemArray)
                    {
                        sqlPhrase = sqlPhrase + "'" + ob.ToString() + "',";
                    }
                    sqlPhrase = sqlPhrase.Substring(0, sqlPhrase.Length - 1);
                    sqlPhrase += ")";
                    ExeSQL(sqlPhrase);
                }
    
            }
    
            public static DataTable ExeSQLdt(string sql)
            {
                try
                {
                    MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    return dt;
                }
                catch (MySqlException ex)
                {
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    conn.Close();
                }
            }
    
            public static int ExeSQL(string sql)
            {
                if (conn.State != ConnectionState.Open)
                    conn.Open();
                MySqlCommand cmd = new MySqlCommand(sql, conn);
                try
                {
                    cmd.ExecuteNonQuery();
                    return 0;
                }
                catch (MySqlException ex)
                {
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    cmd.Dispose();
                    conn.Close();
                }
            }
    
    
        }
    }

## oracleBase.cs ##

using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Data;
    using System.Data.OracleClient;
    
    namespace Excel2Database
    {
        class oracleBase
        {
            static OracleConnection conn;
            static string database ;
            static string user ;
            static string password ;
            static string IPaddress;
    
            public static bool sqlConnect(string IPaddress1,string database1, string user1, string password1)
            {
                IPaddress = IPaddress1;
                database = database1;
                user = user1;
                password = password1;
                string str = "Server=127.0.0.1;Database=" + database + ";Uid=" + user + ";Pwd=" + password + ";";
                conn = new OracleConnection(str);
                try
                {
                    conn.Open();
                }
                catch
                {
                    return false;
                }
                return true;
            }
    
            public static void sqlDisconnect()
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
    
            public static void SetTableNames()
            {
                string str = "select table_name from information_schema.tables where table_schema='" + database + "' and table_type='base table';";
                Form1.GetTableNames(ExeSQLdt(str));
            }
    
            public static void CreateNewTable(string tableName, DataTable dt)
            {
                string sqlPhrase = "CREATE TABLE " + tableName + "(";
                foreach (DataColumn dc in dt.Columns)
                {
                    sqlPhrase = sqlPhrase + dc.ColumnName + " TEXT,";
                }
                sqlPhrase = sqlPhrase.Substring(0, sqlPhrase.Length - 1);
                sqlPhrase = sqlPhrase + ")";
                ExeSQL(sqlPhrase);
                foreach (DataRow dr in dt.Rows)
                {
                    sqlPhrase = "insert into " + tableName + " values(";
                    foreach (object ob in dr.ItemArray)
                    {
                        sqlPhrase = sqlPhrase + "'" + ob.ToString() + "',";
                    }
                    sqlPhrase = sqlPhrase.Substring(0, sqlPhrase.Length - 1);
                    sqlPhrase += ")";
                    ExeSQL(sqlPhrase);
                }
    
            }
    
            public static DataTable ExeSQLdt(string sql)
            {
                try
                {
                    OracleDataAdapter da = new OracleDataAdapter(sql, conn);
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    return dt;
                }
                catch (OracleException ex)
                {
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    conn.Close();
                }
            }
    
            public static int ExeSQL(string sql)
            {
                if (conn.State != ConnectionState.Open)
                    conn.Open();
                OracleCommand cmd = new OracleCommand(sql, conn);
                try
                {
                    cmd.ExecuteNonQuery();
                    return 0;
                }
                catch (OracleException ex)
                {
                    throw new Exception(ex.ToString());
                }
                finally
                {
                    cmd.Dispose();
                    conn.Close();
                }
            }
    
        }
    }

## Form1.cs ##

using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.OleDb;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    using System.IO;
    using System.Reflection;
    
    namespace Excel2Database
    {
        public partial class Form1 : Form
        {
            public Form1()
            {
                InitializeComponent();
                comboBox_sqls.SelectedIndex = 0;
                groupBox2.Enabled = false;
                groupBox3.Enabled = false;
            }
    
            private delegate void GETTABLENAMES(DataTable dt);
            private static int choice = 0;//0为空，1为Mysql，2为SQLServer，3为Oracle
    
            public static void GetTableNames(DataTable dt)
            {
                if (comboBox_tables.InvokeRequired)
                {
                    GETTABLENAMES gtn = new GETTABLENAMES(GetTableNames);
                    comboBox_tables.Invoke(gtn, new object[] { dt });
                }
                else
                {
                    comboBox_tables.Items.Add("---- 请选择 ----");
                    foreach (DataRow dr in dt.Rows)
                    {
                        comboBox_tables.Items.Add((string)dr["TABLE_NAME"]);
                    }
                    comboBox_tables.SelectedIndex = 0;
                    groupBox2.Enabled = true;
                    groupBox3.Enabled = true;
                }
            }
    
            private void DatabaseToExcel(string FileName, DataTable dt)
            {
                Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
                xlApp.Visible = true;
                if (xlApp == null)
                {
                    MessageBox.Show("创建Excel文件失败！");
                    return;
                }
                Microsoft.Office.Interop.Excel.Workbook xlBook=xlApp.Workbooks.Add(Missing.Value);
                int col = 0, row = 2;
                foreach (DataColumn dc in dt.Columns)
                {
                    xlApp.Cells[1, col + 1] = dc.ColumnName.ToString();
                    col++;
                }
                foreach (DataRow dr in dt.Rows)
                {
                    col = 0;
                    foreach (object ob in dr.ItemArray)
                    {
                        xlApp.Cells[row, col + 1] = ob.ToString();
                        col++;
                    }
                    row++;
                }
                xlBook.SaveAs(FileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                xlBook = null;
                xlApp.Quit();
                xlApp = null;
                MessageBox.Show("导出成功");
            }
    
            private void ExcelToDatabase(string excelFile,string tableName)
            {
                FileInfo fi = new FileInfo(excelFile);
                string strCon="";
                if (fi.Extension == "xls")
                    strCon = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelFile + ";" + "Extended Properties='Excel 8.0;HDR=NO;IMEX=1';";
                else
                    strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFile + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
                OleDbConnection xlsCon = new OleDbConnection(strCon);
                DataTable dt = new DataTable();
                string sqlPhrase="SELECT * FROM [Sheet1$]";
                OleDbDataAdapter da = new OleDbDataAdapter(sqlPhrase, xlsCon);
                try
                {
                    da.Fill(dt);
                }
                catch (System.Exception ex)
                {
                    throw new Exception(ex.ToString());
                }
                if (choice == 1)
                    mysqlBase.CreateNewTable(tableName, dt);
                else if(choice==2)
                    sqlBase.CreateNewTable(tableName, dt);
                else if(choice==3)
                    oracleBase.CreateNewTable(tableName, dt);
                MessageBox.Show("导入成功");
            }
    
            private void button_connect_Click(object sender, EventArgs e)
            {
                if (comboBox_sqls.SelectedIndex != 1 && comboBox_sqls.SelectedIndex != 2 && comboBox_sqls.SelectedIndex!=3)
                {
                    MessageBox.Show("请选择数据库类型");
                    return;
                }
                if (textBox_IP.Text.Trim()=="" || textBox_database.Text.Trim() == "" || textBox_user.Text.Trim() == "" || textBox_password.Text.Trim() == "")
                {
                    MessageBox.Show("请将登录信息填写完整");
                    return;
                }
                choice = comboBox_sqls.SelectedIndex;
                this.Cursor = Cursors.WaitCursor;
                if (choice == 1)
                {
                    if (!mysqlBase.sqlConnect(textBox_IP.Text,textBox_database.Text, textBox_user.Text, textBox_password.Text))
                        MessageBox.Show("数据库连接失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    else
                    {
                        //MessageBox.Show("success");
                        mysqlBase.SetTableNames();
                    }
                }
                else if(choice==2)
                {
                    if (!sqlBase.sqlConnect(textBox_IP.Text,textBox_database.Text, textBox_user.Text, textBox_password.Text))
                        MessageBox.Show("数据库连接失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    else
                    {
                        //MessageBox.Show("success");
                        sqlBase.SetTableNames();
                    }
                }
                else if (choice == 3)
                {
                    if (!oracleBase.sqlConnect(textBox_IP.Text,textBox_database.Text, textBox_user.Text, textBox_password.Text))
                        MessageBox.Show("数据库连接失败!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    else
                    {
                        //MessageBox.Show("success");
                        oracleBase.SetTableNames();
                    }
                }
                this.Cursor = Cursors.Arrow;
            }
    
            private void button_disconnect_Click(object sender, EventArgs e)
            {
                if (choice == 1)
                    mysqlBase.sqlDisconnect();
                else if (choice == 2)
                    sqlBase.sqlDisconnect();
                else if (choice == 3)
                    oracleBase.sqlDisconnect();
                comboBox_tables.Items.Clear();
                groupBox2.Enabled = false;
                groupBox3.Enabled = false;
                choice = 0;
            }
    
            private void button1_Click(object sender, EventArgs e)
            {
                FolderBrowserDialog ChooseExcelSavePath = new FolderBrowserDialog();
                if (ChooseExcelSavePath.ShowDialog() == DialogResult.OK)
                    textBox_path.Text = ChooseExcelSavePath.SelectedPath.ToString();
            }
    
            private void button_Excel_Click(object sender, EventArgs e)
            {
                if (comboBox_tables.SelectedIndex==0)
                {
                    MessageBox.Show("请选择需要导出的一张表");
                    return;
                }
                if (textBox_path.Text.ToString().Trim() == "")
                {
                    MessageBox.Show("请输入路径！");
                    return;
                }
                DirectoryInfo di = new DirectoryInfo(textBox_path.Text);
                if (!di.Exists)
                {
                    MessageBox.Show("请输入正确的路径！");
                    return;
                }
                if (textBox_ExcelName.Text.ToString().Trim() == "")
                {
                    MessageBox.Show("请输入文件名！");
                    return;
                }
                this.Cursor = Cursors.WaitCursor;
                string excelFileName = textBox_path.Text + "\\" + textBox_ExcelName.Text + ".xlsx";
                if(choice==1)
                    DatabaseToExcel(excelFileName, mysqlBase.ExeSQLdt("select * from " + comboBox_tables.SelectedItem.ToString()));
                else if(choice==2)
                    DatabaseToExcel(excelFileName, sqlBase.ExeSQLdt("select * from " + comboBox_tables.SelectedItem.ToString()));
                else if (choice == 3)
                    DatabaseToExcel(excelFileName, oracleBase.ExeSQLdt("select * from " + comboBox_tables.SelectedItem.ToString()));
                this.Cursor = Cursors.Arrow;
                //MessageBox.Show("导出成功");
            }
    
            private void button2_Click(object sender, EventArgs e)
            {
                if (ChooseExcelFile.ShowDialog() == DialogResult.OK)
                    textBox_excel.Text = ChooseExcelFile.FileName;
            }
    
            private void comboBox_tables_SelectedIndexChanged(object sender, EventArgs e)
            {
                if (comboBox_tables.SelectedIndex != 0)
                    textBox_ExcelName.Text = comboBox_tables.SelectedItem.ToString() ;
                else
                    textBox_ExcelName.Text = "";
            }
    
            private void button_Database_Click(object sender, EventArgs e)
            {
                FileInfo fi = new FileInfo(textBox_excel.Text);
                if (!fi.Exists)
                {
                    MessageBox.Show("请选择Excel文件！");
                    return;
                }
                string tableName = textBox_TableName.Text.Trim();
                if (tableName.Trim().Length == 0)
                {
                    MessageBox.Show("请输入数据表名称");
                    return;
                }
                bool isExist=false;
                foreach (object ob in comboBox_tables.Items)
                {
                    if (ob.ToString() == tableName)
                    {
                        isExist = true;
                        break;
                    }
                }
                if (isExist)
                {
                    MessageBox.Show("该表名已存在，请更换");
                    return;
                }
                this.Cursor = Cursors.WaitCursor;
                ExcelToDatabase(textBox_excel.Text, tableName);
                this.Cursor = Cursors.Arrow;
            }        
        }
    }

## Form1.Designer.cs ##

namespace Excel2Database
    {
        partial class Form1
        {
            /// <summary>
            /// 必需的设计器变量。
            /// </summary>
            private System.ComponentModel.IContainer components = null;
    
            /// <summary>
            /// 清理所有正在使用的资源。
            /// </summary>
            /// <param name="disposing">如果应释放托管资源，为 true；否则为 false。</param>
            protected override void Dispose(bool disposing)
            {
                if (disposing && (components != null))
                {
                    components.Dispose();
                }
                base.Dispose(disposing);
            }
    
            #region Windows 窗体设计器生成的代码
    
            /// <summary>
            /// 设计器支持所需的方法 - 不要
            /// 使用代码编辑器修改此方法的内容。
            /// </summary>
            private void InitializeComponent()
            {
                this.groupBox1 = new System.Windows.Forms.GroupBox();
                this.button_disconnect = new System.Windows.Forms.Button();
                this.button_connect = new System.Windows.Forms.Button();
                this.textBox_password = new System.Windows.Forms.TextBox();
                this.textBox_user = new System.Windows.Forms.TextBox();
                this.label4 = new System.Windows.Forms.Label();
                this.label3 = new System.Windows.Forms.Label();
                this.textBox_database = new System.Windows.Forms.TextBox();
                this.label2 = new System.Windows.Forms.Label();
                this.comboBox_sqls = new System.Windows.Forms.ComboBox();
                this.label1 = new System.Windows.Forms.Label();
                groupBox2 = new System.Windows.Forms.GroupBox();
                this.textBox_ExcelName = new System.Windows.Forms.TextBox();
                this.label9 = new System.Windows.Forms.Label();
                this.button_Excel = new System.Windows.Forms.Button();
                this.button1 = new System.Windows.Forms.Button();
                this.textBox_path = new System.Windows.Forms.TextBox();
                comboBox_tables = new System.Windows.Forms.ComboBox();
                this.label6 = new System.Windows.Forms.Label();
                this.label5 = new System.Windows.Forms.Label();
                groupBox3 = new System.Windows.Forms.GroupBox();
                this.button_Database = new System.Windows.Forms.Button();
                this.textBox_TableName = new System.Windows.Forms.TextBox();
                this.label8 = new System.Windows.Forms.Label();
                this.button2 = new System.Windows.Forms.Button();
                this.textBox_excel = new System.Windows.Forms.TextBox();
                this.label7 = new System.Windows.Forms.Label();
                this.ChooseExcelFile = new System.Windows.Forms.OpenFileDialog();
                this.label10 = new System.Windows.Forms.Label();
                this.textBox_IP = new System.Windows.Forms.TextBox();
                this.groupBox1.SuspendLayout();
                groupBox2.SuspendLayout();
                groupBox3.SuspendLayout();
                this.SuspendLayout();
                // 
                // groupBox1
                // 
                this.groupBox1.Controls.Add(this.textBox_IP);
                this.groupBox1.Controls.Add(this.label10);
                this.groupBox1.Controls.Add(this.button_disconnect);
                this.groupBox1.Controls.Add(this.button_connect);
                this.groupBox1.Controls.Add(this.textBox_password);
                this.groupBox1.Controls.Add(this.textBox_user);
                this.groupBox1.Controls.Add(this.label4);
                this.groupBox1.Controls.Add(this.label3);
                this.groupBox1.Controls.Add(this.textBox_database);
                this.groupBox1.Controls.Add(this.label2);
                this.groupBox1.Controls.Add(this.comboBox_sqls);
                this.groupBox1.Controls.Add(this.label1);
                this.groupBox1.Location = new System.Drawing.Point(12, 14);
                this.groupBox1.Name = "groupBox1";
                this.groupBox1.Size = new System.Drawing.Size(383, 110);
                this.groupBox1.TabIndex = 0;
                this.groupBox1.TabStop = false;
                this.groupBox1.Text = "连接数据库";
                // 
                // button_disconnect
                // 
                this.button_disconnect.Location = new System.Drawing.Point(297, 76);
                this.button_disconnect.Name = "button_disconnect";
                this.button_disconnect.Size = new System.Drawing.Size(75, 23);
                this.button_disconnect.TabIndex = 9;
                this.button_disconnect.Text = "断  开";
                this.button_disconnect.UseVisualStyleBackColor = true;
                this.button_disconnect.Click += new System.EventHandler(this.button_disconnect_Click);
                // 
                // button_connect
                // 
                this.button_connect.Location = new System.Drawing.Point(195, 76);
                this.button_connect.Name = "button_connect";
                this.button_connect.Size = new System.Drawing.Size(75, 23);
                this.button_connect.TabIndex = 8;
                this.button_connect.Text = "连  接";
                this.button_connect.UseVisualStyleBackColor = true;
                this.button_connect.Click += new System.EventHandler(this.button_connect_Click);
                // 
                // textBox_password
                // 
                this.textBox_password.Location = new System.Drawing.Point(243, 49);
                this.textBox_password.Name = "textBox_password";
                this.textBox_password.PasswordChar = '*';
                this.textBox_password.Size = new System.Drawing.Size(129, 21);
                this.textBox_password.TabIndex = 7;
                this.textBox_password.Text = "1324354657";
                // 
                // textBox_user
                // 
                this.textBox_user.Location = new System.Drawing.Point(63, 49);
                this.textBox_user.Name = "textBox_user";
                this.textBox_user.Size = new System.Drawing.Size(115, 21);
                this.textBox_user.TabIndex = 6;
                this.textBox_user.Text = "sa";
                // 
                // label4
                // 
                this.label4.AutoSize = true;
                this.label4.Location = new System.Drawing.Point(193, 55);
                this.label4.Name = "label4";
                this.label4.Size = new System.Drawing.Size(53, 12);
                this.label4.TabIndex = 5;
                this.label4.Text = "密  码：";
                // 
                // label3
                // 
                this.label3.AutoSize = true;
                this.label3.Location = new System.Drawing.Point(16, 52);
                this.label3.Name = "label3";
                this.label3.Size = new System.Drawing.Size(53, 12);
                this.label3.TabIndex = 4;
                this.label3.Text = "用户名：";
                // 
                // textBox_database
                // 
                this.textBox_database.Location = new System.Drawing.Point(63, 78);
                this.textBox_database.Name = "textBox_database";
                this.textBox_database.Size = new System.Drawing.Size(115, 21);
                this.textBox_database.TabIndex = 3;
                this.textBox_database.Text = "WarehouseDB";
                // 
                // label2
                // 
                this.label2.AutoSize = true;
                this.label2.Location = new System.Drawing.Point(16, 81);
                this.label2.Name = "label2";
                this.label2.Size = new System.Drawing.Size(53, 12);
                this.label2.TabIndex = 2;
                this.label2.Text = "数据库：";
                // 
                // comboBox_sqls
                // 
                this.comboBox_sqls.FormattingEnabled = true;
                this.comboBox_sqls.Items.AddRange(new object[] {
                "-- 请选择 --",
                "Mysql",
                "SQL Server",
                "Oracle"});
                this.comboBox_sqls.Location = new System.Drawing.Point(63, 17);
                this.comboBox_sqls.Name = "comboBox_sqls";
                this.comboBox_sqls.Size = new System.Drawing.Size(115, 20);
                this.comboBox_sqls.TabIndex = 1;
                // 
                // label1
                // 
                this.label1.AutoSize = true;
                this.label1.Location = new System.Drawing.Point(16, 20);
                this.label1.Name = "label1";
                this.label1.Size = new System.Drawing.Size(53, 12);
                this.label1.TabIndex = 0;
                this.label1.Text = "类  型：";
                // 
                // groupBox2
                // 
                groupBox2.Controls.Add(this.textBox_ExcelName);
                groupBox2.Controls.Add(this.label9);
                groupBox2.Controls.Add(this.button_Excel);
                groupBox2.Controls.Add(this.button1);
                groupBox2.Controls.Add(this.textBox_path);
                groupBox2.Controls.Add(comboBox_tables);
                groupBox2.Controls.Add(this.label6);
                groupBox2.Controls.Add(this.label5);
                groupBox2.Location = new System.Drawing.Point(12, 130);
                groupBox2.Name = "groupBox2";
                groupBox2.Size = new System.Drawing.Size(383, 99);
                groupBox2.TabIndex = 1;
                groupBox2.TabStop = false;
                groupBox2.Text = "数据表转Excel";
                // 
                // textBox_ExcelName
                // 
                this.textBox_ExcelName.Location = new System.Drawing.Point(99, 69);
                this.textBox_ExcelName.Name = "textBox_ExcelName";
                this.textBox_ExcelName.Size = new System.Drawing.Size(203, 21);
                this.textBox_ExcelName.TabIndex = 7;
                // 
                // label9
                // 
                this.label9.AutoSize = true;
                this.label9.Location = new System.Drawing.Point(16, 75);
                this.label9.Name = "label9";
                this.label9.Size = new System.Drawing.Size(83, 12);
                this.label9.TabIndex = 6;
                this.label9.Text = "文 件 名 称：";
                // 
                // button_Excel
                // 
                this.button_Excel.Location = new System.Drawing.Point(319, 28);
                this.button_Excel.Name = "button_Excel";
                this.button_Excel.Size = new System.Drawing.Size(53, 47);
                this.button_Excel.TabIndex = 5;
                this.button_Excel.Text = "导出";
                this.button_Excel.UseVisualStyleBackColor = true;
                this.button_Excel.Click += new System.EventHandler(this.button_Excel_Click);
                // 
                // button1
                // 
                this.button1.Location = new System.Drawing.Point(265, 40);
                this.button1.Name = "button1";
                this.button1.Size = new System.Drawing.Size(37, 23);
                this.button1.TabIndex = 4;
                this.button1.Text = "....";
                this.button1.UseVisualStyleBackColor = true;
                this.button1.Click += new System.EventHandler(this.button1_Click);
                // 
                // textBox_path
                // 
                this.textBox_path.Location = new System.Drawing.Point(99, 40);
                this.textBox_path.Name = "textBox_path";
                this.textBox_path.Size = new System.Drawing.Size(160, 21);
                this.textBox_path.TabIndex = 3;
                // 
                // comboBox_tables
                // 
                comboBox_tables.FormattingEnabled = true;
                comboBox_tables.Location = new System.Drawing.Point(99, 14);
                comboBox_tables.Name = "comboBox_tables";
                comboBox_tables.Size = new System.Drawing.Size(203, 20);
                comboBox_tables.TabIndex = 2;
                comboBox_tables.SelectedIndexChanged += new System.EventHandler(this.comboBox_tables_SelectedIndexChanged);
                // 
                // label6
                // 
                this.label6.AutoSize = true;
                this.label6.Location = new System.Drawing.Point(16, 43);
                this.label6.Name = "label6";
                this.label6.Size = new System.Drawing.Size(83, 12);
                this.label6.TabIndex = 1;
                this.label6.Text = "存 储 位 置：";
                // 
                // label5
                // 
                this.label5.AutoSize = true;
                this.label5.Location = new System.Drawing.Point(16, 17);
                this.label5.Name = "label5";
                this.label5.Size = new System.Drawing.Size(83, 12);
                this.label5.TabIndex = 0;
                this.label5.Text = "选择 数据表：";
                // 
                // groupBox3
                // 
                groupBox3.Controls.Add(this.button_Database);
                groupBox3.Controls.Add(this.textBox_TableName);
                groupBox3.Controls.Add(this.label8);
                groupBox3.Controls.Add(this.button2);
                groupBox3.Controls.Add(this.textBox_excel);
                groupBox3.Controls.Add(this.label7);
                groupBox3.Location = new System.Drawing.Point(13, 235);
                groupBox3.Name = "groupBox3";
                groupBox3.Size = new System.Drawing.Size(382, 80);
                groupBox3.TabIndex = 2;
                groupBox3.TabStop = false;
                groupBox3.Text = "Excel转数据表";
                // 
                // button_Database
                // 
                this.button_Database.Location = new System.Drawing.Point(318, 20);
                this.button_Database.Name = "button_Database";
                this.button_Database.Size = new System.Drawing.Size(53, 51);
                this.button_Database.TabIndex = 5;
                this.button_Database.Text = "导入";
                this.button_Database.UseVisualStyleBackColor = true;
                this.button_Database.Click += new System.EventHandler(this.button_Database_Click);
                // 
                // textBox_TableName
                // 
                this.textBox_TableName.Location = new System.Drawing.Point(98, 50);
                this.textBox_TableName.Name = "textBox_TableName";
                this.textBox_TableName.Size = new System.Drawing.Size(203, 21);
                this.textBox_TableName.TabIndex = 4;
                // 
                // label8
                // 
                this.label8.AutoSize = true;
                this.label8.Location = new System.Drawing.Point(15, 53);
                this.label8.Name = "label8";
                this.label8.Size = new System.Drawing.Size(65, 12);
                this.label8.TabIndex = 3;
                this.label8.Text = "数据表名：";
                // 
                // button2
                // 
                this.button2.Location = new System.Drawing.Point(264, 18);
                this.button2.Name = "button2";
                this.button2.Size = new System.Drawing.Size(37, 23);
                this.button2.TabIndex = 2;
                this.button2.Text = "....";
                this.button2.UseVisualStyleBackColor = true;
                this.button2.Click += new System.EventHandler(this.button2_Click);
                // 
                // textBox_excel
                // 
                this.textBox_excel.Location = new System.Drawing.Point(98, 20);
                this.textBox_excel.Name = "textBox_excel";
                this.textBox_excel.ReadOnly = true;
                this.textBox_excel.Size = new System.Drawing.Size(160, 21);
                this.textBox_excel.TabIndex = 1;
                // 
                // label7
                // 
                this.label7.AutoSize = true;
                this.label7.Location = new System.Drawing.Point(15, 26);
                this.label7.Name = "label7";
                this.label7.Size = new System.Drawing.Size(65, 12);
                this.label7.TabIndex = 0;
                this.label7.Text = "选择文件：";
                // 
                // ChooseExcelFile
                // 
                this.ChooseExcelFile.Filter = "Excel 文件(*.xls;*xlsx)|*.xls;*xlsx;";
                // 
                // label10
                // 
                this.label10.AutoSize = true;
                this.label10.Location = new System.Drawing.Point(193, 20);
                this.label10.Name = "label10";
                this.label10.Size = new System.Drawing.Size(53, 12);
                this.label10.TabIndex = 10;
                this.label10.Text = "IP地址：";
                // 
                // textBox_IP
                // 
                this.textBox_IP.Location = new System.Drawing.Point(243, 17);
                this.textBox_IP.Name = "textBox_IP";
                this.textBox_IP.Size = new System.Drawing.Size(129, 21);
                this.textBox_IP.TabIndex = 11;
                this.textBox_IP.Text = "127.0.0.1";
                // 
                // Form1
                // 
                this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 12F);
                this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
                this.ClientSize = new System.Drawing.Size(407, 321);
                this.Controls.Add(groupBox3);
                this.Controls.Add(groupBox2);
                this.Controls.Add(this.groupBox1);
                this.Name = "Form1";
                this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
                this.Text = "Excel与数据库互相转换";
                this.groupBox1.ResumeLayout(false);
                this.groupBox1.PerformLayout();
                groupBox2.ResumeLayout(false);
                groupBox2.PerformLayout();
                groupBox3.ResumeLayout(false);
                groupBox3.PerformLayout();
                this.ResumeLayout(false);
    
            }
    
            #endregion
    
            private System.Windows.Forms.GroupBox groupBox1;
            private System.Windows.Forms.ComboBox comboBox_sqls;
            private System.Windows.Forms.Label label3;
            private System.Windows.Forms.TextBox textBox_database;
            private System.Windows.Forms.Label label2;
            private System.Windows.Forms.TextBox textBox_password;
            private System.Windows.Forms.TextBox textBox_user;
            private System.Windows.Forms.Label label4;
            private System.Windows.Forms.Button button_disconnect;
            private System.Windows.Forms.Button button_connect;
            private static System.Windows.Forms.GroupBox groupBox2;
            private System.Windows.Forms.Button button_Excel;
            private System.Windows.Forms.Button button1;
            private System.Windows.Forms.TextBox textBox_path;
            private System.Windows.Forms.Label label6;
            private System.Windows.Forms.Label label5;
            private static System.Windows.Forms.GroupBox groupBox3;
            private System.Windows.Forms.Label label1;
            private System.Windows.Forms.Button button_Database;
            private System.Windows.Forms.TextBox textBox_TableName;
            private System.Windows.Forms.Label label8;
            private System.Windows.Forms.Button button2;
            private System.Windows.Forms.TextBox textBox_excel;
            private System.Windows.Forms.Label label7;
            private System.Windows.Forms.OpenFileDialog ChooseExcelFile;
            private System.Windows.Forms.TextBox textBox_ExcelName;
            private System.Windows.Forms.Label label9;
            private System.Windows.Forms.TextBox textBox_IP;
            private System.Windows.Forms.Label label10;
            private static System.Windows.Forms.ComboBox comboBox_tables;
        }
    }