title: How to add item to the listview
body: <p>The <strong>Listview</strong> add Item's but the following <strong>error</strong> shows.</p>
  
  <pre><code>Overload resolution failed beacause no 'ADD' can be called with these arguments:
  
   'Public Function Add(text As String) As System.Windows.Forms.ListViewItem.ListViewSubItem':
      Argument matching parameter 'text' cannot convert from 'DBNull' to 'String'.
  
   'Public Function Add(item As System.Windows.Forms.ListViewItem.ListViewSubItem) As System.Windows.Forms.ListViewItem.ListViewSubItem':
      Argument matching parameter 'item' cannot convert from 'DBNull' to 'ListViewSubItem'.
  </code></pre>
  
  <p>THESE IS THE CODE: </p>
  
  <pre><code>ub loadReservedApplication()
      'Try
      Dim sql As String = "SELECT id," &amp; _
                  "(SELECT name FROM `applicants` WHERE `applicants`.`id`=`applicant_id` ) as applicants," &amp; _
                  "(SELECT filesize FROM `applicants` WHERE `applicants`.`id`=`applicant_id` ) as filesize," &amp; _
                  "(SELECT img FROM `applicants` WHERE `applicants`.`id`=`applicant_id` ) as pic," &amp; _
                  "(SELECT `jobTitle` FROM `jobs` WHERE `jobs`.`id`=`job_id`) as job,(SELECT count(*) FROM `applicants_doc` WHERE `application_id`= `job_applicant`.`id`) as docs,(SELECT `contact_number` FROM `applicants` WHERE `applicants`.`id`=`applicant_id`) as contact FROM `job_applicant`ORDER BY  `job_applicant`.`date` DESC "
      tb = execute_and_fetch(sql)
      Dim ctr As Integer = 1
      ListView1.Items.Clear()
      For Each r As DataRow In tb.Rows
          Dim lst As New ListViewItem
          ListView1.Items.Add(lst)
          lst.Text = ctr
          lst.SubItems.Add(r("applicants"))
          If IsDBNull(r("job")) Then r("job") = "N/a"
          lst.SubItems.Add(r("job"))
          lst.SubItems.Add(r("docs"))
          lst.SubItems.Add(r("contact"))
          lst.Tag = r("id")
          ctr += 1
      Next
      'Catch ex As Exception
      '    MsgBox(ex.Message)
      'End Try
  
  End Sub
  </code></pre>