DBConnectTester – Demo .NET app for connection string testing

(Updated 10/23/2016)

Level: Beginner

Source Code: https://github.com/vbp-ph/DbConnectTester

Programming Language: VB.NET (2010)

Required Skills: basic understanding of .NET libraries, Sub Procedures

Purpose: Test connection strings

Additional Packages:

Description:

This .NET windows form application demonstrate the following

  • Connect to the following database
    • SQL Server
    • Oledb
    • MySQL Database
    • SQLite (updated 10/23/2016)
  • Using Sub
  • How to use Link Label to create a google search link
  • Utilize clipboard

Sample Screenshots

When generating error message:

dbconnect_error1

When connection is successful:

dbconnect_ok1

Reference Materials:

https://dev.mysql.com/doc/connector-net/en/connector-net-programming-connecting-open.html

CRUD for VB 2008 using SQL 2008 R2 Database

I have a friend who was studying .NET last month. So i decided to create a quick project for her. it’s an address book application that demonstration basic database operation (CRUD – Create, Read, Update, Delete) by using stored procedures.

The U.I

The project was made using Visual Studio 2008 (i think you can use an Express Edition by downloading it here) and SQL Server 2008 R2 database.

Here’s the download link:
http://www.mediafire.com/?215bei4mkn6bbrl

http://1drv.ms/WXfh7H (reuploaded)