© 2010, DataObjx L.L.C. Meriden Connecticut USA
DataObjx L.L.C.
DataObjx is a participant in the Microsoft Independent Software Vendor program
Custom built desktop applications utilizing the Microsoft .NET Technologies...
Custom Web & Desktop Application Development
The DataObjx (DAL) Data Access Layer with Microsoft SQL Server support combined with VistaDB support provides an even greater dimension to how you derive and manipulate data in your business applications.
The DAL has is a tried and fully tested DLL that makes it easy for your application to;
- Dynamically connect to multiple SQL Server 2005 or 2008 (Express and Standard Versions) and VistaDB databases simultaneously.
- Insert, Update and Retrieve BLOB objects using one line of code
- Populate bound & un-
bound controls in your application / web page - Easily derive recordsets and perform insert, update and delete operations
- Includes support for VistaDB -
a zero foot- Does not include a VistaDB license. VistaDB license purchased separately).print embedded database. Click here for more information about VistaDB. ( - Utilize SQL Text or SQL Parameter driven stored procedures
Data Access Layer - SQL Server with VistaDB support
Example Usage
This example demonstrates the DAL performing a SQL Insert statement in three (3) lines of code.
In Step 1 The DAL is instantiated.
In Step 2 The Connection String to your SQL Server database is applied to the DAL and
In Step 3 The SQL command is executed and the Primary Key of the new record is returned automatically.
Private Sub btnSaveData()
Dim SQL As String = ""
SQL = SQL & "Insert Into tblUsers (last_name,first_name, password, login) "
SQL = SQL & "Values "
SQL = SQL & "('Thumb','Tom','fingers','smallguy') "
1) Dim DAL As New DataAccessLayer.VistaDB
2) DAL.ConnectionString = "Your connection string here..."
3) DAL.ExecuteQuery(SQL) 'Execute & get the Primary Key (ID) of the new record
MsgBox("@@IDENTITY = " & DAL.PKID.ToString, MsgBoxStyle.Information, "PKID")
End Sub
