Member Avatar for ypdev
ypdev 0 Light Poster

Hi Everyone,

I'm trying to set values using checkbox control inside SelectCommand.

For example:
checked = open
unchecked = close + open or any value

The 'checked' seems to be working fine but having an issue to fix the 'unchecked' part.

SelectCommand="SELECT * FROM [table1] WHERE CurrentStatus = case when @ShowOpenClose = 1 then 'open' else 'closed' end ORDER BY [srid] DESC"

<asp:ControlParameter ControlID="CheckBox_ShowOpenClose" PropertyName="Checked" Name="ShowOpenClose" />

Can you please help?

Many Thanks,
Perry

  • 1 Contributor
  • 0 Replies
  • 82 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.