3/31/2023 0 Comments Universal database client![]() ![]() ![]() A dataAccess class which wraps all the data access methods and returns the values or records as required.There should be individual pages one for each operation (CRUD) which will take the tablename as the parameter.User needs to login before doing CRUD (Create/Read/Update/Delete) operations ( Not required for the AdminLite version).Create a self sufficient admin section which can be put into any SQL driven web application by changing the connection string for SQL Server in the web.config file.When I first started with an admin section for a web application, I thought why not try to make something more general, a plug-n-play admin section which can be used for any SQL driven dynamic web application, and here is the result of the effort. This article describes an ASP.NET web module which can be added /customized in any SQL driven web application as a database administration module. Online demo - UDA Introduction (Seven pages is all it needs) Download Admin2005 (ASP.NET 2.0) project source files - 1 MB.Download AdminLite (no login, no admin table, no customization required) - 978 Kb.Download the admin main project source files - 1.01 MB.Universal Database Tools - DtSQL Portable2.10.Universal Database Tools - DtSQL Portable3.0.0.Universal Database Tools - DtSQL Portable3.0.1.Universal Database Tools - DtSQL Portable3.0.2_.Universal Database Tools - DtSQL Portable3.1.1.Universal Database Tools - DtSQL Portable3.2.1.Universal Database Tools - DtSQL Portable3.3.1.Universal Database Tools - DtSQL Portable3.4.1.Universal Database Tools - DtSQL Portable3.4.2.Universal Database Tools - DtSQL Portable3.4.3.Universal Database Tools - DtSQL Portable3.5.1.Universal Database Tools - DtSQL Portable3.6.1.Universal Database Tools - DtSQL Portable3.6.2.Universal Database Tools - DtSQL Portable3.7.1.Universal Database Tools - DtSQL Portable3.7.2.Universal Database Tools - DtSQL Portable3.8.1.Universal Database Tools - DtSQL Portable3.8.2.Universal Database Tools - DtSQL Portable3.9.1.Universal Database Tools - DtSQL Portable3.9.2.Universal Database Tools - DtSQL Portable4.0.0.Universal Database Tools - DtSQL Portable4.0.1.Universal Database Tools - DtSQL Portable4.1.1.Universal Database Tools - DtSQL Portable4.2.1.Universal Database Tools - DtSQL Portable5.1.1.students trying to learning database, SQL database administrators to manage the database objects and data.Ĭ. Lightweight and performance is much better than similar productsī. ![]() Supports managing multiple databases at the same timeĦ. SQL scripts are provided to modify the database objects, such as table, view, index, contraint, trigger, sequence and so on.Ĥ. Export database data (single table/multiple tables/query result) in various formatsĢ. Import database data from various formatsĦ. Help tools to build select, insert, update, delete SQL scripts of most databasesĥ. Redo or undo last database table data change.Ĥ. Insert, duplicate, update, and delete database table data. edit database table data including binary/BLOB and CLOB data types. create, alter, view and drop database objects, such as tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on.ģ. Browse database objects, such as schemas, tables, columns, constraints, views, indexes, triggers, procedures, functions, sequences, and so on.Ģ. Supported Databases : Cache, DB2, Derby, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, PointBase, PostgresSQL, Solid, SQLite, SQL Server, SQL Anywhere, Sybase (ASE)ġ. It can ceate, alter, view and drop database objects, such as tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on. It can access most databases and can be used on all major operating systems. ![]() DtSQL is an universal database query and editor tool for developers and database administrators to Query, Edit, Browse, and Manage Databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |