when I run program to display records from database to listview i encountered a problem in immediate window and it says:
A first chance exception of type 'System.Reflection.AmbiguousMatchException' occurred in Microsoft.VisualBasic.dll
I encountered that problem when one of my data field in recordset is null and the program doesn't display accurately
here is my code:
Expand|Select|Wrap|Line Numbers
- Public cn As New MySqlConnection
- Public recurring As String
- Public Sub LoadEvents()
- On Error Resume Next
- Dim str_2 As String = "SELECT * FROM tbl_event ORDER BY Date"
- Dim rsEvent As New MySqlDataAdapter
- Dim SQLCommand As New MySqlCommand
- Dim TABLE As New DataTable
- Dim i As Integer
- With SQLCommand
- .CommandText = str_2
- .Connection = cn
- End With
- With rsEvent
- .SelectCommand = SQLCommand
- .Fill(TABLE)
- End With
- LVEvList.Items.Clear()
- For i = 0 To TABLE.Rows.Count - 1
- With LVEvList
- .Items.Add(TABLE.Rows(i)("ID"))
- With .Items(.Items.Count - 1).SubItems
- .Add(TABLE.Rows(i)("Event_Name"))
- .Add(TABLE.Rows(i)("Venue"))
- .Add("" & Format(TABLE.Rows(i)("Date"), "MMM dd, yyyy"))
- .Add("" & Format(TABLE.Rows(i)("Time"), "Long Time"))
- .Add(TABLE.Rows(i)("Category"))
- .Add(TABLE.Rows(i)("Recurring"))
- End With
- End With
- Next i
- End Sub
- Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
- If cn.State = ConnectionState.Closed Then
- cn.ConnectionString = "SERVER = localhost; USERID = root; PASSWORD=; DATABASE = clsf_member_information;"
- cn.Open()
- LoadEvents()
- End If
- End Sub