Form1.cs

(开头部分) 58KB

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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.Collections;

namespace SqlScriptExtract
{
    public partial class Form1 : Form
    {

        BackgroundWorker bgWorker = new System.ComponentModel.BackgroundWorker();
        // 

        public Form1()
        {
            InitializeComponent();
        }
        bool ischang = true;
        private void btnLogin_Click(object sender, EventArgs e)
        {
            try {
                //--  SqlServer  MySql  Oracle
                //string strtype = "SqlServer";
                string strtype = cmbdatatype.Text;
                string strlk = "";
                switch (strtype)
                {
                    case "SqlServer":
                         strlk = "Server=" + txtserver.Text + (txtport.Text ==""?"": ","+txtport.Text) + ";Database=master;User ID=" + txtuser.Text + ";Password='" + txtpwd.Text + "'"; //sqlserver
                        break;
                    case "MySql":
                        strlk = "server=" + txtserver.Text + "; port=" + txtport.Text + "; user id=" + txtuser.Text + "; password=" + txtpwd.Text + "; database=" + cmbdatabase.Text + ";"; //mysql  // database="+cmbdatabase.Text +";
                        break;
                    case "Oracle":
                        strlk = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = " + txtserver.Text + ")(PORT = " + txtport.Text + "))) (CONNECT_DATA =(SERVICE_NAME=" + cmbdatabase.Text + ")));User Id=" + txtuser.Text + ";Password=" + txtpwd.Text + ";";
                        break;
                }
                
               // 1521   3306
                // string strlk = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = "+txtserver.Text +")(PORT = 1521))) (CONNECT_DATA =(SERVICE_NAME=cmshn)));User Id="+txtuser.Text +";Password="+txtpwd.Text +";"; //oracle
                // string strlk ="server="+txtserver.Text +"; user id="+txtuser.Text +"; password="+txtpwd.Text +"; database=plusoft_test;"; //mysql

                DBReadOrWrite mylink = new DBReadOrWrite();
                mylink.dbType = strtype;
                mylink.connstr = strlk;
                mylink.BeginConn();
                if (mylink.dbState == true)
                {
                    //MessageBox.Show("登陆成功!");
                    btnLogin.Enabled = false;
                    mylink.EndConn();
                    ArrayList mydatabase = mylink.Select("SELECT * FROM Master..SysDatabases");//sqlserver
                    ischang = false;
                    cmbdatabase.Items.Clear();
                    foreach(Hashtable ondata in mydatabase)
后面还有 1220 行代码,解锁后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。