Devart Forums

Code: Select all

Membership.Providers["nameOfProvider"].CreateUser(string UserName, string Password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status);

Code: Select all

public override void Initialize(string name, System.Collections.Specialized.NameValueCollection config)
    {
        String strConn = Utilerias.ObtenerConnString();
        base.Initialize(name, config);
        base.connectionString = strConn;
    }

Code: Select all

public void Inserta(ref String strMensaje, String strOrigen)
{
    //Definicion el Query
    StringBuilder strQuery = new StringBuilder();
    strQuery.Append("INSERT INTO detalle_facturas_exportacion (");
    strQuery.Append("dfe_id_factura, ");
    strQuery.Append("dfe_id_parte, ");
    strQuery.Append("dfe_cantidad, ");
    strQuery.Append("dfe_precio_unitario, ");
    strQuery.Append("dfe_fraccion, ");
    strQuery.Append("dfe_unidad_comercial, ");
    strQuery.Append("dfe_unidad_tarifa, ");
    strQuery.Append("dfe_factor_conversion, ");
    strQuery.Append("dfe_unidad_cove, ");
    strQuery.Append("dfe_factor_cove, ");
    strQuery.Append("dfe_numero_orden "); ;
    strQuery.Append(") VALUES (");
    strQuery.Append(":prmIdFactura, ");
    strQuery.Append(":prmIdParte, ");
    strQuery.Append(":prmCantidad, ");
    strQuery.Append(":prmPrecioUnitario, ");
    strQuery.Append(":prmFraccion, ");
    strQuery.Append(":prmUnidadComercial, ");
    strQuery.Append(":prmUnidadTarifa, ");
    strQuery.Append(":prmFactorConversion, ");
    strQuery.Append(":prmUnidadCove, ");
    strQuery.Append(":prmFactorCove, ");
    strQuery.Append(":prmNumeroOrden ) ");

    //Definicion de la conexion.
    String strConnAux = Herramientas.Herramientas.ObtenerStringConexion();
    String strConn = System.Configuration.ConfigurationManager.ConnectionStrings[strConnAux].ToString();
    PgSqlConnection pgConn = new PgSqlConnection(strConn);
    PgSqlCommand pgCmd = new PgSqlCommand(strQuery.ToString(), pgConn);
    pgCmd.Parameters.Add("prmIdFactura", PgSqlType.Int).Value = this.IdFactura;
    pgCmd.Parameters.Add("prmIdParte", PgSqlType.Int).Value = this.IdParte;
    pgCmd.Parameters.Add("prmCantidad", PgSqlType.Numeric).Value = this.Cantidad;
    pgCmd.Parameters.Add("prmPrecioUnitario", PgSqlType.Numeric).Value = this.PrecioUnitario;
    pgCmd.Parameters.Add("prmFraccion", PgSqlType.VarChar).Value = this.Fraccion;
    pgCmd.Parameters.Add("prmUnidadComercial", PgSqlType.Int).Value = this.UnidadComercial;
    pgCmd.Parameters.Add("prmUnidadTarifa", PgSqlType.Int).Value = this.UnidadTarifa;
    pgCmd.Parameters.Add("prmFactorConversion", PgSqlType.Numeric).Value = this.FactorConversion;
    pgCmd.Parameters.Add(":prmUnidadCove", PgSqlType.VarChar).Value = this.UnidadCove;
    pgCmd.Parameters.Add(":prmFactorCove", PgSqlType.Numeric).Value = this.FactorCove;
    pgCmd.Parameters.Add(":prmNumeroOrden", PgSqlType.Int).Value = this.NoOrden;


    pgConn.Open();
    pgCmd.ExecuteNonQuery();
    pgConn.Close();

Code: Select all

protected void Page_Load(object sender, EventArgs e)
    {
        String strMensaje = "";
        String strConnString = @"Provider=vfpoledb;Data Source=z:\DatosCtes\dbadmctes.dbc;Collating Sequence=machine;";
        String strCommand = "SELECT * FROM catctes";

        UniConnection objConn = new UniConnection(strConnString);
        UniCommand objCommand = new UniCommand(strCommand, objConn);
        objConn.Open();
        UniDataReader drInfo;
        
        try 
        { 
            drInfo = objCommand.ExecuteReader();
            grdPrueba.DataSource = "drInfo";
        }
        catch (Exception objException)
        {
            strMensaje += objException.Message + "\n";
            strMensaje += objException.StackTrace + "\n";
        }
        
        objConn.Close();
    }