WIndows Forms Window Load method not completing

Question

So in my window onLoad method I am pre-populating a grid with values retrieved from a database. Here is the method below for the window load:

Private Sub winMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        ''#Load Grid
        Dim dt As New DataTable
        With dt
            .Columns.Add("Name")
            .Columns.Add("Frequency")
            .Columns.Add("Percent Spent")
            .Columns.Add("Started")
            .Columns.Add("Ends")
        End With

        Dim Budgets As New List(Of BudgetManager.DTO.Budget)
        Budgets = BudgetManager.Process.Budget.GetAllBudgets()

        Dim values(5) As String
        For Each budget In Budgets
            values(0) = budget.Name
            values(1) = BudgetManager.Lookup.GetLookupTextById(budget.FrequencyId)
            Dim total As Double = 0.0
            Dim spent As Double = 0.0
            For Each category In budget.Categories
                total += category.Amount
                spent += category.Spent
            Next
            values(2) = FormatPercent(spent / total)
            values(3) = budget.StartDate.ToString
            values(4) = budget.EndDate.ToString

            dt.Rows.Add(values)
        Next

        gridBudget.DataSource = dt
    End Sub

What happens is, when I press F5 to debug, the program loads, and the grid is still empty, just as it is without a datasource. When I try to step through the code, it actually reaches down to the line that reads

Budgets = BudgetManager.Process.Budget.GetAllBudgets()

and then stepping over this line...the window loads and it doesn't go any further in the method. What the line of code above does is eventually make a execution call of some SQL to a SQLite database, and the code gets to the point at which it calls the execute method, but doesn't even make the query yet. All the objects up until that point in the code are set properly as well (found through debugging and checking locals.)

What could be happening?

Edit:

Exception is this:

"Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information.

What the hell does this mean? Ha

See http://stackoverflow.com/questions/1604663/what-does-uselegacyv2runtimeactivationpolicy-do-in-the-net-4-config for the a possible fix for you mixed mode assembly exception. — Tim Murphy, Oct 12 '10 at 10:17
That solution actually didn't work for me for some reason... — Scott, Oct 14 '10 at 02:40

score 0 · Accepted Answer · answered Oct 12 '10 at 03:11

0

Best guess: your sqllite execute method fails and you have a global exception handler that's eating the error.

answered Oct 12 '10 at 03:11

Joel Coehoorn

399,467
113
570
794

Stepping through though it never even reaches the inside of the method. It fails on the call. – Scott Oct 12 '10 at 03:15
@Scott - try stepping into the line rather than stepping over it. – Joel Coehoorn Oct 12 '10 at 03:16
@Scott I suggest you write a unit test to test BudgetManager.Process.Budget.GetAllBudgets() is working as expected. – Tim Murphy Oct 12 '10 at 10:14

score 0 · Answer 2 · answered Oct 12 '10 at 04:20

If you manually added the column names to the Datagrid in the design mode then make sure the field names match those that are returning from the db, in this case your datatable.

You could also try binding the list directly

gridBudget.DataSource = BudgetManager.Process.Budget.GetAllBudgets(Of BudgetManager.DTO.Budget)()

WIndows Forms Window Load method not completing

2 Answers2