Creating reports and dashboards | Stimulsoft community forum

Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/

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

https://forum.stimulsoft.com/viewtopic.php?t=58282

Page 1 of 1

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

Posted: Tue Dec 31, 2019 10:35 pm
by 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:
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 ?

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

Posted: Thu Jan 02, 2020 6:43 am
by 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.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited