Forum

How to create a custom cell editor  based on a nullabledatetimepicker with weeknumbers indication

that I can cancel the selection all characters the moment where I enter in the cell for editing?

if i write this code mygrid.FocusedCell.StartEdit(); then automatically are selected all words<qtlend></qtlend>. Τhat i cancel selection?

<qtlbar style="padding: 0pt; display: inline; text-align: left; line-height: 100%; background-color: rgb(236, 236, 236); -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -moz-border-radius-bottomright: 3px; -moz-border-radius-bottomleft: 3px; cursor: pointer; z-index: 999; left: 486px; top: 57px; opacity: 0.9;" dir="ltr" id="qtlbar"><iframe style="border: 1px solid rgb(236, 236, 236); display: none; background-color: white;" src="" id="qtlframe"></iframe></qtlbar>

i can do it programmatically?

Unfortunately you cannot do this at the moment, because there is no public access to the editor. The next version will fix this.

Yes...i can do it?

How i can select cell programmatically or set focused row or cell programmatically?

i can embed some icon in my column header in ribbon grid?

i want only have an icon with text in column header

We prepared and emailed you a sample illustrating what you want to achieve. If you have any questions with this, just let us know.

that I can disable focus cell when I am in the last one in the first column grid,

that I can not change the line when I step arrows when I am in the last one in the first column grid.

i set for my ribbon grid:

    1 - AllowRowSelection = true

    2 - FullRowSelect = false

    3 - ShowFocusRectangle = true

i need when I press the arrow buttons left, right move the focused cell (focused rectangle) in line and is not changed the line until that I would press the arrow buttons up or down. as it is now when focused cell is the first column or last column with press arrow buttons left or right changes automatically the line...

How i can catch event mouse double click when i edit some cell?

Currently you cannot handle events from a cell editor. We will add this opportunity in the next release.

i need open some form after mouse double click in cell when i edit this cell. (like MS outlook -> contacts)

I change backgroud color for some rows like this...

   private void lvwContacts_ModifyCellStyle(object sender, ModifyCellStyleEventArgs e)

        {

            if (e.Cell.Row != null)

            {

                if (e.Cell.Row.Index % 2 == 0)

                {

                        e.Style.BackgroundColor = Color.Red;

                }

                else

                {

                            e.Style.BackgroundColor = Color.White;

                }

            }

        }

How i can disable change backgroud color for current cell when i move mouse in my grid or how i can change default color when i move mouse?

I have table with lines with different colors. when I move the mouse I want it does not change the cell color that you find the mouse. Who event i can use to I make him. MouseMove event already has changed the color background.

how I occupy in who cell it is cursor when i move the mouse

You should use the grid’s method GetRenderableFromPoint(). This method returns an object of the Renderable type which you should check whether it is a cell or not.

I have a last column as calendar in my grid. The VerticalBar it is painted on him and does not appear button I open calendar.what I make in order to it is presented doubly his? The columns property "ColumnsAutoSizeMode" i set "Fill".

BoundGrid.ColumnsAutoSizeMode = ColumnAutoSizeMode.Fill;

Ok. i send you e-mail (support@prof-uis.com)

Hi. I need show and hide some columns when programm run. This is my code...

Mobile and Store is at Columns.

Mobile.Visible = true;

Store.Visible = false;

But my grid repaint very slowly. What can i do for show and hide quickly? 

 

i find what happend...

this is my column

 Mobile.CellStyles.AddRange(new Elegant.Ui.Grid.CellStyle[] { txtCellStyleNotEdit });
 Mobile.DataPropertyName = "Mobile";
 Mobile.HeaderText = " Mobile ";

boundGridControl1.DataSource = myTable;

if  "Mobile" column name it does not exist in myTable then the grid does not function fast when i want show or hide this column. I have resolved the problem.

 

Hi. You can show me one sample how i can set and load one column(cell) in BoundGridControl as combobox element.

Hi. Thanks for sample...I found problem....

if i add columns in InitializeComponent() procedure then combo box cells load data , but if i try add columns some other procedure or function then combo box cells not load data...

DataTable Group = new DataTable();

Group= DataBaseServer.GetTable("tblGroup");

  this.lvwContacts.Columns.AddRange(new Elegant.Ui.Grid.Column[] {  Group});

Thank you. We will look into this problem and fix it in the next version.

DataTable Stores = new DataTable();

the grid control not show me in column ’Store’ all stores if i press button for drop down list. Show me only one store name from ’myCustomersTable’ table...

What can i do ?

We prepared a sample project that illustrates the usage of combo-box cells. Please download it from this website. Here is the correct link.


GridComboBoxCellTest

