用ASP.NET写你自己的代码生成器(8) SqlParameter myParm = m_Scmd.Parameters.Add("@table_type",SqlDbType.VarChar,100); myParm.Value = "'TABLE'"; m_Scon.Open(); SqlDataReader m_Sdr = m_Scmd.ExecuteReader(); this.DropDownList1.Items.Clear(); while(m_Sdr.Read()) { if(m_Sdr["TABLE_NAME"].ToString()!="dtproperties") { ListItem m_LI = new ListItem(); m_LI.Text = m_Sdr["TABLE_NAME"].ToString(); m_LI.Value = m_Sdr["TABLE_NAME"].ToString(); this.DropDownList1.Items.Add(m_LI); }