Hello, I am still evaluting Elegant Grid.

I am quite impressed with the control so far. It is very rare that I evaluate a databound control which works the first time I set a DataSource and run the program. Yours worked the first time, with one line of code.

Some thoughts:

It would be nice to retrieve columns for data sources other than DataTable. I use Object binding (IList, IBindingList, etc.). I was able to work around this by creating a DataSet and temporarily using it as a DataSource. I retrieved the columns, then changed to an object data source. I was presented with a prompt which asked me if I wanted to remove all columns. I answered No and the columns remained. I am very happy to note that your column naming pattern suffixes the DataPropertyName with "Column", instead of using an antique prefix such as "col". Just wondering if this behavior may be customized, although I am very happy with it as is. I think it would also be very good if, when columns are retrieved, the HeaderText property would splt on Camel case to build that string, rather than using the DataPropertyName. For example, the HeaderText for property LastName would be generated as "Last Name".

I find some genuine problems with the product, however:

1.  I note that the text alignment for all cell types is TopLeft by default. The defaults should all be MiddleLeft. Please consider this a feature request. I consider it a bug, though not in the strictest sense of the word; it is more a poor decision. It is difficult for me to imagine why TopLeft became the default. Is there a workaround? I don’t want to be forced to create a new CellStyle for every cell type in every grid. A code workaround in VB.Net will be appreciated which sets all cell text alignment to MiddleLeft. Can I derive from ElegantGrid, making MiddleLeft the default for all cell types?

2.  When I resize a column to something narrower than the length of a visible cell’s content, the text in the cell is moved upward. Is there a property setting available to stop this? If not, will it be fixed? If so, please let me know when.

3. When I double-click the margin/separator between columns, the column is not resized to fit the width or length of content in cells contained in that column? Is there a property setting for this? If not, please let me know when it will be fixed.

Many thanks.

Ok, thanks very much. Cell Styles can be handled in this manner:

CType(Me.BoundGridControl1.CellStyles(GetType(TextCellStyle)), TextCellStyle).TextAlignment = ContentAlignment.MiddleLeft
CType(Me.BoundGridControl1.CellStyles(GetType(NumericCellStyle)), NumericCellStyle).TextAlignment = ContentAlignment.MiddleLeft
CType(Me.BoundGridControl1.CellStyles(GetType(DateTimeCellStyle)), DateTimeCellStyle).TextAlignment = ContentAlignment.MiddleLeft
CType(Me.BoundGridControl1.CellStyles(GetType(ComboBoxCellStyle)), ComboBoxCellStyle).TextAlignment = ContentAlignment.MiddleLeft

Regarding the section of the documentation regarding themes - I had already read it and it mentions nothing about custom themes. However, I saw support’s response to a similar question in another thread, which indicated that custom themes were not supported. This was, however, quite an old thread. Is it still the case that you have not added such support?

I look forward to your comments on Issues 2 and 3 above, when you have the time.

Thanks again.

 

Hi,

Take a look here:

http://www.prof-uis.com/elegant-grid/tech-support/faq/cell-styles.aspx
http://www.prof-uis.com/elegant-grid/tech-support/faq/visual-themes.aspx#what-themes-are-supported-in-elegant-grid

TSELLC_Support

Hello,

I’m evaluating Elegant Grid and would like to know if it is possible to create custom themes.

Thank you and best regards.

Background: 2 data bound columns + 1 custom column
Custom column is built up by iterating through a collection and using StringBuilder to append a formatted string and returns a ToString() of the StringBuilder as the custom column output.

When this is shown in the grid, only the first line of the string builder is shown.

Hi, how to pass the rows of  Uboundgrid control to an ArrayList or Collection?

Roberto

 

Hi. How i can change cell button text programmatically after init grid cell styles and columns? The text property for cell button it is read only (((. 

I found the way to do it...thanks )))

((Elegant.Ui.Grid.DataRow)Grid.Rows[RowIndex]).Cells[Grid.Columns[2]].Style.LeftButtonText = "some text"

 CellStyle.LeftButtonText and CellStyle.RightButtonText properties it is read only properties. I cannot change this properties. I need change button text after input some text in this row but other cell. This is my code to create grid column:

