随笔-137
评论-2149
文章-13
trackbacks-12
2006年4月7日
|
久学培训网--国内最大的培训平台！ |
然后直接粘贴到Word文档里，就成了设计文档了，方便否？
web.config配置:
<add key="DSN" value="server = (local);database = ccs;uid=sa;pwd=***" />private void BindStoreProcedure()
{
string ConnString = System.Configuration.ConfigurationSettings.AppSettings["DSN"]; SqlConnection conn = new SqlConnection(ConnString); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter("SELECT name,id FROM dbo.sysobjects WHERE (xtype = 'p') AND (LEFT(name, 2) <> 'dt')",conn); da.Fill(ds); for(int i =0 ;i<ds.Tables[0].Rows.Count;i++)
{ this.lblStoreProcedure.Text +="<b>"+Convert.ToInt32(i+1).ToString()+". "+ ds.Tables[0].Rows[i]["name"].ToString() + "<b><br>"; this.lblStoreProcedure.Text +="<br><b>作者:</b>"; this.lblStoreProcedure.Text +="<br><b>日期:</b>"; this.lblStoreProcedure.Text +="<br><b>说明:</b>"; this.lblStoreProcedure.Text +="<br><b>参数:</b>"; this.lblStoreProcedure.Text += "<table border = '1' bordercolor='#4D4D4D' width = '600' cellpadding='0' cellspacing='0' >"; this.lblStoreProcedure.Text +="<tr><td>参数</td><td>说明</td></tr>"; DataSet ds2 = GetDataSet(conn,ds.Tables[0].Rows[i]["id"].ToString()); foreach(DataRow r in ds2.Tables[0].Rows) { this.lblStoreProcedure.Text += "<tr>"; this.lblStoreProcedure.Text += "<td width='10%'>"+r["name"].ToString()+"</td>"; this.lblStoreProcedure.Text += "<td> </td>"; this.lblStoreProcedure.Text += "</tr>";
} this.lblStoreProcedure.Text += "</table><br>"; }
} private DataSet GetDataSet(SqlConnection conn,string id) { DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter("SELECT name from syscolumns where id = "+id,conn); da.Fill(ds); return ds; }
