Telerik Forums
UI for WinForms Forum
1 answer
267 views
Hi,
Thanks for the great work.
Am very new to telerik Rad Charts.
I would like to Create 2 Bar Charts on 1 windows Form using VB.net with Data coming from a Database.

I am looking at creating SQL Statements for each of these 2 Charts with the X and Y axis for the Charts in mind.
i.e Select Products, Prices from ProductSale

Kindly provide a sample example that can enable me pick data from the Database and Bind this Data to the Bar Charts.
I have tried but havent been able to get a newby example of this kind from the forum yet

Thank U.





 
Ivan Petrov
Telerik team
 answered on 11 Dec 2012
2 answers
170 views
Hello

I created a new form, added a RadGridView to it, and populated it using a query containing a UNION statement.

pGrid.BeginUpdate();
// QueryDB below returns a Datatable with the resultset or the SELECT
DataTable rs = clsDBConn.QueryDB("SELECT a,b,c FROM T1 UNION SELECT a,b,c FROM T2");
pGrid.DataSource = null;
pGrid.DataSource = rs;
pGrid.MasterTemplate.AutoGenerateColumns = true;
pGrid.MasterTemplate.AllowAutoSizeColumns = true;
pGrid.MasterTemplate.AllowAddNewRow = false;
pGrid.MasterTemplate.AllowDeleteRow = false;
pGrid.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;
pGrid.MasterTemplate.SelectionMode = GridViewSelectionMode.FullRowSelect;
pGrid.TableElement.ShowTranslucentSelectionRectangle = true;
pGrid.ShowRowHeaderColumn = false;
pGrid.EndUpdate();
 
foreach (GridViewDataColumn column in pGrid.Columns)
{
    column.ReadOnly = false;
}


Even with the ReadOnly=false, when I changed a cell's value and clicked elsewhere, a "Data Exception" message saying "Column 'a' is read only." poped up. I put my UNION statement in a view, called the view, and everything worked as expected.
Philippe
Top achievements
Rank 2
 answered on 10 Dec 2012
0 answers
135 views
Hi,

We are using Telerik winform version 2009.3.9.1203. In that, we have used Gridview with the Grouping. And, we need to give the ability to add a new row at any row position. But, when we code that, the grouping is not reflecting properly. Because of which the newly added row is always go to the top.

Attached is the sample screenshot for your reference.

Please let me know, the solution for this.
Nallan Krishnan
Top achievements
Rank 1
 asked on 10 Dec 2012
5 answers
346 views
Hi,

I am using a PrintPreviewDialog, when I click on the Settings Button, I get the Excption below.
To open the Dialog I am only calling the PrintPreview() Method of an RadGridView. Thie error occurs in Telerik RadControls Q2 and Q3 2012 for Winforms. How can I avoid this error?

Kind Regards,
Li

Here is the ErrorMessage:

