How to use AutoGenerateColumns property for GridView when Column shows twice in GridView design in ASP.Net

Hi All,

I am very fortunate to find this helpful article from Mudassar.

http://www.aspsnippets.com/Articles/Search-records-in-GridView-and-highlight-results-in-ASPNet-using-C-and-VBNet.aspx

I copies exactly the code in this article except I have more columns in my SQL string. My Gridview has 3 columns and my SQL string has 8 columns.

When I run my aspx page, the search result page displays 11 columns on my Gridview page. I thought it should only display 3 columns that I specify on my Gridview page.

Am I missing something here?

Thanks so much for any input you can provide.