|
DataEasy_VB: Connect to MS Access (.mdb) Files Easily using VB.Net
|
Email
|
| Submitted on: |
1/21/2004 5:54:50 AM |
| By: |
Anas S. A.
|
| Level: |
Advanced |
| User Rating: |
By 49 Users |
| Compatibility: |
VB.NET |
| Views: |
80766 |
|
|
|
|
|
DataEasy_VB: is an application written in Visual Basic.Net (converted from the c# similar submission as some of you requested) which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your votes will be highly appreciated :).
|
 |
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 7 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 1/22/2004 1:49:19 PM: VyndroX
Real nice work! Rated it 5/5
(If this comment was disrespectful, please report it.)
|
2/5/2004 4:57:54 PM: Roger Reeder
Thankyou for the submission. Really hit the spot, 5 from me.
(If this comment was disrespectful, please report it.)
|
3/2/2004 10:15:58 AM:
Thanks! This showed me what I was doing wrong in my code. Great work!
(If this comment was disrespectful, please report it.)
|
3/28/2004 12:06:21 PM:
This is really great. Thanks a lot
(If this comment was disrespectful, please report it.)
|
4/19/2004 3:48:35 PM: Frank Macall
For all those beginner database programmers out there this is pure gold for software design. Simple and powerful code.
Five stars from me..
Thank you for sharing your work with us.
(If this comment was disrespectful, please report it.)
|
6/13/2004 11:35:27 AM:
This submission is an excellent piece of work! Great learning code:)
(If this comment was disrespectful, please report it.)
|
6/13/2004 7:08:31 PM: A Allen
Exelent code, 5 from me... but i'm new to this and i need it to be online... if anyone has any tips on how to do that please post it
(If this comment was disrespectful, please report it.)
|
8/14/2004 2:28:50 PM:
Excelente es lo que buscaba
(If this comment was disrespectful, please report it.)
|
8/14/2004 2:29:34 PM:
excelente
(If this comment was disrespectful, please report it.)
|
8/16/2004 2:54:36 PM:
Simple and powerful keep up the good work.
(If this comment was disrespectful, please report it.)
|
10/8/2004 1:31:25 PM:
Great database example. Has me rethinking a lot of things I do.
(If this comment was disrespectful, please report it.)
|
10/8/2004 1:37:52 PM:
Quick question, how to add Tooltips to the different labels and textboxes dynamically. I have tried several different things and keep having problems. Any suggestions would be appreciated.
(If this comment was disrespectful, please report it.)
|
1/16/2005 8:45:21 PM: David Dela Fuente Osita Jr.
Ur great like me - cheers!
(If this comment was disrespectful, please report it.)
|
2/12/2005 7:10:40 PM: HappyJ
It works, but it only has two forms and one custom class. It would be much more useable if the database was interfaced via its own class.
(If this comment was disrespectful, please report it.)
|
3/8/2005 2:52:15 AM:
It is really a good sample of database. Great job.
(If this comment was disrespectful, please report it.)
|
3/11/2005 2:22:25 AM:
cool code....i'm looking for this simple code long time ago...for a start
(If this comment was disrespectful, please report it.)
|
5/5/2005 4:36:19 PM:
It's great and works pretty good. If there is a code show how to create a ".mdb" file from scratch instead open and write to the existing one, then it will even much better.
(If this comment was disrespectful, please report it.)
|
5/8/2005 5:35:05 AM:
Awesome work, sure makes things a lot easier... you got a 5!
(If this comment was disrespectful, please report it.)
|
12/25/2005 3:22:15 PM: Seco
Excelente ! Good !
(If this comment was disrespectful, please report it.)
|
1/17/2006 10:59:00 AM: mac daddy enforcer
This is awesome
(If this comment was disrespectful, please report it.)
|
4/8/2006 3:13:51 PM: Carlos
This is the best code I have seen. Is very interesting... Thanks a lot
(If this comment was disrespectful, please report it.)
|
5/12/2006 3:38:57 AM: s
Excellent demo
(If this comment was disrespectful, please report it.)
|
5/16/2006 4:06:26 PM: Bryant
Awsome code... exactly what i need!
(If this comment was disrespectful, please report it.)
|
6/25/2006 4:09:35 AM: balachandran
Nice coding.
(If this comment was disrespectful, please report it.)
|
4/14/2007 6:38:39 AM: Dina
Very clear and easy to understand for a learner like me :)
highly Recommended
(If this comment was disrespectful, please report it.)
|
4/14/2007 6:39:09 AM: Dina
use it :)
(If this comment was disrespectful, please report it.)
|
11/28/2007 2:50:01 AM: kent
wow im new in vb.net tnx very much dude, you deserve to be the winner.
(If this comment was disrespectful, please report it.)
|
1/5/2008 5:39:03 AM: velmurugan
that is very nice thinging,
(If this comment was disrespectful, please report it.)
|
4/23/2008 6:34:02 AM: John Attfield
Very useful code. I like the data type detection routine.
(If this comment was disrespectful, please report it.)
|
8/6/2008 11:50:25 AM: synsuperior
Very nice application. 5 from me.
(If this comment was disrespectful, please report it.)
|
4/9/2012 7:22:15 PM: Roberto
Código maravilhoso.
Estava a muito tempo procurando por este exemplo.
Favor parabenizar o programador pois ele fez um trabalho muito meticuloso.
O designer é simples mais o conteudo é excelente.
Parabéns e obrigado.
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