The value '0' is not a valid value for the enum 'PaperSourceKind'.

   at System.ComponentModel.EnumConverter.ConvertTo(ITypeDescriptorContext context, CultureInfo culture, Object value, Type destinationType)
   at System.ComponentModel.TypeConverter.ConvertToString(Object value)
   at System.Drawing.Printing.PaperSource.ToString()
   at Telerik.WinControls.UI.ListDataLayer.GetUnformattedValue(RadListDataItem item)
   at Telerik.WinControls.UI.RadListDataItem.SetDataBoundItem(Boolean dataBinding, Object value)
   at Telerik.WinControls.UI.ListControlListSource.InitializeBoundRow(RadListDataItem item, Object dataBoundItem)
   at Telerik.WinControls.Data.RadListSource`1.InitializeBoundRows()
   at Telerik.WinControls.Data.RadListSource`1.Initialize()
   at Telerik.WinControls.Data.RadListSource`1.Bind(Object dataSource, String dataMember)
   at Telerik.WinControls.Data.RadListSource`1.set_DataSource(Object value)
   at Telerik.WinControls.UI.ListDataLayer.set_DataSource(Object value)
   at Telerik.WinControls.UI.RadListElement.set_DataSource(Object value)
   at Telerik.WinControls.UI.RadDropDownListElement.set_DataSource(Object value)
   at Telerik.WinControls.UI.RadDropDownList.set_DataSource(Object value)
   at Telerik.WinControls.UI.PrintSettingsDialog.LoadSettings()
   at Telerik.WinControls.UI.GridViewPrintSettingsDialog.LoadSettings()
   at Telerik.WinControls.UI.PrintSettingsDialog.set_PrintDocument(RadPrintDocument value)
   at Telerik.WinControls.UI.PrintSettingsDialog..ctor(RadPrintDocument document)
   at Telerik.WinControls.UI.GridViewPrintSettingsDialog..ctor(RadPrintDocument document)
   at Telerik.WinControls.UI.RadGridView.Telerik.WinControls.UI.IPrintable.GetSettingsDialog(RadPrintDocument document)
   at Telerik.WinControls.UI.RadPrintPreviewDialog.OnShowPrintSettingsDialog()
   at Telerik.WinControls.UI.RadPrintPreviewDialog.buttonSettings_Click(Object sender, EventArgs e)
   at Telerik.WinControls.RadElement.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadItem.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadElement.OnCLREventsRise(RoutedEventArgs args)
   at Telerik.WinControls.RadElement.OnBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadItem.OnBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadItem.RaiseBubbleEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.RaiseRoutedEvent(RadElement sender, RoutedEventArgs args)
   at Telerik.WinControls.RadElement.DoMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadElement.CallDoMouseDown(MouseEventArgs e)
   at Telerik.WinControls.ComponentInputBehavior.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.RadControl.OnMouseDown(MouseEventArgs e)
   at Telerik.WinControls.UI.RadCommandBar.OnMouseDown(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at Telerik.WinControls.RadControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Li
Top achievements
Rank 1
 answered on 10 Dec 2012
2 answers
253 views

Is there any way to set in command bar any control acceptable by command bar, like drop down list, anchored to the right side of the bar?

The command bar in the picture attached is stretched on the whole width of its parent control and is resizing with its parent control together.

Ofer
Top achievements
Rank 1
 answered on 09 Dec 2012
5 answers
1.5K+ views
Hi,

FindItem(string StartsWith) method of RadComboBox to return a RadComboBoxItem with text starting with a given string.

RadComboBoxItem item = radComboBox1.FindItem(strString);

What is the equivalent method in RadDropDownList to find item starting with a given string.

Any help is appreciated.

Thanks
Peter
Telerik team
 answered on 07 Dec 2012
1 answer
76 views
(*I thought I posted this yesterday, but can't find it*)

I created a usercontrol that has a panel. I made the panel with rounded corners, just like the documentation. However. You can still see the square behind the rounded corners. I tried making them transparent, but no luck. See attached img. Suggestions on getting rid of the square in the back?


Thanks!
Plamen
Telerik team
 answered on 07 Dec 2012
6 answers
148 views
Hi, 
  I am evaluating gridview for winforms. I tried but couldnt get it workings ...here is that couple of things i would like to do (very keyboard intensive data entry) all operations performed using keyboard,no mouse at all
  1. Validate a cell after data entry and if validation fails keep the focus in the same cell . escape should remove that row
   2. after entering data for the last cell,add a new row and keep focus on the first cell in the newly added row and repeat this.

Any help is greatly appreciated.
Thanks

s
Top achievements
Rank 1
 answered on 07 Dec 2012
9 answers
505 views
Hi, i want to add a legend to RadChartView. How?

Thanks
Stefan
Telerik team
 answered on 07 Dec 2012
3 answers
164 views
Dear Sir,
 please tell me if i install .dll references
 to this path C:\Windows folder then how my distributed Application .exe file use or read its resource means i am not include  telerik .dll
(example -- Telerik.WinControls.Themes.Office2010BlackTheme.dll ) file resource to my project bin folder ..i am doing WinForm Project on using C#. please give me a suggestion and sorry for my bad english.
and many many thanks for you and your all team members for giving us that type of beautiful WinForm controls.

Stefan
Telerik team
 answered on 07 Dec 2012
Narrow your results
Selected tags
Tags
GridView
General Discussions
Scheduler and Reminder
Treeview
Dock
RibbonBar
Themes and Visual Style Builder
ChartView
Calendar, DateTimePicker, TimePicker and Clock
DropDownList
Buttons, RadioButton, CheckBox, etc
ListView
ComboBox and ListBox (obsolete as of Q2 2010)
Form
Chart (obsolete as of Q1 2013)
PageView
MultiColumn ComboBox
TextBox
RichTextEditor
PropertyGrid
Menu
RichTextBox (obsolete as of Q3 2014 SP1)
Panelbar (obsolete as of Q2 2010)
PivotGrid and PivotFieldList
Tabstrip (obsolete as of Q2 2010)
MaskedEditBox
CommandBar
PdfViewer and PdfViewerNavigator
ListControl
Carousel
GanttView
Diagram, DiagramRibbonBar, DiagramToolBox
Panorama
New Product Suggestions
VirtualGrid
Toolstrip (obsolete as of Q3 2010)
AutoCompleteBox
Label
Spreadsheet
ContextMenu
Panel
Visual Studio Extensions
TitleBar
SplitContainer
Documentation
Map
DesktopAlert
CheckedDropDownList
ProgressBar
MessageBox
TrackBar
Rotator
SpinEditor
CheckedListBox
StatusStrip
CollapsiblePanel
LayoutControl
ShapedForm
SyntaxEditor
Wizard
TextBoxControl
Conversational UI, Chat
DateTimePicker
TabbedForm
CAB Enabling Kit
WaitingBar
GroupBox
DataEntry
ScrollablePanel
ScrollBar
ImageEditor
Tools - VSB, Control Spy, Shape Editor
BrowseEditor
DataFilter
FileDialogs
ColorDialog
Gauges (RadialGauge, LinearGauge, BulletGraph)
ApplicationMenu
RangeSelector
CardView
WebCam
NavigationView
BindingNavigator
RibbonForm
Styling
Barcode
PopupEditor
TaskBoard
Callout
ColorBox
PictureBox
FilterView
Accessibility
VirtualKeyboard
DataLayout
Licensing
ToastNotificationManager
ValidationProvider
CalculatorDropDown
Localization
TimePicker
BreadCrumb
ButtonTextBox
FontDropDownList
BarcodeView
Overlay
Security
LocalizationProvider
Dictionary
TreeMap
StepProgressBar
SplashScreen
Flyout
Separator
SparkLine
ToolbarForm
NotifyIcon
DateOnlyPicker
AI Coding Assistant
Rating
TimeSpanPicker
Calculator
OfficeNavigationBar
TaskbarButton
HeatMap
SlideView
PipsPager
AIPrompt
TaskDialog
TimeOnlyPicker
SpeechToTextButton
+? more
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Top users last month
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?