private void button_getServiceName_Click(object sender, EventArgs e)
{
// https://docs.oracle.com/database/121/ODPNT/OracleDataSourceEnumeratorClass.htm
List <string> lines = new List <string>();
OracleDataSourceEnumerator test = new OracleDataSourceEnumerator();
DataTable dt = test.GetDataSources();
string strLine = "";
foreach (DataColumn column in dt.Columns)
{
strLine += column.ColumnName + ",";
}
lines.Add(strLine);
foreach (DataRow row in dt.Rows)
{
strLine = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
strLine += row[i] += ",";
}
lines.Add(strLine);
}
return;
}
/// <summary>
/// 检索包含有关所有可见 Oracle 实例的信息的 DataTable。
/// </summary>
/// <returns>返回一个包含有关所有可见 Oracle 实例的信息的 DataTable。</returns>
public DataTable CreateDataSourceEnumerator()
{
DbDataSourceEnumerator dataSource = Factory.CreateDataSourceEnumerator();
OracleDataSourceEnumerator sqlDataSource = dataSource as OracleDataSourceEnumerator;
if (sqlDataSource == null)
{
throw new ArgumentNullException("sqlDataSource");
}
return(sqlDataSource.GetDataSources());
}
private void InitServers()
{
OracleDataSourceEnumerator oraEnum = new OracleDataSourceEnumerator();
try
{
DataTable dt = oraEnum.GetDataSources();
foreach (DataRow row in dt.Rows)
{
cbxServer.Items.Add(row[0]);
}
}
catch
{
}
}
private void button_getServiceName_Click(object sender, EventArgs e)
{
// https://docs.oracle.com/database/121/ODPNT/OracleDataSourceEnumeratorClass.htm
List<string> lines = new List<string>();
OracleDataSourceEnumerator test = new OracleDataSourceEnumerator();
DataTable dt = test.GetDataSources();
string strLine = "";
foreach (DataColumn column in dt.Columns)
{
strLine += column.ColumnName + ",";
}
lines.Add(strLine);
foreach (DataRow row in dt.Rows)
{
strLine = "";
for (int i = 0; i < dt.Columns.Count; i++)
{
strLine += row[i] += ",";
}
lines.Add(strLine);
}
return;
}
