Questions on UI for WinForms Forum

3 answers

137 views

Performance question - gridview bound to Oracle DB

Hello,

I would like to bind the gridview control, on a VB.Net form, to an Oracle 11g database that has millions of records.
Can anybody tell what would be the performance in this case? Does grid a have 'pagination' or a buffering feature that would allow a fast load/scrolling?
I have a Windows utility called Oracle SQL Developer (from ORACLE Corp.) that does a similar job, i.e. can be used to browse a table that has millions of records and it works super fast.
Does Telerik grid have a similar performance? I didn't install it yet because I would research for a different product in case the performance is slow.

Regards,
M. R. - Toronto

GridView

answered on 08 Mar 2010

1 answer

210 views

TreeViewList

Hi,

in the Silverlight demos I have seen a TreeViewList demo.
That would be great for WinForms.

Best regards
Andreas

New Product Suggestions

answered on 08 Mar 2010

1 answer

135 views

hierarchical grid double click?

I have successfully created the hierarchical grid and the sub-grid. I am now needing to allow the user to double click on the sub grid that is shown. How would I go about doing this?

I am creating the subgrid like this:

    
            GridViewTemplate oppSubGrid = new GridViewTemplate(); 
        
            // .. other code goes here to setup columns, etc. 
        
            gridDupes.MasterGridViewTemplate.ChildGridViewTemplates.Add(oppSubGrid); 
        
            GridViewRelation relation = new GridViewRelation(gridDupes.MasterGridViewTemplate); 
        
            relation.ChildTemplate = oppSubGrid; 
        
            relation.RelationName = "ContactsOpportunities"; 
        
            relation.ParentColumnNames.Add("ID"); 
        
            relation.ChildColumnNames.Add("ContactID"); 
        
            gridDupes.Relations.Add(relation);

Now I just need to know how to call a function with a double click. Any ideas?

Thanks!

GridView

answered on 08 Mar 2010

5 answers

125 views

adding a context menu to radpanelbargroupelement

I need dynamically add a context menu to radpanelbargroupelement.

the radpanelbargroupelement are created dynamically and I need to have it when you right click the groupelement the menu display and excepts only on the right click for that groupelement. here is what I have but it is not fireing the event when right clicked.

    
             private void PopulatePanelBar()  
        
                    {  
        
                        RadPanelBarGroupElement ItemsGroupElement;  
        
                        foreach (BEItems.ItemRow gcr in ItemsDataSet.Item.Rows)  
        
                        {  
        
                            ItemsGroupElement = new RadPanelBarGroupElement();  
        
                            ItemsRadPanelBar.Items.Add(ItemsGroupElement);  
        
                            ItemsGroupElement.Caption = gcr.Item_nm;  
        
                            ItemsGroupElement.Tag = gcr.Item_id;  
        
                            ItemsGroupElement.MouseDown += new MouseEventHandler(ItemsGroupElement_MouseDown);  
        
                        }  
        
                        foreach (RadPanelBarGroupElement element in this.ItemsRadPanelBar.Items)  
        
                        {  
        
                            RadPanelBarVisualElement visualElement = element.GetCaptionElement();  
        
                            element.EnableHostControlMode = true;  
        
                            visualElement.AutoToolTip = true;  
        
                            ItemUserControl ItemUserControl = new ItemUserControl();  
        
                            element.ContentPanel.Controls.Add(ItemUserControl);  
        
                            ItemUserControl.ItemHeaderRow = (BEItems.Item_headerRow[])ItemsDataSet.Item_header.Select("Item_id = " + (int)element.Tag);  
        
                            ItemUserControl.ItemValueRow = (BEItems.Item_valueRow[])ItemsDataSet.Item_value.Select("Item_id = " + (int)element.Tag);  
        
                        }  
        
                    }  
        
                    void ItemsGroupElement_MouseDown(object sender, MouseEventArgs e)  
        
                    {  
        
                        if (e.Button == MouseButtons.Right)  
        
                        {  
        
                            ContextMenu myMenu = new ContextMenu();  
        
                            if (sender != null)  
        
                            {  
        
                                RadPanelBarGroupElement element = (RadPanelBarGroupElement)sender;  
        
                                element.ContentPanel.ContextMenu = myMenu;  
        
                                MenuItem AddItemRadMenuItem = new MenuItem();  
        
                                MenuItem UpdateItemRadMenuItem = new MenuItem();  
        
                                MenuItem InactivateItemRadMenuItem = new MenuItem();  
        
                                MenuItem ExpandPanelBarRadMenuItem = new MenuItem();  
        
                                MenuItem CollapsePanelBarRadMenuItem = new MenuItem();  
        
                                AddItemRadMenuItem.Click += new EventHandler(AddItemRadMenuItem_Click);  
        
                                UpdateItemRadMenuItem.Click += new EventHandler(UpdateRadMenuItem_Click);  
        
                                InactivateItemRadMenuItem.Click += new EventHandler(InactivateItemRadMenuItem_Click);  
        
                                ExpandPanelBarRadMenuItem.Click += new EventHandler(ExpandPanelBarRadMenuItem_Click);  
        
                                CollapsePanelBarRadMenuItem.Click += new EventHandler(CollapsePanelBarRadMenuItem_Click);  
        
                                myMenu.MenuItems.Add(AddItemRadMenuItem);  
        
                                myMenu.MenuItems.Add(UpdateItemRadMenuItem);  
        
                                myMenu.MenuItems.Add(InactivateItemRadMenuItem);  
        
                                myMenu.MenuItems.Add(ExpandPanelBarRadMenuItem);  
        
                                myMenu.MenuItems.Add(CollapsePanelBarRadMenuItem);  
        
                            }  
        
                        }  
        
                    }

