© 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 provides a new dimension to how you derive and manipulate data in your application.
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) databases simultaneously. (Does not include a license to SQL Server 2005 or 2008. Microsoft SQL Server license purchased separately... Microsoft SQL Server 2008 Express is Free. Conditions may apply).
- 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.
- Utilize SQL Parameter driven stored procedures
Data Access Layer - SQL Server
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.SQLServer
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
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.
Empowering Your SQL Server and VistaDB Applications.
