用ASP.NET写你自己的代码生成器(16) { m_Scon.ConnectionString = "user id="+this.txtUserName.Text+ ";password="+this.txtPassword.Text+ ";initial catalog="+this.DropDownList3.SelectedItem.Text+ ";data source="+this.txtServerName.Text; SqlCommand m_Scmd = new SqlCommand("sp_columns",m_Scon); m_Scmd.CommandType = CommandType.StoredProcedure; SqlParameter myParm = m_Scmd.Parameters.Add("@table_name",SqlDbType.VarChar,100); myParm.Value = this.DropDownList1.SelectedItem.Value; m_Scon.Open(); SqlDataReader m_Sdr = m_Scmd.ExecuteReader(); string TableName = this.DropDownList1.SelectedItem.Value; string m_LayOut = "";
m_LayOut = m_LayOut + "using System;\r\n"; m_LayOut = m_LayOut + "using System.Data;\r\n" ;