1jaws
asked on
select parameters sqldatasource
<asp:SqlDataSource ID="dsMysource" runat="server" ConnectionString="<%$ ConnectionStrings:xxx%>"
SelectCommand="spmy" SelectCommandType="StoredP rocedure">
<SelectParameters>
<asp:Parameter Name="id" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="check" Type="Boolean" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
I get a error for the boolean, what am I doing wrong...? I am trying to set to default value of false for the check field which is bit field...
And second part of the question on code behind c#
dsMysource.SelectParameter s["check"] .DefaultVa lue = ??? ;
SelectCommand="spmy" SelectCommandType="StoredP
<SelectParameters>
<asp:Parameter Name="id" Type="Int32" DefaultValue="0" />
<asp:Parameter Name="check" Type="Boolean" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
I get a error for the boolean, what am I doing wrong...? I am trying to set to default value of false for the check field which is bit field...
And second part of the question on code behind c#
dsMysource.SelectParameter
Its a C# parameter field at this point, Default="False"
dsMysource.SelectParameter s["check"] .DefaultVa lue = true; // = false;
ASKER
on C# code behind, I am setting to check default value to true... but on aspx , here
<asp:Parameter Name="check" Type="Boolean" DefaultValue="0" />
trying to set to false... and for some reason giving me problem..
<asp:Parameter Name="check" Type="Boolean" DefaultValue="0" />
trying to set to false... and for some reason giving me problem..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you and other one should be "True"