/// <exception cref="ConnectionStringBuilderException">Parameter passen nicht</exception>
public string getConnectionString()
{
string connString = null;
if (Art == DBArts.MSSQL)
{
System.Data.Common.DbConnectionStringBuilder dbConnStringBuilder = new System.Data.Common.DbConnectionStringBuilder();
connString = @"Server=" + Server + ";Initial Catalog=" + BaseDB + ";Trusted_Connection=" + Trusted.ToString() + ((bool)Trusted ? "" : ";User Id=" + Username + ";Password="******";";
try
{
dbConnStringBuilder.ConnectionString = connString;
}
catch (System.ArgumentException)
{
throw new ConnectionStringBuilderException();
}
}
if (Art == DBArts.ORACLE)
{
System.Data.OracleClient.OracleConnectionStringBuilder dbConnStringBuilder = new System.Data.OracleClient.OracleConnectionStringBuilder();
connString = @"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")) (CONNECT_DATA=(SERVICE_NAME=" + Sid + "))); User Id=" + Username + ";Password="******";";
try
{
dbConnStringBuilder.ConnectionString = connString;
}
catch (System.ArgumentException)
{
throw new ConnectionStringBuilderException();
}
}
return(connString);
}
public void update()
{
Sybase.DataWindow.Transaction trans = new Sybase.DataWindow.Transaction();
System.Data.OracleClient.OracleConnectionStringBuilder ocs =
new System.Data.OracleClient.OracleConnectionStringBuilder(Neusoft.FrameWork.Management.Connection.Instance.ConnectionString);
trans.Password = ocs.Password;
trans.ServerName = ocs.DataSource;
trans.UserId = ocs.UserID;
trans.Dbms = Sybase.DataWindow.DbmsType.Oracle8i;
trans.AutoCommit = false;
trans.DbParameter = "PBCatalogOwner='lchis'";
trans.Connect();
this.dwMain.SetTransaction(trans);
try
{
this.dwMain.UpdateData(true);
}
catch (Exception e)
{
trans.Rollback();
MessageBox.Show("保存失败！" + e.Message);
return;
}
trans.Commit();
MessageBox.Show("保存成功！");
}
} // End Constructor
public cOracle(string strConnectionString)
{
//this.m_DatabaseConfiguration = dbcDBconfig;
this.m_dbtDBtype = DataBaseEngine_t.Oracle;
this.m_providerFactory = this.GetFactory();
this.m_dictScriptTemplates = GetSQLtemplates();
this.m_dblDBversion = 11.0;
this.m_ConnectionString = new System.Data.OracleClient.OracleConnectionStringBuilder(strConnectionString);
this.m_SqlConnection = new System.Data.OracleClient.OracleConnection(strConnectionString);
} // End Constructor 2
public LisOrder()
{
if (this.dataManager.con.State == ConnectionState.Closed)
{
System.Data.OracleClient.OracleConnectionStringBuilder ooo = new System.Data.OracleClient.OracleConnectionStringBuilder();
ooo.UserID = "newhis45";
ooo.Password = "******";
ooo.DataSource = "chcc";
this.dataManager.con.ConnectionString = ooo.ToString();
this.dataManager.con.Open();
}
}
public ucLisResult()
{
InitializeComponent();
if (!this.DesignMode)
{
if (this.dataManager.con.State == ConnectionState.Closed)
{
this.dataManager.con = new System.Data.OracleClient.OracleConnection();
System.Data.OracleClient.OracleConnectionStringBuilder ooo = new System.Data.OracleClient.OracleConnectionStringBuilder();
ooo.UserID = "newhis45";
ooo.Password = "******";
ooo.DataSource = "chcc";
this.dataManager.con.ConnectionString = ooo.ToString();
this.dataManager.con.Open();
}
}
}
public new static void Tests()
{
System.Data.Common.DbConnectionStringBuilder dbcsb = new System.Data.Common.DbConnectionStringBuilder();
System.Data.SqlClient.SqlConnectionStringBuilder sqlcsb =
new System.Data.SqlClient.SqlConnectionStringBuilder();
sqlcsb.NetworkLibrary = "";
//sqlcsb.TransactionBinding
sqlcsb.TypeSystemVersion = "";
sqlcsb.UserInstance = true;
Npgsql.NpgsqlConnectionStringBuilder csb =
new Npgsql.NpgsqlConnectionStringBuilder();
// csb.Protocol
// csb.Compatible
//csb.SslMode = Npgsql.SslMode.Require;
// csb.UseExtendedTypes
System.Data.OracleClient.OracleConnectionStringBuilder ocb = new System.Data.OracleClient.OracleConnectionStringBuilder();
FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder fbcsb = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder();
fbcsb.ServerType = FirebirdSql.Data.FirebirdClient.FbServerType.Embedded;
Mono.Data.Sqlite.SqliteConnectionStringBuilder litecsb = new Mono.Data.Sqlite.SqliteConnectionStringBuilder();
litecsb.BinaryGUID = true;
litecsb.DateTimeFormat = Mono.Data.Sqlite.SQLiteDateFormats.ISO8601;
litecsb.DefaultIsolationLevel = System.Data.IsolationLevel.ReadCommitted;
litecsb.DefaultTimeout = 123;
litecsb.FailIfMissing = true;
litecsb.JournalMode = Mono.Data.Sqlite.SQLiteJournalModeEnum.Off;
litecsb.LegacyFormat = false;
litecsb.SyncMode = Mono.Data.Sqlite.SynchronizationModes.Full;
litecsb.Uri = "";
litecsb.Version = 123;
MySql.Data.MySqlClient.MySqlConnectionStringBuilder mycb = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
mycb.AllowBatch = true;
mycb.CertificateFile = "";
mycb.CertificatePassword = "";
mycb.CertificateStoreLocation = MySql.Data.MySqlClient.MySqlCertificateStoreLocation.LocalMachine;
mycb.CertificateThumbprint = "";
mycb.CharacterSet = "";
mycb.CheckParameters = true;
mycb.ConnectionLifeTime = 123;
mycb.ConnectionProtocol = MySql.Data.MySqlClient.MySqlConnectionProtocol.Tcp;
mycb.ConnectionReset = true;
mycb.ConvertZeroDateTime = false;
mycb.DefaultCommandTimeout = 123;
mycb.FunctionsReturnString = true;
mycb.IgnorePrepare = true;
mycb.InteractiveSession = false;
mycb.Keepalive = 123;
mycb.PipeName = "";
System.Data.Odbc.OdbcConnectionStringBuilder odbc = new System.Data.Odbc.OdbcConnectionStringBuilder();
//System.Data.OleDb.OleDbConnectionStringBuilder oledb = new System.Data.OleDb.OleDbConnectionStringBuilder();
} // End Sub
/// <summary>Damの選択</summary>
private void cmbDataProvider_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
// 初期は、無効にして、ODP.NET、HiRDB選択時のみ有効にする。
this.nudNumOfBind.Enabled = false;
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_SQL)
{
//sqlClient
this._dam = new DamSqlSvr();
//接続文字列のサンプルを設定する（空の場合）。
SqlConnectionStringBuilder csb = new SqlConnectionStringBuilder();
csb.DataSource = this._ip;
csb.InitialCatalog = "Northwind";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_SQL_CREATED");
}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_OLE)
{
//OLEDB.NET
this._dam = new DamOLEDB();
//接続文字列のサンプルを設定する（空の場合）。
OleDbConnectionStringBuilder csb = new OleDbConnectionStringBuilder();
csb.Provider = "Provider";
csb.DataSource = "DataSourceName";
csb.FileName = "FileName";
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_OLE_CREATED");
}
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_ODB)
{
//ODBC.NET
this._dam = new DamODBC();
//接続文字列のサンプルを設定する（空の場合）。
OdbcConnectionStringBuilder csb = new OdbcConnectionStringBuilder();
csb.Driver = "DriverName";
csb.Dsn = "DataSourceName";
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_ODB_CREATED");
}
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_ORA)
{
//Oracle Client
this._dam = new DamOraClient();
//接続文字列のサンプルを設定する（空の場合）。
System.Data.OracleClient.OracleConnectionStringBuilder csb = new System.Data.OracleClient.OracleConnectionStringBuilder();
csb.DataSource = this._ip + "/orcl";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_ODP_CREATED");
}
if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_ODP)
{
//ODP.NET
this._dam = new DamOraOdp();
//接続文字列のサンプルを設定する（空の場合）。
Oracle.DataAccess.Client.OracleConnectionStringBuilder csb = new Oracle.DataAccess.Client.OracleConnectionStringBuilder();
csb.DataSource = this._ip + "/orcl";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 活性
this.nudNumOfBind.Enabled = true;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_ODP_CREATED");
}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_DB2)
{
//DB2.NET
this._dam = new DamDB2();
//接続文字列のサンプルを設定する（空の場合）。
DB2ConnectionStringBuilder csb = new DB2ConnectionStringBuilder();
//csb.Server = this._ip + ":50000";
csb.Database = "SAMPLE";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_DB2_CREATED");
}
//else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_HiRDB)
//{
// //HiRDBデータ プロバイダ
// this._dam = new DamHiRDB();
// //接続文字列のサンプルを設定する（空の場合）。
// //HiRDBデータ プロバイダは、ConnectionStringBuilderがない。
// string csb = "";
// csb += "DataSource=C:\\Windows\\HiRDB.ini;";
// csb += "UID=" + this._uid + ";";
// csb += "PWD=" + this._pwd + ";";
// this.txtCnnStr.Text = csb;
// // 活性
// this.nudNumOfBind.Enabled = true;
// // 状態
// ((ToolStripStatusLabel)this.statBar.Items[0]).Text = Literal.STATUS_HRD_CREATED;
//}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_MySQL)
{
//MySQL Connector/NET
this._dam = new DamMySQL();
//接続文字列のサンプルを設定する（空の場合）。
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = this._ip;
csb.Database = "test";
csb.UserID = this._uid;
csb.Password = this._pwd;
this.txtCnnStr.Text = csb.ConnectionString;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_MSL_CREATED");
}
else if (this.cmbDataProvider.SelectedItem.ToString() == Literal.DAP_PstgrS)
{
//Npgsql
this._dam = new DamPstGrS();
//接続文字列のサンプルを設定する（空の場合）。
//NpgsqlConnectionStringBuilderは、冗長な接続文字列を返すので使わない。
//NpgsqlConnectionStringBuilder csb = new NpgsqlConnectionStringBuilder();
string csb = "";
//csb.Host = this._ip;
//csb.Database = "postgres";
//csb.UserName = this._uid;
//csb.Password = this._pwd;
csb += "HOST=" + this._ip + ";";
csb += "DATABASE=postgres;";
csb += "UID=" + this._uid + ";";
csb += "PWD=" + this._pwd + ";";
this.txtCnnStr.Text = csb;
// 状態
((ToolStripStatusLabel)this.statBar.Items[0]).Text = this.RM_GetString("STATUS_PGS_CREATED");
}
else
{
//ありえない
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}