I want to use the rowfilter method of the dataview object to show specific rows of a database that a person stated in a text box. The thing is is that if a person writes something that is not in the database, I want the an error message show that the record does not exist. Here is my code: -

if ((Request.Form["Author"] != null) && (Request.Form["Author"].Length > 0))
       {
         if(Author.Text == null)
         {
           Response.Write("This entry does not exist");
         }
         else
         {
           objDataView.RowFilter = "BookAuthor LIKE'" + Author.Text + "'";
         }
       }

Any ideas where I am going wrong??

Thanks

Adz - Portsmouth Massive

__________________
Adz - Learning The J2EE Ways.

I'm not sure -- I've never bothered to use the Request.Form collection, because (as you have done in your code) you can access the page's controls directly.

Anyway, it looks like your code says "If the author is present, then if the author is not present then write an error message."

So it looks like a simple logic error to me. You can never write an error message with this code, because if the first condition is satisfied, the second condition will never be satisfied.


-Van
(Old dog learning new tricks...)

You need to create the filter first:

objDataView.RowFilter = "BookAuthor LIKE '%" + Author.Text + "%'";

Note the addition of %s to assist the search.

Then, once the data is filtered, you need to see if there are any rows. It's illogical to say that rows don't exist because the user didn't enter anything.

Also, if this is all in ASPX, what is with all the Request and Response calls? ASP.Net is supposed to move code away from using that stuff. To provide feedback on the form you should use asp:label or literal controls and (en|dis)able then and set their text properties according to the appropriate outcomes.

Peter
------------------------------------------------------
Work smarter, not harder.