StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » How do I use an Infragistics UltraGrid in my app?

How do I use an Infragistics UltraGrid in my app?

Robert Carl Johnson — Thu, 05 Jul 2007 16:29:01 GMT

Hi all. You guys have been great helping me get up to speed and I appreciate you time and effort. Now I need to use a Ultragrid and I'm totally lost. I dropped a BO on the form, added my UltraGrid (7.1) and manually bound to the BO but no columns displayed in the start wizard. So, obviously I'm missing something. Do I need to add anything else to facilitate the connection? Please explain this step by step and keep it simple for a simple man if you can.. lol.

BTW. This is a maint form and the grid is a child of the parent record. I will finally have 3 child grids on this form in tabs. FYI: Its a customer table and the child tables are related tables. The child BO's are related to the parent BO on the form. I think this describes the situation properly.

Regards,

Robert

RE: How do I use an Infragistics UltraGrid in my app?

Robert Carl Johnson — Thu, 05 Jul 2007 16:29:01 GMT

Michael, thanks for your replys. Your examples have helped me very much.

Regards,

Robert

RE: How do I use an Infragistics UltraGrid in my app?

Trent L. Taylor — Thu, 05 Jul 2007 16:15:38 GMT

Michael,

Thanks for all of your detailed help here! :)

RE: How do I use an Infragistics UltraGrid in my app?

Michael Reese — Thu, 05 Jul 2007 15:28:11 GMT

Hey Robert,

Use of the calendars is pretty straight forward. I mainly use the grid for drilling down to a SF form. So what is important to me is navigating records and appropraite display of mundane things like category records. The following will code will be useful in helping to make it (the grid) look human readible. My experience with the designer is mixed. I have spent a lot of time configuring the grid only to loose all my work. So I code on.

Example

Private Sub gridSubjects_InitializeLayout(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs) Handles gridSubjects.InitializeLayout
With Me.gridSubjects.DisplayLayout
'.AutoFitColumns = True

gridSubjects.DisplayLayout.Bands(0).LevelCount = 1

e.Layout.Bands(0).Columns("ID").Header.VisiblePosition = 1
e.Layout.Bands(0).Columns("SubID").Header.VisiblePosition = 2

            e.Layout.Bands(0).Columns.Add("ubRecType").DataType = GetType(System.String)
            e.Layout.Bands(0).Columns("ubRecType").Header.Caption = ("Record Type")
            e.Layout.Bands(0).Columns("ubRecType").Header.VisiblePosition = 3
End With

'for printing
        e.Layout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.RowSelect
End Sub

--------------------------------------------------------------------------------------------------------

Private Sub gridSubjects_InitializeRow(ByVal sender As Object, ByVal e As Infragistics.Win.UltraWinGrid.InitializeRowEventArgs) Handles gridSubjects.InitializeRow
     Dim BORecordType As New ORION_BO.BOGenRecTypeCodes

     'This line of code will get the value of the record by record column value.
     BORecordType.FillByPrimaryKey(BOSubjects.RecTypeID)

     'Note, you must first do an unbound setup.
      e.Row.Cells("ubRecType").Value = BORecordType.Description

'Cleanup Programatically Created BO's
     BORecordType.Dispose()

End Sub

RE: How do I use an Infragistics UltraGrid in my app?

Robert Carl Johnson — Wed, 04 Jul 2007 12:44:36 GMT

Ok Michael, I got my connection and I understand your comment regarding wizards. Can you give me some code examples using:

InitializeLayout

InitializeRow

I need to add ultracombo box's and ultraCalulators and ultraCalendars to columns.

Thanks for all your help so far...

Regards,

Robert

RE: How do I use an Infragistics UltraGrid in my app?

Michael Reese — Wed, 04 Jul 2007 11:46:36 GMT

Yeah pretty much.

I am trying to stay away from the wizards. You will find yourself using the following a lot.

InitializeLayout

InitializeRow

Now do not get your hopes up too much on the some of the fancy leveling you can do with a direct connection. We have been asking for and the SF gang are looking into that.

Michael

RE: How do I use an Infragistics UltraGrid in my app?

Robert Carl Johnson — Wed, 04 Jul 2007 11:13:53 GMT

Thanks for the reply Michael, I'll give that a shot. "To make it look pretty you have to do some coding" are you saying that I can't use the wizard to set parameters?

Regards,

Robert

RE: How do I use an Infragistics UltraGrid in my app?

Michael Reese — Wed, 04 Jul 2007 10:34:16 GMT

Hey Robert,

You have to use the Business Binding Source to attach the the BO. Then attach the Grid datasource to the BBS.

To make it look pretty, you have the do some coding.

Michael