Hello Telerik Team! I'm working on WPF Project using Telerik Controls. My goal is to build an application for a Medic Clinic, and this app must run on a pendrive, so we are using MS Access as Database. I'm having problems to bind ScheduleView to Access Database.



Before I sent  this post, have you sure I had tried different ways to solve this problem. So, direct to the point, when I try to Insert or Update an Appointment (CustomAppointment), I always receive an syntax error in INSERT INTO or UPDATE statement. The error is raised because DateTime format of Start/End properties from ScheduleView. I'm using a OleDBCommand with Parameters, as you see below.



I already tried pass date/time values surrounded with single quotes, double quotes, sharp (#), and DateTime as you can se in this code. Also I tried OleDbType.DBDate. OleDbType.Date and OleDbType.DBTimeStamp. But always got the same Syntax Error in INSERT INTO.



Could you please help me?

protected override void OnAppointmentCreated(IAppointment appointment)

{

CustomAppointment addedAppointment = appointment as CustomAppointment;

if (addedAppointment != null)

{

OleDbConnection cnInsertAppointment = new OleDbConnection(Properties.Resources.cnDBPhito);

cnInsertAppointment.Open();

OleDbCommand cmdInsertAppointment = new OleDbCommand();

cmdInsertAppointment.Connection = cnInsertAppointment;

cmdInsertAppointment.CommandType = CommandType.Text;

cmdInsertAppointment.CommandText = "insert into Appointments(AppointmentID, Subject, Body, Start, End, IsAllDayEvent, Location, Url, TimeMarker, Importance, Category, RecurrencePattern, IsReturn, MedicalOrder, HealthClubID, PatientID) values(@AppointmentID, @Subject, @Body, @Start, @End, @IsAllDayEvent, @Location, @Url, @TimeMarker, @Importance, @Category, @RecurrencePattern, @IsReturn, @MedicalOrder, @HealthClubID, @PatientID)";

cmdInsertAppointment.Parameters.Add("@AppointmentID", OleDbType.VarChar, 36).Value = addedAppointment.UniqueId;

cmdInsertAppointment.Parameters.Add("@Subject", OleDbType.VarChar, 100).Value = addedAppointment.Subject;

cmdInsertAppointment.Parameters.Add("@Body", OleDbType.VarChar, 400).Value = addedAppointment.Body;

DateTime dtStart = new DateTime(addedAppointment.Start.Year, addedAppointment.Start.Month, addedAppointment.Start.Day, addedAppointment.Start.Hour, addedAppointment.Start.Minute, addedAppointment.Start.Second);

cmdInsertAppointment.Parameters.Add("@Start", OleDbType.DBTimeStamp).Value = dtStart;

DateTime dtEnd = new DateTime(addedAppointment.End.Year, addedAppointment.End.Month, addedAppointment.End.Day, addedAppointment.End.Hour, addedAppointment.End.Minute, addedAppointment.End.Second);

cmdInsertAppointment.Parameters.Add("@End", OleDbType.DBTimeStamp).Value = dtEnd;

cmdInsertAppointment.Parameters.Add("@IsAllDayEvent", OleDbType.Boolean).Value = addedAppointment.IsAllDayEvent;

cmdInsertAppointment.Parameters.Add("@Location", OleDbType.VarChar, 200).Value = addedAppointment.Location;

cmdInsertAppointment.Parameters.Add("@Url", OleDbType.VarChar, 200).Value = addedAppointment.Url;

cmdInsertAppointment.Parameters.Add("@TimerMarker", OleDbType.VarChar, 50).Value = addedAppointment.TimeMarker == null ? String.Empty : addedAppointment.TimeMarker.TimeMarkerName;

cmdInsertAppointment.Parameters.Add("@Importance", OleDbType.VarChar, 50).Value = addedAppointment.Importance == null ? String.Empty : addedAppointment.Importance.ToString();

cmdInsertAppointment.Parameters.Add("@Category", OleDbType.VarChar, 50).Value = addedAppointment.Category == null ? String.Empty : addedAppointment.Category.CategoryName;

if (addedAppointment.RecurrenceRule != null)

{

cmdInsertAppointment.Parameters.Add("@RecurrencePattern", OleDbType.VarChar, 100).Value = RecurrencePatternHelper.RecurrencePatternToString(appointment.RecurrenceRule.Pattern);

}

cmdInsertAppointment.Parameters.Add("@IsReturn", OleDbType.Boolean).Value = addedAppointment.IsReturn;

cmdInsertAppointment.Parameters.Add("@MedicalOrder", OleDbType.Boolean).Value = addedAppointment.MedicalOrder;

cmdInsertAppointment.Parameters.Add("@HealthClubID", OleDbType.Integer).Value = addedAppointment.HealthClubID;

cmdInsertAppointment.Parameters.Add("@PatientID", OleDbType.Integer).Value = addedAppointment.PatientID;

try

{

cmdInsertAppointment.ExecuteNonQuery();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message.ToString());

}

cmdInsertAppointment.Dispose();

cnInsertAppointment.Close();

cnInsertAppointment.Dispose();

}

}

I'm using VS2010 + SP1, WPF Application, Target .NET Framework 3.5, Access 2007 Database (mdb) and Telerik WPF Controls Q1 2012.

I am quite new to all of this, so it maybe no surprise that I would be a little lost...
Here is where I am at: I would like to get the CustomerID (from a viewModel) when a row is selected, to pass it to anotherViewModel to filter orders matching the currently selected Customer.
in XAML I have:
In the viewModel, I have a delegate command.
I have been following the example in the documentation about RadEventsToCommandExamples, and when I look in the debugger, I can see that my Object is of type Telerik.Windows.Controls.SelectionChangeEventsArgs, but if I try to cast the Object to this, I get an error, as it find Windows.Controls.SelectionChangedEventsArgs (note the difference between change and changed).
I did try to cast it from RadRoutedEventArgs, but I am not too sure how to do.

