ALTER proc [dbo].[autherlist] @l nvarchar(1)='' as IF @l = '' BEGIN SELECT [author_id], [F-name], [L-name]FROM [authors] ORDER BY [L-name] end else begin SELECT [author_id], [F-name], [L-name]FROM [authors] where [L-letter] = @l ORDER BY [L-name] end
<asp:SqlDataSource ID="ds" runat="server" ConnectionString="<%$ ConnectionStrings:ariaquoteConnectionString %>" SelectCommand="autherlist" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:RouteParameter DefaultValue="" Name="l" RouteKey="letter" Type="String" /> </SelectParameters> </asp:SqlDataSource>
CancelSelectOnNullParameter="false"
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)