Hi. i show you my code...

1 - this is my column

Stores = DataBaseServer.GetTable("tblStores", "StoreName", "", "");

            Store.CellStyles.AddRange(new Elegant.Ui.Grid.CellStyle[] { comboboxCellStyle });

            Store.DataPropertyName = "StoreName";

            Store.FillWeight = 100.8155F;

            Store.HeaderText = "Store";

            Store.MappingDataSource = myStores;

            Store.MappingDisplayDataMember = "StoreName";

            Store.MappingValueDataMember = "StoreID";

            Store.CellType = typeof(ComboBoxCell);

2 - this is my grid control

  lvwContacts.Columns.AddRange(new Elegant.Ui.Grid.Column[] {

            Store});

3 - DataTable myCustomersTable = new DataTable()

 myCustomersTable = DataBaseServer.GetTable("Customers");

                lvwContacts.DataSource = myCustomersTable;

Hi,

I would like to display some custom text as a tooltip when the user hover over some special cells in a BoundGridControl.  Is that possible?

Francois

Hello,

I’m using the BoundGridControl. I noticed something strange. If I have a row in a group with the focus, that is, the row is highlighted. Now, if I close the group (by clicking on the "-" button in the header row), then the focus will move to whatever row will physically appear where the old row was.

For example, if I have

- Group 1
Line 1
Line 2
- Group 2
Row 3
Row 4

and the focus is on "Line 2". If I close the Group 1, so I have

+ Group 1
- Group 2
Row 3
Row 4

Then suddenly, the focus will be on Row 3!

Similarly, if the focus was initially on Line 1, then it is the row "Group 2" which now has the focus and is highlighted (And this makes it unreadable btw).
Any suggestion?

I’m installed trial ElegantGrid on a machine running Windows Vista Business and Visual Studio 2008 Professional. But grid elements (NavigationGridControl for example) isn’t visible on Toolbox panel in Visual Studio...

Hello,

I would like to use a custom sorting algorithm for the data in some columns but for the other columns I want to rely on the default sorting algorithm.  How can I do that? 

Using the "CompareRows" property I can attach a custom comparison operator but then I can’t find how to revert to the default comparison method if the current sort rule doesn’t include the columns for which I want to use my custom comparison.

Thanks in advance,

Francois

Let me give a more detailed example then.

Suppose I have a grid, call it grid1, with 3 colums: Name, Phone, Address. If I sort the grid using the address column, I can to use a custom comparison, say conmpare_addresses, (for example, to handle zip code in a special way), but for the other columns, I want to use the default comparison operation. How do I do that? I can see how to invoke my comparison operator:

...
grid1.CompareRows += new Elegant.Grid.CompareObjectsEventHandler(my_CompareRows);
...

