Linglom.com

Perform SQL Operations

From the previous part, I have successfully connect to world database on MySQL Server from VB.NET. Next, I try to perform basic SQL operations (SELECT, INSERT, UPDATE and DELETE) on the world database.
Note: This post is continued from the previous part. If you start a new project, you’ll need to add MySql.Data reference. See the previous post for more detail.

Read the rest of this entry »

Create Connection

After I have prepared many things for showing how to access MySQL Server using VB.NET. Let’s see what I have done so far. Right now, I have a remote MySQL Server at 192.168.125.21 with port 3306 (Default port). Also, a sample database “world” and a user account “worldUser” with password “worldpassword”. Now it’s time to start Microsoft Visual Studio 2005 on a development PC.

Read the rest of this entry »

Install MySQL Connector Net

From last 4 parts, I have prepared MySQL Server with sample database. I’ve done on a database PC. Next, I’ll move to a development PC. Assume that I have already installed Microsoft Visual Studio 2005 already. Now I need to download and install MySQL Connector/Net 5.2 on a Development PC which is a library for connect to MySQL Server from .NET Application.

Read the rest of this entry »

Create & Grant MySQL User Account

By default, the root account on MySQL Server has all privileges on every tables on MySQL Server but only localhost can have accessed (remote access is not allowed) and it is recommend to use other user account rather than root account to perform operations on MySQL Server (for security issue). Therefore, you should create a new user account on MySQL and grant at least privileges for the account as possible.

Read the rest of this entry »

Install Sample Database

You can download example databases for MySQL at http://dev.mysql.com/doc (Scroll down to Example Databases section). By the time I’m writing the article, there are 4 sample databases available on the page. I choose the world database since it compatible with all MySQL version.

Read the rest of this entry »

Setup MySQL Server

This section I’ll show how to setup MySQL Server on a database PC. You can see index of this series at Accessing MySQL on VB.NET using MySQL Connector/Net, Part I: Introduction

Read the rest of this entry »

Introduction

Here comes again, tutorial about programming to access a database server. This tutorial shows you how to use Microsoft Visual Studio’s VB.NET to connect MySQL using MySQL Connector/Net.

Read the rest of this entry »

Introduction

When you create a store procedure on Microsoft SQL Server with some input parameters, sometimes you don’t want to assign all of parameters (optional parameters) so you need to specify default value for the parameters. Otherwise, it shows error when execute the store procedure.

Read the rest of this entry »

This post, I’ll cover only in the second section “Create ASP.NET Web Application on MS Visual Studio 2005 (C#)”. I’m not going to repeat other sections again since they’re same as in the previous post. The other sections can be found in “Create Dynamic RSS Feed from MS SQL Server using ASP.NET, Part I: VB.NET”.

Read the rest of this entry »

Introduction

Before I started, let’s get to know what RSS is.

Quoted from Wikipedia.org Read the rest of this entry »

Microsoft BizTalk server provides a predefined set of macros to help in create output filenames on File send handler. If you working with sending output as a file, you’ll find these macros are really useful that you don’t have to coding any statement to get these value. These macros can be found on MSDN library but I sometimes find it’s time consuming to search on MSDN every time I forget the macro. Therefore, I decide to quote the table from MSDN to this post instead.

Read the rest of this entry »

Introduction

From previous part, you’ve learned to develop a simple windows service on Microsoft Visual Studio 2005 and how to create a setup wizard for install the service. But it wouldn’t be complete, if you don’t know how to debug a windows service while you’re developing a windows service. This part is about how to debug a windows service.

Read the rest of this entry »