VistaDB.Net

Looking for help learning how to program Dot Net database applications using VistaDB?     You've come to the right place!

NUnit Samples

The NUnit sample project is written in C# and is a fast way to see specific programming features in small chunks of code.  If you are not familiar with NUnit or unit testing it may seem a little strange at first, but the format is pretty easy to understand.  The unit tests are functional examples of how to perform certain database related tasks using only code, there are no databound or visual controls used. 

VistaDB Training Videos

We have a video VistaDB Training Channel on YouTube with tutorial videos for learning VistaDB.  We do create videos on the channel for user requests also, so you may see lots of introductory video topics.

Your First App Quickstart

Your first app tutorial shows how to build a basic databound Winforms application using Visual Studio. A screen captured version is also available to view.   This example is written in C#, but should be easy to follow for VB.Net programmers as well since most of the demo is using Visual Studio databound controls.

Insert SQL records sample

This sample was written for a user on our forums who wanted to know how to insert 30000 records in a table.  The sample uses DDA and SQL methods to demonstrate both processes.  The SQL uses parameterized queries to demonstrate that concept as well.

VB.NET Insert Database Sample - Visual Studio 2008 solution showing how to insertrows into a sql database using SQL parameters and DDA.

C-Sharp Insert Database Sample - Visual Studio 2008 solution demonstrating sql row insertion using SQL parameterized queries and DDA access methods.

Tutorial posts from our blog

Visit the Tutorial section of our blog to view all the articles tagged as tutorial.

Import data into VistaDB

Starting Data Conversion with NorthwindEF

For many years the Northwind database was the benchmark app for many different database vendors. This database was a sample provided with Access by Microsoft (we offer it for download from our public downloads site).  We are now using the NorthwindEF database (which is an updated version including FK's for Entity Framework support).

Many users have used it to learn the basics of database design and coding.  VistaDB can convert the complete Northwind database to VDB4 format (including views, although many of the views in the NorthwindEF database are broken in the original database). 

This tutorial is a walkthrough of how to convert the database and view the data after conversion.  The conversion takes place with the Data Migration Wizard included in VistaDB. 

We also include the full C# source code for subscribers.  You can also use this convertor to convert data from Access, SQL CE, or SQL Server to VistaDB.  The application support command line parameters as well for running inside a setup app or deployment scenario (not included in Lite or Personal Editions).

CLR Procs Tutorial

During the coding of CLR Procs this tutorial was built as a quick walk through for existing users to understand how to build and use CLR Procs.  The data included in this tutorial is slightly out of date, but it may be of interest for those learning CLR Procs.

CLR Procs Tutorial - Screencast and sample project for CLR Procs

Check your local help

Please also check in your local help files for more information and HOWTO articles.  The main help file can be brought up by pressing F1 in the Data Builder, or from the start menu.  An online version of the help file can also be found here.

Visual Studio Database Programming

There are a number of different ways to program databases in Visual Studio using VB.Net or C-Sharp.  Visual Studio has the databound controls, which are often used in Microsoft examples as ways to program databases. These databound controls are often great for quickly getting an application prototyped.

Something you need to learn?

Do you have a database related programming task you need help learning?  Visit our forums and post in the Examples forum.  We have a large community of users who might be able to explain or even help with code.  In addition we have a number of sample applications for database programming in the forum already.