Murugan.com
Murugan Andezuthu Dharmaratnam

  |  HOME   |  BLOG   |  TWITTER   |  ARTICLES   |  8086  |  C++   |  VC++   |  ASP .NET   |  VB .NET   |  JAVA SCRIPT   |  MS SQL   |  MY   |  VIDEOS   |  DOWNLOADS   |  CONTACT ME   |  



Data View Row Filter , Multiple Filters

Home    ASP .NET    Data View Row Filter

       


Data row filter for a dataview could be set like this

        oDataView.RowFilter = "TABLENAME = 1"

If you would like to set multiple filters then 

        oDataView.RowFilter =  oDataView.RowFilter  +   '"AND POSTTITLE LIKE " & "'%" & txtSearch.Text & "%'"

Here I am using the clause LIKE , like in the sql query






  |  HOME   |  BLOG   |  TWITTER   |  ARTICLES   |  8086  |  C++   |  VC++   |  ASP .NET   |  VB .NET   |  JAVA SCRIPT   |  MS SQL   |  MY   |  VIDEOS   |  DOWNLOADS   |  CONTACT ME   |  

Copyright 2009 @ Murugan Andezuthu Dharmaratnam