TextCellStyle btnColumnStyle = new TextCellStyle(); btnColumnStyle.AllowEdit = false;
btnColumnStyle.AlwaysShowLeftButton = true;
btnColumnStyle.LeftButtonText = "text";
btnColumnStyle.LeftButtonType = typeof(Elegant.Ui.Grid.TextCellButton);//.EllipsisCellButton);
btnColumnStyle.LeftButtonVerticalAlignment = VerticalAlignment.Top;

  Column column2 = new Column();
  column2.CellStyles.AddRange(new Elegant.Ui.Grid.CellStyle[] { btnColumnStyle });
  column2.DataPropertyName = "Btn";
  column2.HeaderText = " ";
  column2.Visible = true;
  column2.AllowResizing = false;
  column2.Width = _BtnColumnWidth;
  column2.FillWeight = 26F;
  Grid.Columns.Add(column2);

and after i try change text only for selected row and selected cell this way

((Elegant.Ui.Grid.DataRow)Grid.Rows[_SelectedRowIndex]).Cells[Grid.Columns[2]].LeftButton.Text = "some ..."

is there any other way to make it?

in unbound grid control...

Hello

I am using the report grid.

When I sort, group, expand or collapse I lose the current selection.

I would really like to avoid setting up a system to save and restore my selection structure.

Is there a way to tell the report grid not to reset the selection during a sorting, grouping, expand or collapse operation?

1. I use column with CellType == Color. And I use yours standard color dialog for edit this cells. But "More colors..." options don’t return another colors.

2. Do you have localize text (for ru-RU) for  "More colors..." string in color popup window?

I use Elegant.Ui.Grid 4.1 and put Elegant.Ui.Grid.resources.dll to ru-RU folder.

1) It is not completely clear what you mean by: "More colors..." options don’t return another colors. Please elaborate.
2) But the default "More colors..." button is already localized if it is generated by designer. If you want to add this button from the code, please use the Elegant.Ui.MoreColorsButton button without setting its Text property.

1. Please run your "Simple Demos" application for Elegant Grid. Select "Progress Bar and Color Picker" list item.

Click on a color cell to select the color.

In popup window click "More colors..." button.

Select a new custom color in the color dialog.

Click OK.

Color in the cell didn’t change.

2. I created Elegant.Ui.Grid.UnboundGridControl by designer.

One of the column have a standard color (CellType = Color) cell style (AllowEdit = true, CustomEditor = (none)). It is also determined by the designer.

So when you click on a cell popup color selection window appears automatically.

And button "More colors..." it is not localized.

I do

System.Globalization.
System.Threading.
System.Threading.CultureInfo ci_ru = new System.Globalization.CultureInfo("ru-RU");Thread.CurrentThread.CurrentCulture = ci_ru;Thread.CurrentThread.CurrentUICulture = ci_ru;

 

in Program.Main() and put Elegant.Ui.Grid.resources.dll to ru-RU folder with other russian resources.

Thank you for the bug report. We’ve fixed the issue with ColorDialog not changing the cell color. Regarding the localization issue: did you also put Elegant.Ui.Common.resources.dll to ru-RU folder?

Yes, I put Elegant.Ui.Common.resources.dll (from C:\Program Files\FOSS Software Inc\Elegant Ribbon\Bin\Core\ru-RU\ folder) to Bin\Debug\ru-RU folder of my project. But button "More colors..." it isn’t localized, with the color selection dialog (that appears when you click button) on the Russian.

Thank you, we confirm the issue. The fix will be included in the next version.

Hi,

Is there an equivalent method for datarowboundevent in the boundgridcontrol?

I want an event to be fired whenever a row is bound to the grid control so I can alter the contents of cells, for example format dates etc etc.

 

Is this possible??

 

Thanks

Hi all,



I am still evaluating the Grid v3.8 and I am still not getting along with the control at all.  I am not able to find any code samples for how to work with it.



Pretty much, I am working with three tables in a database that have an FK relationship.  I am not using any designers.  I prefer to code by hand.  I have my code setup where I am creating one DataSet and then creating two DataTables within the DataSet for the information I want based on a FK.  I also have a DataRelation set up for the DataTables due to the FK relationship within the database.



