Tutorials

If all you want to do is create a unique ID for a record, the auto_increment feature in MySQL will do the job nicely. Sometimes, however, you need more functionality. Unfortunately, unlike Oracle or PostgreSQL, MySQL doesn't have native support for the nextval() function, so creating real sequences is a little more challenging. First, we need to define what we want the nextval() function to achieve. We want to be able to begin the sequence with any number, and auto increment in multiples of any number, not just 1, including negative integers (-1 for example).

This is a simple database application. Using vb.net 2010, ms access 2007, crystal report 2008. The many options in this application such as: Insert, Update, Delete, Search, Navigation, DataGridView filteration, Patient code auto genration, Print Report etc etc... This tutorial for beginners only, like me.. I hope this application is very helpfull for any type of database application development in vb.net... So "Happy Programming"

Importing or Exporting a MySQL database sometimes using phpMyAdmin is a bit problematic especially if the size of your database exceed the maximum limit of PHP upload.

By following this two-part video guide you'll easily create a simple event calendar in pure Java. In the end you’ll get a nice-looking web calendar with a drag-and-drop UI, basic calendar views (day, week, month) and functionality.

A While Loop can do a repetitive task that an if…then statements can’t. Just like if…then statement, it checks whether the condition is true or false. There are two different usage of While loop.

Detecting the selected value of ComboBox is done by using the event like SelectedIndexChanged, SelectedValueChanged, and SelectionChangeCommitted. This event is being fired once you select a value in a ComboBox. However, if you have a ComboBox column in DataGridView control, you cannot easily use those events without adding a Handler.

This video tutorial will teach you on how to create a Master/Detail Windows Form using VB.NET. I used the Library System project to create this tutorial. You can access the source code at Library System in Visual Basic .NET 2008 and SQL Server 2008.

Only the Borrowing of books is being discussed in this video. The important is you will learn how to create a Dataset and drag it into you form.

This password generator is based on the class created by Obviex. The generator can create a unique password that does not include ambiguous character. It can create alphanumeric and special character password.

In some cases, you want to add new rows to the DataGridView programmatically. If you are using a data-bound DataGridView control, you cannot easily use the cells properties of the DataGridView control. All you need to do is use the dataset where the DataGridView control is connected.

Getting a value from a ListView is one of the most common questions I found on the Internet.

So, to help you find the value of a SelectedItem in your Listview, let’s take some example.

Supposed you have a Listview with the following column: