Thom,
I'm terribly sorry for the long delay. I've been out of the office. Anyway here is a sample of how I use my stored procedures.
--[ The stored procedure in pubs database ]
CREATE Procedure GetEmpl
@LName nVarChar(30)
as
/*
The creating of this table is just for the sake of
showing you how I use temp tables.
With a procedure as simple as this, creating the table
is just a waste
*/
Table #tmp(
LName nVarChar(50),
FName nVarChar(50),
Hired DateTime)
Insert into #tmp
Select
lname,
fname,
hire_date
From employee
Where lname Like @LName
Select * from #tmp
GO
--[End of Procedure]
I'm not sure how this is accessed using ADO.NET but with ADO 2.xx this is how I do it...
rs=cn.execute("exec GetEmpl '" & TxtLName.Text.Trim & "'")
At this point the recordset has been populated with the result of the stored procedure.
Hope this clears things up 8)
Regards
Martin
Shit happens!!!