I know this works because the way I have the form setup, if an end-user types in a client name, if there is only one phone number for the client, the other controls are auto-populated with the information.   This works without issue.  If more than one phone number exist, a form comes up asking them to choose the phone number and phone number type from the BoundGrid control. This was coming up without issue prior to trying to code to get the BoundGrid to populate the information.  This is where I am having the issue.  I am trying to populate the BoundGrid from the DataSet/DataTables/DataRelation code I have going on.

The issue I am having is that as soon as the form loads that holds the BoundGrid control, I am getting an OutOfMemoryException and then my app crashes.



The following is what I have done and what I have tried to do to get the BoundGrid to populate the information. Please note that the code to populate the BoundGrid is toward the bottom of the Sub.

We asked to you send us a test project so that we can help you more efficiently. Could you do that? Thank you.

    <CLSCompliant(True)> Private Sub cboClientName_LostFocus(ByVal sender As Object, _

                                                             ByVal e As System.EventArgs) Handles CboClientName.LostFocus



        ’Only run the following code if there is data present/selected/typed in the ComboBox.

        With CboClientName

            If .Text.Trim.Length > 0 _

            AndAlso .Text.Trim IsNot Nothing Then

                ’Check the backend database to see if the client name exists.

                ’If the client name exists, check to see how many phone numbers the client has.

                ’If there is only one phone number, populate the MaskedTextBox and ComboBox.

                ’If there are multiple phone numbers, show a form for the end user to choose the phone number

                ’they want.

                Using SetDatabaseConnection As SqlConnection = New SqlConnection(GetDatabaseConnectionString)

                    Try

                        ’Open the connection to the database.

                        SetDatabaseConnection.Open()



                        ’Create a DataSet.

                        Dim ClientInfoDS As DataSet = New DataSet



                        ’Set the locale of the DataSet.

                        ClientInfoDS.Locale = CurrentCulture



                        ’Create two DataTables.

                        Dim ClientPhoneDT As DataTable = New DataTable("ClientInformation_PhoneNumbers")

                        Dim ClientPhoneTypeDT As DataTable = New DataTable("ClientInformation_PhoneNumberType")



                        ’Set the locale for the DataTables.

                        ClientPhoneDT.Locale = CurrentCulture

                        ClientPhoneTypeDT.Locale = CurrentCulture



                        ’Create the columns for the DataTables.

                        With ClientPhoneDT

                            .Columns.Add(New DataColumn("PhoneNumberID_PK", GetType(Integer)))

                            .Columns.Add(New DataColumn("ClientPhoneNumber", GetType(String)))

                            .Columns.Add(New DataColumn("PhoneNumberTypeID_PKFK", GetType(Integer)))

                            .Columns.Add(New DataColumn("ClientInfoID_PKFK", GetType(Integer)))



                            ’Set the primary key column.

                            Dim PrimaryKey(1) As DataColumn

                            PrimaryKey(1) = .Columns("PhoneNumberID_PK")

                            .PrimaryKey = PrimaryKey

                        End With



                        With ClientPhoneTypeDT

                            .Columns.Add(New DataColumn("PhoneNumberTypeID_PK", GetType(Integer)))

                            .Columns.Add(New DataColumn("PhoneNumberTypeName", GetType(String)))



                            ’Set the primary key column.

                            Dim PrimaryKey(1) As DataColumn

                            PrimaryKey(1) = .Columns("PhoneNumberTypeID_PK")

                            .PrimaryKey = PrimaryKey

                        End With



                        ’Add the DataTables to the DataSet.

                        With ClientInfoDS

                            .Tables.Add(ClientPhoneDT)

                            .Tables.Add(ClientPhoneTypeDT)

                        End With



                        ’Create a DataRelation for the two tables.

                        Dim ClientInfoDRe As DataRelation



                        ’Create a new SQLCommand.

                        Dim MySQLCommand As SqlCommand = New SqlCommand



                        ’Set the attributes for the SQLCommand.

                        With MySQLCommand

                            .Connection = SetDatabaseConnection

                            .CommandType = CommandType.StoredProcedure

                            .CommandText = "sp_GetPhoneInfoByName"

                            .Parameters.AddWithValue("@ClientName", CboClientName.Text.Trim.ToString)

                        End With



                        ’Create a DataAdapter.

                        Dim ClientInfoDA As SqlDataAdapter = New SqlDataAdapter(MySQLCommand)



                        ’Clear the DataSet prior to doing anything.

                        ClientInfoDS.Clear()



                        ’Fill the DataTables with the information found.

                        With ClientInfoDA

                            .Fill(ClientPhoneDT)

                            .Fill(ClientPhoneTypeDT)

                        End With



                        ’Create two DataColumns for the DataRelation relationship.

                        Dim ParentTableDC, ChildTableDC As DataColumn



                        With ClientInfoDS

                            ’Create the DataRelation between the PK/FK columns.

                            ParentTableDC = .Tables("ClientInformation_PhoneNumberType").Columns("PhoneNumberTypeID_PK")

                            ChildTableDC = .Tables("ClientInformation_PhoneNumbers").Columns("PhoneNumberTypeID_PKFK")



                            ’Create a new DataRelation.

                            ClientInfoDRe = New DataRelation("Phone Numbers", ParentTableDC, ChildTableDC)



                            ’Add the DataRelation to the DataSet housing the two DataTables.

                            .Relations.Add(ClientInfoDRe)

                        End With



                        ’Create two DataRows.  One for the parent and another for the child.

                        Dim ParentTableDR, ChildTableDR As DataRow



                        ’Now the fun begins, let’s go ahead and get the information from the DataTables.

                        ’If there is one phone number, auto populate the MaskedTextBox with the phone number and ComboBox with the phone number type.

                        ’If there are multiple phone numbers, show a form to allow the end user to select the desired phone number.

                        ’If there are no records returned, focus the MaskedTextBox.

                        For Each ParentTableDR In ClientInfoDS.Tables("ClientInformation_PhoneNumberType").Rows ’PK.

                            For Each ChildTableDR In ParentTableDR.GetChildRows(ClientInfoDRe) ’FK.

                                ’Now see how many records were returned.

                                Select Case ClientInfoDS.Tables("ClientInformation_PhoneNumberType").Rows.Count

                                    Case 0 ’No records.

                                        ’No records returned, go ahead and focus the MaskedTextBox.

                                        MtbClientPhoneNumber.Focus()



                                        ’Go no further because nothing returned.

                                        Exit For

                                    Case 1 ’One record.

                                        ’Yippee!  A record was returned.

                                        ’Auto populate the the MaskedTextBox (Phone Number).

                                        ’Auto populate a default value in the ComboBox (Phone Number Type).

                                        MtbClientPhoneNumber.Text = ChildTableDR("ClientPhoneNumber").ToString

                                        CboPhoneNumberType.Text = ParentTableDR("PhoneNumberTypeName").ToString



                                        ’Focus the Partner Name ComboBox.

                                        CboPartnerName.Focus()

                                    Case Else ’Multiple records.

                                        With FrmMultiPhoneSelect

                                            ’Add some text to the Form Caption Label.

                                            .LblFormCaption.Text = "Please select a phone number from the list below that you would like to use for " & CboClientName.Text & "."



                                            ’Populate the control with all the phone numbers and phone number types.

                                            With .GridPhoneNumbers

                                                Dim ClientInfoBS As BindingSource = New BindingSource



                                                With ClientInfoBS

                                                    .DataMember = "ClientInformation_PhoneNumbers" ’Child table.

                                                    .DataSource = ClientInfoDS ’DataSet that holds two DataTables and has a DataRelation.

                                                End With



                                                .DataSource = ClientInfoBS ’BindingSource.



                                                ’Phone Number.

                                                .Columns(0).MappingDataSource = ParentTableDC

                                                .Columns(0).MappingDisplayDataMember = ChildTableDR("ClientPhoneNumber").ToString

                                                .Columns(0).MappingValueDataMember = ChildTableDR("ClientPhoneNumber").ToString

                                                ’Phone Number Type.

                                                .Columns(1).MappingDataSource = ChildTableDC

                                                .Columns(1).MappingDisplayDataMember = ParentTableDR("PhoneNumberTypeName").ToString

                                                .Columns(1).MappingValueDataMember = ParentTableDR("PhoneNumberTypeName").ToString

                                            End With

                                        End With



                                        ’Show a form to the end user, so that s/he can select from a list of available phone numbers.

                                        ShowFormInMDI(FrmMultiPhoneSelect, FrmMain)

                                End Select

                            Next ChildTableDR

                        Next ParentTableDR



                        ’Close the database connection.

                        SetDatabaseConnection.Close()

                    Catch ex As SqlException

                        MessageBox.Show("There was an error getting data from the database. The error is:" & vbNewLine & _

                                        ex.Message, _

                                        "Error Retrieving Data.", _

                                        MessageBoxButtons.OK, _

                                        MessageBoxIcon.Information, _

                                        MessageBoxDefaultButton.Button1, _

                                        MessageBoxOptions.DefaultDesktopOnly, _

                                        False)

                    End Try

                End Using

            End If

        End With

    End Sub

