Hello,
I'm using ASP.Net 2.0 and the Jan 2006 Enterprise Library.
What I'm doing is passing an ArrayList into a stroed procedure to do an
Insert. Here's some code:
Dim params as New ArrarList
params.Add("first parameter value")
params.Add("second parameter value")
etc.
db.ExecuteNonQuery(transaction, "sproc_Insert", params.ToArray)
tansaction.Commit()
Obviously some code is missing, which doesn't matter because the insert
works. The problem I'm not sure how to get around is how can I get the ID of
the inserted record out of hte stored procedure using this same method or is
there a way to add something to what I'm doing to get the @@indentity from
the SPROC.
Any suggestions are welcomed.
Thanks
Clint Pidlubny