The gridview simply displays rows from its datasource.
If you want to filter rows, you should do it in the datasource. It's
usually best to do the filtering in your SQL, but you can also use a
DataView.
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"yasin" <ce*******@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...
For instance there is a column which grabs city names from Sql Database, I
want only see the rows whose city is new york.