By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,356 Members | 1,023 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,356 IT Pros & Developers. It's quick & easy.

Gridview and Empty Textbox .net 2.0

P: n/a
Hi,

I have a gridview based on a SQL stored procedure. I then want to let
the user filter the results by 4 textboxes. When all 4 textboxes have
"some" search criteria the gridview works fine, but if even one is left
blank the gridview doesn't return any records. When I test the stored
procedure itself it works fine. Can you help me work with the empty
textboxes.

thanks,
Paul

Jan 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
> Hi,

I have a gridview based on a SQL stored procedure. I then want to let
the user filter the results by 4 textboxes. When all 4 textboxes have
"some" search criteria the gridview works fine, but if even one is left
blank the gridview doesn't return any records. When I test the stored
procedure itself it works fine. Can you help me work with the empty
textboxes.

thanks,
Paul


What will the query be when you have empty textboxes?
How did you test the stored procedure?

An empty textbox will have an "empty string" as value, not "null",
maybe that's the problem.

Can you use SqlProfiler to check what is executed in SqlServer?

Hans Kesting
Jan 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.