public int SaveDataTable(string safeSql, DataTable dt)
{
try
{
open();
switch (dbtype)
{
case "Mssql":
cmd_mssql.CommandText = safeSql;
SqlDataAdapter da_mssql = new SqlDataAdapter(cmd_mssql);
SqlCommandBuilder cb_mssql = new SqlCommandBuilder(da_mssql);
return(da_mssql.Update(dt));
//case "Access":
// cmd_access.CommandText = safeSql;
// OleDbDataAdapter da_access = new OleDbDataAdapter(cmd_access);
// OleDbCommandBuilder cb_access = new OleDbCommandBuilder(da_access);
// return da_access.Update(dt);
case "Oracle":
cmd_oracle.CommandText = safeSql;
DDTek.Oracle.OracleDataAdapter da_oracle = new DDTek.Oracle.OracleDataAdapter(cmd_oracle);
DDTek.Oracle.OracleCommandBuilder cb_oracle = new DDTek.Oracle.OracleCommandBuilder(da_oracle);
return(da_oracle.Update(dt));
default:
throw new Exception("无法识别的数据库类型!");
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Form1()
{
InitializeComponent();
DataTable dtProviderFactorys = DbProviderFactories.GetFactoryClasses();
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Add("User ID", "hzzgis");
dcsBuilder.Add("Password", "hzzgis");
dcsBuilder.Add("Service Name", "sunz");
dcsBuilder.Add("Host", "172.16.1.9");
dcsBuilder.Add("Integrated Security", false);
string licPath = Application.StartupPath + "\\DDTek.lic";
if (!System.IO.File.Exists(licPath))
licPath = CretateDDTekLic.CreateLic();
dcsBuilder.Add("License Path", licPath);
//若路径中存在空格，则会在路径名称前加上"\""
string conStr = dcsBuilder.ConnectionString;
conStr = conStr.Replace("\"", "");
DDTek.Oracle.OracleConnection orclConnection = new DDTek.Oracle.OracleConnection(conStr);
DDTek.Oracle.OracleCommand cmd = new DDTek.Oracle.OracleCommand();
DDTek.Oracle.OracleDataAdapter adapter = new DDTek.Oracle.OracleDataAdapter();
adapter.SelectCommand = cmd;
DbDataAdapter dAdapter = adapter;
DbCommand dbCommand = dAdapter.SelectCommand;
orclConnection.Open();
//Configuration config = new Configuration();
//ISessionFactory pFactory = config.BuildSessionFactory();
//ISession pSession= pFactory.OpenSession(orclConnection as IDbConnection);
//DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
//IDbConnection dbConn = factory.CreateConnection();
//if (dbConn != null)
// MessageBox.Show("Connection Created");
//Conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
IDbConnection dbConn=new System.Data.OleDb.OleDbConnection();
string Server = "sunzvm-lc", Port = "1521", Service = "sunz", User = "******", PWD = "hzzgis";
//dbConn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
dbConn.ConnectionString = "Provider=MSDAORA.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
try
{
dbConn.Open();
}
catch(Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
public DataTable ReadDataTable(string safeSql)
{
try
{
DataTable dtResult = new DataTable();
switch (dbtype)
{
case "Mssql":
cmd_mssql.CommandText = safeSql;
SqlDataAdapter da_mssql = new SqlDataAdapter(cmd_mssql);
da_mssql.Fill(dtResult);
da_mssql.Dispose();
break;
case "Access":
cmd_access.CommandText = safeSql;
OleDbDataAdapter da_access = new OleDbDataAdapter(cmd_access);
da_access.Fill(dtResult);
da_access.Dispose();
break;
case "Oracle":
cmd_oracle.CommandText = safeSql;
DDTek.Oracle.OracleDataAdapter da_oracle = new DDTek.Oracle.OracleDataAdapter(cmd_oracle);
da_oracle.Fill(dtResult);
da_oracle.Dispose();
break;
default:
throw new Exception("无法识别的数据库类型!");
}
return(dtResult);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Form1()
{
InitializeComponent();
DataTable dtProviderFactorys = DbProviderFactories.GetFactoryClasses();
DbConnectionStringBuilder dcsBuilder = new DbConnectionStringBuilder();
dcsBuilder.Add("User ID", "hzzgis");
dcsBuilder.Add("Password", "hzzgis");
dcsBuilder.Add("Service Name", "sunz");
dcsBuilder.Add("Host", "172.16.1.9");
dcsBuilder.Add("Integrated Security", false);
string licPath = Application.StartupPath + "\\DDTek.lic";
if (!System.IO.File.Exists(licPath))
{
licPath = CretateDDTekLic.CreateLic();
}
dcsBuilder.Add("License Path", licPath);
//若路径中存在空格，则会在路径名称前加上"\""
string conStr = dcsBuilder.ConnectionString;
conStr = conStr.Replace("\"", "");
DDTek.Oracle.OracleConnection orclConnection = new DDTek.Oracle.OracleConnection(conStr);
DDTek.Oracle.OracleCommand cmd = new DDTek.Oracle.OracleCommand();
DDTek.Oracle.OracleDataAdapter adapter = new DDTek.Oracle.OracleDataAdapter();
adapter.SelectCommand = cmd;
DbDataAdapter dAdapter = adapter;
DbCommand dbCommand = dAdapter.SelectCommand;
orclConnection.Open();
//Configuration config = new Configuration();
//ISessionFactory pFactory = config.BuildSessionFactory();
//ISession pSession= pFactory.OpenSession(orclConnection as IDbConnection);
//DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
//IDbConnection dbConn = factory.CreateConnection();
//if (dbConn != null)
// MessageBox.Show("Connection Created");
//Conn.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
IDbConnection dbConn = new System.Data.OleDb.OleDbConnection();
string Server = "sunzvm-lc", Port = "1521", Service = "sunz", User = "******", PWD = "hzzgis";
//dbConn.ConnectionString = "Provider=OraOLEDB.Oracle.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
dbConn.ConnectionString = "Provider=MSDAORA.1;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + Server + ")(PORT=" + Port + ")))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + Service + ")));user id=" + User + ";password="******";pooling = true;Unicode=True";
try
{
dbConn.Open();
}
catch (Exception exp)
{
MessageBox.Show(exp.ToString());
}
}
public HyOracleDataAdapter(DDTek.Oracle.OracleDataAdapter innerAdapter)
{
this.InnerAdapter = innerAdapter;
}
