.Net Stats:

How to support the site


Site Wide Message: (current site time 7/31/2010 5:38:05 AM EDT)
  • We want your input! One of our sponsors wants to know your opinion about development related issues. Click here to tell us what you think.
  • Are you an emerging/young developer (aged 18-30)? If so, would you like the chance to affect future developer tools and products?
    If so, then click here to give your feedback.
 

MySQL Front

Print
Email
winzip icon
Submitted on: 4/19/2010 8:36:54 AM
By: C. David Hamilton  
Level: Intermediate
User Rating: By 1 Users
Compatibility:VB.NET

Users have accessed this code  13030 times.
 
author picture
(About the author)
 
     UPDATE 4-20-10, recompiled in vb2008. Working on a SQLEditor that uses a semitransparent drag control, intellisense with listboxitem tooltip. Still alot to make and fix. You will need the connector found at http://dev.mysql.com/downloads/connector/odbc/5.1.html. An almost complete rewrite of my original code. It is far from complete. It only has some basic functionality at this point and probably full of errors. It works pretty well with MySQL 4 and somewhat with MySQL 5. It uses a plug-in architecture. It is best for local host use, although there is the ability to do all the updates at the end. Swapping from table to table is slow though. I have been using to go between version 4.?, 5.0, and 5.1. Some ajustments still need to be made.
 
winzip iconDownload 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:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. 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...   
  1. 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.
  2. 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.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 20 submission(s) by this author

 

 
 Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:
 
Your Vote!

What do you think of this code(in the Intermediate category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
Other User Comments
2/4/2005 8:07:28 PMGustavo Leal

Excelent code,
could be great if work with most recently version of MySql.

(If this comment was disrespectful, please report it.)

 
3/2/2005 12:55:13 AMC. David Hamilton

Thanks. Planning on doing some more work on it and updating it for compatability with this and new version. But been very busy.
(If this comment was disrespectful, please report it.)

 
6/8/2005 3:15:33 AMC. David Hamilton

I am currently working on the new "safe" version (4.1) and getting ready to update the post for those MySQL users out there. Thanks for the interest and the feedback..any ideas, please post them.
(If this comment was disrespectful, please report it.)

 
6/29/2005 10:56:47 PMC. David Hamilton

It seems that the problem when going to
the newer version maybe the ODBC
connector. Make sure you have the
latest version found at
http://dev.mysql.com/downloads/connector
/odbc/3.51.html . I found that is started to work if I installed MySQL Administrator. If there are other
problems please let me know what the
issues are. Thanks.
(If this comment was disrespectful, please report it.)

 
3/7/2006 5:21:07 AMC. David Hamilton

I have been working on a new version. I have decided to make the interface a little more professional such as menus with icns, cleaner user controls, import/export of access files, fixed the printing of the datagrids, and tools to use versions 4 and 5 of MySQL DataBase. Due to some of these changes I have to rewrite a lot of code and it is taking a bit of time. Like many people here, I can't dedicate very much time to side code because of other work. I hope to have it up in a couple of weeks..even if it just a rough draft that is at least workable. If people are interested in the menu with icons or the fixed datagrid printing, please post and I will put in project for these items.
(If this comment was disrespectful, please report it.)

 
3/9/2006 10:09:21 PMfadi

ty
(If this comment was disrespectful, please report it.)

 
3/25/2006 3:25:40 AMC. David Hamilton

I have noticed a probelm with updating records..I am currently working on it. I will have a fixed version up as soon as I can.
(If this comment was disrespectful, please report it.)

 
4/4/2006 6:59:39 AMC. David Hamilton

Thanks for all the interest in this project. I am still amazed how this little personal thing has become such a task/obsesion. I am sure some people have noticed that I am giong to add a access conversion to htis project. I ahve found some other small issues, but I am going to try to get the access conversion done before I upload the new version. I will be adding in support for csv files also, but I think I am goin to go a safer route than what I have seen available so far. I am in the planning stages on it, so it may be a little bit. Thanks again and as always feedback is always good. Suggestions and ideas are always welcome.
(If this comment was disrespectful, please report it.)

 
5/16/2006 12:44:49 AMDon Steele

It does not seem to work with visual studio express 2005. once i convert all the projects over it gives a ton of errors about not being able to refrence all the custom controls. I am very interested in this project.
(If this comment was disrespectful, please report it.)

 
9/14/2006 2:46:18 AMC. David Hamilton

The 2005 problems is intersting, but I have not update to that version yet. I will see what happens. I have been spending a lot of time with fixing bugs, new controls, updating controls, and whatnot. I asm working the issue of nulls with dates at this time along with a more professional interface. It is getting close a new release with older version od MySQL in mind. Once that is cool I will add in the new things that the new versions of MySQL has to offer. The .Net 2005 will be address soon hopefully. But I would like a better understanding of the issues.
(If this comment was disrespectful, please report it.)

 
11/2/2009 7:16:52 PMC. David Hamilton

I hadn't look at this for a long time. But I recently needed it and found that there are tons of errors. If you try to use the new version of the ODBC you will be cursing up a storm. But since I am going to need my front end again I am working on a rewrite.
(If this comment was disrespectful, please report it.)

 
5/13/2010 3:46:32 PMCharlie

Excellent
(If this comment was disrespectful, please report it.)

 
6/3/2010 1:58:35 AMC. David Hamilton

Thank you. Still have a lot to do. I have gotten rather side tracked. I can not get the SQL editor to a point that I like and is stable. Hopefully I will be able to complete more of the basics soon.
(If this comment was disrespectful, please report it.)

 
Add Your Feedback!

Note:Not only will your feedback be posted, but an email will be sent to the code's author from the email account you registered on the site, so you can correspond directly.

NOTICE: The author of this code has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.
 
To post feedback, first please login.