3 answers

178 views

Loading Data On-Demand when ChildGridViewTemplate is Expanded

I have a 4-level RadGridView with a total of 3 Sibling ChildGridViewTemplates for a total of 7 GridViewTemplates (2 of them sharing a DataSet with 1 each of the other ChildGridViewTemplates). I have one case that currently loads 44 k Rows total (between all GridViewTemplates) into the DataSets used by RadGridView taking ~8 seconds. I'd like to cut that time down to no more than 1, maybe 2 seconds by suppressing data loads for ChildGridViewTemplates until each one is opened (i.e. it's ParentRow is expanded). Once it's opened, the data for its Rows would stay in memory and possibly be cleared when it's closed (i.e. it's ParentRow is collapsed). Of course, it would need to allow for multiple Cousin ChildGridViewTemplates being open at the same time (but if necessary, even that's optional if I can force close all other open Cousins). I'm binding to DataSet's filled by SqlDataAdapter's. My grid is read-only (well at the grid-level anyways, Rows will be edited using a separate Form per Row).

I imagine I need to handle the ChildViewExpanded Event, but I wanted to get your input before I stray too far down the wrong path. Maybe I even need to change my binding method?

NOTE: I'm also considering a GridViewTemplate-level "Refresh" option.

2009Q2 (2009.2.9.729), VS 2005 (v8.0.50727.762 SP.050727-7600), .Net2 (2.0.50727), XP SP3, Core2Duo 2.99GHZ with 3GB.

GridView

answered on 05 Jun 2013

2 answers

126 views

Grid to Excel - modified column not exporting correctly

I am returning bound data to a RadGridView via a DataTable. In the process I need to modify one of the columns which is contains a timestamp value (seconds from midnight) to display time. The code below shows where I intercept the column in the CellFormatting event and convert the timestamp value to a DateSerial, which I then set the CellElement.Text to.

Based on this function the grid displays the timestamp exactly as I want - ie: 44233 is displayed correctly as 12:17:13 PM in the grid. However, when export the grid to Excel, the timestamp value (44233) is exported and not the new CellElement.Text.

Am I doing something wrong or can I modify the column via the exporter before it gets into Excel? Thanks

Private Sub grdAccessLogs_CellFormatting(sender As Object, e As CellFormattingEventArgs) Handles grdAuditLogs.CellFormatting

Dim sCol As String = e.CellElement.ColumnInfo.Name.ToUpper

'format timestamp column

If sCol.IndexOf("TYPE=TS") > 0 Then

Dim sTs As String = e.CellElement.Text

If e.CellElement.Text.IndexOf(":") = -1 Then e.CellElement.Text = fConvertSysTime(sTs).ToString

End If

End Sub

Function fConvertSysTime(lTime As Integer) As String

Dim lHours As Integer

Dim lMinutes As Integer

Dim lSeconds As Integer

Try

'truncate decimals - only want full hours

lHours = Int(lTime / 3600)

lMinutes = Int((lTime - lHours * 3600) / 60)

lSeconds = Int(lTime - lHours * 3600 - lMinutes * 60)

'build time string

Return TimeSerial(lHours, lMinutes, lSeconds)

Catch e As Exception

Return ""

End Try

End Function

GridView

answered on 04 Jun 2013

5 answers

539 views

How to bind dataset to Radgrid in Windows App.

How to bind dataset to Radgrid in Windows Application(Normally used DataBind() method not available)

SqlConnection conn;

SqlDataAdapter da;

SqlCommand cmd;

conn = new SqlConnection("Data Source=SWAP;Initial Catalog=Swapnil;User ID=sa;Password=************");

cmd = new SqlCommand("select * from Employee", conn);

conn.Open();

DataSet ds = new DataSet();

DataTable dt= new DataTable();

da = new SqlDataAdapter(cmd);

cmd.ExecuteNonQuery();

conn.Close();

da.Fill(ds);

radGridView1.DataSource = ds;

Thanks.

GridView

answered on 04 Jun 2013

1 answer

116 views

Ungrading telerik gives 'DataAccessComponent' does not exist in the namespace 'Telerik.WinControls.Data'

Hi,

I am suppose to make an upgrade from a very old version of telerik to the latest version. I am trying to do this in small steps. Currently I have upgraded to Q3 2010, but I get the following error 'DataAccessComponent' does not exist in the namespace 'Telerik.WinControls.Data'. I understand that DataAccessComponent is not supported anymore, but I cannot find any information in the release notes on when it was modified and what it was modified with.

If you could provide some feedback on this, it would be great.

Thanks

GridView

answered on 04 Jun 2013

1 answer

171 views

Datetime picker - MinDate

e.g. MinDate = #5/30/2013#
When I set the MinDate to a value the value is also set to MinDate.

   With calStartDate
    .MinDate = MinimumDate
    .MaxDate = MaxDate
    .SetToNullValue()
   End With

Applying SetToNullValue does not reset the value to null/nothing. How can I ensure the value (default) is always set to NULL

Telerik WnForms Q1 2013 SP1
VS2010

Calendar, DateTimePicker, TimePicker and Clock

answered on 04 Jun 2013

4 answers

187 views

2009 Q3 Exit and Options Buttons in the RadRibbonBar

Hello,

how can I handle the click events of the Exit and Option Button in the RadRibbonBar?

THX.

RibbonBar

answered on 04 Jun 2013

28 answers

569 views

Save/Load layout issue

Hi, I'm having issue with save/load layout of a grid control.

I have a date column that I filter between date 1 and date 2. If I save the layout I cannot reload it. I get an error message in Visual Studio :

Exception has been thrown by the target of an invocation.
{"Invalid filter expression."}

I noticed that the filter menu changed since last version and I can now select dates with a calendar control instead of a textbox. Maybe it has something to do with it...

thanks

GridView

answered on 04 Jun 2013

4 answers

411 views

How to make user entry in RadTextbox as uppercase?

in win forms?

TextBox

answered on 04 Jun 2013

1 answer

305 views

animated chart

hi,is it possible to create animated charts in windows form or it's just possible in wpf and silverlight?

ChartView

answered on 03 Jun 2013

1 answer

77 views

using RadCarousel

HI

I am newly using RadCarousel in windows winform application. I want to show different controls like analog meters, images in it.
No idea how to make a attractive look. Need some guidance.

Thanks in advance.

General Discussions

answered on 03 Jun 2013