Answer Question
Trying to add date column to listview
I am trying to retrieve data from a table in MS Access with VisualBasic. When the Date data type is set to date/time in access, the queries run fine, but I receive an error and it will not populate the listview. When I change the data type to text it will populate the listview, but the queries return the wrong information.
-------------------------------------------------------
Error:
An unhandled exception of type
'System.Reflection.AmbiguousMatchException' occured in
microsoft.visualbasic.dll
Additional information: No accessible overloaded
'ListViewItemCollection.Add' can be called without a narrowing conversion.
--------------------------------------------------------
Dim cnnConnection As New OleDb.OleDbConnection
cnnConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Database.mdb"
cnnConnection.Open()
Dim strSQL As String = "SELECT * FROM TableName ORDER BY Date DESC;"
Dim adpDataAdapter As New OleDb.OleDbDataAdapter(strSQL, cnnConnection)
cnnConnection.Close()
Dim dstDataSet As New DataSet
adpDataAdapter.Fill(dstDataSet, "TableName")
Dim rowDataRow As DataRow
Dim litListViewItem As ListViewItem
For Each rowDataRow In dstDataSet.Tables("TableName").Rows
litListViewItem = lvwListView.Items.Add(rowDataRow("Date")
itListViewItem.SubItems.Add(rowDataRow("Item1"))
itListViewItem.SubItems.Add(rowDataRow("Item2"))
itListViewItem.SubItems.Add(rowDataRow("Item3"))
Next
TEXT
Uploading file and scanning for virus...
Please Wait