Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Closed Points: 25 Time: 18:37 - Apr 24, 2007
aristud
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
Categories:
Add Categories
When adding more than one category, separate them with commas.
nidhi
Date:: Apr 25, 2007
Time:: 04:15
I dont know if it will work with vb.net but u can tweak the SQL that u use and format the date eg Dim strSQL As String = "SELECT f1, f2, f3, format(f4,'Short Date') FROM TableName ORDER BY f4 DESC;"
Time:: 04:32
yes it should work, I tried it in C#
I used OleDbCommand and OleDbDataReader to read it and treat the datefield as a string i.e. OleDbCommand oleCmd = new OleDbCommand("SELECT format(mydtefld,'short date') FROM tblDates", oleConn); and gettting that value worked like this Console.WriteLine(oleRead.GetString(0).ToString()); so yes, u should be able to use the format command. It does mean u have to specify each column in your query though
PeterNZ
Date:: Apr 26, 2007
Time:: 15:25
One note: oleRead.GetString(0) returns a string, so why do you add a .ToString() to it? Cheers Peter
Time:: 17:45
Thanks!
Question Answered
This question has been closed, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
whats the best food to eat during midnight?
How to identify the tiffany jewelry? www.tffanycheapmall.com.
Send an email alert to each user of the php application based on criteria
How I Increased My AdSense Earnings?
how to choose the lady dress ?
How can I fulfill the minimum requirement to make your computer support 3D?
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software