Executing a Stored Procedure using Command Text

moforiappiah

I urgently need help on how to execute a stored procedure in SQL Express 2005. I have created a stored procedure with as follows:

Create Procedure upInsertCountry

@CountryName varchar(50)

INSERT INTO CountryTable (CountryName) VALUES (@CountryName)

When run the following code :

myCom.CommandType.StoredProcedure
myCom.CommandText = "upInsertCountry @CountryName = 'South Africa' "

I get the error message 'Incorrect Syntax near 'upInsertCountry'

But when i copy the above statement and run it in the Management Studio, it works.

I am using SQL Express 2005
Any idea what the problem is?

Sep 8 '07 #1

topdown

You have the wrong CommandText for the CommandType of StoredProcedure.
You should be simply setting CommandText = to the stored procedure name, and set the parameters in the parameters collection of the command object.

An alternative, however less desired method of executing would be to execute the procedure as CommandType.Text. Then you could execute with the CommandText set as such:


http://forums.microsoft.com/MSDN/Sho...89684&SiteID=1

Oct 5 '07 #2

debasisdas

Find the details of calling stored procudure here and modify as required including the connection string.

Oct 5 '07 #3