SqlConnection con = DB.createCon();
            con.Open();
            SqlCommand cmd = new SqlCommand("select ProductTypeId from tbMapProductTypeInfo where ProductTypeFatherId="+ProductTypeId,con);               
            SqlDataReader sdr = cmd.ExecuteReader();
            Repeater1.DataSource = sdr;
                     

SqlDataReader sdr = cmd.ExecuteReader();
            Repeater1.DataSource = sdr;
//以上这2句可以写成一句的不用SqlDataReader就可以
Repeater1.DataSource = cmd.ExecuteReader();
//使用SqlDataReader 是为了一些操作，下面是我一个小例子

int i=0;  //计数器
            string ProductMsgProperty=Request.QueryString["ProductMsgProperty"];//产品信息特性，0普通，1供应，2求购
            string ProductTypeId=Request.QueryString["ProductTypeId"];            //产品类别ID
            //            ProductTypeId="2";
            //将点击类的下级类邦定到TABLE中
            SqlConnection con = DB.createCon();
            con.Open();
            SqlCommand cmd = new SqlCommand("select ProductTypeId from tbMapProductTypeInfo where ProductTypeFatherId="+ProductTypeId,con);               
            SqlDataReader sdr = cmd.ExecuteReader();
            Repeater1.DataSource = sdr;
            TableRow tr = new TableRow();
            while(sdr.Read())
            {
                i+=1;
                TableCell tc =new TableCell();
                type tp =(type)this.LoadControl("type.ascx");
                tp.PRODUCTTYPEID=(sdr.GetInt32(0)).ToString();
                tc.Controls.Add(tp);
                tr.Controls.Add(tc);

                if(i%this.rowNum==0)
                {
                    this.Table2.Rows.Add(tr);
                    tr= new TableRow();
                }
            }

            if(i%this.rowNum!=0)
            {
                this.Table2.Rows.Add(tr);
            }
            con.Close();