Forum

Hi, we are using the Elegant grid in an application that requires screen update, but when we try to update the datasource of a Bound Grid it keeps the old data and add the new one, kind of duplicating columns.

We have tried to clean the datasource with .Datasource = Nothing, but this causes an

"Object Reference Not Set to an Instance of an Object" error.

How can we proceed?

Thanks so much

Marcos

Unfortunately we failed to reproduce this problem. Could you send us a project that illustrates the issue?

Hi, I’ve just sent an e-mail with the sample. The subject was "RE: Cleaning the Datasource property in a Bound Grid".

But I’ve sent the mail from wsouza@bulltick.com ’cause my mail has problems...

Thanks in advance,

It semms that the mail doesn’t allow zip files so I’m sending a text file

From a click button, I try to consent to the value of a cell with DataValue, but an error exists

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
UnboundGridControl1.Cell(1,1).DataValue <-----------ERROR
EndSub

got it, sorry, changed datarow for row when adding references

tried this example to modify a column value depending on other comboboxcell but can’t
cause it says


Dim _TotalByColumnRow As Elegant.Ui.Grid.Row
_TotalByColumnRow = grdU.Rows(1)
Dim totalByColumnCell As Elegant.Ui.Grid.Cell = _TotalByColumnRow.Cells(grdU.Columns(1))

_TotalByColumnRow.Cells(grdU.Columns(1))

’Cells’ is not a member of ’Elegant.Ui.Grid.Row’.    

what reference i’d have to add to use object cells?

thanks

In the event click, intent to save to a file in particular the value of some cell.

As I can consent to the value of a cell of an UnboundGridControl from code?

You can use Cell.DataValue and Cell.DisplayValue properties for that.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

UnboundGridControl1.Cell.DataValue
EndSub

Impossible, it indicates me ERROR

greetings.
My question is, like I can set text to a cell of the RowHeaderColumn

There is no default implementation for text in row header cells but you can render it yourself using the ICellContentViewer interface. All you need is to implement two methods of this interface: Measure() and Paint(). Then you should set the CellStyle.CustomContentViewerType property of a particular cell style to the type of class that implements the methods in order to apply your custom viewer. You can learn how to make custom cell viewer from the following samples in Simple Demos set: Search, Product Photos, Multithreading, and Graphs.

I have modified the code of the TextCell and I have compiled the code of the "ElegantGrid", it generates me the file Elegant.Grid.dll, simply substitution the new file compiled by the previous one, but when trying to use the ElegantGrid the TextCell doesn’t modify.
Not you if it should assemble the file Elegant.Grid.dll or simply to substitute it. If one has to assemble, could I explain as making it?

We are not completely sure what the problem is but if you compiled Elegant Grid successfully and cannot see any changes in your modified TextCell then you may have forgotten to install your new assembly to GAC (global assembly cache). If it is the case, use gacutil.exe (it comes with Visual Studio) in the following way:

gacutil.exe /i Elegant.Grid.dll

This procedure guarantees that you are using the proper assembly. Please however note that you can modify the source code on your own risk because we do not provide any support for such changes but rather the source code is provided for maintenance purposes.

I agree, the problem is that I need that in a cell there are a button and an editbox together, something similar to a combobox but when giving click in the button I appear a dialog.
thank you

Is there not a way using the bound grid to allow the user to add a new row to the grid similar to Microsoft’s DataGridView, by clicking on the last row? Thanks for your help.

Dear Sir\Madam,

I have one query regarding property grid.

1. Say in One of the row in the property grid we are having the combo box.
2. Choose the appropriate option from Combo Box.
3. After selecting the option atleast one of the rows in the property grid should be enable or disable.


Let me know how to disable or enable the row, which is explained in the step 3.?

Waiting for your fast reply. Thanks in advance

Regards

Lavate Mallikarjun Avanna

Hi,

Can a databound grid show the row number on the left side of the grid similar to the way Excel shows the row number on the left side of the spreadsheet? Thanks!


John

Hi,

I tried using this example from the elegant grid documentation, but it doesn’t seem to work. I get a blank grid, but I’m
not too sure why. I know the dataset is being populated because when I read out the dataset columns, they come
out correctly.


[C#]
using System.Data;
using System.Data.OleDb;
using Elegant.Grid;

OleDbConnection oleDbConnection =
new OleDbConnection("...connection string...");
OleDbCommand oleDbSelectCommand =
new OleDbCommand("SELECT * FROM Contact", oleDbConnection);

OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = oleDbSelectCommand;

DataSet dataSet = new DataSet("Contact");

private void Form1_Load(object sender, System.EventArgs e)
{
boundGridControl1.DataSource = dataSet ;
boundGridControl1.DataMember = "Contact";
dataAdapter.Fill(dataSet);
}

Hi,

How do I send the project to you? Thanks!

Please send it to support@prof-uis.com.

Hi,

I’m new to elegant grid and I’m evaluating its functionality at the moment. I was wondering, does elegant grid have any of these
three features for a databound grid?

1. freeze column (or split scroll)
2. card view that can be created dynamically at run-time
3. can handle column names and column headers that contain spaces in the name

Thanks!

Hi,

Thx for the responses. =-)

Do you guys have plans to incorporate the freeze column (or split scroll) or card view features in the future? Thanks!

