예제 #1
0
        private void btn_connect_Click(object sender, System.EventArgs e)
        {
            try
            {
                var DBConnectString = this.cbbxConnectstring.Text;
                switch (this.cbbx_database.Text)
                {
                case "MsSQL":
                    ODAContext.SetODAConfig(ODA.DbAType.MsSQL, this.cbbxConnectstring.Text);
                    break;

                case "MySql":
                    ODAContext.SetODAConfig(ODA.DbAType.MySql, this.cbbxConnectstring.Text);
                    break;

                case "OdbcInformix":
                    ODAContext.SetODAConfig(ODA.DbAType.OdbcInformix, this.cbbxConnectstring.Text);
                    break;

                case "OledbAccess":
                    ODAContext.SetODAConfig(ODA.DbAType.OledbAccess, this.cbbxConnectstring.Text);
                    break;

                case "Oracle":
                    ODAContext.SetODAConfig(ODA.DbAType.Oracle, this.cbbxConnectstring.Text);
                    break;

                case "Sybase":
                    ODAContext.SetODAConfig(ODA.DbAType.Sybase, this.cbbxConnectstring.Text);
                    break;

                case "SQLite":
                    ODAContext.SetODAConfig(ODA.DbAType.SQLite, this.cbbxConnectstring.Text);
                    break;

                case "DB2":
                    ODAContext.SetODAConfig(ODA.DbAType.DB2, this.cbbxConnectstring.Text);
                    break;

                default:
                    break;
                }

                ODAContext cxt     = new ODAContext();
                var        DateNow = cxt.DBDatetime;

                if (!_ConnectString.Contains(this.cbbxConnectstring.Text))
                {
                    _ConnectString.Add(this.cbbxConnectstring.Text);
                    JavaScriptSerializer js = new JavaScriptSerializer();
                    string jsStr            = js.Serialize(_ConnectString);
                    System.IO.File.WriteAllText(ConnPath, jsStr, Encoding.UTF8);
                }
                this.Close();
            }
            catch (Exception ex)
            {
                this.lblExecuteRlt.Text = "Create DataSource Error : " + ex.Message;
            }
        }