sqldatasource textbox control NULL problem

Question

User-1849419740 posted

i've a stored procedure and i wanna make searching by using textboxs.when the textbox3 and textbox5 is empty , it is required that all the records has come but there is no record.

stored procedure 


@camera  nvarchar(20), 
@three nvarchar (20),
 
AND  camera = coalesce(@camera, camera) AND three = coalesce(@three, three) 
   
 

<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString 
="<%$ ConnectionStrings:conn %>" SelectCommand="Urungoster"SelectCommandType ="StoredProcedure"> 
<SelectParameters> 
<asp:ControlParameter ControlID="TextBox3" Name="camera" PropertyName="Text" Type="String"
  ConvertEmptyStringToNull ="false"/> 
<asp:ControlParameter ControlID="TextBox5" Name="three" PropertyName="Text" Type="String" 

ConvertEmptyStringToNull="false"/>

 

 

  

Answer 1

User1288251396 posted

Could you please clean up your posted code?

(It makes things a lot more readable if you use the Insert Code tool. If you need instructions, see this How to use the Forums' "Insert Code" tool post.)

Also, please post all related code, markup, and stored procedures.

Answer 2

User1295264499 posted

When you are passing parameter from your application via textbox it is sending an empty character '' and not null so colease might not work. I think you should use the wild charater '%' when parameter is empty or NULL.

Hope this help

---

Please mark as answer if this solve your problem

DevTechie.com

 

Answer 3

User77042963 posted

 

Your SqlDataSource with  CancelSelectOnNullParameter="false"

 

<asp:SqlDataSource ID="SqlDataSource4" runat="server  CancelSelectOnNullParameter="false" ...>

Your stored procedure with default value null for the two parameters:

stored procedure

..
@camera  nvarchar(20)=null, 

@three nvarchar(20)=null 
....

SELECT  * FROM yourTable
WHERE ...AND (camera =@camera OR =@camera IS NULL)) AND (three = @three OR @three IS NULL)