If I ran my sproc from query analyzer, I get the correct results(data is filtered by datetime), i.e:
exec Uds.Dashboard_GetJobs '9/20/2010 11:01:23 PM'
However, if I ran it from the Asp.Net page, (ALL records are showed). Looking at the SQL Profiler I see the following call:
exec sp_executesql N'exec Uds.Dashboard_GetJobs',N'@date nvarchar(21)',@date=N'9/20/2010 11:01:23 PM'
Running both statements above in the query analyzer it WILL return me different results. Why???
Someone mentioned that it looks like I don't have correct data type specified for SQLParameter in .Net application.
I was asked to create something like: cmd.Parameters.Add("@Date",SqlDbType.DateTime).Value = ..
Well, my code in the asp.net is in this form:
<asp:SqlDataSource ID="sourceRealtimeLogging" runat="server"
ConnectionString="<%$ ConnectionStrings:UctConnectionString %>"
<asp:ControlParameter ControlID="UpdatedTimeUTC" Name="date" PropertyName=&quo
View Complete Post