SqlCommand.Prepare method requires all parameters to have an explicitly set type.

[Rezakhosravi]

HI
when i use a range Parameter and have this error :
SqlCommand.Prepare method requires all parameters to have an explicitly set type.
1- crate a range Variable:


2- Create 2 new Parameter for Num.From and Num.To like this:


3- use Parameter to Sql Server Query :


4- run and error :


How solve it ?

[Andrew]

Hello,

Please send us a sample that reproduces the issue to support@stimulsoft.com. We will check everything and give you proper advice.

Thank you.