StrataFrame Forum

How do I use an Infragistics UltraGrid in my app?

http://forum.strataframe.net/Topic9959.aspx

By Robert Carl Johnson - 7/4/2007

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
By Michael Reese - 7/4/2007

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 

By Robert Carl Johnson - 7/4/2007

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
By Michael Reese - 7/4/2007

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

By Robert Carl Johnson - 7/4/2007

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
By Michael Reese - 7/5/2007

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 

By Trent L. Taylor - 7/5/2007

Michael,

Thanks for all of your detailed help here! Smile 

By Robert Carl Johnson - 7/5/2007

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



Regards,



Robert