Hello,

I have to DropDownList elements in my GridView. Everything is fine except, that the dropdownlist closes immediatly after I click on the scrollbar of the dropdownlist. So there is no way to an item with comfort.

Thanks for help

I have a databound grid.

When I right click on a row and choose "delete row" I want it to delete it in the database as well.

My code seems pretty simple:

It steps through it fine, the row is gone but the database does not get updated UNLESS I edit another field, then it calls this and it not only does the field edit but it also removes the row:

im trying to add a custom calculated field in my pivot following the intructions you give here 

http://www.telerik.com/help/winforms/pivotgrid-calculated-fields.html

here is my code and it doesnt work, any help?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Telerik.Pivot.Core;
using Telerik.Pivot.Core.Aggregates;
using Telerik.WinControls;

namespace GAR.Ventas
{
  public partial class frmPivot2 : Telerik.WinControls.UI.RadForm
  {
    public frmPivot2()
    {
      InitializeComponent();
    }

    public class Venta
    {
      public string Vendedor { get; set; }
      public string Cliente { get; set; }
      public string Zona { get; set; }
      public string Articulo { get; set; }
      public decimal Cantidad { get; set; }
      public decimal Precio { get; set; }
      public decimal Total { get { return Cantidad * Precio; } }
      public decimal Costo { get; set; }
      public decimal Margen { get { return Precio - Costo; } }
      public DateTime Fecha { get; set; }
    }

    public class Articulo
    {
      public string Descripcion { get; set; }
      public decimal Precio { get; set; }
      public decimal Costo { get { return Precio - (Precio * (SGS.Utils.convert.ToDecimal(20) / SGS.Utils.convert.ToDecimal(100))); } }
    }

    public class Cliente
    {
      public string Nombre { get; set; }
      public string Zona { get; set; }
    }


    public List<Venta> Ventas { get; set; }


    private void frmPivot2_Load(object sender, EventArgs e)
    {
      LocalDataSourceProvider provider;

      List<Cliente> Clientes = new List<Cliente>();
      List<Articulo> Articulos = new List<frmPivot2.Articulo>();
      List<Cliente> Vendedores = new List<Cliente>();

      Clientes.Add(new Cliente { Nombre = "JOSE PENA", Zona = "SANTO DOMINGO" });
      Clientes.Add(new Cliente { Nombre = "JUAN PEREZ", Zona = "SANTO DOMINGO" });
      Clientes.Add(new Cliente { Nombre = "JULIAN MONTERO", Zona = "SANTO DOMINGO" });

      Clientes.Add(new Cliente { Nombre = "SAMUEL AURELIO", Zona = "SANTIAGO" });
      Clientes.Add(new Cliente { Nombre = "SERGIO GUZMAN", Zona = "SANTIAGO" });
      Clientes.Add(new Cliente { Nombre = "JUAN CARLOS TEJEDA", Zona = "SANTIAGO" });
      Clientes.Add(new Cliente { Nombre = "LUIS CROUSSET", Zona = "SANTIAGO" });

      Clientes.Add(new Cliente { Nombre = "JOSE PERDOMO", Zona = "LA ROMANA" });
      Clientes.Add(new Cliente { Nombre = "ERIK GUTIERRES", Zona = "LA ROMANA" });
      Clientes.Add(new Cliente { Nombre = "ERICK GOMEZ", Zona = "LA ROMANA" });

      Articulos.Add(new Articulo { Descripcion = "CAJA DE BOLA", Precio = 100 });
      Articulos.Add(new Articulo { Descripcion = "JUEGO DE GOMAS AX100", Precio = SGS.Utils.convert.ToDecimal(123.44) });
      Articulos.Add(new Articulo { Descripcion = "CUARTO ACEITE CASTROL", Precio = SGS.Utils.convert.ToDecimal(1830.22) });
      Articulos.Add(new Articulo { Descripcion = "MICA DERECHA HONDA CIVIC", Precio = SGS.Utils.convert.ToDecimal(289.44) });
      Articulos.Add(new Articulo { Descripcion = "PANTALLA DELANTERA", Precio = SGS.Utils.convert.ToDecimal(2400.00) });
      Articulos.Add(new Articulo { Descripcion = "TAPA BOCINAS", Precio = SGS.Utils.convert.ToDecimal(1645.00) });
      Articulos.Add(new Articulo { Descripcion = "BOLA ESFERICA HONDA", Precio = SGS.Utils.convert.ToDecimal(999.99) });
      Articulos.Add(new Articulo { Descripcion = "FRENTIL NISSAN", Precio = SGS.Utils.convert.ToDecimal(1255) });
      Articulos.Add(new Articulo { Descripcion = "PUERTA DERECHA CIVIC 2000", Precio = SGS.Utils.convert.ToDecimal(1320.99) });
      Articulos.Add(new Articulo { Descripcion = "MONITOR 24", Precio = SGS.Utils.convert.ToDecimal(2800) });
      Articulos.Add(new Articulo { Descripcion = "LAPTOP ACER", Precio = SGS.Utils.convert.ToDecimal(23000.00) });


      Vendedores.Add(new Cliente { Nombre = "PEDRO CASTILLO" });
      Vendedores.Add(new Cliente { Nombre = "ERNESTO PASCUAL" });
      Vendedores.Add(new Cliente { Nombre = "CARLOS PAULINO" });
      Vendedores.Add(new Cliente { Nombre = "CARLO ACOSTA" });
      Vendedores.Add(new Cliente { Nombre = "GERONIMO MARTE" });
      Vendedores.Add(new Cliente { Nombre = "ANTHONY REYES" });

      Ventas = new List<Venta>();

      int idArticulo = 0;
      int idCliente = 0;
      int idVendedor = 0;
      Random rnd = new Random();
      for (int i = 0; i <= 10000; i++)
      {
        idArticulo = rnd.Next(1, 11);
        idCliente = rnd.Next(1, 10);
        idVendedor = rnd.Next(1, 6);

        Ventas.Add(new Venta
        {
          Articulo = Articulos[idArticulo].Descripcion
          ,
          Cantidad = rnd.Next(1, 100)
          ,
          Cliente = Clientes[idCliente].Nombre
          ,
          Zona = Clientes[idCliente].Zona
          ,
          Vendedor = Vendedores[idVendedor].Nombre
          ,
          Precio = Articulos[idArticulo].Precio
          ,
          Costo = Articulos[idArticulo].Costo
          ,
          Fecha = DateTime.Now.AddDays(rnd.Next(1, 200) * -1)
        });
      }

      provider = new LocalDataSourceProvider() { ItemsSource = Ventas  };
      provider.Culture = new System.Globalization.CultureInfo("es-DO");

      this.radPivotGrid1.DataProvider = provider;


      using (radPivotGrid1.PivotGridElement.DeferRefresh())
      {
        CommissionCalculatedField calculatedField = new CommissionCalculatedField();
        calculatedField.Name = "Commission";

        ((LocalDataSourceProvider)this.radPivotGrid1.DataProvider).CalculatedFields.Add(calculatedField);
      }




      this.radPivotGrid1.PivotGridElement.DataProvider.Refresh();
    }


