Connection String Errors HELP!!

Question

I am trying to connect to my Access database via Dreamweaver, asp.net c#.  I go to OLE connection, Build, In the Data link Properties, I choose Microsoft Jet 4.0 OLE DB Provider,   I click next, it then takes me to the connection tab where it says, Specify the following to connect to Access data 1. Select or enter a database name:.   I then browse to my database on my C:.  When I test connection, It's successfull!  I hit o.k. and it takes me back to the OLE DB Connection window, I input a Connection name, connection1,when I test there, it gives me this error….   Format of the initialization string does not conform to the OLE DB specification.  HELP.  I've been stuck on this for hours

Am I even in the right spot?  Should I be doing something different?

Answer 1

listView.Items.Add(fileName) will add the parent item in the list view. Then you'd issue, listView.SubItems.Add(subItem) to add subitems under the parent item in ONE row. Imagine how the Windows Explorer displays files. First Filename, Data, Size, etc etc. That's what it does. So, retrieve the data from using data reader and insert it right in the list view; listView.Items.Add(dataReaderReadItem); listView.SubItems.Add(dataReaderReadItemFromtheNextColumnInTheRow); If you need to do casting before adding..take care of that . Regards, JJ

Answer 2

Unfortunately it didn't.. :( What does the following line actually add in to the list view??? anything? listview.Items.Add(fileName); I am sort of new to all this so please forgive me.. I have a database which I can successfully connect to. I am trying to use the data reader to read records from a table and then populate this information in to the list view. I guess I don't understand how I can get the information from the DB... reader.GetInt32(0).tostring(), **as information for column 1 ** reader.GetString(1).tostring(), ** as information for column 2 **... etc.. Thanks, Bob

Answer 3

You'll have to add the columns first, which you know how. Then add subitems under the columns: Follow this: listview.Items.Add(fileName); //fileName is your parent Column listview.Items[count].SubItems.Add(size); //size is the child under the Parent Column listview.Items[count].SubItems.Add(date); //another child. so this will look like in ListView with 3 columns. First row is the column. File Name Size Date fileName1 size1 date1 fileName2 size2 date2 Hope that helps. JJ