C#Express & Access DB not flowing to Form

Please support our C# advertiser: Intel Parallel Studio Home
Reply

Join Date: Nov 2007
Posts: 9
Reputation: globalizard is an unknown quantity at this point 
Solved Threads: 0
globalizard globalizard is offline Offline
Newbie Poster

C#Express & Access DB not flowing to Form

 
0
  #1
Sep 24th, 2009
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!
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,215
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 573
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: C#Express & Access DB not flowing to Form

 
0
  #2
Sep 25th, 2009
Make a copy of your access database, truncate the tables, add a test row in each table, and upload the database.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 9
Reputation: globalizard is an unknown quantity at this point 
Solved Threads: 0
globalizard globalizard is offline Offline
Newbie Poster

Re: C#Express & Access DB not flowing to Form

 
0
  #3
Sep 25th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,215
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 573
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: C#Express & Access DB not flowing to Form

 
0
  #4
Sep 25th, 2009
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.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 9
Reputation: globalizard is an unknown quantity at this point 
Solved Threads: 0
globalizard globalizard is offline Offline
Newbie Poster

Re: C#Express & Access DB not flowing to Form

 
0
  #5
Sep 26th, 2009
Originally Posted by sknake View Post
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.
duh, sorry, I was so stressed out & have been away from programming I thought you meant for me to try attaching the shorter DB. I have truncated from thousands to 220 on one table, the other 2 are smaller. There is a test row at the bottom of 2 tables, the state table auto aphabetized the testrow under T.

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.
Attached Files
File Type: zip TruncatedMED_SCHOOLS.zip (240.5 KB, 2 views)
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,215
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 573
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: C#Express & Access DB not flowing to Form

 
0
  #6
Sep 26th, 2009
I'll make a project for you with a grid and a screencast of how I did it. Will that work?
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 9
Reputation: globalizard is an unknown quantity at this point 
Solved Threads: 0
globalizard globalizard is offline Offline
Newbie Poster

Re: C#Express & Access DB not flowing to Form

 
0
  #7
Sep 26th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,215
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 573
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: C#Express & Access DB not flowing to Form

 
0
  #8
Sep 26th, 2009
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.
Attached Files
File Type: zip daniweb.medschools.zip (263.9 KB, 3 views)
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,215
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 573
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: C#Express & Access DB not flowing to Form

 
0
  #9
Sep 26th, 2009
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.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 9
Reputation: globalizard is an unknown quantity at this point 
Solved Threads: 0
globalizard globalizard is offline Offline
Newbie Poster

Re: C#Express & Access DB not flowing to Form

 
0
  #10
Sep 26th, 2009
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!
Reply With Quote Quick reply to this message  
Reply

Tags
access, c#, dbconnection

Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC