Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 17

Displaying posts with tag: VB.NET (reset)

Hidden Features Of Perl, PHP, Javascript, C, C++, C#, Java, Ruby, Python, And Others [Collection Of Incredibly Useful Lists]
+2 Vote Up -0Vote Down


StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of joelonsoftware.com, Jeff Atwood of codinghorror.com, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

The Story

Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to

  [Read more...]
New Spanish Translations
+0 Vote Up -0Vote Down

Thanks to Leonardo Villamil Gamba, there are new Spanish translations of Article Four and Article Five in the popular VB.NET/MySQL article series.

See all the Spanish translations at http://www.vbmysql.com/articles/espanol/.

Google Translated:

Los gracias al espicanardo de Leonardo Villamil, allí son nuevas traducciones españolas del Article Four de Article Five. Ver todas las traducciones españolas en el

  [Read more...]
Connector/NET 5.0.1
+0 Vote Up -0Vote Down

Looks like we have a new version. From the announcement:

MySQL Connector/Net 5.0.1 Beta has been released. MySQL Connector/Net is an all-managed ADO.Net provider for MySQL. While this release is suitable for any version of MySQL, it is strongly encouraged that this release not be used on any production data. This release is feature complete with the exception of DTC support in System.Transactions.

It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can’t find this version on some mirror, please try again later or choose another download site.)

The following major changes

  [Read more...]
Visual Studio Integration has Arrived
+0 Vote Up -0Vote Down

One common request I see is for better integration between MySQL and Visual Studio, allowing developers to manage MySQL databases from within VS. Well, the wait is over, announcement to follow:

Today we have released the first build of MySQL Tools for Microsoft Visual Studio — a downloadable plug-in for Visual Studio 2005 that allows Windows developers to quickly build MySQL data-driven applications with Visual Studio. With this plug-in, developers will be able to create, modify and manage MySQL database objects with an easy-to-use interface from within the Visual Studio IDE. This product is delivered as a package compatible with Visual Studio 2005 and delivers the following features:

  • DDEX (Data Designer Extensibility) compatibility
  • Ability to work with MySQL objects (tables, views, stored procedures, etc)
  [Read more...]
Connector/NET 5 ? Go Forth and Test!
+0 Vote Up -0Vote Down

The wait is finally over, MySQL Connector/NET 5 is here!


MySQL Connector/Net 5.0.0 Alpha 1 has been released. MySQL Connector/Net is an all-managed ADO.Net provider for MySQL.

While this release is suitable for any version of MySQL, it is strongly encouraged that this release not be used on any production data. This release has some features that are not yet complete and a few test cases that are not passing but is being made available to the public to gather feedback for the beta phase. Please see below for a list of the areas that are not complete or are not working.

It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html
and mirror sites (note that not all mirror sites may be up to date at this point of time - if you

  [Read more...]
New Design at VBMySQL.com
+0 Vote Up -0Vote Down

I’ve introduced a new design and Wordpress backend at www.vbmysql.com, feel free to take a look and provide feedback. Now that editing will be easier I think I’ll be pushing out some fresh content too.

New VB.NET/MySQL Article Online
+0 Vote Up -0Vote Down

There is a new entry in the developer notes series, available at


This one covers managing hierarchies using stored procedures and the nested set model.

.NET Sessions at the MySQL UC 2006
+0 Vote Up -0Vote Down

There are four .NET specific sessions at the MySQL User Conference this year:

Tuesday, April 25th, 2006

Creating .Net Applications with Linux and MySQL
Matt Lord, Support Engineer, MySQL AB

MySQL and Windows: Playing Well Together
Reggie Burnett, Software Developer, MySQL AB

Wednesday, April 26th, 2006

MySQL Connector/Net: Work the Way You Want To!

  [Read more...]
New Article
+0 Vote Up -0Vote Down

I have completed another article in my series of VB2005/MySQL developer notes.


MySQL Connector/NET 1.0.7
+0 Vote Up -0Vote Down

Connector/NET 1.0.7 has been released.

It is available at http://dev.mysql.com/downloads/connector/net/1.0.html

This looks like a bugfix release, so if you have encountered any bugs in a previous version you may want to upgrade.

Kudos to Reggie for another great release!

Starting a New Article Series
+0 Vote Up -0Vote Down

Several months ago I finished a series of articles on Visual Basic.NET and MySQL. I have decided to start a new series that will focus more on new features of MySQL 5 and Visual Basic 2005.

The first installment is up at this link and will hopefully be the start of a useful series.

Visual Studio 2005 Express Editions are Free (as in beer)
+0 Vote Up -0Vote Down

Looks like Microsoft will be offering the express editions of its Visual Studio 2005 products for free* for one year.

The download is available at http://msdn.microsoft.com/vstudio/express/default.aspx

There is a good feature comparison also available at http://msdn.microsoft.com/vstudio/products/compare/

I've done a few quick and dirty VB.NET/MySQL apps with the VB2005 Express Edition, and I find it handy. I will want to get into the VS Professional edition as some point just to play with PocketPC, but for now the Express edition is good for the tinkerer in me.

* For the first year, free as in beer, not speech, some conditions apply, offer not valid in all areas, YMMV.

Connector/ODBC Version 5 Now Available
+0 Vote Up -0Vote Down

It is still in Alpha, but you can now download Connector/ODBC version 5 from dev.mysql.com!


This is a pretty serious rewrite of the old Connector/ODBC, so please take some time to test and report bugs at bugs.mysql.com.

Cancel the Display of a ContextMenuStrip in VB.NET 2005
+0 Vote Up -0Vote Down

I encountered a bug recently in my tool where I could right-click on a listview, even if I was not right-clicking on a listview item, and still use the item related entries of a contextMenuStrip. The problem is that unlike the TreeView, the ListView does not allow you to assign a ContextMenuStrip to individual items, just the control as a whole.

The solution was to use the new Opening event of the ContextMenuStrip:

Private Sub eventMenu_Opening(ByVal sender As Object, _
ByVal e As System.ComponentModel.CancelEventArgs) Handles eventMenu.Opening
        If lvwEvents.SelectedItems.Count = 0 Then
            e.Cancel = True
        End If
End Sub

By setting e.Cancel to True, the menu is never shown. I determine whether an item was clicked on by checking the count of selecteditems.

Determine User Idle Time in VB.NET
+0 Vote Up -0Vote Down

While working on a new feature for my time tracker, I needed to be able to determine how long a user had been idle using VB.NET (so that if I walked away without punching out, the tool could prompt me and punch me out retroactively upon my return). There are a lot of convoluted ways to do this involving a lot of hooks, but there is a nice LASTINPUTINFO call in User32.dll that can be used to accomplish the task with a minimum of coding.

The only limitation is that the call is only available as of Windows 2000, but that is not a concern for me, and I can just disable the functionality for users of earlier versions of Windows.

I have posted a class I found that takes advantage of LASTINPUTINFO for VB.NET at http://www.vbmysql.com/samplecode/idle-time.html.

Using My.Settings and Data Binding to Create a Configuration Form
+0 Vote Up -0Vote Down


While working on a new project recently, I have been adding various items to the My.Settings collection, which I documented previously in my VB/MySQL tutorial series. I reached the stage in my application where I needed to add an actual configuration form to my application, and I wanted to create one with as little effort as possible. I found that with the new My.Settings collection in Visual Basic.NET 2005 (aka Whidbey) this was even easier than expected.

About My.Settings

The My.Settings collection is a new addition to VB.NET 2005, as part of the new My. namespace. My.Settings provides an easy way to persist user and application settings in XML without

  [Read more...]
So What am I UpTo?
+0 Vote Up -0Vote Down

Aah vacation, a time when married men spend 8 hours a day doing the whim of their wife instead of their company. My vacation started yesterday (or last Friday if you count the Canadian national holiday), and so far I have taken in a parade and done little else.

One thing I am working on is a time tracker tool for myself. I wanted something that was simple that I could develop as a practice project which would be of use to me:

In essence it will be a simple Open Source time tracker/punchclock tool. I am using VB.NET with MySQL 5, SQL trees for managing the project hierarchy, and a nice helping of views, stored procedures, and the like.

This should be handy for keeping track of what I do in a given

  [Read more...]
Showing entries 1 to 17

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.