If I just do the following:

                                        With FrmMultiPhoneSelect

                                            ’Add some text to the Form Caption Label.

                                            .LblFormCaption.Text = "Please select a phone number from the list below that you would like to use for " & CboClientName.Text & "."



                                            ’Populate the control with all the phone numbers and phone number types.

                                            With .GridPhoneNumbers

                                                .DataSource = ClientInfoDS

                                                .DataMember = "ClientInformation_PhoneNumbers"

                                            End With

                                        End With



Then two rows are generated in the BoundGrid but no information shows at all.  I am not getting any errors at this point when I try that.  This particular test client has two phone numbers available.  I will see if I can get the information to populate. FYI, the BoundGrid has two columns.

OK, I am still not able to get the data to display.  It just creates two rows with empty cells.



I have tried the following too and no go.



                                        With FrmMultiPhoneSelect

                                            ’Add some text to the Form Caption Label.

                                            .LblFormCaption.Text = "Please select a phone number from the list below that you would like to use for " & CboClientName.Text & "."



                                            ’Populate the control with all the phone numbers and phone number types.

                                            With .GridPhoneNumbers

                                                .DataSource = ClientInfoDS

                                                .DataMember = "ClientInformation_PhoneNumbers"

                                                .Columns(0).MappingDisplayDataMember = ChildTableDR("ClientPhoneNumber").ToString

                                                .Columns(0).MappingValueDataMember = ChildTableDR("ClientPhoneNumber").ToString

                                                .Columns(1).MappingDisplayDataMember = ParentTableDR("PhoneNumberTypeName").ToString

                                                .Columns(1).MappingValueDataMember = ParentTableDR("PhoneNumberTypeName").ToString

                                            End With

                                        End With

