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; }