
Hi.
In my grid I've got some columns with double values. Some of the values might be null values or Double.NaN resp.
However, in a summary row I need value counts, average and standard deviation of the values - excluding the null values!
How can I customize the grid aggregate functions to achieve this?
I experimented with GridViewSummaryItem.AggregateExpression a bit, but I don't know how to formulate an If-Condition to skip the null value row.
My code so far looks like this:
Dim avg As New GridViewSummaryRowItem()
Dim count As New GridViewSummaryRowItem()
Dim stdev As New GridViewSummaryRowItem()
For col As Integer = 2 To table.Columns.Count - 1
Dim row_cnt As New GridViewSummaryItem()
row_cnt.Name = table.Columns(col).ColumnName
row_cnt.Aggregate = GridAggregateFunction.Count
row_cnt.FormatString = "# {0}"
count.Add(row_cnt)
Dim row_avg As New GridViewSummaryItem()
row_avg.Name = table.Columns(col).ColumnName
row_avg.Aggregate = GridAggregateFunction.Avg
row_avg.FormatString = "Ø {0:F4}"
avg.Add(row_avg)
Dim row_stdev As New GridViewSummaryItem()
row_stdev.Name = table.Columns(col).ColumnName
row_stdev.Aggregate = GridAggregateFunction.StDev
row_stdev.FormatString = "σ {0:F4}"
stdev.Add(row_stdev)
Next
grd_data_.SummaryRowsBottom.Add(count)
grd_data_.SummaryRowsBottom.Add(avg)
grd_data_.SummaryRowsBottom.Add(stdev)


Hello dear,
I can save layout for more than one grid view in the same file ??, for example:
i have gv1 and gv2, i want to save layout for all grids in one file so i can do this ?? if yes let me know, thanks.
In winforms Radgridview whenever I need to create a new row I have been generating a class with members for each column like:
public class stopCreationRow { public string shipper, consignee, zip; }
Then I create and use it for adding rows like:
private void radButton35_Click(object sender, EventArgs e) { stopCreationRow newRow = new stopCreationRow(); //throughout the code set the various fields as needed newRow.consignee = "person"; newRow.shipper = "new shipper"; //then transfer everything to the proper cells GridViewDataRowInfo dataRowInfo = new GridViewDataRowInfo(this.stopCreation_grid.MasterView); dataRowInfo.Cells["consignee"].Value = newRow.consignee; dataRowInfo.Cells["shipper"].Value = newRow.shipper; //finally create the row stopCreation_grid.Rows.Add(dataRowInfo); }
My question is two fold:
1. Can I somehow use newRow from above to directly create the row?
2. Instead of created my own class, since all this information is already in the datagrid can I access the field names though a class derived from the datagrid?
Hi,
I created a Usercontrol using telerik winform controls.
How to include the created Usercontrol into telerik grid view column as Column type
regards
Subramanya Udupa

hi,
i have some code like this
For i = 0 To count Dim col1 As CheckedListBox.CheckedItemCollection = chk_Sorumlular.CheckedItems Dim col2 As CheckedListBox.CheckedItemCollection = chk_Beyannameler.CheckedItems If col1.Contains(Me.Izgara.Rows(i).Cells(Me.sutun_sorumlu.Name).Value) And col2.Contains(Me.Izgara.Rows(i).Cells(Me.sutun_Turu.Name).Value) Then Dim str As String = Me.Izgara.Rows(i).Cells(Me.sutun_ID.Name).Value.ToString() Dim chrArray() As Char = {"|"c} If (Microsoft.VisualBasic.CompilerServices.Operators.CompareString(str.Split(chrArray)(1).Trim(), "", False) <> 0) And chk_TahakkukFisi.Checked Then Me.Izgara.Rows(i).Cells(Me.sutun_Sec_Tahakkuk.Name).Value = CheckState.Checked Else Me.Izgara.Rows(i).Cells(Me.sutun_Sec_Tahakkuk.Name).Value = CheckState.Unchecked End If If (Microsoft.VisualBasic.CompilerServices.Operators.CompareString(str.Split(chrArray)(0).Trim(), "", False) <> 0) And chk_Beyanname.Checked Then Me.Izgara.Rows(i).Cells(Me.sutun_Sec_Beyanname.Name).Value = CheckState.Checked Else Me.Izgara.Rows(i).Cells(Me.sutun_Sec_Beyanname.Name).Value = CheckState.Unchecked End If Else Me.Izgara.Rows(i).Cells(Me.sutun_Sec_Tahakkuk.Name).Value = CheckState.Unchecked Me.Izgara.Rows(i).Cells(Me.sutun_Sec_Beyanname.Name).Value = CheckState.Unchecked End If Application.DoEvents()Next
i can do this with microsoft checkedlistbox component
but i try do with radcheckedlistbox and get error
An unhandled exception of type 'System.InvalidCastException' occurred in asd.exe
Additional information: An object of type 'System.String' could not be thrown to 'Telerik.WinControls.UI.ListViewDataItem'.
how can i fix this
thank you

I am trying to validate a change to a property from within a propertygrid that requires a password. I am trying to capture the ValueChanging event for the underlying editor. If a form is launched from within the event handler and the change is not cancelled, an ArgumentOutOfRangeException ends up being thrown sometime after the event handler returns. I have attached a simple example that throws the exception. In it there is a simple Yes/No message box. If Yes is answered -> Exception is thrown. Any help is much appreciated. Thank you
Enum type and simple class edited by the Property Grid.
public enum EnumeratedProp { FirstItem, SecondItem, ThirdItem}public class TestProps{ [DisplayName("Formula Lock Active")] [Description("Indicates whether custom formulas can be locked to prevent editing")] public EnumeratedProp TestProp { get; set; }}
Form Code
public partial class TestPropsForm : Form{ public TestProps tstProps = new TestProps(); public TestPropsForm() { InitializeComponent(); radPropGrid.SelectedObject = tstProps; } private void radPropGrid_EditorInitialized(object sender, Telerik.WinControls.UI.PropertyGridItemEditorInitializedEventArgs e) { if(e.Item.Name == "TestProp") { e.Editor.ValueChanging += TestProp_ValueChanging; } } private void TestProp_ValueChanging(object sender, Telerik.WinControls.UI.ValueChangingEventArgs e) { e.Cancel = (MessageBox.Show("Are you sure you want to change this?", "Question", MessageBoxButtons.YesNo) != DialogResult.Yes); }}