|
DataEasy: Connect to MS Access (.mdb) Files Easily using C#
|
Email
|
| Submitted on: |
1/2/2004 2:49:27 AM |
| By: |
Anas S. A.
|
| Level: |
Advanced |
| User Rating: |
By 28 Users |
| Compatibility: |
C# |
| Views: |
31580 |
|
|
|
|
|
DataEasy: is an application written in C# 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 voting will be 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/2/2004 5:38:26 AM:
I found this code very useful and user friendly
(If this comment was disrespectful, please report it.)
|
1/3/2004 9:33:07 AM:
great work, i guess u have really worked hard, keep up your hard work n thanks for sharing..
(If this comment was disrespectful, please report it.)
|
1/3/2004 11:32:14 PM: José Alberca
great work
(If this comment was disrespectful, please report it.)
|
1/5/2004 8:06:29 AM:
Great work....
(If this comment was disrespectful, please report it.)
|
1/5/2004 10:49:34 AM:
nice work, but i wish i cud realate tables in your program... any way it deserves 5 stars.
(If this comment was disrespectful, please report it.)
|
1/7/2004 11:03:34 AM: ARTWARE_RE
DataEasy is an excellent idea and a very good work.
I am interested to discuss with you for an great enhancement of this code.
(If this comment was disrespectful, please report it.)
|
1/12/2004 2:45:40 PM:
hi
i found your code lovely and friendly
i give 5 big ones
i also have suggestion chao..... :)
(If this comment was disrespectful, please report it.)
|
1/20/2004 10:47:21 PM:
Can you write this code in vb.net
(If this comment was disrespectful, please report it.)
|
2/20/2004 7:54:22 AM:
Thank you for the sharing your codes. Do you have a vb.net version?
(If this comment was disrespectful, please report it.)
|
2/20/2004 11:30:55 AM:
Thanks for sharing this great application
(If this comment was disrespectful, please report it.)
|
4/30/2004 1:34:17 AM:
The usefullness of this code is paramount. Good Work!
(If this comment was disrespectful, please report it.)
|
5/28/2004 5:19:34 AM:
I'm a begginer, Kindly tell how to run this code.
Thx !
(If this comment was disrespectful, please report it.)
|
6/6/2004 12:59:17 PM: milorat
wow
(If this comment was disrespectful, please report it.)
|
1/11/2005 1:52:26 AM:
thank you very much!
(If this comment was disrespectful, please report it.)
|
6/8/2006 5:43:28 AM: Hasan
good work dude ...
(If this comment was disrespectful, please report it.)
|
9/4/2006 12:35:00 PM: Naveeen reddy
Thank you very much,this article is very nice
(If this comment was disrespectful, please report it.)
|
1/7/2007 12:29:29 PM: dungtd
Good Job
(If this comment was disrespectful, please report it.)
|
1/14/2008 5:02:19 PM: Bum
Great Code! 5 from me. Can this software be modified to be used with SQL or other database types?
(If this comment was disrespectful, please report it.)
|
6/23/2008 6:36:05 AM: Muthu
its helpfull to me
(If this comment was disrespectful, please report it.)
|
2/11/2009 8:10:06 PM: amix
tanks tanks <>
(If this comment was disrespectful, please report it.)
|
1/16/2010 5:21:19 PM: brutus
great work indeed ...thanks this is very very usefull
(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.
|
