Jiri Cincura wrote:
>
> On Thu, Oct 2, 2008 at 11:01 AM, Zento <[EMAIL PROTECTED]> wrote:
>> "Execute Query" button worked correctly, but "Test Query" button show
>> this
>> error: "Must declare command parameters". Tryed also to fill SelectQuery
>> property directly, adding a named and typed parameter manually, but same
>> error showed again.
>
> Did you add parameter with same name? How you code looks like?
>
This is the .aspx code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AT3W %>"
ProviderName="<%$ ConnectionStrings:AT3W.ProviderName %>"
SelectCommand="SELECT UsuDisp.Dispositivo, Usu.IDUsuario, Usu.Usuario,
Usu.Nombre
FROM UsuariosDispositivos UsuDisp
LEFT OUTER JOIN Usuarios Usu ON Usu.IDUsuario = UsuDisp.Usuario
WHERE (UsuDisp.Dispositivo = @Param1)">
<SelectParameters>
<asp:Parameter DefaultValue="2" Name="Param1" />
</SelectParameters>
</asp:SqlDataSource>
There is still no .aspx.cs code involving this query, because it's failing
to work in the IDE and the "Refresh Schema" link from smart tag shows a
"Must declare command parameters" error, so I haven't coded anything yet.
I've tried "@Param1" as parameter name, "Dispositivo" and no parameter name,
also with same result.
--
View this message in context:
http://www.nabble.com/Problems-with-parametrized-queries-%28DDEX-VS2008%29-tp19775726p19836392.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
