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.

 

 
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.

 

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!

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:



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.

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

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

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
 
 

I am creating windows application with C# that requires to work with 2-3 users.The admin user should get
all the rights to access all forms and can do activity such as retreive data,insert, update and delete.wherein other
users should not get all the access.how do I disable controls that r updating data in database for other users.
can anyone brief me on this?
thanks in advance

hi, i have looked at the other posts regarding validation and your validation video. i do understand the row_validation and cell_validation events. However, in order to validate the entries AND mark the errors, i have to use the validation code twice which i dont want to do.  

My test code is shown below. Have also attached a screenshot.

Here's what i am trying to do:

in the grid2_RowValidating event i am validating and preventing user to go to next row. i would like to "mark/color" the cell with the error. I tried all the Style properties but only the forecolor works. (i have commented the lines not working)

So, in addition to RowValidating event, i decided to use the grid2_ViewCellFormatting event to validate and color the cell with the error.
This is working but i dont understand why i have to validate twice. (once in the RowValidating event to prevent them to go to the next row and again in the ViewCellFormatting event to "color" the cell) 

Am i doing something wrong? Why am i not able to set the Style Properties directly from within the RowValidating. I am using the Q2 2011 version (latest) 

 

I'm currently using a multiselect enabled dropdownlist.  How do I retreive the list of 'selected' items in the multiselect dropdownlist?

Thanks.

I'm new to Telerik controls so I'm hopeful there maybe a solution to my problem but searching the documentation and forums I have yet to see it.

Problem
A typical usability problem with menus I frequently see is a menu or sub-menu (grouping of menu items beneath another menu) that instantly disappears if the user mouses over the wrong pixel while trying to mouse over to the menu item.  This can be frustrating causing the user to have to retrace their steps to once again reveal the menu and this time carefully tip-toe the mouse back through the narrow parameters allowed them so as not to trip the code just waiting to remove their destination.

Solution
This is a fairly simple problem technically which requires the library author to allow from some time delay before hiding the menu.  The logic would go something like (pseudo code):

OnMouseOverNonMenu
Start Timer

OnMouseOverMenu
     Stop Timer

OnTimerElapsed
      Hide menu
 

Summary
So far, I have not seen this solution being build into the Telerik menu though it seems like a perfect place for this solution.  Did I miss it? Is there a way to do this without me rolling my own menu control?

thanks,
Eric