Hi all! So my first Post:
I want to pass to a DataSource(SQL, Linq) more than one SelectParameter or what ever will do the work.
I have many ArtistIds i want to pass to my source, so that it will display only those entries with my Parameters.
My Problem is, that i dont know in which Format i can pass more than one Parameter, till now i used QueryStrings but that only works for one Parameter, no?
I have a DataTable filled with all my IDs and im system-caching it to pass it from a Search-Site to a Detail-Site, maybe theres a better way?
This is my Source:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MvcMusicStoreConnectionString %>"
SelectCommand="SELECT Album.Title, Album.Price, Album.AlbumArtUrl, Artist.Name, Genre.Name AS Expr1 FROM Album INNER JOIN Artist ON Album.ArtistId = Artist.ArtistId INNER JOIN Genre ON Album.GenreId = Genre.GenreId WHERE Album.ArtistId = @ArtistId">
View Complete Post