I am trying to get an output value from a stored procedure using
sqlDataSource in asp.net 2.0.  But I only get a null value for the
output.  Can someone please help?

The sqlDataSource:

<asp:SqlDataSource ID="DataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings: ConnectionString1 %>"
           SelectCommand="UserLkp" SelectCommandType="StoredProcedure"

           <SelectParameters>
                 <asp:Parameter Name="UserID" Type="String" />
<asp:Parameter Direction="InputOutput" Name="Role" Type="String" />
</SelectParameters>
       </asp:SqlDataSource>

My stored Procedure is

CREATE PROCEDURE [dbo].[UserLkp]
@Hawkid varchar(30),
@eRole varchar(50) OUTPUT
as
select @eRole=eRole from eUsers Where eUser=@Hawkid
GO

I am using selected event of dataSource1 as in the following:

Protected Sub DataSource1_Selected(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles
eUserDataSource.Selected

       Dim param As System.Data.SqlClient.SqlParameter
       For Each param In e.Command.Parameters
           Response.Write(Server.HtmlEncode(param.ParameterName) &
"=")
           Response.Write(Server.HtmlEncode(param.Value) & " (")

Response.Write(Server.HtmlEncode(param.Value.GetType().ToString()) &
")<br />")
       Next
       
   End Sub