微型机与应用
微型機與應用
미형궤여응용
MICROCOMPUTER & ITS APPLICATIONS
2013年
21期
7-9
,共3页
SQL Server 数据库%表设计结构%报表生成
SQL Server 數據庫%錶設計結構%報錶生成
SQL Server 수거고%표설계결구%보표생성
SQL Server database%design structure of table%report generation
为便于团队交流与系统维护,在对表的设计结构修改后,应及时更新项目技术文档。为克服现有方法存在的不足,在 Visual Studio 2010环境下,基于 C#编程语言,开发了一个针对 SQL Server 数据库表结构的报表生成系统。该系统支持单表导出和批量导出两种工作模式,支持将表结构导出到 Word 和 Excel 两种应用接口,具有操作简单、使用灵活和功能完善的优点,对提高团队开发效率和技术文档的规范性具有一定的应用价值。
為便于糰隊交流與繫統維護,在對錶的設計結構脩改後,應及時更新項目技術文檔。為剋服現有方法存在的不足,在 Visual Studio 2010環境下,基于 C#編程語言,開髮瞭一箇針對 SQL Server 數據庫錶結構的報錶生成繫統。該繫統支持單錶導齣和批量導齣兩種工作模式,支持將錶結構導齣到 Word 和 Excel 兩種應用接口,具有操作簡單、使用靈活和功能完善的優點,對提高糰隊開髮效率和技術文檔的規範性具有一定的應用價值。
위편우단대교류여계통유호,재대표적설계결구수개후,응급시경신항목기술문당。위극복현유방법존재적불족,재 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 excellare 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.