Passing parameter of C# DateTime to SQL Server 2005?

Question

How do I pass C# DateTime values (FromCreateDate and ToCreateDate) to SQL Server 2005 in order to select from a view ?

The result set CreateDate column must be between FromDateDate and ToCreateDate.

Answer 1

Just set the parameter type to SqlDbType.DateTime

e.g

SqlCommand cmd = new SqlCommand("Select * From dbo.MyView Where createDate = @FromDate", SqlCon);
cmd.Parameters.Add(new SqlParameter(@FromDate, SqlDbType.DateTime));
cmd.Parameters["@FromDate"].Value = fromDate;