[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.3

Unhandled Exception

Asked by coperations07 in Visual Studio, .NET Framework 2.x, Miscellaneous Programming

Hi,
VB.Net/VS2005
I made an app. and it works fine on my pc, but when I put the executable on other pc's I get an 'unhandled exception' error message. It is a pretty generic looking error message. The error throws when the attached click event occurs.  I've been looking at putting a try/catch in somewhere, but I'm not sure where it would need to go or if this is what I need.
Please Advise...

Thanks,
Dave
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
Private Sub btnAccept_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAccept.Click
 
        If dgResults.Rows.Count = 0 Then
            MsgBox("cannot accept empty trailer.", MsgBoxStyle.OkOnly)
            Exit Sub
        End If
        'delete contents of tbl_Current_Wave from database.
        Dim oledbConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source='I:\Wave_Selection\Wave_Selection.mdb';Persist Security Info=False")
        oledbConnection.Open()
        Dim oledbCommand As New OleDb.OleDbCommand("DELETE * FROM tbl_Current_Wave", oledbConnection)
        oledbCommand.ExecuteNonQuery()
        oledbConnection.Close()
 
        'get julian date. prompt for trailor name. check if exists.
        Dim x As String
        Dim iCheck As Integer = 0
        'Dim sJulian As String
        'sJulian = Now.DayOfYear.ToString.PadLeft(3, "0")
        x = InputBox("Name the Trailor", "Trailor Name")
        If x = "" Then
            Exit Sub
        End If
 
        Dim stringSQL As String = "SELECT [WAVE] FROM tbl_Waves GROUP BY WAVE "
        Dim zAdapter As New OleDbDataAdapter(stringSQL, connectionString)
        Dim tCheck As New DataTable
        zAdapter.Fill(tCheck)
 
        Dim dview As DataView = tCheck.DefaultView
        For z As Integer = 0 To dview.Table.Rows.Count - 1
            If dview.Table.Rows(z).Item("WAVE") = x Then
                iCheck = iCheck + 1
            End If
        Next z
        If iCheck > 0 Then
            MsgBox("Trailor Name already exists", MsgBoxStyle.Exclamation)
            Exit Sub
        End If
 
        iSkip = iSkip + 1
        'Set datatable equal to the datagridview.
        Dim tSorter1 As New DataTable
        tSorter1.Clear()
        tSorter1 = dgResults.DataSource
 
        'set adapter to tbl_Current_Wave. Store dgResults data in tSorter.
        Me.Validate()
        Dim cn As New OleDbConnection(connectionString)
        cn.Open()
        mAdapter.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM tbl_Current_Wave", New OleDb.OleDbConnection(connectionString))
        Dim cb As New OleDb.OleDbCommandBuilder(mAdapter)
 
        'Add column that will hold wave name
        If Not tSorter1.Columns.Contains("Wave") Then
            Dim WAVE As DataColumn = New DataColumn("WAVE")
            WAVE.DataType = System.Type.GetType("System.String")
            tSorter1.Columns.Add(WAVE)
        End If
 
        'Insert name into wave column
        Dim dv As DataView = tSorter1.DefaultView
        For y As Integer = 0 To dv.Table.Rows.Count - 1
            dv.Table.Rows(y).Item("WAVE") = x
        Next y
 
        'Update Database 
        mAdapter.Update(tSorter1)
        cn.Close()
 
        'clear contents of grid.
        mAdapter.SelectCommand = New OleDb.OleDbCommand("SELECT * FROM tbl_Waves WHERE OAPS = 'Z' ", New OleDb.OleDbConnection(connectionString))
        Dim clearTable As New DataTable
        mAdapter.Fill(clearTable)
        dgResults.DataSource = clearTable
 
        'remove totals from dgvtotal.
        Dim iColumnCount As Integer = 7
        Do Until iColumnCount = 20
            dgvtotal.Item(iColumnCount, 0).Value = ""
            iColumnCount = iColumnCount + 1
        Loop
 
        'Show form with current wave selection
        If F9 Is Nothing OrElse F9.IsDisposed Then
            F9 = New frmVarify
        End If
        F9.Show()
        F9.Activate()
 
    End Sub
[+][-]04/30/08 02:10 PM, ID: 21474576Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: Visual Studio, .NET Framework 2.x, Miscellaneous Programming
Sign Up Now!
Solution Provided By: webtubbs
Participating Experts: 3
Solution Grade: A
 
[+][-]04/30/08 02:10 PM, ID: 21474568Assisted Solution

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 30-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]04/30/08 02:10 PM, ID: 21474569Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05/01/08 05:57 AM, ID: 21478107Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05/01/08 08:04 AM, ID: 21479290Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05/01/08 08:12 AM, ID: 21479356Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05/01/08 08:30 AM, ID: 21479547Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05/01/08 08:48 AM, ID: 21479758Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 / EE_QW_2_20070628