[C #] Zdbviewcs: cross-platform Database viewer. Supports SQL Server, Oracle, MySQL and other databases

Source: Internet
Author: User

zyl910

I. Description

This tool is suitable for use in the following situations-

* Quickly view data and table structure information in the database.
* Test the wording of the connection string under ADO.
* Help analyze the ADO database operation.


Second, usage

Run this program.
Select the data provider factory in the Provider drop-down box. (if not, try adding the data provider factory configuration to the Zdbviewcs.exe.config).
Fill in the connection string in the "ConnectionString" text box.
Click the "Open" button to open the data.

After you open the database. You will find tables in the table and view in the "table" page on the left. The data in the data table is shown in the "Data" page on the right.
Click on another table in the table, and the Data on the right will also transform the content.
In fact, when you click in the "Table" table, the SQL statement is automatically generated from the drop-down box to the right of "table" and the "Exec" button is automatically clicked.
You can also write your own SQL statement in the "SQL" text box and click the "Exec" button. Note that the text box to the left of "Exec" is a record number limit, and if set to 0, all records are obtained.

Click "Dataschema" on the right side to view the table structure table.

Click on the right "datainfo" to view the property information for each object at the time of the query.

Source code Download--
Https://github.com/zyl910/zdbviewcs

[C #] Zdbviewcs: cross-platform Database viewer. Supports SQL Server, Oracle, MySQL and other databases

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.