Server Error in '/' Application.

The parameterized query '(@Training_ID nvarchar(4000))SELECT *   FROM all_trainings  wher' expects the parameter '@Training_ID', which was not supplied.

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: The parameterized query '(@Training_ID nvarchar(4000))SELECT *   FROM all_trainings  wher' expects the parameter '@Training_ID', which was not supplied.

Source Error:


Line 94:         Command.Parameters.Add(New SqlParameter("@Training_ID", Data.SqlDbType.NVarChar, 4000)).Value = Training_ID
Line 95:         Connection.Open()
Line 96:         Dim dr As SqlDataReader = Command.ExecuteReader()
Line 97:         Dim dt As DataTable = New DataTable("all_trainings")
Line 98:         dt.Load(dr)

Source File: C:\inetpub\wwwroot\App_Code\fn.vb    Line: 96

Stack Trace:


[SqlException (0x80131904): The parameterized query '(@Training_ID nvarchar(4000))SELECT *   FROM all_trainings  wher' expects the parameter '@Training_ID', which was not supplied.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +91
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +764
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4620
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +90
   System.Data.SqlClient.SqlDataReader.get_MetaData() +103
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
   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) +3386
   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) +710
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +1366
   System.Data.SqlClient.SqlCommand.ExecuteReader() +147
   fn.GetTrainingDetils(String Training_ID) in C:\inetpub\wwwroot\App_Code\fn.vb:96
   CourseDetails.Page_Load(Object sender, EventArgs e) in C:\inetpub\wwwroot\CourseDetails.aspx.vb:15
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +154
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4082


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