<asp:ListItem Text="Select" Value='x' Selected="True"></asp:ListItem> for the ddlEid DropDown List. Change the value to -1 and then in your SELECT statement make the WHERE clause something like WHERE @Eid = (the interger field you want to check)
OR @Eid = -1
paindaasp
Star
12080 Points
2034 Posts
Re: Passing ControlParameters from code behind in C#
Jul 16, 2012 12:33 AM|LINK
I assume that you are hitting the error on:
<asp:ListItem Text="Select" Value='x' Selected="True"></asp:ListItem> for the ddlEid DropDown List. Change the value to -1 and then in your SELECT statement make the WHERE clause something like WHERE @Eid = (the interger field you want to check) OR @Eid = -1
For the date:
Set the DefaultValue to a date: '01/01/2001'
khurj01
Member
15 Points
236 Posts
Re: Passing ControlParameters from code behind in C#
Jul 16, 2012 12:47 AM|LINK
It seems to work fine now...
Thanks for all your help.