Questions on UI for WinForms Forum

1 answer

132 views

Missing Thread.

I had created a new thread relating to a question on WinForms GridView, but this is not accessible anymore/has disappeared.
http://www.telerik.com/community/forums/winforms/gridview/editing-gridviewdatetimecolumn.aspx

It does not appear in the WinForms GridView Forum.
However it does appear when we search the WinForms GridView forum with key word "Editing".
Please see attached screenshot.

Just thought someone would like to know.
And if this thread is retrieved, could it please be answered?

Regards
Sameer.

General Discussions

answered on 03 Aug 2011

1 answer

546 views

DataError handling with RadGridView

Hello

I am working with a databound RadGridView, I would like to intercept data exceptions errors while editing but also while adding a record. At the moment Im more concerned with adding. While adding if the DataError method is called the ErrorText is set for the row, but instead of staying focused in the current cell, it deletes all data in all cells that were entered. There is an exclamation icon set in the first column of the grid when the ErrorText is set but it is overlapping the current icon.

Isnt the e.Cancel = true line supposed to cancel validation and keep the focus in the current cell till valid data is entered?

private void radGridView1_DataError(object sender, GridViewDataErrorEventArgs e)

{

e.Cancel = false;

if ((e.Exception) is System.Data.NoNullAllowedException)

{

RadGridView view = (RadGridView)sender;

if (view.CurrentRow is GridViewNewRowInfo)

{

view.CurrentRow.ErrorText = e.Exception.Message;

		//The following line doesnt work when adding a row, as e.RowIndex will equal -1

//(sender as RadGridView).Rows[e.RowIndex].ErrorText = e.Exception.Message;

e.ThrowException = false;

}

Could you provide me with a way to retain all data that was entered into the row before the error. Also to some method of indicating which cell has the error, and also how to shut off that exclamation icon when the ErrorText is set or have it be the only icon showing?

Attached are pictures to illustrate how the icon is appearing within the row and showing the tooltip with the empty record

GridView

answered on 03 Aug 2011

2 answers

138 views

Where is it?

Hi everyone!

I've just installed the Controls for WinForm Q2 2011 and everything appears as expected in VS2008, but i'm missing the RichtTextBox in the toolbox. Even by trying to manually add an element to the toolbox i can't find the new RichTextBox by searching all available .net Framwork Components. Is there any trick i don't know?

Best Regards,
Michael

RichTextBox (obsolete as of Q3 2014 SP1)

answered on 03 Aug 2011

1 answer

112 views

Automatically Bind Checked Field on CheckBox

In Visual Studio we have added Business Objects as data sources. When we set the default UI to be the RadCheckBox to the bool properties on the business object it automatically binds to the text field.

How can I make it automatically bind to the checked field?

thanks,

gj

General Discussions

answered on 02 Aug 2011

2 answers

1.2K+ views

How to loop through each cell and set value?

I could use a little help if you can. I am new to Telerik and a relatively new programmer, so please bear with me as I try to explain my goal.

Essentially what I am trying to do is pivot records from a "View" in my database to produce a full year calendar using a radGridView as the container for the output. The radGridView is bound to a seperate SQL Server table. There are 12 records in the table and 33 columns.This table is only used as a template for the radGridView so all fields are null except for the two where I have set the month name and month #. The radGridView is to be used for visualization only and is not meant to allow for direct editing of records. The table I am using for the template has;
* 12 rows
    - One row for each month ( RowIndex + 1 = month of the year)
* 33 Columns
    - One column for the name of the month ( .ColumnIndex 0)
    - One column for each possible day of the month ( .ColumnIndex 1 - 31). The day columns are named 1, 2, ..... ,31
    - The last column in the grid ( .ColumnIndex 32) has the month number. Used for sorting only.

What I am trying to do is;

Loop through each cell where the column index is between 1 and 31;
Query a view in my database (There is a date field in the View where I have parted the day, month and year from the date into seperate columns)

Return a record, if it exists, where
- day = .ColumnIndex
- month = Rowindex + 1
- Year = Textbox2.Text
- GPID = Textbox1.Text
- Set the Cell value to the string returned from the database

The "View" I am querying has 6 columns; GPID, AttDate, aDay, aMonth, aYear, Incidents

The following code works except that it sets each cell value in the columns to the first matching record it finds in the database.

Private Sub radGridView1_CellFormatting()

Dim selectedIndex As Integer = Me.RadGridView1.Rows.IndexOf(Me.RadGridView1.CurrentRow)

Dim selectedcolumn As Integer = Me.RadGridView1.CurrentCell.ColumnIndex

Dim EE As Integer

Dim vbDay As Integer 'Day of the month, also the name of the column

Dim vbMonth As Integer ' Month of the year, also row index + 1

Dim vbYear As Integer 'Year being generated

EE = CInt(TextBox1.Text) ' Employee id #

vbYear = CInt(TextBox2.Text) 'Year for calendar

For Each row As GridViewDataRowInfo In RadGridView1.Rows

If Me.RadGridView1.CurrentCell.ColumnIndex > 0 and Me.RadGridView1.CurrentCell.ColumnIndex < 32 Then

vbDay = selectedcolumn

vbMonth = selectedIndex + 1

row.Cells("1").Value = GetEntry(EE, vbDay, vbMonth, vbYear) 'Testing with only a couple of columns.

row.Cells("2").Value = GetEntry(EE, vbDay, vbMonth, vbYear) 

                      ' ......

End If

Next

End Sub

Public Function GetEntry(ByVal EE As Integer, ByVal vbDay As Integer, ByVal vbMonth As Integer, ByVal vbYear As Integer)

Dim CalEntry As String

Dim connstring As String = ("Data Source=MyComputer\SQLEXPRESS;Initial Catalog=MAPPSQL;Persist Security Info=True;User ID=myuser;Password=mypass")

Dim SelectSQLInc As String = ("Select Incidents From View_AttCombined Where (GPID like '" & EE & "') and (aDay like '" & vbDay & "') and (aMonth like '" & vbMonth & "')and (aYear like '" & vbYear & "')")

Dim MySDA As New SqlDataAdapter

Dim DBconn As New SqlConnection(connstring)

Dim myCom As New SqlClient.SqlCommand(SelectSQLInc, DBconn)

Dim MyDS As New DataSet

DBconn.Open()

MySDA.SelectCommand = myCom

MySDA.Fill(MyDS)

DBconn.Close()

Try

CalEntry = MyDS.Tables(0).Rows(0).Item(("Incidents").ToString)

Catch ex As Exception

CalEntry = "" 'Return nothing if no matching record is found.

End Try

Return CalEntry

End Function

What would I change to loop through each cell one at the time and set the value to the value returned from GetEntry?

Thanks for the help. Let me know if I have totally confused you and need to clarify myself.

GridView

answered on 02 Aug 2011

1 answer

193 views

CODE: Power of ViewCellFormatting

I thought I would contribute this proof of concept code I had to work out. A single cell in a grid needed to update data via a call to a remote system. However, if the grid had thousands of records, I did not want it to make thousands of remote calls on load. So, I looked at the ViewCellFormatting event which allows me to retrieve the data only when the cell is visible.

I also "cached" the data in the cell by setting its flag to "UPDATED". The "Refresh Data" function actually loops through all rows, clears the cells' tags, and sets the value to zero. When the visible cell's value is changed, the ViewCellFormatting event is fired and the remote call is made again.

In this proof of concept code, I am simply just updating the row to the current time's Second. The first button refreshes the data and makes the other non-visible cell's stale by removing the tag.

The second button will show the "i" count to prove the "remote" call is called only on the visible cells.

I tip my hat to Telerik for this pretty powerful and useful functionality!

Imports Telerik.WinControls.UI

Public Class Form1

Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click

i = 0

For Each oRow As GridViewDataRowInfo In RadGridView1.Rows()

oRow.Cells(0).Tag = ""

oRow.Cells(0).Value = 0

Next

End Sub

Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load

CreateFormControls()

Dim list As New ArrayList()

Dim i As Integer = 0

While i < 55

list.Add(New ValueType(Of Integer)((i + 1)))

' System.Math.Max(System.Threading.Interlocked.Increment(i), i - 1)

i += 1

End While

Me.RadGridView1.DataSource = list

End Sub

Private Sub CreateFormControls()

Me.RadGridView1 = New Telerik.WinControls.UI.RadGridView()

Me.Button1 = New System.Windows.Forms.Button()

Me.Button2 = New System.Windows.Forms.Button()

'

'RadGridView1

'

Me.RadGridView1.Location = New System.Drawing.Point(13, 13)

Me.RadGridView1.Name = "RadGridView1"

Me.RadGridView1.Size = New System.Drawing.Size(267, 194)

Me.RadGridView1.TabIndex = 0

Me.RadGridView1.Text = "RadGridView1"

'

'Button1

'

Me.Button1.Location = New System.Drawing.Point(13, 213)

Me.Button1.Name = "Button1"

Me.Button1.Size = New System.Drawing.Size(252, 23)

Me.Button1.TabIndex = 1

Me.Button1.Text = "Refresh Viewable Cells...Make other cell stale"

Me.Button1.UseVisualStyleBackColor = True

'

'Button2

'

Me.Button2.Location = New System.Drawing.Point(12, 242)

Me.Button2.Name = "Button2"

Me.Button2.Size = New System.Drawing.Size(136, 23)

Me.Button2.TabIndex = 1

Me.Button2.Text = "Total Data Updates"

Me.Button2.UseVisualStyleBackColor = True

'

'Form1

'

Me.Controls.Add(Me.Button2)

Me.Controls.Add(Me.Button1)

Me.Controls.Add(Me.RadGridView1)

End Sub

Public Class ValueType(Of T)

Private item As T

Public Sub New()

End Sub

Public Sub New(ByVal item As T)

Me.item = item

End Sub

Public Property ItemProperty() As T

Get

Return Me.item

End Get

Set(ByVal value As T)

Me.item = value

End Set

End Property

End Class

Private Sub RadGridView1_ViewCellFormatting(sender As Object, e As Telerik.WinControls.UI.CellFormattingEventArgs) Handles RadGridView1.ViewCellFormatting

If e.ColumnIndex = 0 Then

If e.Row.Cells(0).Tag <> "UPDATED" Then

e.CellElement.Value = Now.Second

e.Row.Cells(0).Tag = "UPDATED"

i += 1

End If

End Sub

Dim i As Integer

Private Sub Button2_Click(sender As Object, e As System.EventArgs) Handles Button2.Click

MsgBox("Date Update Called " & i & " times")

End Sub

End Class

GridView

answered on 02 Aug 2011

1 answer

236 views

RadGridView hierarchical view filters

Hi,
I'm using a grid which is using a hierarchical view. I'm trying to apply a filter to one of the columns on the parent grid, which contains a simple Y/N character.

I've constructed the filter in the same way as I would on a simple grid view (on which it does what I ask of it) This is the code:

rgvResults.MasterTemplate.EnableFiltering = True

Dim filter As New FilterDescriptor()

filter.PropertyName = "attrib_exists"

filter.[Operator] = FilterOperator.IsEqualTo

filter.Value = "Y"

filter.IsFilterEditor = True

rgvResults.MasterTemplate.FilterDescriptors.Add(filter)

rgvResults.MasterTemplate.Columns("attrib_exists").FilterDescriptor = filter

rgvResults.MasterTemplate.Refresh()

The filter on the parent column appears on the grid and is populated once I apply the filter. However the data doesn't change. Infact, manually adjusting any of the column filters has no influence over the data at all.

Could someone please help me with where i'm going wrong? Like I said, on a simple grid, it works perfectly, I just cant get the parent/child grid to work correctly. I've spent the afternoon trying various things from example code but still no luck!

nb. the grid is bound to a datatable datasource.

Thanks in advance

Chris

Update: I fixed this by removing the grid from the form and adding a new one?! bizarre.

GridView

answered on 02 Aug 2011

11 answers

194 views

A completed radrtb configured control

Hi,

I like the demo of the rtb. The features in the demo would be absolutely fine for my purposes. The new rtb control seems to be a tiny part of the demo. I'd like to have the rtb with all formatting capabilities etc. as part of one drag and drop control with all the stripe commands (maybe configurable )etc.. Have I possibly overseen a fast way of configuring the rtb? Or how could it be made as one single drag and drop tool?

I see that you have a wizard for quicksilver. Am I missing one?

Thank you,
Karl

RichTextBox (obsolete as of Q3 2014 SP1)

answered on 02 Aug 2011

1 answer

204 views

Organizational chart

Hi,

In our HR system there are lot of situations, where we have to handle the structure of a company. The treeview is a possible solution, but that is not so impressive, like a real organizational chart.

On the web I have found these components, a similar control set would be nice to use in the Winforms environment.

Best regards,

Peter

New Product Suggestions

answered on 02 Aug 2011

1 answer

129 views

Multiseries /series type - chart help

I would like to show a stacked bar chart that is comprised of two series. This part I have set up and working just fine using databinding.
There is always 24 points, one for each hour for both series. I have set up the xaxis with shorttime and formatted the labels. My datalayer is doing the oa date conversions and passing date values as double to the source datatable. I'm handing the on_databind event to set up appropriate properties for the series including the col specifications and series type properies.

Now that my range stacked bars are setup and working fine I am trying to add an additonal series to the chart that is not made up of a full 24 points. In fact there may be 0 points or many points in the entire series landing on dates between the xaxis markers (which are formatted for each hour). The reason for this is the third series is intended to represent events which for all intents and purposes are random. I intended to use the same databinding event handler to capture and change the type to type point of this third series to point and simply append my data for this series to the existing datatable. I would intended to pass the variable x dates of the third series with a static y value representing a value just above the max of my existing series1/2 stacked ranges.

and i was wondering if you could help me with a vb.net sample?

the series data looks something like this (assume in my data that I've done the oa_Date conversion). Further assume that for both series 1 and 2 there are full 24 points, one for each hour.

Whether I try to represent the dataset below using binding or manually creating series I can not get the position of the 3rd series set properly on the xaxis.

series_1,5/5/2011 2:00,8
series_1,5/5/2011 3:00,9
series_1,5/5/2011 4:00,32
series_1,5/5/2011 5:00,3
series_2,5/5/2011 2:00,21
series_2,5/5/2011 3:00,23
series_2,5/5/2011 4:00,3
series_2,5/5/2011 5:00,12
series_3,5/5/2011 2:23,30
series_3,5/5/2011 4:46,30

Chart (obsolete as of Q1 2013)

answered on 02 Aug 2011