第100篇博文纪念 | C# 根据数据库表结构生成DOC数据库文档-阿里云开发者社区

开发者社区> 开发与运维> 正文

第100篇博文纪念 | C# 根据数据库表结构生成DOC数据库文档

简介:

一、目标
    下图是我们要实现的目标:

二、实现
    原理非常简单,首先制作样式模版,可以参照文章2,将排版好的Word另存为html,然后复制粘贴到aspx页面中,然后从数据库读取表以及字段信息,动态的插入表名和字段信息。
    2.1  SqlSchemaProvider.cs
//==============================================================================
//
// 作 者:农民伯伯
// 邮 箱:over140@gmail.com
// 博 客:http://over140.cnblogs.com/
// 时 间:2009-9-9
// 描 述:获取SQL SERVER 元数据
//
//==============================================================================


using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Linq;

public sealed class SqlSchemaProvider
{

    
#region Constructor

    
public SqlSchemaProvider(string connectstring)
    {
        ConnectString 
= connectstring;
    }

    
#endregion

    
#region GetTableColumns

    
public IList<ColumnInfo> GetTableColumns(string tableName)
    {
        IList
<ColumnInfo> result = new List<ColumnInfo>();

        SqlConnectionStringBuilder scsb 
= new SqlConnectionStringBuilder(ConnectString);

        
using (SqlConnection conn = new SqlConnection(scsb.ConnectionString))
        {
            conn.Open();
            SqlCommand cmd 
= new SqlCommand(SQL2000_GetTableColumns, conn);
            cmd.Parameters.Add(
new SqlParameter("@DatabaseName", scsb.InitialCatalog));
            cmd.Parameters.Add(
new SqlParameter("@SchemaName""dbo"));
            cmd.Parameters.Add(
new SqlParameter("@TableName", tableName));
            SqlDataReader reader 
= cmd.ExecuteReader(CommandBehavior.CloseConnection);
            
while (reader.Read())
            {
                result.Add(
new ColumnInfo()
                {
                    Name 
= reader.GetString(0),
                    DataType 
= reader.GetString(1),
                    Length 
= reader.GetInt32(3),
                    Nullable 
= reader.GetString(6).Trim().Equals("YES"? true : false,
                    DefaultValue 
= reader.IsDBNull(7? "" : reader[7].ToString(),
                    Identity 
= reader.GetInt32(8),
                    IdentitySeed 
= Convert.ToInt32(reader.GetString(12)),
                    IdentityIncrement 
= Convert.ToInt32(reader.GetString(13)),
                    ColumnDesc 
= reader.GetString(17)
                });
            }
            reader.Close();
        }

        
return result;
    }

    
public IList<string> GetTables()
    {
        IList
<string> result = new List<string>();

        SqlConnectionStringBuilder scsb 
= new SqlConnectionStringBuilder(ConnectString);

        
using (SqlConnection conn = new SqlConnection(scsb.ConnectionString))
        {
            conn.Open();
            SqlCommand cmd 
= new SqlCommand(SQL2000_GetTables, conn);
            SqlDataReader reader 
= cmd.ExecuteReader(CommandBehavior.CloseConnection);
            
while (reader.Read())
            {
                result.Add(reader.GetString(
0));
            }
            reader.Close();
        }

        
return result;
    }


    
#region Type Maps

    
private string GetCSharpType(string type)
    {
        
if (string.IsNullOrEmpty(type))
            
return "string";

        
string reval = string.Empty;
        
switch (type.ToLower())
        {
            
case "varchar":
            
case "nchar":
            
case "ntext":
            
case "text":
            
case "char":
            
case "nvarchar":
                reval 
= "string";
                
break;
            
case "int":
                reval 
= "int";
                
break;
            
case "smallint":
                reval 
= "Int16";
                
break;
            
case "bigint":
                reval 
= "Int64";
                
break;
            
case "float":
                reval 
= "double";
                
break;
            
case "bit":
                reval 
= "bool";
                
break;
            
case "decimal":
            
case "smallmoney":
            
case "money":
            
case "numeric":
                reval 
= "decimal";
                
break;
            
case "binary":
                reval 
= "System.Byte[]";
                
break;
            
case "real":
                reval 
= "System.Single";
                
break;
            
case "datetime":
            
case "smalldatetime":
            
case "timestamp":
                reval 
= "System.DateTime";
                
break;
            
case "tinyint":
                reval 
= "System.Byte";
                
break;
            
case "uniqueidentifier":
                reval 
= "System.Guid";
                
break;
            
case "image":
            
case "varbinary":
                reval 
= "System.Byte[]";
                
break;
            
case "Variant":
                reval 
= "Object";
                
break;

            
default:
                reval 
= "string";
                
break;
        }
        
return reval;
    }

    
#endregion

    
#endregion

    
#region SQL Templates

    
#region GetTableColumns

    
private const string SQL2000_GetTables = @"
          SELECT
              object_name(so.id) AS OBJECT_NAME,
              user_name(so.uid)  AS USER_NAME,
              so.type            AS TYPE,
              so.crdate          AS DATE_CREATED,
              fg.file_group      AS FILE_GROUP,
              so.id              AS OBJECT_ID
          FROM 
              dbo.sysobjects so
          LEFT JOIN (
                SELECT 
                    s.groupname AS file_group,
                    i.id        AS id
                FROM dbo.sysfilegroups s
                INNER JOIN dbo.sysindexes i
                    ON i.groupid = s.groupid 
                WHERE i.indid < 2                           
              ) AS fg
              ON so.id = fg.id
          WHERE
              so.type = N'U'
              AND permissions(so.id) & 4096 <> 0
              AND ObjectProperty(so.id, N'IsMSShipped') = 0
          ORDER BY user_name(so.uid), object_name(so.id)
";

    
private const string SQL2000_GetTableColumns = @"
              SELECT
                clmns.[name] AS [Name],
                usrt.[name] AS [DataType],
                ISNULL(baset.[name], N'') AS [SystemType],
                CAST(CASE WHEN baset.[name] IN (N'char', N'varchar', N'binary', N'varbinary', N'nchar', N'nvarchar') THEN clmns.prec ELSE clmns.length END AS INT) AS [Length],
                CAST(clmns.xprec AS TINYINT) AS [NumericPrecision],
                CAST(clmns.xscale AS INT) AS [NumericScale],
                CASE CAST(clmns.isnullable AS BIT) WHEN 1 THEN 'YES' ELSE 'NO' END AS [Nullable],
                defaults.text AS [DefaultValue],
                CAST(COLUMNPROPERTY(clmns.id, clmns.[name], N'IsIdentity') AS INT) AS [Identity],
                CAST(COLUMNPROPERTY(clmns.id, clmns.[name], N'IsRowGuidCol') AS INT) AS IsRowGuid,
                CAST(COLUMNPROPERTY(clmns.id, clmns.[name], N'IsComputed') AS INT) AS IsComputed,
                CAST(COLUMNPROPERTY(clmns.id, clmns.[name], N'IsDeterministic') AS INT) AS IsDeterministic,
                CAST(CASE COLUMNPROPERTY(clmns.id, clmns.[name], N'IsIdentity') WHEN 1 THEN IDENT_SEED(QUOTENAME(stbl.[name]) + '.' + QUOTENAME(tbl.[name])) ELSE 0 END AS NVARCHAR(40)) AS [IdentitySeed],
                CAST(CASE COLUMNPROPERTY(clmns.id, clmns.[name], N'IsIdentity') WHEN 1 THEN IDENT_INCR(QUOTENAME(stbl.[name]) + '.' + QUOTENAME(tbl.[name])) ELSE 0 END AS NVARCHAR(40)) AS [IdentityIncrement],
                cdef.[text] AS ComputedDefinition,
                clmns.[collation] AS Collation,
                CAST(clmns.colid AS int) AS ObjectId,
        isnull(prop.value, '') AS ColumnDesc
              FROM
                dbo.sysobjects AS tbl
                INNER JOIN dbo.sysusers AS stbl ON stbl.[uid] = tbl.[uid]
                INNER JOIN dbo.syscolumns AS clmns ON clmns.id=tbl.id
                LEFT JOIN dbo.systypes AS usrt ON usrt.xusertype = clmns.xusertype
                LEFT JOIN dbo.sysusers AS sclmns ON sclmns.uid = usrt.uid
                LEFT JOIN dbo.systypes AS baset ON baset.xusertype = clmns.xtype and baset.xusertype = baset.xtype
                LEFT JOIN db.syscomments AS defaults ON defaults.id = clmns.cdefault
                LEFT JOIN dbo.syscomments AS cdef ON cdef.id = clmns.id AND cdef.number = clmns.colid
        LEFT OUTER JOIN sysproperties prop ON clmns.id = prop.id AND clmns.colid = prop.smallid 
              WHERE
                (tbl.[type] = 'U' OR tbl.[type] = 'S') 
                AND stbl.[name] = 'dbo'
                AND tbl.[name] = @TableName
              ORDER BY
                  clmns.colorder
";

    
#endregion

    
#endregion

    
#region Properties

    
public string ConnectString { getset; }

    
#endregion

}

      代码说明:
        这里是获取数据库2000元数据的类,如果其他数据库可参照文章1。
    2.2  ColumnInfo.cs

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
///ColumnInfo 的摘要说明
/// </summary>
public class ColumnInfo
{
    
public ColumnInfo()
    {
        
//
        
//TODO: 在此处添加构造函数逻辑
        
//
    }

    
/// <summary>
    
/// 列名
    
/// </summary>
    public string Name { getset; }
    
/// <summary>
    
/// 数据类型
    
/// </summary>
    public string DataType { getset; }
    
/// <summary>
    
/// 长度
    
/// </summary>
    public int Length { getset; }
    
/// <summary>
    
/// 是否允许空
    
/// </summary>
    public bool Nullable { getset; }
    
/// <summary>
    
/// 1 标识
    
/// </summary>
    public int Identity { getset; }
    
/// <summary>
    
/// 1 标识种子
    
/// </summary>
    public int IdentitySeed { getset; }
    
/// <summary>
    
/// 标识增量
    
/// </summary>
    public int IdentityIncrement { getset; }
    
/// <summary>
    
/// 说明
    
/// </summary>
    public string ColumnDesc { getset; }
    
/// <summary>
    
/// 默认值
    
/// </summary>
    public string DefaultValue { getset; }

}

      代码说明:
        数据库字段Model。
    2.3  Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<html>
<head>
    
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    
<meta name="Generator" content="Microsoft Word 11 (filtered)">
    
<title>数据库文档</title>
    
<style>
        
<!-- 
        
/* Font Definitions */ 
        @font
-face
        {
            font
-family: 宋体;
            panose
-12 1 6 0 3 1 1 1 1 1;
        }
        @font
-face
        {
            font
-family: 楷体_GB2312;
            panose
-12 1 6 9 3 1 1 1 1 1;
        }
        @font
-face
        {
            font
-family: "\@宋体";
            panose
-12 1 6 0 3 1 1 1 1 1;
        }
        @font
-face
        {
            font
-family: "\@楷体_GB2312";
            panose
-12 1 6 9 3 1 1 1 1 1;
        }
        
/* Style Definitions */p.MsoNormal, li.MsoNormal, div.MsoNormal
        {
            margin: 0cm;
            margin
-bottom: .0001pt;
            text
-align: justify;
            text
-justify: inter-ideograph;
            font
-size: 10.5pt;
            font
-family: "Times New Roman";
        }
        p.MsoFooter, li.MsoFooter, div.MsoFooter
        {
            margin: 0cm;
            margin
-bottom: .0001pt;
            layout
-grid-mode: char;
            font
-size: 9.0pt;
            font
-family: "Times New Roman";
        }
        
/* Page Definitions */@page Section1
        {
            size: 
595.3pt 841.9pt;
            margin: 
72.0pt 90.0pt 72.0pt 90.0pt;
            layout
-grid: 15.6pt;
        }
        div.Section1
        {
            page: Section1;
        }
        
-- ></style>
</head>
<body lang="ZH-CN" style='text-justify-trim: punctuation'>
    
<div class="Section1" style='layout-grid: 15.6pt'>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal" align="center" style='text-align: center'>
            
<span lang="EN-US" style='font-size: 42.0pt'>&nbsp;</span></p>
        
<class="MsoNormal" align="center" style='text-align: center'>
            
<span lang="EN-US" style='font-size: 42.0pt'>&nbsp;</span></p>
        
<class="MsoNormal" align="center" style='text-align: center'>
            
<span style='font-size: 42.0pt; font-family: 楷体_GB2312'>数据库文档</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
        
<div align="center">
            
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style='margin-left: 34.6pt;
                border-collapse: collapse; border: none'>
                <tr style='height: 15.6pt'>
                    
<td width="85" valign="top" style='width: 64.0pt; border: solid windowtext 1.0pt;
                        padding: 0cm 5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span style='font-family: 宋体'>版本号</span></p>
                    
</td>
                    
<td width="131" valign="top" style='width: 98.6pt; border: solid windowtext 1.0pt;
                        border-left: none; padding: 0cm 5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span style='font-family: 宋体'>日期</span></p>
                    
</td>
                    
<td width="132" valign="top" style='width: 98.65pt; border: solid windowtext 1.0pt;
                        border-left: none; padding: 0cm 5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span style='font-family: 宋体'>负责人</span></p>
                    
</td>
                    
<td width="132" valign="top" style='width: 98.65pt; border: solid windowtext 1.0pt;
                        border-left: none; padding: 0cm 5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span style='font-family: 宋体'>备注</span></p>
                    
</td>
                
</tr>
                
<tr style='height: 15.6pt'>
                    
<td width="85" valign="top" style='width: 64.0pt; border: solid windowtext 1.0pt;
                        border-top: none; padding: 0cm 5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">0.1</span></p>
                    
</td>
                    
<td width="131" valign="top" style='width: 98.6pt; border-top: none; border-left: none;
                        border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt;
                        padding: 0cm 
5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">2009-9-9</span></p>
                    
</td>
                    
<td width="132" valign="top" style='width: 98.65pt; border-top: none; border-left: none;
                        border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt;
                        padding: 0cm 
5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span style='font-family: 宋体'>农民伯伯</span></p>
                    
</td>
                    
<td width="132" valign="top" style='width: 98.65pt; border-top: none; border-left: none;
                        border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt;
                        padding: 0cm 
5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">&nbsp;</span></p>
                    
</td>
                
</tr>
                
<tr style='height: 15.6pt'>
                    
<td width="85" valign="top" style='width: 64.0pt; border: solid windowtext 1.0pt;
                        border-top: none; padding: 0cm 5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">&nbsp;</span></p>
                    
</td>
                    
<td width="131" valign="top" style='width: 98.6pt; border-top: none; border-left: none;
                        border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt;
                        padding: 0cm 
5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">&nbsp;</span></p>
                    
</td>
                    
<td width="132" valign="top" style='width: 98.65pt; border-top: none; border-left: none;
                        border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt;
                        padding: 0cm 
5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">&nbsp;</span></p>
                    
</td>
                    
<td width="132" valign="top" style='width: 98.65pt; border-top: none; border-left: none;
                        border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt;
                        padding: 0cm 
5.4pt 0cm 5.4pt; height: 15.6pt'>
                        <class="MsoNormal" align="center" style='text-align: center'>
                            
<span lang="EN-US">&nbsp;</span></p>
                    
</td>
                
</tr>
            
</table>
        
</div>
        
        
<asp:Repeater ID="rptData" runat="server">
            
<HeaderTemplate>
            
</HeaderTemplate>
            
<ItemTemplate>
                
<class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
                
<class="MsoNormal"><span lang="EN-US">&nbsp;</span></p>
        
                
<class="MsoNormal">
                    
<b><span style='font-size: 12.0pt; font-family: 宋体'></span></b><b><span lang="EN-US"
                        style
='font-size: 12.0pt'>&nbsp; </span></b><b><span style='font-size: 12.0pt; font-family: 宋体'>
                            名:
</span></b><b><span lang="EN-US" style='font-size: 12.0pt'><%#Container.DataItem%></span></b></p>
                
<class="MsoNormal">
                    
<b><span style='font-size: 12.0pt; font-family: 宋体; background: yellow'>表说明:</span></b></p>
        
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style='border-collapse: collapse;
            border: none'>
            <tr>
                
<td width="130" valign="top" style='width: 97.7pt; border: solid windowtext 1.0pt;
                    background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>字段名</span></p>
                
</td>
                
<td width="81" valign="top" style='width: 60.95pt; border: solid windowtext 1.0pt;
                    border-left: none; background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>数据类型</span></p>
                
</td>
                
<td width="50" valign="top" style='width: 37.3pt; border: solid windowtext 1.0pt;
                    border-left: none; background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>长度</span></p>
                
</td>
                
<td width="67" valign="top" style='width: 49.95pt; border: solid windowtext 1.0pt;
                    border-left: none; background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>允许空</span></p>
                
</td>
                
<td width="67" valign="top" style='width: 49.95pt; border: solid windowtext 1.0pt;
                    border-left: none; background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>默认值</span></p>
                
</td>
                
<td width="88" valign="top" style='width: 65.85pt; border: solid windowtext 1.0pt;
                    border-left: none; background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>其他</span></p>
                
</td>
                
<td width="86" valign="top" style='width: 64.4pt; border: solid windowtext 1.0pt;
                    border-left: none; background: #E0E0E0; padding: 0cm 5.4pt 0cm 5.4pt'>
                    <class="MsoNormal" align="center" style='text-align: center'>
                        
<span style='font-family: 宋体'>字段说明</span></p>
                
</td>
            
</tr>
            
<%# ColumnInfo(Container.DataItem.ToString()) %>
            
</table>
            
</ItemTemplate>
            
<FooterTemplate>
            
</FooterTemplate>
        
</asp:Repeater>
           
        
<class="MsoNormal">
            
<span lang="EN-US">&nbsp;</span></p>
    
</div>
</body>
</html>

      代码说明:
        如果大家觉得截图上就是你要的文档格式,这里不用修改直接运行就行了,要是有自己的格式的话需要制作模版,参照文章2,对应修改就行。
    2.4  Default.aspx.cs

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections;
using System.Collections.Generic;
using System.Text;

public partial class _Default : System.Web.UI.Page
{

    
private const string connstr = "Data Source=SERVER;Initial Catalog=Test;User ID=sa;Password=sa";
    
private readonly SqlSchemaProvider provider = new SqlSchemaProvider(connstr);

    
protected void Page_Load(object sender, EventArgs e)
    {
        
if (!IsPostBack)
        {
            
this.rptData.DataSource = provider.GetTables();
            
this.rptData.DataBind();
        }
    }


    
/// <summary>
    
/// 
    
/// </summary>
    
/// <param name="obj"></param>
    
/// <returns></returns>
    public string OutputNullable(bool nullable)
    {
        
return nullable ? "<span style='font-family:宋体'>是</span>" : "<span style='font-family: 宋体; color: red'>否</span>";
    }

    
public string ColumnInfo(string tablename)
    {
        StringBuilder result 
= new StringBuilder();
        IList
<ColumnInfo> columns = provider.GetTableColumns(tablename);

        
foreach (ColumnInfo column in columns)
        {
            result.AppendFormat(
@"<tr>
  <td width=103 valign=top style='width:77.4pt;border:solid windowtext 1.0pt;
  border-top:none;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><span lang=EN-US>{0}</span></p>
  </td>
  <td width=84 valign=top style='width:63.0pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><span lang=EN-US>{1}</span></p>
  </td>
  <td width=51 valign=top style='width:38.25pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><span lang=EN-US>{2}</span></p>
  </td>
  <td width=71 valign=top style='width:53.55pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'>{3}</p>
  </td>
  <td width=71 valign=top style='width:53.55pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><span lang=EN-US>{4}</span></p>
  </td>
  <td width=95 valign=top style='width:71.3pt;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><span lang=EN-US>{5}</span></p>
  </td>
  <td width=92 valign=top style='width:69.05pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal align=center style='text-align:center'><span lang=EN-US>{6}</span></p>
  </td>
 </tr>
", column.Name, column.DataType, column.Length, OutputNullable(column.Nullable), 
                OutputValue(column.DefaultValue),
                OutputIdentity(column.Identity, column.IdentitySeed, column.IdentityIncrement),
                OutputValue(column.ColumnDesc));
        }

        
return result.ToString();
    }

    
//<span style='font-family: 宋体'>自动增长</span><span lang="EN-US">(1) </span><span style='font-family: 宋体'>
    
//                        不用于复制</span>

    
/// <summary>
    
/// 输出其他
    
/// </summary>
    
/// <param name="obj"></param>
    
/// <returns></returns>
    public string OutputIdentity(int identity, int seed, int increment)
    {
        
if (identity == 1 && seed == 1 && increment == 1)
            
return "<span style='font-family: 宋体'>自动增长</span><span lang='EN-US'>(1) </span>";
        
else
            
return "&nbsp;";
    }

    
private string OutputValue(string obj)
    {
        
if (string.IsNullOrEmpty(obj))
            
return "&nbsp;";
        
else
            
return obj;
    }

}

    代码说明:
      这里是嵌套输出的表格,注意处理为空的情况,否则表格可能不完整,大家可以根据实际情况进行修改。
三、结果

    大家直接把页面上的表格全选然后复制到Word里面即可,这里注意了,我试过直接另存为word,但是版式不对,但是直接复制到Word里面是可以的。
四、下载
    DB2Word2009-9-9.rar

本文转自博客园农民伯伯的博客,原文链接:第100篇博文纪念 | C# 根据数据库表结构生成DOC数据库文档,如需转载请自行联系原博主。


版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
开发与运维
使用钉钉扫一扫加入圈子
+ 订阅

集结各类场景实战经验,助你开发运维畅行无忧

其他文章