public HistoricoCambios() { InitializeComponent(); Login rutas = new Login(true); conexion = new OleDbConnection(); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; }
public RegistroNuevoUsuario() { Login rutas = new Login(true); conexion = new OleDbConnection(); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; InitializeComponent(); }
public ProductosModificados() //constructor { Login rutas = new Login(true); connEsp2 = new OleDbConnection(); connAccess = new OleDbConnection(); connAccess.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; connEsp2.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathExcel.LocalPath + "; Extended Properties='Excel 12.0 Macro;HDR=NO;'"; InitializeComponent(); }
public InventarioCompleto() { InitializeComponent(); app = new Excel.Application(); workbook = app.Workbooks.Add(Type.Missing); Login rutas = new Login(true); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; this.LlenarDiccinario(); }
public QuejasLotes() { Login rutas = new Login(true); conexion = new OleDbConnection(); conexionExcel = new OleDbConnection(); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; conexionExcel.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathExcel.LocalPath + "; Extended Properties='Excel 12.0 Macro;HDR=NO;'"; InitializeComponent(); }
public Manejo_BD(string u, bool esAdmin) { InitializeComponent(); usuario = u; usuarioEsAdmin = esAdmin; Login rutas = new Login(true); conexion = new OleDbConnection(); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; }
public NuevoLote(string clavprod) { InitializeComponent(); clavp = clavprod; conClave = true; Login rutas = new Login(true); conexion = new OleDbConnection(); conexionExcel = new OleDbConnection(); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; conexionExcel.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathExcel.LocalPath + "; Extended Properties='Excel 12.0 Macro;HDR=NO;'"; }
public NuevoLote(string clavprod, string almacen, string cliente, string frecuencia, string clavor, string engrane, string color, string material, string lub, string corte, string perfil, string amplitud, string comentarios, string calibre) { InitializeComponent(); alm = almacen; clavp = clavprod; clien = cliente; frec = frecuencia; clavOri = clavor; eng = engrane; col = color; mat = material; lubr = lub; cor = corte; perf = perfil; amp = amplitud; com = comentarios; cali = calibre; conClave = false; Login rutas = new Login(true); conexion = new OleDbConnection(); conexionExcel = new OleDbConnection(); conexion.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathDB.LocalPath + "; "; conexionExcel.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data" + @" Source=" + rutas.pathExcel.LocalPath + "; Extended Properties='Excel 12.0 Macro;HDR=NO;'"; }