| | |
C#Express & Access DB not flowing to Form
Please support our C# advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Nov 2007
Posts: 9
Reputation:
Solved Threads: 0
This is not a homework problem & my first post in 2+ years. I just got asked to do this in C# based on my asp & DB experience & I am tearing my hair out as they want in done in one day & 2 MS videos say to do the same thing & it does not work (at least does not display like their examples did.
I managed to get the Access Database connected (it checked out ok) and I actually can see the data in the tables in the C# IDE (solution explorer), but when I followed the Microsoft video steps telling me to create a dataset & then drag the table to a form, all I see is the empty table. The columns titles showed up fine, but when I went to build, no data shows up like in Beth's video, even though I can see the table data if I look at the table in the solution explorer (100's of lines).
I can't find any info on how to troubleshoot this, as it seems so basice, no one else has had this issue? I hope some one out there can help me figure out why I can't see the data in the Form Table. is there something in Properties that was not mentioned that I have to set to allow it to flow in?
TIA to all to try to help!
I managed to get the Access Database connected (it checked out ok) and I actually can see the data in the tables in the C# IDE (solution explorer), but when I followed the Microsoft video steps telling me to create a dataset & then drag the table to a form, all I see is the empty table. The columns titles showed up fine, but when I went to build, no data shows up like in Beth's video, even though I can see the table data if I look at the table in the solution explorer (100's of lines).
I can't find any info on how to troubleshoot this, as it seems so basice, no one else has had this issue? I hope some one out there can help me figure out why I can't see the data in the Form Table. is there something in Properties that was not mentioned that I have to set to allow it to flow in?
TIA to all to try to help!
Make a copy of your access database, truncate the tables, add a test row in each table, and upload the database.
•
•
Join Date: Nov 2007
Posts: 9
Reputation:
Solved Threads: 0
Tried to & get the same results. I can see the rows in preview, just not on the table. When I try to add data in CS, when i try to save, I get:
InvalidOperationException was Unhandled
Microsoft Jet.OLEDB.4.0 provider is not registered on local machine.
When I open the access db directly in Access I get a warning about unsafe queries or the like & suggesting that I install some this Jet thing, which I passed on since I know the database source is ok.
I read something about needing controls on the form, but Beth just dragged the table node 7 then hit build. No other controls, unless I missed something.
InvalidOperationException was Unhandled
Microsoft Jet.OLEDB.4.0 provider is not registered on local machine.
When I open the access db directly in Access I get a warning about unsafe queries or the like & suggesting that I install some this Jet thing, which I passed on since I know the database source is ok.
I read something about needing controls on the form, but Beth just dragged the table node 7 then hit build. No other controls, unless I missed something.
I asked you to do that so I would have a copy of your database tables that I could test on........ I don't see the database attached.
•
•
Join Date: Nov 2007
Posts: 9
Reputation:
Solved Threads: 0
•
•
•
•
I asked you to do that so I would have a copy of your database tables that I could test on........ I don't see the database attached.
From reading it seems that I was supposed to at controls to the form first, but the tutorial I was following did no such thing. I tried following the northwind tutorial even though its (the database-it came with either the C# program or the tutorial I downloaded) on my pc, & "ok" when I connect the database, when I tried to do a different exericse, I got an "access not allowed"error.
Didn't comprehend that you wanted the DB. Now I understand , but I had to zip it to upload. It is only 3 tables. Thanks.
•
•
Join Date: Nov 2007
Posts: 9
Reputation:
Solved Threads: 0
For someone w/a degree, it seems I do not comprehend english today.
First of all, thanks so much & I am really glad you are online at this hour as I am getting desparate trying to use tutorials that don;t work.
Does the grid mean steps of what to do?
I assume screencast means a video?
If yes to either, that sounds wonderful.
First of all, thanks so much & I am really glad you are online at this hour as I am getting desparate trying to use tutorials that don;t work.
Does the grid mean steps of what to do?
I assume screencast means a video?
If yes to either, that sounds wonderful.
Here is the project, I can't get the video to upload .. the forum keeps bombing out saying upload failed. Let me try it another post.
Ok the video won't attach, I will PM you a download link and please post back here or PM me when you're done so I can delete it.
•
•
Join Date: Nov 2007
Posts: 9
Reputation:
Solved Threads: 0
I just got the video to work. flash does not work in vista, unlesss you know how to go in & turn it on inside 6 layers of files. After 2-3 tries to reinstall, I googled & found out the proble, then had to find the solution, which actually worked.
I only watched the first few seconds to see that it worked, so I could report back that I got that far. Its a bit fuzzy, so its going to take me a bit to figure out what I am looking at & compare to to my project. (Honestly I am not complaining!!) Just give me some time to figure out what I am looking at & see if it makes sense.
I am not sure where these steps pick up/start: right after selecting a dataset? i think thats where I messed up cuz there was no drop down arrow to continue.
Starting to feel hopeful, thanks to you!
I only watched the first few seconds to see that it worked, so I could report back that I got that far. Its a bit fuzzy, so its going to take me a bit to figure out what I am looking at & compare to to my project. (Honestly I am not complaining!!) Just give me some time to figure out what I am looking at & see if it makes sense.
I am not sure where these steps pick up/start: right after selecting a dataset? i think thats where I messed up cuz there was no drop down arrow to continue.
Starting to feel hopeful, thanks to you!
![]() |
Similar Threads
- access events of form in UserControl (Visual Basic 4 / 5 / 6)
- Access to a master form, from a component class (C#)
- start access reports or form from vb6 (Visual Basic 4 / 5 / 6)
- How to show Access Table in a form (Visual Basic 4 / 5 / 6)
- Updating problem of Access DB in child form (C#)
- load data from access database into form (VB.NET)
- MS Access - Form question (MS Access and FileMaker Pro)
- VB6 & Access (user name, network printer, reminders) (Visual Basic 4 / 5 / 6)
- Access Linking a Form to a report (MS Access and FileMaker Pro)
Other Threads in the C# Forum
- Previous Thread: help in threading problem
- Next Thread: How to properly close a running Windows Form Process from a Service [C#]
| Thread Tools | Search this Thread |
.net 3.5 2005 access algorithm array asp.net c# check client code combo combobox commerce connection contorl control data database datagrid datagridview datastructure datetime development disabled dll drawing dropdownlist ecommerce editor error excel file form gdi+ http httpwebrequest index internet ip keypress label linux list login lookup mailmerge mal marshalbyrefobject messagebox module mono msword mysql net operator oracle panel photoshop platform post print problem programming record redirect region remote remoting reporting resource reuse richtextbox robot security silverlight sql sql-server sqlserver statistics stream study tcpclientchannel text textbox uploadatextfile usercontrol validate validation vb vb.net virus visual-studio web webdevelopemnt windows winforms wordautomation wpf write







