select c.id,a.PCName,b.pcname,b.pinyin,b.JianMa,c.location
from cf_provice_city a inner join cf_provice_city b on a.pcid = b.ParentId inner join cf_location c on b.pcid=c.pcid
where b.PCName="蘇州市"
在數據庫中這行SQL執行是沒有問題的，但是如何用Eval綁定到一列中去？我之前是這樣綁定的：<asp:Label runat="server" ID="lblCity" Text="<%# Eval("a.PCName")+"-"+Eval("b.pcname")+"("+Eval("b.pinyin")+"-"+Eval("b.JianMa")+")" %>"></asp:Label>但是運行後一直報錯，說找不到a。後來我在高人的指導下把SQL改成了select c.id,a.PCName as city,b.pcname asprovince,b.pinyin,b.JianMa,c.location from cf_provice_city a inner join cf_provice_city b on a.pcid = b.ParentId inner join cf_location c on b.pcid=c.pcid where b.PCName="蘇州市" 在用Eval綁定就可以了！
<asp:Label runat="server" ID="lblCity" Text="<%# Eval("City")+"-"+Eval("Province")+"("+Eval("pinyin")+"-"+Eval("JianMa")+")" %>"></asp:Label>
