Could not find stored procedure

Question

Hi Am new to using this strore procedure System.Data.SqlClient.SqlException: Could not find stored procedure m getting this type of error so please help to me to rectify this error.. Thank You

Manish Dwivedi · Answer

Hi Prabhaker I think you are using stored procedure in your application which doesn't exist in your database. So first create the stored procedure in your database and then use that.

Manish Dwivedi · Answer

Hi Please Check all these once again check the name on the server matches exactly the name you call check the data source is set to the right server check the database name is specified. or might be it's database permission for that check this article http://imar.spaanjaars.com/395/configuring-an-aspnet-20-application-to-work-with-microsoft-sql-server-2000-or-sql-server-2005

Ankit Mishra · Answer

Perfectly Right and more over it can be a spelling mistake while mentioning the database name in app.config. This is the error which i got.

Prabhakar Reddy · Answer

ya okbut i have created store procedure in my db also. but still its showing Could not find store procedure error