Topics

Store-Retrieve binary data (BLOBs – Audio, Video, Image, Exe, etc) in database in VB Net

There are many scenarios in which we require to store some kind of binary data in the database. This data may be anything from an image, to audio, video, executables, xml files, multi lingual data files and so on. This discussion presents the simplest and perhaps the shortest way to do this in VB.NET.

Continue reading Store-Retrieve binary data (BLOBs – Audio, Video, Image, Exe, etc) in database in VB Net

Clear all database tables – VB DDL

This is a simple example demonstrating how to use SQL Data Definition Language (DDL) commands in vb.net. In a now distant past, I used to need a code to clear all the tables in a MS Access database. This code is particularly quite useful during the testing phase when the database becomes fat with ‘dummy’ data.

Continue reading Clear all database tables – VB DDL