Forum

How i can use per-cell data mapping to display available values in my combo box cell?

Hi. You can show one sample how i can use per-cell data mapping to display values in combo box cell in unbound grid control?

We prepared a sample illustrating per-cell data mapping for a combo-box in an unbound grid:

UnboundGridComboBoxDataBindingSample

Unfortunately you cannot define per cell mapping in bound mode. We will consider adding this functionality in later versions.

IN BOUDGRID ELEMENT I NEED THIS FUNCTIONALITY...

OK. THANKS. BUT I NEED LOAD  IN COMBO BOX FOR EACH ROW DIFFERENT DATA. I SAW HIM IN ’SIMPLE ELEGANT GRID DEMOS’ WHEN I CHOICE ENUMS LINE.

how i can catch event when i press some key in my edited cell?

Greetings -



Is there a way to enable multiline text in cells, particularly for the header. I can see how that can be implemented with a custom viewer, but then there the issue with matching to skins, etc., so I am hoping there a built-in method. Under the hood it’s just a flag to string draw function. You have similar functionality in Prof-UIs with __EGCS_EX_WRAP_TEXT attribute... Thanks!

-A

 

Yes, I have tried both \r\n and \n and it does not seem to work. This particular project is in VB.NET so the following code:

		    cols(i) = New Elegant.Grid.Column
		    dvgData.Columns.Add(cols(i))
		    cols(i).Width = 40
		    cols(i).HeaderText = "123" & vbLf & "456"

makes 456 disappear, but does not make it multiline nonetheless. Furthermore, it would be my preference to have automatic word wrapping rather than having to specify explicit line breaks, especially given the fact that Graphics.DrawString method can draw wrapped text into a rectangle when StringFormat.FormatFlags.NoWrap is not set. I am presuming that the grid uses that method to draw text at some point or another...



Any other suggestions?



-A

You should increase the header’s height. 456 is not visible partially because the text is wrapped by the text area rather than not by the header cell area. The text area is smaller than header cell area.Here is how to set a 90 pixel height for header row at top:

aGridControl.RowHeaderColumn.CellStyles[typeof(Elegant.Grid.ColumnHeaderRowHeaderCellStyle)].MinimalHeight = 90;

Here is how to set a 90 pixel height for outer row header cells on left and, as a result make each grid row having at least a 90 pixels height:

aGridControl.RowHeaderColumn.CellStyles[typeof(Elegant.Grid.RowHeaderCellStyle)].MinimalHeight = 90;

Text wrapping is not supported at the moment, we plan to implement it in future releases.

Hi -

I am probably missing something obvious, but I am unable to get to the Cell instances [that are inside the grid]. I am using the control in unbound mode for performance reasons. 

Neither row nor column classes have anything like .Cells property. There are CellStyles and everything else imaginable, but no cells. There is no Cell constructor that will take row and column that I can find.... How do I get a cell reference in a populated unbound grid so that I can modify its contents? Thank you.

-A

 

Thank you - I was missing the difference between Row and Datarow. Everything is working properly now.

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?