Databases supported :
Platform : C# 2010
Operating System : Windows
2000 /
XP /
2003 /
Vista /
win7 (32bit)
Requirements : v4.0 .NET framework
Filesize : 3mb
online - new features presentation
Download through GitHub
V2.4.0
+SQLServer Tunnel support
*tunnels working with BZIP/GZIP
V2.3.9 (after 3years from last release)
-no code changes, released at GitHub under MIT license - https://github.com/pipiscrew/DBManager
V2.3.8
*mysql - create table proper
*mysql - enable utf8 via connection string
+mysql tunnel - pdo support (also something wrong with json_decode on some servers?)
+nuser can write javascript pseudocode (generate his own templates) from tables treeview context menu
v2.3.6 *silent update*
*minor fixes
*mysql port on connection string
v2.3.6
*minor fixes
*CRUD > wenzhixin - bootstrap-table v1.3 supported
v2.3.3
+CRUD > wenzhixin - bootstrap-table v1.2.3 supported
On x64 machine if you like to open an access/excel files, you must have installed :
VC++ 2015 (x86)
AccessDatabaseEngine (x86) - when troubles, use setup.exe /quiet or setup.exe /passive (src)
possible errors you receiving when the dependencies are not installed :
example of excel query
if you getting :
happens when sheet has more than 255 columns, restrict it with :
- SQL Server 2000 -2005-2008-2010-2012 + Azure!
- Access 97-2012 (mdb/accdb)
- Excel 97-2012 (xls/xlsx)
- SQLite v2.x – 3.x
- MySQL v3.23 – v5.7.4
- CSharp Code Generation + Controls Generation
- PHP / MySQL / Bootstrap / Login + Portal pages
- Azure template code generation through bootstrap
- MySQL Tunnel aka connect from your desktop to secure http localhost that accepts only local connections!!
- Moving records from a dbase type to another type ex. access or xls to mysql or sql server!!
Platform : C# 2010
Operating System : Windows
Requirements : v4.0 .NET framework
Filesize : 3mb
online - new features presentation
Download through GitHub
V2.4.0
+SQLServer Tunnel support
*tunnels working with BZIP/GZIP
V2.3.9 (after 3years from last release)
-no code changes, released at GitHub under MIT license - https://github.com/pipiscrew/DBManager
V2.3.8
*mysql - create table proper
*mysql - enable utf8 via connection string
+mysql tunnel - pdo support (also something wrong with json_decode on some servers?)
+nuser can write javascript pseudocode (generate his own templates) from tables treeview context menu
v2.3.6 *silent update*
*minor fixes
*mysql port on connection string
v2.3.6
*minor fixes
*CRUD > wenzhixin - bootstrap-table v1.3 supported
v2.3.3
+CRUD > wenzhixin - bootstrap-table v1.2.3 supported
On x64 machine if you like to open an access/excel files, you must have installed :
VC++ 2015 (x86)
AccessDatabaseEngine (x86) - when troubles, use setup.exe /quiet or setup.exe /passive (src)
possible errors you receiving when the dependencies are not installed :
example of excel query
JavaScript:
select * from [sheet1$] where column_name = '1729'if you getting :
happens when sheet has more than 255 columns, restrict it with :
JavaScript:
// apply range to the query, the following selects the 1column to 76column for 1200rows, ofc u can remove 1200
string sql = "select * from [Sheet1$A1:BP1200]";
//or set 255cols by default
string sql = "select * from [A1:IU]";