日期:2014-05-18 浏览次数:20531 次
DataView dv = (DataView)DSAlbum.Select(DataSourceSelectArguments.Empty);
<asp:SqlDataSource ID="DSAlbum" runat="server" ConnectionString="<%$ ConnectionStrings:Jigu_ConnectionString %>" SelectCommand="SELECT album.aldate, album.acomp, album.adisc, album.aintro, album.aname, artist.aname AS artist, lang.laname, cate.catname, artist.aid, picture.pname, picture.pdir, picture.psid FROM album INNER JOIN cate ON album.acate = cate.catid INNER JOIN lang ON album.alan = lang.lanid INNER JOIN artist ON album.arid = artist.aid INNER JOIN picture ON album.alid = picture.psid WHERE (picture.psize = 'M') and alid=@id"> <SelectParameters> <asp:QueryStringParameter Name="newparameter" QueryStringField="id" DefaultValue="1" /> </SelectParameters> </asp:SqlDataSource>