title: Vb.net NO value given for one or more given parameters
body: <pre><code>Dim cmd As OleDbCommand = New OleDbCommand(Sql, con)
  Dim strSql As String = "Select EmpName,Count(EmpName) from tblPO where OrderType='" &amp;
                             "B2B" &amp; "' and POExpireDate &lt; @LogDate Group By EmpName"
  Dim tstDate As DateTime = DateTime.Now
  Dim dateAsString As String = tstDate.ToString("dd/MM/yy")
  cmd.Parameters.AddWithValue("@LogDate", CType(dateAsString, String))
  Dim dtb As New DataTable
  
  Using dad As New OleDbDataAdapter(strSql, con)
      dad.Fill(dtb)
  End Using
  con.Close()
  </code></pre>
  
  <p>I'm working in VB.NET</p>
  
  <blockquote>
    <p>NO value given for one or more given parameters</p>
  </blockquote>
  
  <p>error coming while filling datatable..why...how could I fix this.
  pls help</p>