WIDatabaseSample

WIDatabaseSample is an advanced sample programing showing many of the major features of the WIDatabase libaray including low level examples of using the SQL Language directly

C# - WIDatabase\Samples\WIDatabaseSample\WIDatabaseSample.csproj

Databases - Samples to manipulate databases

Create - Creates a database

C# - WIDatabase\Samples\WIDatabase\Database\Create\Create.csproj
VB - WIDatabase\Samples\WIDatabase\Database\Create_VB\Create_VB.vbproj

Drop - Drops/deletes a database

C# - WIDatabase\Samples\WIDatabase\Database\Drop\Drop.csproj
VB - WIDatabase\Samples\WIDatabase\Database\Drop_VB\Drop_VB.vbproj

Exists - Checks if a database is already on the server

C# - WIDatabase\Samples\WIDatabase\Database\Exists\Exists.csproj
VB - WIDatabase\Samples\WIDatabase\Database\Exists_VB\Exists_VB.vbproj

Delete - Sample to delete data from database tables

Simple - Simple data deletion

C# - WIDatabase\Samples\WIDatabase\Delete\Simple\Simple.csproj
VB - WIDatabase\Samples\WIDatabase\Delete\Simple_VB\Simple_VB.vbproj

Multiple Wheres - Complex data deletion

C# - WIDatabase\Samples\WIDatabase\Delete\MultipleWhere\MultipleWhere.csproj
VB - WIDatabase\Samples\WIDatabase\Delete\MultipleWhere_VB\MultipleWhere_VB.vbproj

Insert - Insert data into database tables

Insert - Simple data insertion

C# - WIDatabase\Samples\WIDatabase\Insert\Insert\Insert.csproj
VB - WIDatabase\Samples\WIDatabase\Insert\Insert_VB\Insert_VB.vbproj

Multiple Inserts - Multiple inserts into database tables

C# - WIDatabase\Samples\WIDatabase\Insert\MultipleInsert\MultipleInsert.csproj
VB - WIDatabase\Samples\WIDatabase\Insert\MultipleInsert_VB\MultipleInsert_VB.vbproj

Select - Search for (SELECT) data from database table(s)

Simple - Simple search example

C# - WIDatabase\Samples\WIDatabase\Select\Simple\Simple.csproj
VB - WIDatabase\Samples\WIDatabase\Select\Simple_VB\Simple_VB.vbproj

Simple Where - Search with simple condition (WHERE) statement

C# - WIDatabase\Samples\WIDatabase\Select\SimpleWhere\SimpleWhere.csproj
VB - WIDatabase\Samples\WIDatabase\Select\SimpleWhere_VB\SimpleWhere_VB.vbproj

Multiple Where - Search with multiple conditions (WHERE) clauses

C# - WIDatabase\Samples\WIDatabase\Select\MultipleWhere\MultipleWhere.csproj
VB - WIDatabase\Samples\WIDatabase\Select\MultipleWhere_VB\MultipleWhere_VB.vbproj

Complex Where - Complex search (SELECT) sample

C# - WIDatabase\Samples\WIDatabase\Select\ComplexWhere\ComplexWhere.csproj
VB - WIDatabase\Samples\WIDatabase\Select\ComplexWhere_VB\ComplexWhere_VB.vbproj

Simple Join - Simple Joining (JOIN) of tables

C# - WIDatabase\Samples\WIDatabase\Select\SimpleJoin\SimpleJoin.csproj
VB - WIDatabase\Samples\WIDatabase\Select\SimpleJoin_VB\SimpleJoin_VB.vbproj

Complex Join - Complex Joning (JOIN) of tables

C# - WIDatabase\Samples\WIDatabase\Select\ComplexJoin\ComplexJoin.csproj
VB - WIDatabase\Samples\WIDatabase\Select\ComplexJoin_VB\ComplexJoin_VB.vbproj

Multiple Join - Multiple table Joins (JOIN)

C# - WIDatabase\Samples\WIDatabase\Select\MultipleJoin\MultipleJoin.csproj
VB - WIDatabase\Samples\WIDatabase\Select\MultipleJoin_VB\MultipleJoin_VB.vbproj

Simple Sort By - Simple sorting (ORDER BY) of result set

C# - WIDatabase\Samples\WIDatabase\Select\SimpleSortBy\SimpleSortBy.csproj
VB - WIDatabase\Samples\WIDatabase\Select\SimpleSortBy_VB\SimpleSortBy_VB.vbproj

Multiple Sort By - Sorting (ORDER BY) of result set using multiple columns

C# - WIDatabase\Samples\WIDatabase\Select\MultipleSortBy\MultipleSortBy.csproj
VB - WIDatabase\Samples\WIDatabase\Select\MultipleSortBy_VB\MultipleSortBy_VB.vbproj

Limit - Sample of limiting search results

C# - WIDatabase\Samples\WIDatabase\Select\Limit\Limit.csproj
VB - WIDatabase\Samples\WIDatabase\Select\Limit_VB\Limit_VB.vbproj

C# - WIDatabase\Samples\WIDatabase\Select\Offset\Offset.csproj
VB - WIDatabase\Samples\WIDatabase\Select\Offset_VB\Offset_VB.vbproj

Count/Distinct - Samples to return column counts and distinct results

C# - WIDatabase\Samples\WIDatabase\Select\Count\Count.csproj
VB - WIDatabase\Samples\WIDatabase\Select\Count_VB\Count_VB.vbproj

C# - WIDatabase\Samples\WIDatabase\Select\Distinct\Distinct.csproj
VB - WIDatabase\Samples\WIDatabase\Select\Distinct_VB\Distinct_VB.vbproj

C# - WIDatabase\Samples\WIDatabase\Select\DistinctCount\DistinctCount.csproj
VB - WIDatabase\Samples\WIDatabase\Select\DistinctCount_VB\DistinctCount_VB.vbproj

Table - Sample to manipulate database tables

Create - Create a table in a database

C# - WIDatabase\Samples\WIDatabase\Table\Create\Create.csproj
VB - WIDatabase\Samples\WIDatabase\Table\Create_VB\Create_VB.vbproj

Drop - Delete (DROP) a table from a database

C# - WIDatabase\Samples\WIDatabase\Table\Drop\Drop.csproj
VB - WIDatabase\Samples\WIDatabase\Table\Drop_VB\Drop_VB.vbproj

Exists - Check if a table is already created in database

C# - WIDatabase\Samples\WIDatabase\Table\Exists\Exists.csproj
VB - WIDatabase\Samples\WIDatabase\Table\Exists_VB\Exists_VB.vbproj

Update - Samples to update data within a table

Simple - Simple update of data

C# - WIDatabase\Samples\WIDatabase\Update\Simple\Simple.csproj
VB - WIDatabase\Samples\WIDatabase\Update\Simple_VB\Simple_VB.vbproj

Multiple Where - Update of table data using multiple conditions (WHERE)

C# - WIDatabase\Samples\WIDatabase\Update\MultipleWhere\MultipleWhere.csproj
VB - WIDatabase\Samples\WIDatabase\Update\MultipleWhere_VB\MultipleWhere_VB.vbproj

Error Checking - How to perform error checking

C# - WIDatabase\Samples\WIDatabase\ErrorChecking\ErrorChecking.csproj
VB - WIDatabase\Samples\WIDatabase\ErrorChecking_VB\ErrorChecking_VB.vbproj