repeater的双重绑定

 前天，我做企业列表的时候遇到了难题，因为在企业的company表里，类别只是一个typeid，我必须要通过companytype表里的读取类别的名字．我在数据绑定的时候用的是repeater．在绑定以后还需要对类别进行二次绑定．遇到一些问题，就是在repeater里

 <asp:Repeater runat="server" OnItemDataBound="companylist_ItemDataBound" >
                              <ItemTemplate>
                            <table width="576" border="0" cellspacing="0" cellpadding="0">
                                <tr>
                                  <td background="../member/i/member_06.gif">
                                  
                                  <table width="576" border="0" cellspacing="0" cellpadding="0">
                                      <tr>
                                        <td width="441">
                                        <table width="100%" border="0" cellspacing="5" cellpadding="0">
                                                    <tr>
                                                         <td width="100"><font color="#FF0000"><strong>[<asp:Label runat="server" Text=""></asp:Label>]  </strong></font></td>
                                                         <td align="left" width="250"><a href= "CompanyDetail.aspx?CompanyID=<%#Eval("Company_ID") %>&temp_name=<%#Eval("Template_3") %>"><%#Eval("CompanyName")%></a></td>
                                                         <td> <%#Eval("CompanyCity")%></td>
                                                         <td></td>
                                                     </tr>
                                                     <tr>
                                                         <td colspan="4"><%# GetCutTitle(HtmlCoder(Convert.ToString(Eval("CompanyComment"))))%></td>
                                                      </tr>
                                                       </table>
                                        </td>
                                        <td width="135"><div align="center"></div></td>
                                      </tr>
                                    </table>
                                    </td>
                                </tr>
                              </table>
                              </ItemTemplate>
                              </asp:Repeater>

在后置代码里是这样写的

 

 protected void companylist_ItemDataBound(object sender, RepeaterItemEventArgs e)
 {

  string cnstr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  SqlConnection cn0 = new SqlConnection(cnstr);
  cn0.Open();
  if (!string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(e.Item.DataItem, "CompanyClass_3"))))
  {
   string mysql = "SELECT * FROM T_CompanyClass_3 WHERE CompanyClass_ID='" + DataBinder.Eval(e.Item.DataItem, "CompanyClass_3") + "'";
   SqlCommand cm0 = new SqlCommand(mysql, cn0);
   SqlDataReader dr = cm0.ExecuteReader();
   if (dr.Read())
   {
    Label myLabel = (Label)e.Item.FindControl("myLabel");
    myLabel.Text = Convert.ToString(dr["name"]);
   }
   
  }
  else
  {
   Label myLabel = (Label)e.Item.FindControl("myLabel");
   myLabel.Text = "无";
  }
  
 }

各位注意看哦．在前置代码里，我们在ＶＳ２００５里一般写为　Eval（“companyclass_3”）但是在二次绑定的时候，我们用的是DataBinder.Eval(e.Item.DataItem, "CompanyClass_3")

还有就是，平时我们对lable控件付值是用lable.text=fsf;形式就可以了，但是在这里，我们采用的是

Label myLabel = (Label)e.Item.FindControl("myLabel");
    myLabel.Text = Convert.ToString(dr["name"]);

，我要去查下为什么这么写哦．有知道的告诉偶一声也可以哦