public void my_CompareRows(object sender, Elegant.Grid.CompareObjectsEventArgs e) {
System.Data.DataRowView X1 = (System.Data.DataRowView)e.X;
System.Data.DataRowView Y1 = (System.Data.DataRowView)e.Y;

if (grid1.SortRules[0].Column.DataPropertyName == "address") {
e.result = compare_addresses(X1.Row["address"], Y1.Row["address"]);
}
else { // Invoke the default comparison operation
???? <<<<<<<< How to do this?
}

Thanks in advance,
Francois

I need to filter a bound data grid and everything that I have tried is not working.  I have a form with a bound data grid connected to a dataset and one of the tables.  Also on the form are some drop down controls for the user to select the field to filter, the operation (=) and a place for the text box.  So the filter statement might be something like: State=’TX’.  However, everything from this point forward isn’t setting or applying the filter correctly.

Can someone help please?

Thanks,

Tom

 

Hi,

When grouping rows, I would like to add to the HeaderCell an indication of the number of rows in that group.  Is that possible for bound or unbound grids and how?  What I would like to have is something like:

Name                 |   Address              |  tel

- John (3)

       John            |  1 road                   | 555

       John            |  2 road                   | 666

       John            |  3 road                   | 777

- Tom (1)

       Tom             | 1 str                      | 888

 

My question is how to add the "(3)" and "(1)" in the header cell.

Francois Bronsard

We are sorry but you cannot obtain this count right now not using internal properties, i.e. reflection. We’ll fix this issue in the next release which we plan for November.

As a workaround, you can use the following code:

int itemsCount = 0;

                GroupRow gr = cell.Row as GroupRow;
                if (gr != null)
                {
                    PropertyInfo pi = gr.GetType().GetProperty(
                        "MarkupTreeNode",
                        BindingFlags.GetProperty | BindingFlags.NonPublic | BindingFlags.Instance);
                    SortGroupMarkupTreeNode node = pi.GetValue(cell.Row, null) as SortGroupMarkupTreeNode;
                    if(node != null)
                        itemsCount = node.DataItemCount;
                }

In order to display a custom content in the group row, you should implement a custom content viewer. Add a class to your project like as follows:

public class GroupRowViewer : ICellContentViewer
    {
        #region ICellContentViewer Members

        public System.Drawing.Size Measure(Cell cell, System.Drawing.Graphics g)
        {
            return Size.Empty;
        }

        public void Paint(Cell cell, System.Drawing.Graphics g)
        {
            using (StringFormat sf = new StringFormat())
            {
                sf.LineAlignment = StringAlignment.Center;
                sf.Alignment = StringAlignment.Center;
                g.DrawString("This is custom text for group cell \"" + cell.DisplayValue + "\"", 
cell.GridControl.Font, SystemBrushes.ControlText, cell.ContentRectangle);
            }
        }

        #endregion
    }

Then add the following line after InitializeComponent() method :

boundGridControl1.CellStyles[typeof(GroupRowCellStyle)].CustomContentViewerType = typeof(GroupRowViewer);

Very good! Thanks.

I have one more question though: How can I get the count of children rows? The data members "Rows" and "Children" associated with the group row are both null. If I use the debugger, I can see that there seem to be some internal private data member with the information I need (specifically, I can see that cell.Row.DataProvider.DataItemCount does countain the info I want but I don’t seem to be allowed to access that member.

Is there any other way to get that information, short of accessing the datatable and recalculating how many row match the display value of the cell?

Thanks

Thanks but this is not quite what I meant: I want to change the text of the "row header" not the column header.  More precisely, suppose I have the table:

Name                 |   Address              |  tel

       John            |  1 road                   | 555

       John            |  2 road                   | 666

       John            |  3 road                   | 777

       Tom             | 1 str                       | 888

 and I group the table using the Name column.  So I end up with:

                  Address              |  tel

- John

                 1 road                   | 555

                 2 road                   | 666

                 3 road                   | 777

- Tom

                 1 str                      | 888

My question is: how could I change the text in the rowheaders "John" and "Tom" to indicate the number of children.  That is, I would like to have:

                  Address              |  tel

- John (3)

                 1 road                   | 555

                 2 road                   | 666

                 3 road                   | 777

- Tom (1)

                 1 str                      | 888

Is it possible? 

If it is only possible with an unbound grid, is there a simple way to populate an unboundgridcontrol with a datatable?

HI,

Is it possible to either have a datarow with children rows or a grouprow with the same information as a datarow?

My problem is that I want to associate some rows with a parent row and I wonder how to do that.  For example, think of  a list of parents and children as in:

       NAME            |  Address            | Phone

     - John Smith  | 33 Elm st           | 333-3333

             - Children

                     Sue  |  33 Elm str        | 333-3334

                     Pete |  33 Elm str        | 609-5555

 

My problem is how to create the GroupRow "Children" as a child row of the DataRow that contains the info about John Smith.

Is that possible?

Thanks,

Francois

I am new with This One Help From every One Will Be Appreciated ..

I am using elegant UI Controls i-e Ribbon Control , Status Bar , Ribbon Tab Page for Controls like buttons etc , Ribbon TextBoxes , Ribbon Labels And Sysrem.windows Tab page Control (Coz This Feature Is Not Yet provided By Elegant UI Controls) To Design An Interface For Product Information .. I have set The Tab Indexes in Order that Labels And Textboxes First And Then All Other Controls After.. The Hotkeys with & sign are Defined in labels text assosiated with textboxes. I want the Interface Be perfect ready for key punching or DataEntry so tha the user Dont moves Out his hand From Keyboard during Entry.

Now Problem I am Facing Is that when I dont Use The Elegent UI Controls It Works Perfectly By Pressing Alt + Assoiacted Hot Key For Control Transfering But Dont Work when I Used the said Controls .. and also i cant abuse them coz my user wants the interface be made in ElegentUI controls.

Could Any one help?? Any Idea??/



Thanks In Advance..

Mbilal

<!--IBF.ATTACHMENT_551107--><!-- THE POST -->

We have discovered some strange behaviour with the tabbed toolbar.

To recreate this, I can first minimize the program containing a CExtTabbedToolControlBarFlat.  Then I change the desktop background (to some other image).

Next, when I maximize the app again, it can be seen that the tabbed toolbar has had its height changed.  It has lost some space at both the top and bottom of the toolbar.  This happens whether or not the tabbed tool bar has text under the button icons or not.

Resizing the window fixes the problem, bringing the toolbar size back to normal.

Any ideas as to what this is about?