Question : system.data.sqlclient.sqlexception: 'must declare the scalar variable
Answered by : richard-john
I know you closed this - but for future reference you and others - your web.config has a debug level output parameter - set it to debug. Your SQL query will be logged in order to provide some very useful info.
I have used the query generated in the log to troubleshoot what appears to be incorrect or missing ..
From Web Config find or add this
<configuration> <appSettings>
<add key="Logging" value="{ File: '~\\App_Data\\Log\\App_{0}_{1}.log', FlushTimeout: 0, Level: 'Debug' }" /> <appSettings>
<configuration>
Source : https://github.com/ | Last Update : Tue, 30 Aug 22