Infragistics dialog control not displaying when looping thru an excel spreadsheet

I am opening an excel worksheet and looping thru the rows,

based on values in certain cells, I would like the infragistics web dialog to display in a modal state, allow the app to gather information in the dialog, then save that information, make the dialog non modal and hide it, then continue scrolling thru the spreadsheet.

The problem is that the dialog will not display, and I just continue rolling thru the spreadsheet

 

The code I'm using follows

 


        'Item Record Information

        Dim lRow As Long
        Dim iCol As Integer

        Dim iInterfaceRecordID As Integer
        Dim iInterfaceFileRecordID As Integer
        Dim sSegSeq As String
        Dim sItemSequence As String
        Dim sItemDescription As String
        Dim sDataType As String
        Dim sMaxLength As String
        Dim sName As String
        Dim sItemComments As String


        ''     Dim sCurrentRecSeq As String

        For iCol = 9 To xlWorkSheet.Rows(1).cells.Count  ' Col 9 is where the list of receiving applications starts

            If Trim(xlWorkSheet.Rows(1).Cells(iCol).text) <> vbNullString Then   ' Do nothing if no receiving application.

                Session("currrentrecseq") = xlWorkSheet.Rows(2).Cells(2).text   ' Row 2 is where data starts, row 1 is header

                For lRow = 2 To xlWorkSheet.Rows.Count    ' read the worksheet row by row

                    If Session("currrentrecseq") <> xlWorkSheet.Rows(lRow).Cells(2).text.trim Then     ' Compare the values, if different enter if block
                        ' write interface file item record record

                        Session("currrentrecseq") = xlWorkSheet.Rows(lRow).Cells(2).text.trim              ' reset the sequence
                        wDialogRecord.Visible = True                ' set dialog to visible
                        wDialogRecord.Modal = True                 ' set dialog to Modal, also set in properties
                        wDialogRecord.WindowState = Infragistics.Web.UI.LayoutControls.DialogWindowState.Normal     ' set window state to normal so it will show

                        ' when dialog shows, user fills out information and hits save button, which set dialog visible property to false, modal to false, and dialog window state to hidden

                    End If

                    If Trim(xlWorkSheet.Rows(lRow).Cells(1).text) = vbNullString Then Exit For ' Jump loop on Blank, END              

                    If xlWorkSheet.Rows(lRow).Cells(iCol).text = "X" Then                          ' If this column has an "X", then we need to save this record

                        If xlWorkSheet.Rows(lRow).Cells(1).text <> vbNullString Then           ' to account for a skipped row, or invalid data          

                            iInterfaceRecordID = xlWorkSheet.Rows(lRow).Cells(1).text           ' read values from spreadsheet
                            sSegSeq = xlWorkSheet.Rows(lRow).Cells(2).text
                            sItemSequence = xlWorkSheet.Rows(lRow).Cells(3).text
                            sItemDescription = xlWorkSheet.Rows(lRow).Cells(4).text
                            sDataType = xlWorkSheet.Rows(lRow).Cells(5).text
                            sMaxLength = xlWorkSheet.Rows(lRow).Cells(6).text
                            sName = xlWorkSheet.Rows(lRow).Cells(7).text
                            sItemComments = xlWorkSheet.Rows(lRow).Cells(8).text

                           ' Write the Interface File Record Item
                            SaveInterfaceFileRecordItem(Int(wNumInterfaceID.Value), Int(wNumRecordID.Value), sItemSequence, sItemDescription, sDataType, sMaxLength, sName, 999, sItemComments)
                        End If

                    End If

                Next

            End If

        Next

        xlWorkBook.Close()

Is this too much to ask from this dialog control. I have a open support incident when them and they have said the code looks like it should work, but haven't given me an answer why not.


LVL 1
jbhtghAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

derftoyCommented:
try  wDialogRecord.Show()

You have to call the show method for the dialog to show up.
0
jbhtghAuthor Commented:
derftov,

thanks for the help, but in version 9.2 this control doesn't have a show method.
0
derftoyCommented:
By any chance do you have this dialog within an AJAX UPDATE PANEL.  I had some problems with them not showing up correctly when inside one.  Of course I haven't moved to 9.2, since it is stuff like this that always breaks my code.  LOL
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

jbhtghAuthor Commented:
No, the dialog is just on the form.

What I've noticed today is that after I loop thru the entire spreadsheet, and there is no code executing, the dialog will appear.

it's sort of like that it doesn't have time to display when I'm reading the spreadsheet

But needless to say, that isn't acceptable.

thanks,
0
CodeCruiserCommented:
In winforms applications, we use Application.DoEvents function so that the application processes all its win messages (which include the updating of UI). In ASP.NET, this is not available. The problem i think is that the dialog is only displayed once the function completes executing and sends data back to the client.
0
jbhtghAuthor Commented:
I think you nailed it codecruiser.

Excel makes no difference, I ge the same results when I try to do the same thing reading an array.

It is an extremely slow dialog to display also. if i just put the code to display it behind a button it takes 3 seconds.

I am working with Infragsitics support but they have been no help.
0
CodeCruiserCommented:
I think you wont be able to show this dialog the way you are attempting. Would require some rearchitecting.
0
jbhtghAuthor Commented:
While I'm waiting to see what infragistics pulls out their butt, I am rearchitecting the application so I won't need the dialog.

Much heavier, but it's gotta work.

thanks
0
jbhtghAuthor Commented:
The real answer seems to be that you can't do it. I awarded points on the effort.

thanks,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Editors IDEs

From novice to tech pro — start learning today.