private void GenerarID() { Controlador.Conexion conexion = new Controlador.Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("SELECT COUNT(ID_DEPARTAMENTO) FROM DEPARTAMENTO", conn); int i = Convert.ToInt32(comando.ExecuteScalar()); conn.Close(); i++; TxtId.Text = i.ToString(); }
private void GenerarID() { Controlador.Conexion conexion = new Controlador.Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("SELECT COUNT(ID_FLUJO_TAREA) FROM FLUJO_TAREA", conn); int i = Convert.ToInt32(comando.ExecuteScalar()); conn.Close(); i++; IDPiola.Text = i.ToString(); }
public DataSet consultar(string consultaSQL) { Controlador.Conexion conexion = new Controlador.Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand(consultaSQL, conn); OracleDataAdapter da = new OracleDataAdapter(comando); DataSet ds = new DataSet(); da.Fill(ds); conn.Clone(); return(ds); }
public DataTable dtFuncionario() { DataTable dt = new DataTable(); Controlador.Conexion conexion = new Controlador.Conexion(); OracleConnection conn = new OracleConnection(); conn = conexion.getConn(); conn.Open(); OracleCommand comando = new OracleCommand("ListarTareasAdministrador", conn); comando.CommandType = System.Data.CommandType.StoredProcedure; comando.Parameters.Add("ListarTarea", OracleDbType.RefCursor).Direction = System.Data.ParameterDirection.Output; OracleDataAdapter adaptador = new OracleDataAdapter(comando); adaptador.Fill(dt); adaptador.Dispose(); return(dt); }