asp.net - Passing null in textboxes not working -
hi m trying pass null values in date textboxes textbox 3 , textbox 4 not able so. please let me know doing wrong. need when page load , textboxes empty need gridview load entire table . @ present loads when enter date range if leave date textboxes empty empty page.i have ajax calendar extension drop down calendar control attached these 2 text boxes. don't know if problem. please help..
here code
<asp:sqldatasource id="sqldatasource2" runat="server" connectionstring="<%$ connectionstrings:ingestconnectionstring %>" selectcommand="select id, story_number, date, memory_card, story_name library (story_name '%' + @story_name + '%') , (story_number '%' + @story_number + '%') , (@startdate null or @startdate = '' or date >= @startdate) , (@enddate null or @enddate = '' or date <= @enddate)"> <selectparameters> <asp:controlparameter controlid="textbox1" name="story_name" propertyname="text" defaultvalue="%" /> <asp:controlparameter controlid="textbox2" defaultvalue="%" name="story_number" propertyname="text" /> <%--<asp:controlparameter controlid="dropdownlist1" defaultvalue="%" name="memory_card" propertyname="selectedvalue" />--%> <asp:controlparameter controlid="textbox3" name="startdate" convertemptystringtonull="true" propertyname="text" /> <asp:controlparameter controlid="textbox4" name="enddate" convertemptystringtonull="true" propertyname="text" /> </selectparameters> </asp:sqldatasource>
it works when put ridiculous date range in default values under not able pass null database see full table when page loads
<asp:controlparameter controlid="textbox3" name="startdate" convertemptystringtonull="true" defaultvalue="1/1/1977" propertyname="text" /> <asp:controlparameter controlid="textbox4" name="enddate" convertemptystringtonull="true" defaultvalue="1/1/2100" propertyname="text" />
update:
where add code? adding in control parameter this
<asp:controlparameter controlid="textbox4" name="enddate" sqldatasource2.cancelselectonnullparameter="false" propertyname="text" />
it gives me following error when
literal content ('<asp:controlparameter controlid="textbox4" name="enddate" sqldatasource2.cancelselectonnullparameter="false" propertyname="text" />') not allowed within 'system.web.ui.webcontrols.parametercollection'
cancelselectonnullparameter
property of sqldatasource control, not parameters contained in control:
<asp:sqldatasource id="sqldatasource2" runat="server" cancelselectonnullparameter="false" connectionstring="<%$ connectionstrings:ingestconnectionstring %>" selectcommand="select id, story_number, date, memory_card, story_name library (story_name '%' + @story_name + '%') , (story_number '%' + @story_number + '%') , (@startdate null or @startdate = '' or date >= @startdate) , (@enddate null or @enddate = '' or date <= @enddate)"> <selectparameters> <asp:controlparameter controlid="textbox1" ...
Comments
Post a Comment