MSFLEXGRID: Adding data


  • hi guys!
    well im having some trouble using the flexgrid. i have this following code:
        With MSFGFields
            .Rows = 1
            .TextMatrix(0, 0) = "Field"
            .ColWidth(0) = 1750
            .ColWidth(1) = 1750
        End With
    what i want to do is to read a tables COLUMN name and show it into the grid. 
    my code look like this but it doesnt work.
    dont know where the problem is.
                Set FieldName = MainConnection.OpenSchema(adSchemaColumns, 
    Array(Empty, Empty, "MyTable"))
                Set MSFGFields.DataSource = FieldName
                Do While Not FieldName.EOF
                    MSFGFields.AddItem FieldName!COLUMN_NAME
    do any of you have any ideas solving this problem? that will be great! thanks!
    Tuesday, October 31, 2006 8:36 AM