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

Stimulsoft Ultimate discussion
Post Reply
Rezakhosravi
Posts: 11
Joined: Mon Dec 23, 2019 10:23 pm

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

Post by Rezakhosravi » Tue Dec 31, 2019 10:35 pm

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:
Image

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

3- use Parameter to Sql Server Query :
Image

4- run and error :
Image

How solve it ?
Andrew
Posts: 3998
Joined: Fri Jun 09, 2006 3:58 am

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

Post by Andrew » Thu Jan 02, 2020 6:43 am

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.
Post Reply