Questions on UI for WinForms Forum

13 answers

312 views

Retrieving "appointments" programmatically with SQL

I'm trying to bind the RadScheduler through SQL command programmatically, but I can't display the record found in my database.

Below is the code I came up with. Kindly point out the flaw.

    
                    Dim mySqlCmd As New SqlCommand 
        
                    Dim da As New SqlDataAdapter 
        
                    Dim SchedSource As New SchedulerBindingDataSource() 
        
                    Dim appointmentMappingInfo As New AppointmentMappingInfo() 
        
                    Dim resourceMappingInfo As New ResourceMappingInfo 
        
                    Dim mySqlConn = New SqlConnection("server = compname\SQLEXPRESS;database = dbname;Trusted_Connection = yes") 
        
                    mySqlConn.Open() 
        
                    Try 
        
                        mySqlCmd = mySqlConn.CreateCommand 
        
                        mySqlCmd.CommandText = _ 
        
                        "SELECT tbl_ReservationInfo.ReservationInfoID as 'ID', tbl_ReservationInfo.ReservationStart as 'Start', tbl_ReservationInfo.ReservationEnd as 'End', tbl_ResourceInfo.ResourceName As 'Resource Name', tbl_ResourceInfo.Description as 'Description', tbl_ResourceInfo.Type as 'Type'" 
        
                        mySqlCmd.CommandText += " FROM tbl_ReservationInfo INNER JOIN tbl_Reservations ON tbl_ReservationInfo.ReservationID = tbl_Reservations.ReservationID INNER JOIN tbl_ResourceInfo ON tbl_ReservationInfo.ResourceInfoID = tbl_ResourceInfo.ResourceInfoID INNER JOIN" 
        
                        mySqlCmd.CommandText += " tbl_Resources ON tbl_ResourceInfo.ResourceInfoID = tbl_Resources.ResourceInfoID INNER JOIN" 
        
                        mySqlCmd.CommandText += " tbl_Users ON tbl_ReservationInfo.UserID = tbl_Users.UserID" 
        
                        mySqlCmd.CommandText += " WHERE (tbl_ResourceInfo.Type = 'Venue')" 
        
                        da.SelectCommand = mySqlCmd 
        
                        da.Fill(SchedDataSet, "Schedules") 
        
                        appointmentMappingInfo.Start = "Start" 
        
                        appointmentMappingInfo.End = "End" 
        
                        appointmentMappingInfo.Summary = "Resource Name" 
        
                        appointmentMappingInfo.Location = "Resource Name" 
        
                        appointmentMappingInfo.Description = "Description" 
        
                        appointmentMappingInfo.Visible = "Visible" 
        
                        resourceMappingInfo.Id = "ID" 
        
                        resourceMappingInfo.Name = "Type" 
        
                        SchedulerBindingDataSource1.ResourceProvider.Mapping = appointmentMappingInfo 
        
                        SchedulerBindingDataSource1.ResourceProvider.DataSource = "Schedules" 
        
                        SchedulerBindingDataSource1.ResourceProvider.Mapping = resourceMappingInfo 
        
                        SchedulerBindingDataSource1.ResourceProvider.DataSource = "Schedules" 
        
                        VenueSchedTable.DataSource = SchedulerBindingDataSource1 
        
                    Catch ex As Exception 
        
                        MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly, "Connection Error !!") 
        
                    End Try

I have one record in my database,wherein if that SQL Select Statement is executed will retrieve it, as seen on the image below:
http://img69.imageshack.us/img69/4580/12849791.jpg

Scheduler and Reminder

answered on 02 Mar 2012

2 answers

199 views

get a cell value on a hierearchical gridview

I have a hierarchical grid that contains 2 child gridviews. When a particular value on the 3rd gridview (3rd level of hierarchy) is shown then another cell should change its color. For the first grid is not a problem at all. But when trying to do so for the inner gridviews I fail to get the correct cell value.