Panelbar (obsolete as of Q2 2010)

answered on 05 Mar 2010

5 answers

178 views

RadListBox doesnt show DescriptionText

i use a radlistbox to display a list of clients. i have set the DataSource, DisplayMember,ValueMember property. during the ItemBound event i set the DescriptionText property for each RadListBoxItem. when the app loads i can only see the DisplayMemebr. the DescriptionText doesn't appear. i have put the RadLisBox inside a RadPanelBar. after i switch to another RadPanelBarGroupElement and come back to the element which shows the client list box, everything is fine. RadPanelBar is set to outlook style.

how can i solve this issue?

ComboBox and ListBox (obsolete as of Q2 2010)

answered on 05 Mar 2010

5 answers

142 views

Licensing Query

Hi
(There are multiple questions , iin this single question. )

I was understanding deployment process. I created a simple winforms application with couple of forms getting datafrom SQL into GridControl. I marked assembly as "Copy Local" and published it. When i Installed it on a Fresh XP machine, it did get installed, but the form containing GRID did not open. Why?

I recalled my experience of Crystal report with VS2003 or VS2005 where report runs fine on developer PC, but when deployed, it stops working and we need to add a key into deployment and setup project and then deploy it on client machines.

In order to understand how deployment will work, I came upon this link http://blogs.telerik.com/vassilterziev/posts/08-01-15/telerik_licensing_demystified.aspx and got more confused.

"Our products do NOT work with license keys and you can safely install them on any machine without worrying about license key errors"

Well this is fine and I understand the freedom behind it. but then how licensing works?
Do I not to enter license key anywhere on PC?

Regards

General Discussions

answered on 05 Mar 2010

2 answers

108 views

Gridview - SQLQuery with Multiple Joins - Performance.

I am here trying to find if GridView has some solution to my problem.

I have a table 'Contacts' with has fields like
PresentAddress|CityID|StateID|CountryID|ZoneID
PermanentAddress|CityID|StateID|CountryID|ZoneID
DepartmentID
DesignationID
DivisionID.

Now all above fields are foreign keys in contacts table. Currently i am retrieving data using Joins and displaying in Gridview.
One of my problem is that CityID|StateID|CountryID|ZoneID tables are used twice in joins with different alias to fill up their associated values for PresentAddress & PermanentAddress fields. so overall 11 to 12 tables in a join. I am sure performance will shout as no of records will increase.

I am thinking if i retrieve from database those Individual master tables (City,State,Country,Zone etc and Contact table) into DataSet (without joins) then CAN GridView help me to retrieve associate data and display. which mean whereever it finds a column CityID, it brings CityName from CityMaster table and display in place of CityID column.

Regards

GridView

answered on 05 Mar 2010

0 answers

85 views

Dynamically chosen amount of multiple series

Ok, i want to be able to make a radchart with multiple Y series on it.

The situation is this.
I want the user to be able to make a comparative bar chart.Each Y series will represent a year.On X axis will be the amount of let's say fishes he caught.

So the user wants to see the data from 2007-2010 or 2001-2002, etc.
That means that if he wants from 2007 to 2010, there should be 12 items (for the months) and each item will have 4 series (2007,2008,2009,2010)

Can you help ?

I use Visual Basic .net 2008

Chart (obsolete as of Q1 2013)

asked on 05 Mar 2010

2 answers

143 views

Disable or Manage ChildGridView Tabs

Hello,
I want to disable or change ChildGridView Tabs. Another words I want to create a Standart Hierarchy RadGridView, not Tabbed.
Could you please show me the way.
Thank you.
Bertan

GridView

answered on 05 Mar 2010

3 answers

123 views

Resize of data area after grouping

Unbound RadGridView with Datatable passed as data source

Columns programatically set (Best fit, Custom headers etc), grid height Auto sizes depending on number of rows passed in Datatable (built-in functionality - not set programatically).

Grid populates and operates exactly as expected, however after "grouping" by a particular column, the "data rows" element of the grid is not redrawn leading to a scroll-bar.

I'm pulling my hair out trying to resize the data area in the "GroupByChanging" event to show all rows (with Group headers) without the need for a scroll bar - your help would be greatly appreciated !!!

Apologies for what is probably a straight forward solution and my thanks in advance,

Tim.

GridView

answered on 04 Mar 2010