Hello; I find a bug with stored procedures and DateTime params.
The code auto-generated by Radzen is:
... new SqlParameter("@MyDateTimeParam", SqlDbType.DateTime) {Direction = ParameterDirection.Input, Value = string.IsNullOrEmpty(MyDateTimeValue) ? (DateTime?)null : DateTime.Parse(MyDateTimeValue, null, System.Globalization.DateTimeStyles.RoundtripKind)} ...
This throw a error, because the SqlServer don't accept the (DateTime?)null ... The correct code (tested and working) is:
... new SqlParameter("@MyDateTimeParam", SqlDbType.DateTime)
{
Direction = ParameterDirection.Input,
Value = string.IsNullOrEmpty(MyDateTimeValue) ? DBNull.Value : (object)DateTime.Parse(MyDateTimeValue, null, System.Globalization.DateTimeStyles.RoundtripKind)
} ....
Please, set this in an update!