I'm trying to follow the sample provided on the link Applying formatting only to cells in a child template but is only works for one level hierarchy verifying that the parent template is not nothing. On my case this is not helpfull has there is a parent and "grandparent" template.

Thanks!

GridView

answered on 01 Mar 2012

7 answers

478 views

[Solved] Inheriting RadButtonElement

Hi,

I have created new class inheriting RadButtonElement and using this class on my Ribbonbar QuickAccessToolBar instead of RadButtonElement. When the mouse pointer comes to over button, background of the image does not change. Whereas, it does when i use RadButtonElement. Is it a bug, or i need to handle some events?

Thanks,

Baris

public class MyRadButtonElement:Telerik.WinControls.UI.RadButtonElement

{

private String _blabla;

public MyRadButtonElement(String blabla)

: base()

{

_blabla = blabla;

}

protected override Type ThemeEffectiveType

{

get

{

return typeof(Telerik.WinControls.UI.RadButtonElement);

}

RibbonBar

answered on 01 Mar 2012

1 answer

563 views

[Solved] Setting the background color of a cell

I found this link which shows some sample code on how to set the background color of a cell. The selectionmode is FulLRowSelect. I have some code in an event handler for CellFormatting that does this:

if (someConditionIsTrue)

{

	e.CellElement.BackColor = Color.Red;

	return;

}



e.CellElement.ResetValue(LightVisualElement.BackColorProperty, Telerik.WinControls.ValueResetFlags.Local);

when certain conditions are met. At first I didn't think it was working, but I noticed when I moved my mouse over a row that should have a cell with a red background, suddenly the background switched to red. As soon as I move my mouse off that row it switches back to it's default color. That's not the behavior I'd like - it should be red regardless of whether the mouse is over that row or not.

What am I missing?

GridView

answered on 01 Mar 2012

18 answers

632 views

RADGRID SCROLL ISSUE

Hi,

I am using radgrid to dynamically load controls(drop down,textbox) @ runtime.If the grid contains too many rows and when i try to scroll the grid all the controls within the grid cell are getting distracted(please refer to the snap shot).

Basically in some textbox fileds drop drown icon is visible.

Please address this issue as soon as possible.

GridView

answered on 01 Mar 2012

1 answer

118 views

How to show the new appointment dialog (advanced) when double-clicking rather than the simple inline new appointment dialog?

Hi.

I want to show the new appointment Dialog (advanced) (see pictures attached) rather than the “inline” 3 option ( Save, Cancel, Options) dialog, when you DoubleClick on the RadSchduler to create a new appointment.

Your help will be appreciated.

Thank you

Scheduler and Reminder

answered on 01 Mar 2012

3 answers

217 views

Multiple Cells Selection

I was searching through the samples, but I cannot find a sample code that will enable the user to perform multi cells selection. The user needs to be able to select multiple cell from the same row or other rows. Each selected cells will have different background and foreground color.

Thank you,
Hendra

GridView

answered on 29 Feb 2012

1 answer

108 views

Where is ManageBookmarksDialog?

Hi,
In the documentation a ManageBookmarksDialog of RadRichTextBox is mentioned. Where can I find this dialog?

Thanks,

Karl

RichTextBox (obsolete as of Q3 2014 SP1)

answered on 29 Feb 2012

1 answer

275 views

Collapsing child rows automatically

Greetings,

How could I get the radgridview to display collapsed child rows set. In other words we have a radgridview with rows and child rows but how could we get the child rows collapsed for all initially until the user decides which one to expand.

Thanks and best regards,

G

GridView

answered on 29 Feb 2012

13 answers

482 views

[Solved] reordering rows with bound data

When I attempt to enable row reordering with a gridview bound to a DataTable rather than manually adding rows like in the demo application, nothing happens.

Is it possible to make reordering or drag/drop work when bound to a DataTable?

GridView

answered on 29 Feb 2012