tags:

views:

55

answers:

1
Q: 

What is the full syntax for calling a stored procedure in SubSonic 3.0?

What is the full syntax for a stored procedure using SubSonic 3.0? Here is my code which is not working:

DataSet ds = new DataSet();
StoredProcedure sp = test.Usersp_Stock_Search("", 0, "");
sp.ExecuteDataSet();
A: 

ds=sp.ExecuteDataSet()

Rob Conery  2010-01-25 18:30:43

related questions

What do you use to write and edit stored procedures in Oracle?
How do I determine using TSQL what roles are granted execute permissions on a specific stored procedure?
How do I run Oracle plsql procedure from Lisp?
Output parameters not readable when used with a DataReader
How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?
How do I call MySQL stored procedures from Perl?
Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?
Default Integer type in ASP.Net from a Stored Procedure
Should data security be performed on the database side?
How do I conditionally create a stored procedure in SQL Server?
Why is parameterized SQL generated by NHibernate just as fast as a stored procedure?
PHP + MySql + Stored Procedures, how do I get access an "out" value?
SQL file encoding in Visual Studio
T-SQL stored procedure that accepts multiple Id values
SQL Server Fast Forward Cursors
Formatting Stored Procedures
Asynchronous Stored Procedure Calls
Stored Procedure and Timeout
Which is better: Ad hoc queries, or stored procedures?
Query a union table with fields as columns.
Standalone tools for debugging stored procedures
What are the pros and cons to keeping SQL in Stored Procs versus Code
LINQ-to-SQL vs stored procedures?
Insert Update stored proc on SQL Server
Is there any list datatype in MySQL stored procedures, or a way to emulate them?