not like & dropdownlist关联listBox绑定到数组

      //打开数据库

          conn  =   new  SqlConnection(C.ConfigurationSettings.AppSettings[ 0 ]);
      conn.Open();

          //定义一个数组
      ArrayList al  =   new  ArrayList();

       string  sql  =   " select citynumb.*,ouname.* from citynumb,ouname where citynumb.ssqydm=' " + Request.Form[ " ddl_city " ].ToString() + " ' and citynumb.ssqydm=ouname.ssqydm and ouname.region not like '%线' " ;

         //用dateread读取sql并添加到数组
      SqlCommand comm;
      comm  =   new  SqlCommand(sql, conn);
      SqlDataReader dr;
      dr  =  comm.ExecuteReader();
       while  (dr.Read())
       ... {
       al.Add(new string(dr["pathcms"].ToString().ToCharArray()));
            }
      dr.Close();
      conn.Close();

          //将数组中的内容绑定到ListBox
       this .Lbx_meiti.DataSource  =  al;
       this .Lbx_meiti.DataBind();