Returning Record ID Value

[Kevin]

Am very new at ASP.NET 2.0 and .NET!
Want to get the MembershipID from an inserted record using SqlDataSource:-
<InsertParameters>
<asparameter Name="MembershipID" Direction="Output" Type="Int32"
DefaultValue="0" />
<asparameter Name="FirstNames" Type="String" />
<asparameter Name="LastNames" Type="String" />
</InsertParameters>

How can i get the MembershipID using VB??

Thanks
Kevin

 

[Stuart Irving]

http://www.devx.com/vb2themax/Tip/18893

 

[Kevin]

Thanks for the help.

Have discovered and used:-
myID = e.Command.Parameters(0).Value.ToString

In the SqlDataSource1_Inserted event.

Kevin

 

[Kevin Spencer]

You can also use a SELECT in the SP which pulls the @IDENTITY value, and
simply call any data method which executes a Stored Procedure and returns a
record set.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Numbskull

Show me your certification without works,
and I'll show my certification
*by* my works.