//--------------------------------------------------------------- public Sdt Query(String sql) { Sdt dt = new Sdt(); cmd.CommandText = sql; if (dbType == DbType.MySQL) { MySqlDataAdapter da = new MySqlDataAdapter((MySqlCommand)cmd); da.Fill(dt); dt.SecoundConstructor(); } else if (dbType == DbType.Oracle) { OracleDataAdapter da = new OracleDataAdapter((OracleCommand)cmd); da.Fill(dt); dt.SecoundConstructor(); } else if (dbType == DbType.OleDb) { OleDbDataAdapter da = new OleDbDataAdapter((OleDbCommand)cmd); da.Fill(dt); dt.SecoundConstructor(); } else { return(null); } return(dt); }
public Sdt ExecuteProcedure(String procedureName) { Sdt dt = new Sdt(); if (dbType == DbType.Oracle) { cmdOra.CommandText = procedureName; cmdOra.CommandType = CommandType.StoredProcedure; System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmdOra); da.Fill(dt); dt.SecoundConstructor(); } if (dbType == DbType.MySQL) { cmd.CommandText = procedureName; cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter((MySqlCommand)cmd); da.Fill(dt); dt.SecoundConstructor(); } return(dt); }