    #region PRUEBA 1
    public class CommissionCalculatedField : CalculatedField
    {
      private RequiredField extendPriceField;

      public CommissionCalculatedField()
      {
        this.Name = "Commission";
        this.extendPriceField = RequiredField.ForProperty("Precio");
      }

      protected override IEnumerable<RequiredField> RequiredFields()
      {
        yield return this.extendPriceField;
      }

      protected override AggregateValue CalculateValue(IAggregateValues aggregateValues)
      {
        var aggregateValue = aggregateValues.GetAggregateValue(this.extendPriceField);
        if (aggregateValue.IsError())
        {
          return aggregateValue;
        }

        double extendedPrice = aggregateValue.ConvertOrDefault<double>();
        if (extendedPrice > 15000)
        {
          return new DoubleAggregateValue(extendedPrice * 0.1);
        }

        return null;
      }
    }
    #endregion
  }
}

Hi,

I'm using gridview to list some important datas. After datas are listed, when i right clicked on the cell's, it shows a standard menu that contains copy, paste, cut, delete and some another options. But, i don't want that end users can cut or delete the cell's content even accidentally. I need only copy option. So, how can i remove that options except copy from that menu?   

Hello;

I have run out of ideas!

I have a simple parent/child databound grid.

The parent has a list of people, the child has a list of stores assigned to them.

I am wanting so that if I want to assign a new store they can click on "click here to add a new row" then have it work.

The attached picture should help.

In "Cust Stop No" they should be able to type in a number, then I want to do some validation to make sure it is a valid store ID.

If it is, i want to fill in the other columns of data.

I populate the grid here:

Then I have tried to catch the cell change event here:

I am several hours in and not making any headway....please help!

Thank you,

Joe

In the picture that I've attached you can see that the actual rows look fine with the white and blue color, just as i want them to look. However, the row grouping header is gray, and i can not for the life of me find a way to change the color of it. 

(I want to change the color of the grouping header in C# code)

Thanks

A.

Hi,

if i doubleclick on the appointmen cell on the Scheduler for Winform UI the EditAppointmentDialog is shown.

Question:

How can i disable the  EditAppointmentDialog , it is possible after a DoubleClick not to popup this EditAppointmentDialog??

Regards,

Bledar

Hi folks.

I have a list view which can be populated with many rows of data (not databound)

Once populated I want to grab the text values of certain sub items - but the ListViewDataItem does not have a subitem property

EG:

foreach (ListViewDataItem item in radListViewPOItem.Items)

{
                    
}

Any tips on how to accomplish a simple task?

Thanks.

Hi,

I have a grid with multiple columns and rows and inside a method which handles cellformatting, based on some criteria which change dynamically,  set different properties to cells(including enabling/disabling , coloring and many more). but when i do scroll the grid, the cells appearance are mixed up and cells which should be enabled will be disabled and many weird appearances. So i Was wondering how it can be fixed and is there any way to update the grid on fly when scrolling

Thank you 

Cheers,

Niloofar