第100篇博文纪念 | C# 根据数据库表结构生成DOC数据库文档(4)-优快云博客

本文介绍了一个使用 ASP.NET 将数据库元数据导出到 Word 的方法。通过 C# 编程实现从 SQL Server 获取表名及字段信息，并以 HTML 格式输出到 Word 文档中，方便进行数据库设计审查。

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 ? "是" : "否";
 }

 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'>
 {0}
 </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'>
 {1}
 </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'>
 {2}
 </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'>
 {3}
 </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'>
 {4}
 </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'>
 {5}
 </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'>
 {6}
 </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();
 }

 //自动增长(1) 
 // 不用于复制

 /// <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 "自动增长(1) ";
 else
 return " ";
 }

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

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