How should I do? Looks like a bug to me, but I would really like to know about a work around. Thanks in advance!
Bernard

for the last 2 hours I've been trying to figure this one out. i have a column displaying an enum value. the enum value is displayed using a custom template and works fine. every enum value has its corresponding icon. now i was asked to provide a way to edit all the selected rows at once. the data behind are observableobjects (INotifyPropertyChanged). My code is simple, after setting a value in a dialog and accepting, I modify all the selected elements property to the new value. this works fine for string and double by the way. it also mostly works for my enum, but sometimes (mainly when i repeat this process quickly) i get a crash with the (consistent) error listed below.

I removed my template and the code worked. if i only display text in my template and no icon, it also seems fine. the main reason, why i think this must be telerik related, or at least a combination effect: I dont get an exception in my own code and can not debug a thing. if i edit the cells directly i also have no problems. it only seems to occur by modifying multiple data-objects at once.

I've also tried the following: prevent my objects notifying that the enum value has changed -> no exception. then calling rebind on the grid -> same exception.

Telerik.Windows.Data, Version=2012.1.215.40
System.ArgumenNullException: {"Der Wert darf nicht NULL sein.\r\nParametername: element"} //german: element is null

bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei Telerik.Windows.Controls.ChildrenOfTypeExtensions.<GetChildrenRecursive>d__3.MoveNext()
   bei System.Linq.Enumerable.<OfTypeIterator>d__aa`1.MoveNext()
   bei System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   bei Telerik.Windows.Controls.GridView.GridViewCell.<GetDataErrors>d__7.MoveNext()
   bei Telerik.Windows.Data.EnumerableExtensions.Count(IEnumerable source)
   bei Telerik.Windows.Controls.GridView.GridViewCell.UpdateIsValidState()
   bei Telerik.Windows.Controls.GridView.GridViewCell.UpdateValue()
   bei Telerik.Windows.Controls.GridView.GridViewCell.SetCellElement()
   bei Telerik.Windows.Controls.GridView.GridViewRow.PrepareCell(GridViewCellBase cellBase, GridViewColumn column)
   bei Telerik.Windows.Controls.GridView.GridViewCellsPanel.PrepareCell(GridViewCellBase cell, GridViewColumn column)
   bei Telerik.Windows.Controls.GridView.GridViewCellsPanel.GetVirtualizedCell(GridViewColumn column, Boolean createIfNull)
   bei Telerik.Windows.Controls.GridView.GridViewCellsPanel.RealizeAndMeasureCells(Int32 startIndex, Int32 predictedLastIndex, Func`2 calculateNextIndex)
   bei Telerik.Windows.Controls.GridView.GridViewCellsPanel.UpdateVirtualizedCells()
   bei Telerik.Windows.Controls.GridView.GridViewCellsPanel.MeasureOverride(Size availableSize)
   bei System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   bei System.Windows.UIElement.Measure(Size availableSize)
   bei System.Windows.ContextLayoutManager.UpdateLayout()

Hello Telerik,
    first; my apologises. I have searched the GridView forum for answers to the following question and came up with nothing useful.
    The same goes for Google.

Problem:
    I have a ObservableCollection containing a 'ColumnVisibility' class - which is bound to a ComboBox control.
    But I am unable to specify a particular indexed element to the RadGridView's columns (bound to IsVisible property, see below).

    
As you can see, the DataMemberBinding references a different collection and I have previously used the RadGridView's itemsource property to attach this collection to the Grid - neither gave me the desired effect (which is to hide certain columns based upon the user's ComboBox selections).

Can you give me any pointers?

I get an index out of range error when i search for a property that does not exist within my property list.

Is there something I can do to have it just show a blank property grid?

Thanks

Stefan

Hello,
I have a problem with a wpf application : theorically wpf is indipendent from the dpi of the screen, but in my wpf application if I set the screen size to 125% or 150% the visual elements of the applications are bigger.
My goal is to have always the same size of the application, because is a visual benchmark application, so it is important for me the visual aspect of the is fixed with every dpi/% of the screen.
Is there a way to fix the size of the application and make it indipendent from the screen settings?

Hello,

I am using the Richtextbox to create a text that the user can then copy to outlook or word. In this text I also have a table. But when it is coppied every cell starts on a new line. Do I need to set something so the table is Copied as a real table?

I used to use the windows Richtextbox with FlowDocument and there this worked only line ends were skipped.

I'm experiencing a strange behavior: The RadBusyIndicators's content (the yellow circle and the text "Loading...") appears far too late, but the BusyIndicator becomes grey at the right moment. The content (progress bar) appears not until the time-consuming action is over.

Here is what I'm doing in Pseudocode:

MyDialog dialog = new Dialog();             // A Window that contains the BusyIndicator
dialog.myRadBusyIndicator.IsBusy = true;    // Startup with the BusyIndicator activated
dialog.Dispatcher.BeginInvoke(new System.Action(MyLoginAction));   // Start some time-consuming action in the Background
dialog.ShowDialog();                        // Show the user a Dialog with busy information

Problem: The yellow circle in the BusyIndicator shows up AFTER the time-consuming action is over, but Busy-State (graying) is activated correctly when the Dialog pops up.

Some intricate threading problem?

Hi,

I'm looking for a way to call the save command from code behind. I tried different kinds of maner but with no success.

Thanks