System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'prcGetRes' expects parameter '@IDSUBZ', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClsRes.clsFront.GetresData(String IDSUBZ, String IDS, String IDT, String UF, String IDTG, String Top, String Start) in c:\Inetpub\vhosts\abhimanu.com\abhipedia.abhimanu.com\App_Code\ClsRes.cs:line 19533 at WAPI_Default.getarticlesside1(String IDSUBZ, String IDS, String IDT, String UF, String tpname, String restypename) in c:\Inetpub\vhosts\abhimanu.com\abhipedia.abhimanu.com\WAPI\Default.aspx.cs:line 20380 at WAPI_Default.getarticlesside() in c:\Inetpub\vhosts\abhimanu.com\abhipedia.abhimanu.com\WAPI\Default.aspx.cs:line 20673 at WAPI_Default.Page_Load(Object sender, EventArgs e) in c:\Inetpub\vhosts\abhimanu.com\abhipedia.abhimanu.com\WAPI\Default.aspx.cs:line 181 ClientConnectionId:f65abef4-b64c-44e6-aa3d-093a0ecdb8d3 Error Number:201,State:4,Class:16