2 answers

164 views

[Solved] 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

596 views

[Solved] 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

152 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

211 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

224 views

[Solved] 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

656 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

462 views

How to make user entry in RadTextbox as uppercase?

in win forms?

TextBox

answered on 04 Jun 2013

1 answer

356 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

100 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