If I try the following, I am told InvalidOperationException. Cannot bind to IListSource instance.

                                        With FrmMultiPhoneSelect

                                            ’Add some text to the Form Caption Label.

                                            .LblFormCaption.Text = "Please select a phone number from the list below that you would like to use for " & CboClientName.Text & "."



                                            ’Populate the control with all the phone numbers and phone number types.

                                            With .GridPhoneNumbers

                                                ’DataSet that holds two DataTables with a DataRelation.

                                                .DataSource = ClientInfoDS

                                                ’Table that holds the PK in the PK/FK relationship.

                                                .DataMember = "ClientInformation_PhoneNumberType"

                                                ’The columns within the DataTables for the columns in the BoundGrid.

                                                .Columns(0).MappingDataSource = ClientInfoDS

                                                .Columns(0).MappingDisplayDataMember = ChildTableDR("ClientPhoneNumber").ToString

                                                .Columns(0).MappingValueDataMember = ChildTableDR("ClientPhoneNumber").ToString

                                                .Columns(1).MappingDataSource = ClientInfoDS

                                                .Columns(1).MappingDisplayDataMember = ParentTableDR("PhoneNumberTypeName").ToString

                                                .Columns(1).MappingValueDataMember = ParentTableDR("PhoneNumberTypeName").ToString

                                            End With

                                        End With

Could you send us a sample project that illustrates the issue?

