.Net 2005 introduces a much easier way of doing this... a SqlDataSource .

The SqlDataSource object allows you to retrieve the parameter data automatically. Here's how: Put a SqlDataSource object...

The best way to utilize a recordsets output from a stored procedure is through a function.  I recommend that instead of having SP#1 call SP#2 for data, that SP#2 be...

This is a ramification of the sqlslammer fix which was applied by the early SP package. If you had no SP's applied, then SP4 would install seemlessly.

To resolve the error:...

Yes, you are retrieving the data exactly as SQL Server has stored it physically on disk.

You can eliminate the problem by either:

  a) When inserting the data, order it.  So...

Could be the security setting are out of synch.

  In Tools/Internet Options, Security tab.  Move the "Security for this zone" verticle slider bar in any direction, then select "Default level".

 ...

Presuming you simply want to pass in one parameter you could do:

CREATE PROCEDURE dbo.SPName @v_Dt as datetime

AS

Select WhatEver from dbo.YourTable

where DateCol >= @v_Dt and DateCol < DATEADD(m, 1, @v_Dt)