2 Replies - 675 Views - Last Post: 02 October 2012 - 05:16 AM Rate Topic: -----

#1 hiral2cool  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 13
  • Joined: 15-July 12

In RowFilter How To Select the All The Table Column in C#?

Posted 01 October 2012 - 10:11 AM

Here Is My Code...

here i have one textbox..when writing some text automatically match the String and find all Row..

now ..but in my code..here Only Filter using "ClientName" i want serch that text from all the Column..

How to specify the All The Column in the RowFilter plzz give me solution



    private void txtSearch_TextChanged(object sender, EventArgs e)
    {
      dv.RowFilter = "ClientName Like '%" + txtSearch.Text + "%'";
      dgClientMaster.DataSource = dv;
    }

This post has been edited by Curtis Rutland: 01 October 2012 - 11:34 AM
Reason for edit:: use code tags


Is This A Good Question/Topic? 0
  • +

Replies To: In RowFilter How To Select the All The Table Column in C#?

#2 Skydiver  Icon User is online

  • Code herder
  • member icon

Reputation: 3662
  • View blog
  • Posts: 11,466
  • Joined: 05-May 12

Re: In RowFilter How To Select the All The Table Column in C#?

Posted 01 October 2012 - 03:20 PM

You have to change your row filter do a like comparison on each of the columns: "Col1 LIKE %foo% OR Col2 LIKE %foo% OR ..."
Was This Post Helpful? 0
  • +
  • -

#3 hiral2cool  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 13
  • Joined: 15-July 12

Re: In RowFilter How To Select the All The Table Column in C#?

Posted 02 October 2012 - 05:16 AM

View PostSkydiver, on 01 October 2012 - 03:20 PM, said:

You have to change your row filter do a like comparison on each of the columns: "Col1 LIKE %foo% OR Col2 LIKE %foo% OR ..."

perfect....thnksss
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1