public void InsertarModelo(string Modelo) { var comando = new SqlCommand("INSERT INTO[dbo].[Cat_Modelo]([Modelo])VALUES ('" + Modelo + "')", Conexion.AbrirConexion()); try { comando.ExecuteNonQuery(); } catch (Exception) { throw; } Conexion.CerrarConexion(); }
public DataTable CargarDatosSites(int edificio) { DataTable dtd = new DataTable(); var comando = new SqlCommand("select * from Cat_Site where idEdificio = '" + edificio + "';", Conexion.AbrirConexion()); SqlDataReader dr = comando.ExecuteReader(); dtd.Clear(); dtd.Load(dr); Conexion.CerrarConexion(); return(dtd); }
public void InsertarSite(string Site) { var comando = new SqlCommand("INSERT INTO[dbo].[Cat_Site]([Site])VALUES ('" + Site + "')", Conexion.AbrirConexion()); try { comando.ExecuteNonQuery(); } catch (Exception) { throw; } Conexion.CerrarConexion(); }
public void InsertarProveedor(string Proveedor) { var comando = new SqlCommand("INSERT INTO[dbo].[Cat_Proveedor]([Proveedor])VALUES ('" + Proveedor + "')", Conexion.AbrirConexion()); try { comando.ExecuteNonQuery(); } catch (Exception) { throw; } Conexion.CerrarConexion(); }