Some of the many features - all .Net data providers
easy and stable access to data from external data sources (native, OLE-DB, ODBC)
execute/query data from database with the most less amount of code lines: simply fill a complete DataTable with 1 (!!) line of code
'VB.NET sample:
Dim MyTable As System.Data.DataTable = CompuMaster.Data.DataQuery.AnyIDataProvider.FillDataTable(
New System.Data.OleDb.OleDbConnection(ConnectionString),
"SELECT * FROM table", System.Data.CommandType.Text,
Nothing,
CompuMaster.Data.DataQuery.AnyIDataProvider.Automations.AutoOpenAndCloseAndDisposeConnection,
"MyTableName") // C# sample:
System.Data.DataTable myTable = CompuMaster.Data.DataQuery.AnyIDataProvider.FillDataTable(
New System.Data.OleDb.OleDbConnection(ConnectionString),
"SELECT * FROM table", System.Data.CommandType.Text,
null,
CompuMaster.Data.DataQuery.AnyIDataProvider.Automations.AutoOpenAndCloseAndDisposeConnection,
"MyTableName");
execute a query with several command parameters within 5 (!!) lines of code
Dim MyCmd As New System.Data.SqlClient.SqlCommand("SELECT * FROM table WHERE FN=@FirstName AND LN=@FamilyName", New System.Data.SqlClient.SqlConnection(ConnectionString))
MyCmd.Parameters.Add("@FirstName", SqlDbType.NVarChar).Value = "John"
MyCmd.Parameters.Add("@FamilyName", SqlDbType.NVarChar).Value = "O'Regan"
MyCmd.CommandType = System.Data.CommandType.Text
MyTable = CompuMaster.Data.DataQuery.AnyIDataProvider.FillDataTable(
MyCmd,
CompuMaster.Data.DataQuery.AnyIDataProvider.Automations.AutoOpenAndCloseAndDisposeConnection,
"MyTableName")
code reduction = maintenance costs reduction
execute/query data from database with the most less amount of code lines seen ever
code reduction = more stable code
forget the Try-Catch-Finally blocks
never forget to close a connection and run into pooling problems
simplified common methods to query/update data from/on database for all .Net data providers
don't care any more about MS SQL Server, MySql, Oracle, PostgreSql or many other RDMS
don't care any more about accessing the RDMS using native .Net data providers, OLE-DB or ODBC connections
simplified common methods to write back your locally changed data to your external data source
culture dependent or culture independent (especially column separtors, decimal separators)
always use correct file encoding (ANSI, UTF-8, UTF-16, WINDOWS-1252, ISO-8859-1 and many others)
always create valid CSV data
support for multi-line data in your CSV files - even Microsoft Excel will understand it on import
CSV files can use column separators of fixed column widths
read/write from/to files, strings or
read directly a CSV file from an URL
ideal for your simple REST web service client/server
DataTables - your in-memory relational database system
extract columns and rows using filters, where-clauses and many other technics you already know from your favorite SQL system
join several DataTables in memory as you do with your favorite SQL system
Inner Join
Left Join
Right Join
Full Outer Join
Cross Join
use 1 or more columns for joining
Dim NewTable As DataTable = _
CompuMaster.Data.DataTables.SqlJoinTables(
LeftTable, New String() {"ID"},
RightTable, New String() {"PrimaryKeyID"},
CompuMaster.Data.DataTables.SqlJoinTypes.FullOuter)
rearrange columns, sort rows and put them into new DataTables
convert full DataTables, DataSets or just some DataRows into beautiful plain text or HTML tables with just 1 line of code
Still not convinced? Download your library now and for free and see the many stuff in the library you need all the days regardless if you're a C#, VB.NET or ... developer
String/Object/Value/Double checks for DbNull.Value, null/Nothing, String.Empty, Double.NaN
Remove password part from ConnectionString in case you need to show it to your administrative user
Query from LDAP directories directly into DataTables
Create empty Microsoft Excel or Microsoft Access database files for immediate read/write access
Honors
This library has been developed and maintained by CompuMaster GmbH for years.
References
CompuMaster.Data.Controls
You may find this library useful for using DataGrids in Windows Forms application with row update support on the foreign data source
