Server Error in '/MasterPage' Application.

Could not find stored procedure 'spSearchPlayers'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'spSearchPlayers'.

Source Error:

Line 31: cmd.Parameters.Add(searchParameter);

Line 32: con.Open();

Line 33: GridView1.DataSource=cmd.ExecuteReader();

Line 34: GridView1.DataBind();

Line 35: }

Source File: c:\Users\Hp\Documents\Visual Studio 2010\WebSites\MasterPage\Default.aspx.cs Line: 33

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'spSearchPlayers'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +90 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1406 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +134 System.Data.SqlClient.SqlCommand.ExecuteReader() +99 _Default.getdata(String SearchTerm) in c:\Users\Hp\Documents\Visual Studio 2010\WebSites\MasterPage\Default.aspx.cs:33 _Default.Page_Load(Object sender, EventArgs e) in c:\Users\Hp\Documents\Visual Studio 2010\WebSites\MasterPage\Default.aspx.cs:18 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51 System.Web.UI.Control.OnLoad(EventArgs e) +92 System.Web.UI.Control.LoadRecursive() +54 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34248

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir11y ago
Hi,

As per your error, it is saying stored procedure id not present.

Please ensure that you are using correct stored Procedure Name in your code.

If it is correct check for it is exist in same database which you are using in your application.
Manas Mohapatra11y ago
Hi Deepak,

As per your error, it is saying stored procedure id not present.

Means it doesn't exist in your current database. Please check database name in your connection string and go to that database find there that stored procedure is exist.

I am anticipating that you might refer wrong database in your connection string or you have not crated stored procedure in your current database.

Hope it will resolve your issue.

could not find stored procedure

Server Error in '/MasterPage' Application.

Could not find stored procedure 'spSearchPlayers'.