Hello,
I am using Telerik version 2013.3.1127.40. The Problem I am facing is how to Bind the RadGridView with ColumnGroupView using a DataTable or DataSet as DataSource. The Demo with respect to ColumnGroupView Doesn't Mention the above( https://docs.telerik.com/devtools/winforms/gridview/view-definitions/column-groups-view).Please Help
I need to format the background color of the Summary row based on its Aggregated (Sum) value compared to another value on the form. If the values are equal, I want it blue, if they are not equal, I need it to be red.
Dim ugRow As GridViewRowInfo
Dim dAdditionTotal As Double = 0
For Each ugRow In radGVBuildingAdditions.Rows
dAdditionTotal += ugRow.Cells("Addition_SQFT").Value
Next
With Me.radGVBuildingAdditions.SummaryRowsBottom
If .Count > 0 Then
For i As Integer = 0 To .Count - 1
.Remove(.Item(i))
Next i
End If
End With
If dAdditionTotal > 0 Then
Dim summary1 As New GridViewSummaryItem()
summary1.Name = "Addition_SqFt"
summary1.Aggregate = GridAggregateFunction.Sum
summary1.FormatString = "Addition Total SF {0:#,##0}"
Dim summaryRowItem As New GridViewSummaryRowItem()
summaryRowItem.Add(summary1)
Me.radGVBuildingAdditions.SummaryRowsBottom.Add(summaryRowItem)
Me.radGVBuildingAdditions.MasterTemplate.ShowTotals = True
Me.radGVBuildingAdditions.MasterView.SummaryRows(0).IsVisible = True
Dim dBuildingArea As Double = IIf(CLIB_MAPPS.Utilities.ConvertNULLtoDouble(Me.txtBldgNetSF.Text) > 0, CLIB_MAPPS.Utilities.ConvertNULLtoDouble(Me.txtBldgNetSF.Text), Me.txtBldgEstimatedSF.Text)
If dAdditionTotal = dBuildingArea Then ' dBuildingArea from another control on the form
'MAKE SUMMARY ROW (NOT CELL, ENTIRE ROW) BLUE
Else
'MAKE SUMMARY ROW (NOT CELL, ENTIRE ROW) RED
End If
Else
Me.radGVBuildingAdditions.MasterTemplate.ShowTotals = False
End If
I attempted to do it in the ViewCellFormatting event, but this requires parsing the number back out of the formatted text and is only working with the Cell in which I placed the total.
Private Sub radGVBuildingAdditions_ViewCellFormatting(sender As Object, e As CellFormattingEventArgs) Handles radGVBuildingAdditions.ViewCellFormatting
If TypeOf e.CellElement Is GridSummaryCellElement Then
Dim dArea As Double = IIf(CLIB_MAPPS.Utilities.ConvertNULLtoDouble(Me.txtBldgNetSF.Text) > 0, CLIB_MAPPS.Utilities.ConvertNULLtoDouble(Me.txtBldgNetSF.Text), Me.txtBldgEstimatedSF.Text)
If e.CellElement.ColumnInfo.Name = "Addition_SqFt" Then
If dArea = CInt(e.CellElement.Value) Then 'I HAVE TO PARSE THE TOTAL BACK OUT OF e.CellElement.Value
e.CellElement.BackColor = Color.DodgerBlue
Else
e.CellElement.BackColor = Color.Firebrick
End If
End If
End If
End Sub
is there a better way to do this?
Hello,
I am using a map with 2 layers
Dim
layer
As
New
MapLayer(
"Site"
)
layer.ClusterStrategy =
New
ElementClusterStrategy()
layer.ClusterDistance = 50
Me
.RadMap1.Layers.Add(layer)
Me
.RadMap1.Layers.Add(
New
MapLayer(
"Base départ"
))
And i add elements to the map like this
Dim
element
As
New
MapPin(siteInfo.Location)
element.Text =
String
.Format(
"{0}"
& vbCrLf &
"{1}"
, siteInfo.Name, siteInfo.adresse)
element.BackColor =
Me
.colors(siteInfo.identifieur)
element.Tag = siteInfo
element.ToolTipText =
String
.Format(
"{0}"
& vbCrLf &
"{1}"
, siteInfo.Name, siteInfo.adresse)
Me
.RadMap1.Layers(siteInfo.identifieur).Add(element)
In this setup, tooltiptext works on pins contained on layer without cluster, but they don't on the one with cluster.
Can you tell me how can i use ToolTipText with cluster ?
Thank you
Hi,
I am zooming to particular area of the ChartView. Depending on the zoom, some lines may not be visible in the current zoomed in portion of the chart. So, the legend is displaying items that are not currently visible in the chart. I need to display legend only for the lines that are visible in different zoom/pan settings. How to achieve this?
I have a databound list, in which my object contains the following properties
DOB
FirstName
LastName
When I bind my times to the list view, the columns come out as
DOB FirstName LastName
Is there a way to programmatically order the columns?
FirstName LastName DOB
TIA
Is it possible to use data bindings in a list view that contains both groups & multiple column lists?
TIA
Hello,
I'm coming back with a new question :).
There is a way to minimize a radform just with the titlebar and keep the windows active ?
I found the TitleBar_Minimize event handler but I don't know which options use.
step1.png the windows is active
step2.png I click on the minimize button in title bar
step3.png I have my radform active and reducted (without resizebutton), I can click on the maximum button to show the radform content.
Best regards,
Could someone help with adding the following Unicode character to a tables textbox. I have been asked to add the following service mark character (U+2120) which resolves to "SM" to the end of a string. For some reason when I add this and try to save the report, I am getting the following error. "Some unicode characters in this file could not be saved in the current codepage. Do you want to resave this file as unicode in order to maintain your data?"
I need to add a string to the table cell textbox as follows "Some test for textbox (℠)"
Thanks
Dave.
I have a BindingList of a business object that I want to bind with a ListView (in detail mode).
I can change which properties get displayed (and there respective column headers) using the ColumnCreating event, but I cannot change the order of the columns.
As I understand, the binding process of ListView will use the properties in the order that they appear in code, this should have been fine, except that in case of object inheritance, the parent's class properties come after the child's class properties. In my case, I want base class properties to appear first and followed by child class properties.
Is there a way to change or affect the order that columns get created?
This would also allow me to save and recreate the order in which the columns appear, if, in future, I allow the user to reorder the columns of the ListView.
I know that I could use a DataTable to manipulate the columns beforehand, and use this as my binding source, but I would like to avoid this "conversion" between business object and DataTable.