We added your feature requests to our to-do list. Thank you.

Hi,

When is v1.4 going to be released? Will the freeze column feature be included? If it is released soon, I will design my entire project around it. But for now, I may reluctantly have to either go with Sybase’s DataWindow (which is hard to program) or Syncfusion’s Essential Grid (the scrolling is slow). Your grid is the best, as long as you add the freeze column or split scroll feature.


John

Thank you for the kind words, John. The features you requested are not in our immediate plans. These features may only be implemented not earlier than this fall. We are sorry.

Try to resize grid column in Designer mode, and press F5 in Visual studio net but not moving mouse cursor from grid area, VSplit cursor appear instead of Default cursor.

Currently, I have XD++ MFC Diagram Kit from ucancode software ( http://www.ucancode.net ), I hope I am also need a modern GUI Kit, so I found Prof - UIS, I think it maybe one of a good choice, but I cann’t make sure if it works with XD++ MFC Diagram Kit or not? Please give us some help on this, thanks!

I am currently evaluating ElegantGrid. I want to know if it is possible not to show the GroupByBox and set the grouping in my code. Also, can I hide the columns that I am setting GroupBy for? It is taking unnecessary space by displaying a column whose value is displayed by the grouping node on top and repeating the same value for each row. Thanks.

You can show or hide the Group By Box using the GroupByBoxVisible property. You can hide a column by setting Column.Visible to true. Here is how the grouping and sorting works. There is a SortRules collection that specifies the columns by which the grid can be grouped and sorted. There is a SortGroupCount property that tells the grid by how many columns from the SortRules collection the grid should be sorted. For instance, you have two columns in this collection and you set SortGroupCount to 1. This means the grid will be grouped by one column (the first column in the collection). You can play with all these properties in the Visual Studio designer. So all features you are asking about requested work.

Thanks for a quick response. I went through most of the properties of ElegantGrid and everything is self explanatory. I just have 2 more questions for you.

1. AllowDraggingOffColumns property allows whether the end-user can hide columns by dragging header cells out of the header.
How can they make them visible again?

2. How can rows auto-size to fit content in height? This is shown in your sample demos project in the Search section. However, how does this grid auto-size the row height to fit the content? I have ColumnAutoSizeMode set to Fill. Anything else I am missing?

Thanks for all the help.

You can make the columns visible again by setting the Column.Visible property to true.

As for your second question, cells measure their height by content automatically. Still if you want to make the cell height fixed, please use the CellStyle.FixedHeight property. In the Search demo, we did this by using a custom cell content viewer.

Follow-up to my previous question:

I have a button sitting in an empty column in a grouped grid. I do not want to display the GUID’s since they are meaningless to the end user, so the button is all by itself in the grid, and the GUID column is hidden. When the user selects the button, I can determine which row was selected through the row index property, but with grouping active I can’t equate that to a row in the data table.

At the moment, I do not see any way in any exposed object or collection to determine an adjacent cell’s value. I am looking for something like the row/column selection you can do in a data table (myDataTable.Rows[0][3].ToString() or something similar). Failing that, I would like to find a way to get at the actual row index that equates to the data source. Either method works for me, but at the moment I can’t see any way to do either.

-Dave Ferreira

I am currently evaluating ElegantGrid for use in one of my client’s projects.

I have a bound data grid loaded and grouped as desired, but so far I have been unable to figure out how to expand and collapse all groups through code. I have the groups by default collapsed, but I want to have buttons on the form which will expand and collapse all for the user.

Is this possible, and if so how?

-Dave Ferreira

Dear Sir/Madam

I am using CExtGridWnd class. Using this class i derive a class .I then inserted some column .
In one of the column i am inserting some names using

CExtGridCellString * pCellString0 =STATIC_DOWNCAST(CExtGridCellString, GridCellGet( 0, iLoop ));
pCellString0->TextSet( _T(szFullName) );

I am using style
.BseModifyStyle( __EGWS_BSE_SORT_COLUMNS,0,FALSE);

After inserting data when i click on column header having text data not sorted properly i.e. not in alphabetical order either ascending or descending.
When arrow on column header shown upword the sorting order is like this
Ganesh Rai
Hitesh
Kiran
Ramesh
Vasant
arm
enov

etc...
Why not names like , arm then enov & then Ganesh like this are sorted when ascending order or when arrow upword.

where is problem.
Please suggest quickly some solution .
Thanks.


    

Sometimes, we need to make a CExtGridWnd gray to show that it cann’t be selected or manipulated. I have changed the style of the grids in the window to __EGCS_READ_ONLY,but it doesn’t work.

__EGCS_READ_ONLYis a cell style. You can disable the whole grid window using this:

wndGrid.EnableWindow( FALSE );

Hi,

I have an Visual Studio C++ Mfc Project with prof-UIS.

When I run application ,I open a dialog.There is my custom grid in opened dialog.Then I change Theme,but I can’t repaint my custom grid color when page opened.But if I open window again ,I can see changing.Because colors loaded initializing.

I must repaint my custom grid color.
How can I understand opened window?
How can I do? Please help me!

Does elegant grid offer an autocomplete feature? Particularly, can it automatically match the typing into a comboboxcell to the list of values and offer completion suggestions? If not, how can I set the text (and selection) that is being edited so I can implement my own autocomplete?

Thanks.