With the code I have, am I even doing it right?  I can more than likely do this with a DataSet but this DataSet has two DataTables with a DataRelation.  I am unable to get this to work.  Should be simple to populate this Grid.  Other than that, might have to drop Grid and go with ListView instead.  I’d rather not have to do that though.

In the ListView, there it an .Items.Add option, I don’t seem to find anything in your intellisence to be able to add the rows.

I have been working at this for weeks now and still not able to get it to work.  Not about to pay $95 for a control that is useless to me.

I have tried the following and it creates two rows which are completely blank (no data).  What am I doing wrong?!

                                            With .GridPhoneNumbers

                                                .DataSource = ClientInfoDS

                                                .DataMember = ClientInfoDS.Tables(PhoneNumberTypeTable).ToString



                                                ’Phone Numbers.

                                                .Columns(0).MappingDisplayDataMember = ChildTableDR(ClientPhoneNumberColumn).ToString

                                                .Columns(0).MappingValueDataMember = ChildTableDR(ClientPhoneNumberColumn).ToString

                                                ’Phone Number Types.

                                                .Columns(1).MappingDisplayDataMember = ParentTableDR(PhoneNumberTypeNameColumn).ToString

                                                .Columns(1).MappingValueDataMember = ParentTableDR(PhoneNumberTypeNameColumn).ToString

                                            End With

                                        End With

Even tried the following just now and nothing.  Just creates two blank rows of cells.  Frustrating!

                                        For Each ParentDR In ClientInfoDS.Tables(PhoneNumberTypeTable).Rows ’PK.

                                            For Each ChildDR In ParentTableDR.GetChildRows(ClientInfoDRe) ’FK.

                                                ’Add the phone numbers and the phone number types to the grid.

                                                With FrmMultiPhoneSelect.GridPhoneNumbers

                                                    .DataSource = ClientInfoDS

                                                    .DataMember = ClientInfoDS.Tables(PhoneNumberTypeTable).ToString



                                                    ’Phone Numbers.

                                                    .Columns(0).MappingDisplayDataMember = ChildDR(ClientPhoneNumberColumn).ToString

                                                    .Columns(0).MappingValueDataMember = ChildDR(ClientPhoneNumberColumn).ToString



                                                    ’Phone Number Types.

                                                    .Columns(1).MappingDisplayDataMember = ParentDR(PhoneNumberTypeNameColumn).ToString

                                                    .Columns(1).MappingValueDataMember = ParentDR(PhoneNumberTypeNameColumn).ToString

                                                End With

                                            Next ChildDR

                                        Next ParentDR

Could you also check your email address? We can see that messages from this forum are not delivered to you.

I recently updated my email address and address the other day.  All should be fine.

I have tried so hard to get the control to display the data and its only displaying two rows and empty cells.  I even checked the font color and its not a color whereby the text would be hidden.

I am lost when it comes to working with the grid v3.8

please do help if you can.

We asked you to create a simple test project and send it to us so that we can help you. Do you have any problems with that?

I don’t have a problem with that. I would also have to send a copy of my database as a BAK file along with it.  This database has personal information in it but I am sure I could replace the records with dummy records for security reasons.

Do you have access to an instance of SQL Server 2005?

Your test project and db bak will be fine. We will restore the db on SQL Server 2005 and check what’s wrong.

The code I am using is being used on multiple forms, so I have it in a module. When I am pulling up that form to display a user with multiple phone numbers, I am not doing it in form load event.  I have not tried it in the form load event.  I would rather not duplicate the code.  Almost 200 lines of code is being used for that particular situation.  Where can I send the project and bak file?  Would rather not post it on the forum.

Is it possible to maintain the scroll position within the BoundGridControl so when the datasource is refreshed, the scroll position is maintained?

Thanks,

 

when will u have in .ΝΕΤ version the freezing row and columns for the grid?

I am using v3.8

I have a unbound grid on the form with four columns.  The last column is set as a ComboBoxCell.  Where do I go to programatically make the ComboBoxCell display the DropDownList and populate it with some values?  I have tried many things and I don’t know what I am doing.  I can’t even find what I need in the properties window of the unbound grid.  Please advise.