基于C#的数据库表结构报表系统的设计与实现

Design and implementation of report generation system for database table structure based on C# programming language

为便于团队交流与系统维护,在对表的设计结构修改后,应及时更新项目技术文档。为克服现有方法存在的不足,在Visual Studio 2010环境下,基于C#编程语言,开发了一个针对SQL Server数据库表结构的报表生成系统。该系统支持单表导出和批量导出两种工作模式,支持将表结构导出到Word和Excel两种应用接口,具有操作简单、使用灵活和功能完善的优点,对提高团队开发效率和技术文档的规范性具有一定的应用价值。

To make team communication and system maintenance become easier,when the design structure of table is modified, updating the project technical documentation followed is very important. To overcome the deficiencies of traditional methods, a report generation system for table design structure of SQL server database by development tool of visual studio 2010, based on C# programming language is developed. It supports two working modes： single table export and batch （multi-table） export, meanwhile it provides two application interfaces： exporting the design structure of table to word and excel are allowed, with advantages of easy operation and flexible, it will help us to improve the efficiency of team development and the normalization of technical documentation.