MYSQL

How to Concatenate Column Values from Multiple Rows

Submitted by admin on

Just want to share with you on how to concatenate or combine one or more values from multiple rows. This SQL code is part of my “Online Hotel Reservation” project.

The idea here is to group column values while concatenating the other column to avoid duplicate records.

Here’s an example:

I have the following record on my table:

Simple Login using Visual Basic 2010 (SQL Server database)

Submitted by EmbuscadoGeoff on
Simple Login System using Visual Basic 2010. The File-type for its database is SQL SERVER. This Project is for beginners specially for those who are developing System and finding their security purposes for their System using in Visual Basic 2010. This is for Education purposes. Mabuhay Filipino Programmers~!

Salon System using visual basic .net and SQL server

Submitted by thesis2425 on
Im selling the complete source code of the SALON SYSTEM for your thesis, with also the database and a free configuration to your computer. Free technical issue consultation Program was coded using Visual Basic .net 2011 and SQL Server 2008 as database. Report was created using Reporting Services. SYSTEM HAS BEEN DESIGNED FOR A TOUCH SCREEN MONITOR Flow of the system:

Scheduling System

Submitted by may ann on
This is a system called Online Scheduling System made as one of the requirements in school.. uses Sessions for logging in and out [user authentication]. Has Add, View, Edit, delete information related to scheduling such as room, subjects, course, teacher.. etc.. Has a functionality to add, view and delete schedules.

CheckBox Control with MySQL

Submitted by admin on
Another source code on how to populate a CheckBox control with data, this time by using MySQL. In order to run this program you need to install the database included in the TreeView Control with MySQL. This program needs the Products table from the Northwind database which I ported to MySQL. Again the purpose of this code is to show you how to easily populate checkbox control with data. For more

ComboBox Control with MySQL

Submitted by admin on
This program will use the database from the previous source code called DataGridView Control with MySQL. You can use this program without downloading the previous source code by importing the SQL file to the northwind database. If you like you can use different name for the database. Just make sure to change the connection string to the name you choose. I just modified the source code from our

TreeView Control with MySQL

Submitted by admin on
While I was trying to convert TreeView Control to work with MySQL I encounter an error with concurrent connection using DataReader. The error message was “ There is already an open DataReader associated with this Connection which must be closed first”. Even the Microsoft KB does not help in solving this problem. The workaround on this problem is to create another connection to avoid this error

DataGridView Control with MySQL

Submitted by admin on
I received a lot of email if I can make a tutorial on how to connect VB.NET with MySQL. So here it is. I am planning to continue this tutorial that is similar on my previous article on Database Programming Made Easy. The only difference with the previous one is that I will be using MySQL instead of MS Access and MS SQL Server. This tutorial will teach you how to connect Visual Basic .NET 2008 to

Simple remote MySQL database in VB Application

Submitted by emond on
a simple database app that can be used to manipulate your website's MYSQL database, applicable in administrating your web databse from your Windows based PC .Connection is via MySQL ODBC 3.51 Driver. CAn perform CRUD and it shows how to connect and query records in a remote server (for this sample i used www.freesql.org) using ADOdb control and datagrid to show data from remote server.. I'll Post