| 1. |
Using «LCPI ADO.NET Data Provider for OLE DB» with Firebird SQL Server |
| 2. |
IBProvider and «Registration Free COM» |
| 3. |
SSIS. Using «LCPI ADO.NET Data Provider for OLE DB» as a data recipient |
| 4. |
Usage of System.IO.Stream (C#, FB) |
| 5. |
Getting System.IO.Stream through OUT-parameter (C#) |
| 6. |
Usage of System.IO.TextReader (C#) |
| 7. |
Getting System.IO.TextReader through OUT-parameter (C#) |
| 8. |
Execution of query «INSERT RETURNING» (C#) |
| 9. |
Execution of query «INSERT RETURNING» [Compact version] (C#) |
| 10. |
Execution of query «INSERT RETURNING INTO» (C#) |
| 11. |
Execution of query «INSERT RETURNING INTO» [Compact version] (C#) |
| 12. |
Write and read large (8GB) binary blob (C#) |
| 13. |
Usage of OleDbDataReader.GetChars (C#) |
| 14. |
Usage of OleDbDataReader.GetBytes (C#) |
| 15. |
Creation and working with PACKAGE (C#, FB3) |
| 16. |
OleDbDataAdapter and «INSERT RETURNING INTO» (C#) |
| 17. |
Creation of provider through System.Data.Common.DbProviderFactories (C#) |
| 18. |
Code Access Security and ADO.NET. Usage of OleDbPermission. (C#, NET4.x) |
| 19. |
Work with native BOOLEAN datatype of Firebird and InterBase (C#, FB3, IB11) |
| 20. |
Cancel of query execution (C#) |
| 21. |
Cancel of query execution. Verification of implementation. (C#) |
| 22. |
Parallel transactions within one connection. (C#) |
| 23. |
Execution of the script with DDL queries and IN/OUT parameters. (C#) |
| 24. |
Work with arrays in database table. (FB, C#) |
| 25. |
Creation of database through ADO.NET provider. For Jedi only. (C#, Firebird 2.5+) |
| 26. |
Collaboration of ADO.NET, ADODB and OLE DB technologies. (C#) |
| 27. |
Work within ADODB connection. (C#) |
| 28. |
Usage of connection pool from «LCPI OLE DB Services». (C#) |
| 29. |
Getting information about OLE DB provider. (C#) |
| 30. |
Reading of IsAutoIncrement attribute. (C#, FB3) |
| 31. |
Getting statement plan (C#, FB) |
| 32. |
Using VBScript for database operations (C#, VBScript, FB) |
| 33. |
Work with IBProvider via LcpiComApiProvider (C#, FB) |
| 34. |
Resetting the session settings before reusing a connection (C#, FB4) |
| |
| 1. |
Connection to database from .NET Core application. (C#, FB) |
| |
| 1. |
OLE DB Exceptions Handling (C#, VB.Net) |
| 2. |
Database Connection methods (C#, VB.Net) |
| 3. |
Work with Data Reader Object (C#, VB.Net) |
| 4. |
Connection Pooling (C#, VB.Net) |
| 5. |
ADO.Net Objects. Read and Write XML (C#, VB.Net) |
| 6. |
Data Grid Filling (VB.Net) |
| 7. |
Filter in Data Grid (VB.Net) |
| 8. |
Stored procedure. Obtaining of row set (C#, FW 2.0) |
| 9. |
DataGridView filling (C#, FW 2.0) |
| 10. |
How to insert image into the blob field (C#, FW 2.0) |
| 11. |
System.Data.OleDbDataAdapter and query «INSERT … RETURNING» (C#) |
| 12. |
InterBase and Firebird Developer’s manual for Visual Studio Net. Part 1. Introduction to ADO.NET |
| 13. |
InterBase and Firebird Developer’s manual for ADO.NET. Part 2. Using code generators and tools of Visual Studio 2008 (2005) |
| 14. |
InterBase and Firebird in ADO Net. Part 3. Additional features: DDL, Metadata schemas, ODBC Escape Sequences |
| 15. |
New features of Firebird 2.0. Examples for ADO.NET (c#) |
| 16. |
Using new features of Firebird 2.1 in ADO.NET |
| |
| 1. |
Getting data from database (VB) |
| 2. |
Getting picture from database (VB) |
| 3. |
Working with Firebird and InterBase with limited system rights. |
| |
| 1. |
Connection to DataBase (VB, C++) |
| 2. |
Work with resulting set (VB, C++) |
| 3. |
Work with command (VB, C++) |
| 4. |
Work with BLOB field (VB, C++) |
| 5. |
Arrays reading (VB) |
| 6. |
Arrays writing (VB) |
| 7. |
Update recordset (VB, C++) |
| 8. |
Updatable recorset. Writing of changes in separate transaction (VB, C++) |
| 9. |
Updatable recorset. Controlled mode (VB, C++) |
| 10. |
Updatable recorset. Testing of query pool (VB) |
| 11. |
Stored procedure. IN-OUT parameters (VB, C++) |
| 12. |
Stored procedure. Obtaining of row set (VB) |
| 13. |
Stored procedure. Use of property std_exec_sp (VB) |
| 14. |
Stored procedure. ODBC call. IN-OUT parameters (WSF:VBS, C++) |
| 15. |
Stored procedure. ODBC call. Obtaining of row set (WSF:VBS) |
| 16. |
ActiveX Components. Manager of generators (VB) |
| 17. |
ActiveX Components. Clone of connection in ADODB (VB) |
| 18. |
ActiveX Components. Calculation of CPU time (VB) |
| 19. |
Database metadata extract (VB) |
| 20. |
Table metadata extract (VB) |
| 21. |
Work with InterBase Exceptions (VB) |
| 22. |
Work with InterBase using the ScriptControl (VB) |
| 23. |
Usage of bookmarks (VB) |
| 24. |
Work with InterBase triggers (VB) |
| 25. |
MSSQL Linked Servers. Samples for article (WSF:VBS) |
| 26. |
Work with transactions through SQL commands (VB) |
| |
| 1. |
Work with parameters |
| 2. |
Work with IN and OUT parameters in stored procedure |
| 3. |
Work with BLOB fields and parameters |
| 4. |
RecordSet getting |
| 5. |
SELECT with parameter, Command and RecordSet |
| 6. |
Working with Firebird and InterBase in Delphi. Part 1. |
