<div>
I would also like to re-name some columns - say CustomerID to just ID. 
 
Thanks for helping me - new to web-programming (.net really)
</div>

<div>
Change your query. 
Example: 
If you are using 
 
Select * from Customers 
 
Then; Name the fields which you want and assign alias to re-name the columns 
 
Select CustomerID as ID, CustomerName as Name from Customers
</div>

<div>
are you trying to hide other columns based on the search. If so you can set the GridView.Columns[i].Visible property. You can also rename columns using HeaderText &nbsp;GridView.Columns[i].HeaderText
</div>

<div>
Thanks for the response, 
 
I am using a DataSet to get my data, and don't want to change the query as it is used on more than one page. 
 
I like the idea of the GridView.Columns[i].visible, as well as GridView.Columns[i].HeaderText, however is there a way I can address the columns by name, index of index location? 
 
For a perfect solution, I would like to hide everything first, then make visible by name, for example: 
 
HideEverything 
Show(&quot;FirstName&quot;) 
Rename(&quot;FirstName&quot; to &quot;First&quot;) 
Show(&quot;LastName&quot;) 
Rename(&quot;LastName&quot; to &quot;Last&quot;) 
 
Thanks for the help!
</div>

<div>
A Bound Column in a grid view will not have a name property. You can access the item of ColumnCollection only through index property.
</div>

<div>
Another Note - with this code: 
Me.GridViewResults.Columns(0).Visible = False 
 
I get this error: 
Index was out of range. Must be non-negative and less than the size of the collection. 
Parameter name: index 
 
I know there is data there, the same query without the visible line returns man rows. 
I tried index of 1 and 2 as well - no go. 
 
Thanks, 
Andrew
</div>

<div>
It means that Columns count is zero. make a check that 
Me.GridViewResults.Columns.Count &gt;&nbsp;0 
before executing that line
</div>

<div>
What I did is in the code selection below. 
 
it results in popping up a 0 in the message box, but the screen looks like the jpg 
 
any thoughts? 

<pre><code class="code-1 nolinks" id="code-122162">If (Me.GridViewResults.Columns.Count &gt; 0) Then
 Me.GridViewResults.Columns(0).Visible = False
Else
 MsgBox(Me.GridViewResults.Columns.Count.ToString)
End If
</code></pre>
<a href="https://filedb.experts-exchange.com/incoming/2008/07_w29/42841/SearchResults.JPG" target="_blank" class="file-inline" title="Search Results (26 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SearchResults.JPG</a>
</div>

SearchResults.JPG

<div>
Is this code getting executed before or after the databind call?
</div>

<div>
Full Code (Sub) 

<pre><code class="code-10 nolinks" id="code-122172"> Protected Sub BtnFind_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnFind.Click
 Dim ClientAdapter As New RMSTableAdapters.CustomersTableAdapter
 'Determine what drop-down box was used
 If Me.DropDownSearchBy.SelectedValue = &quot;Email&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByEmail(Me.TxtSearch.Text)
 ElseIf Me.DropDownSearchBy.SelectedValue = &quot;LName&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByLName(Me.TxtSearch.Text)
 ElseIf Me.DropDownSearchBy.SelectedValue = &quot;FName&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByFName(Me.TxtSearch.Text)
 End If
 'other options for the GiridView
 Me.GridViewResults.AutoGenerateSelectButton = True
 Me.GridViewResults.DataBind()
 If (Me.GridViewResults.Columns.Count &gt; 0) Then
 Me.GridViewResults.Columns(0).Visible = False
 Else
 MsgBox(Me.GridViewResults.Columns.Count.ToString)
 End If
 
 End Sub
</code></pre>
</div>

<div>
Full VB Code: 

<pre><code class="code-10 nolinks" id="code-122176">
Partial Class FindCustomer
 Inherits System.Web.UI.Page
 
 Protected Sub BtnFind_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnFind.Click
 Dim ClientAdapter As New RMSTableAdapters.CustomersTableAdapter
 'Determine what drop-down box was used
 If Me.DropDownSearchBy.SelectedValue = &quot;Email&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByEmail(Me.TxtSearch.Text)
 ElseIf Me.DropDownSearchBy.SelectedValue = &quot;LName&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByLName(Me.TxtSearch.Text)
 ElseIf Me.DropDownSearchBy.SelectedValue = &quot;FName&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByFName(Me.TxtSearch.Text)
 End If
 'other options for the GiridView
 Me.GridViewResults.AutoGenerateSelectButton = True
 Me.GridViewResults.DataBind()
 If (Me.GridViewResults.Columns.Count &gt; 0) Then
 Me.GridViewResults.Columns(0).Visible = False
 Else
 MsgBox(Me.GridViewResults.Columns.Count.ToString)
 End If
 
 End Sub
 
 Protected Sub GridViewResults_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridViewResults.SelectedIndexChanged
 Response.Write(&quot;&lt;script language='javascript'&gt; { window.opener.update('&quot; &amp; Me.GridViewResults.SelectedRow.Cells(1).Text &amp; &quot;'); }&lt;/script&gt;&quot;)
 Response.Write(&quot;&lt;script language='javascript'&gt; { self.close() }&lt;/script&gt;&quot;)
 Response.End()
 End Sub
 
End Class
</code></pre>
</div>

<div>
Full ASPX Code 

<pre><code class="code-10 nolinks" id="code-122177">&lt;%@ Page Language=&quot;VB&quot; AutoEventWireup=&quot;false&quot; CodeFile=&quot;FindCustomer.aspx.vb&quot; Inherits=&quot;FindCustomer&quot; %&gt;
 
&lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;
 
&lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot; &gt;
&lt;head runat=&quot;server&quot;&gt;
 &lt;title&gt;Untitled Page&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
 &lt;form id=&quot;form1&quot; runat=&quot;server&quot;&gt;
 &lt;div&gt;
 &lt;asp:Panel ID=&quot;Panel1&quot; runat=&quot;server&quot; GroupingText=&quot;Find Customer&quot; Height=&quot;50px&quot;
 Width=&quot;541px&quot;&gt;
 Find
 &lt;asp:TextBox ID=&quot;TxtSearch&quot; runat=&quot;server&quot;&gt;&lt;/asp:TextBox&gt;
 By&amp;nbsp;&lt;asp:DropDownList ID=&quot;DropDownSearchBy&quot; runat=&quot;server&quot;&gt;
 &lt;asp:ListItem&gt;Email&lt;/asp:ListItem&gt;
 &lt;asp:ListItem Value=&quot;LName&quot;&gt;Last Name&lt;/asp:ListItem&gt;
 &lt;asp:ListItem Value=&quot;FName&quot;&gt;First Name&lt;/asp:ListItem&gt;
 &lt;/asp:DropDownList&gt;
 &lt;asp:Button ID=&quot;BtnFind&quot; runat=&quot;server&quot; Text=&quot;Go&quot; /&gt;
 &lt;asp:TextBox ID=&quot;TextBox1&quot; runat=&quot;server&quot;&gt;&lt;/asp:TextBox&gt;&lt;/asp:Panel&gt;
 
 &lt;/div&gt;
 &amp;nbsp;
 &lt;asp:Panel ID=&quot;Panel2&quot; runat=&quot;server&quot; GroupingText=&quot;Search Results&quot; Height=&quot;50px&quot;
 Width=&quot;125px&quot;&gt;
 &lt;asp:GridView ID=&quot;GridViewResults&quot; runat=&quot;server&quot; CellPadding=&quot;4&quot; ForeColor=&quot;#333333&quot;
 GridLines=&quot;None&quot;&gt;
 &lt;FooterStyle BackColor=&quot;#5D7B9D&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;White&quot; /&gt;
 &lt;RowStyle BackColor=&quot;#F7F6F3&quot; ForeColor=&quot;#333333&quot; /&gt;
 &lt;PagerStyle BackColor=&quot;#284775&quot; ForeColor=&quot;White&quot; HorizontalAlign=&quot;Center&quot; /&gt;
 &lt;SelectedRowStyle BackColor=&quot;#E2DED6&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;#333333&quot; /&gt;
 &lt;HeaderStyle BackColor=&quot;#5D7B9D&quot; Font-Bold=&quot;True&quot; ForeColor=&quot;White&quot; /&gt;
 &lt;EditRowStyle BackColor=&quot;#999999&quot; /&gt;
 &lt;AlternatingRowStyle BackColor=&quot;White&quot; ForeColor=&quot;#284775&quot; /&gt;
 &lt;/asp:GridView&gt;
 &lt;/asp:Panel&gt;
 &lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;
</code></pre>
</div>

<div>
ok.. what I said works only with Static Columns. Auto-generated columns are not added to the Columns collection and hence you cannot use the expression I had mentioned
</div>

<div>
Thankyou for your try. 
 
Does anyone else have any ideas? 
 
Thanks, 
 
Andrew
</div>

<div>
Alternatively, 
 
You can remove those columns from the Datatable coming back from the database before you set the datasource property of the GridView
</div>

<div>
Can you please show me how to do that?
</div>

<div>
Sorry to be a pain, however Datatable is not an option (in the IDE) &nbsp;I tried: 
 
Dim Dt as New datatable 
Dim Dt as datatable
</div>

<div>
AAAAHHHHH &nbsp;Low on sleep - Imports System.Data - Will get back to your other post and see if it works.
</div>

<div>
Works Great - Almost There - Anything for a nice rename?
</div>

<div>
Really very basic - just found out: 
Dt.Columns(&quot;CustomerID&quot;).ColumnName = &quot;ID&quot; 
 
I was looking for Name, not ColumnName 
 
Thanks for everything A+ Help! 
 
-Andrew
</div>

<div>
<div class="content wysiwyg-content">
Basic setup - I have a text box, drop-down, and a button the user should use to search a database with. &nbsp; 
 
From there, the adapter returns results, with all the fields in the database for customers. 
 
Now, with that said, how to I only display specific fields? &nbsp;I know you can modify some settings in the GUI for the GridView, however I only know how to do that if I also use the GUI to set the data source. &nbsp;(and the code below works great for what I want to do, and really don't want to change it - just add to it) 

<pre><code class="code-10 nolinks" id="code-122022">Dim ClientAdapter As New RMSTableAdapters.CustomersTableAdapter
 
 If Me.DropDownSearchBy.SelectedValue = &quot;Email&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByEmail(Me.TxtSearch.Text)
 ElseIf Me.DropDownSearchBy.SelectedValue = &quot;LName&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByLName(Me.TxtSearch.Text)
 ElseIf Me.DropDownSearchBy.SelectedValue = &quot;FName&quot; Then
 Me.GridViewResults.DataSource = ClientAdapter.GetDataByFindByFName(Me.TxtSearch.Text)
 End If
 
 Me.GridViewResults.DataBind()
</code></pre>
</div>
</div>

Basic setup - I have a text box, drop-down, and a button the user should use to search a database with.  

From there, the adapter returns results, with all the fields in the database for customers.

Now, with that said, how to I only display specific fields?  I know you can modify some settings in the GUI for the GridView, however I only know how to do that if I also use the GUI to set the data source.  (and the code below works great for what I want to do, and really don't want to change it - just add to it)

GridView Columns

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications