nao estou a perceber, tenho aqui o codigo , talvez me possas ajudar
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
Escalão:
<asp
ropDownList ID="escalao" runat="server">
<asp:ListItem Text="Seniores" Value="Seniores"></asp:ListItem>
<asp:ListItem Text="Juniores" Value="Juniores"></asp:ListItem>
<asp:ListItem Text="Juvenis" Value="Juvenis"></asp:ListItem>
<asp:ListItem Text="Iniciados" Value="Iniciados" ></asp:ListItem>
</asp
ropDownList>
<asp:Button ID="Button1" runat="server" Text="Go" OnClick="mudar" />
<br />
<div align="center">
<asp:SqlDataSource ID="Jogadores" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="System.data.SqlClient"
SelectCommand="SELECT * from Jogadores">
</asp:SqlDataSource>
<asp:GridView ID="listaj" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
DataSourceID="Jogadores" AllowPaging="false" AllowSorting="True" BackColor="white" BorderWidth="5px" FooterStyle-BackColor="Chocolate">
<pagerstyle backcolor="white" Font-Size="Small" horizontalalign="Center" />
<Columns>
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000" Visible="false"/>
<asp:BoundField DataField="Nome Completo" HeaderText="Nome Completo" SortExpression="Nome Completo" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Alcunha" HeaderText="Alcunha" SortExpression="Alcunha" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Idade" HeaderText="Idade" SortExpression="Idade" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Peso" HeaderText="Peso" SortExpression="Peso" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Altura" HeaderText="Altura" SortExpression="Altura" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Posição" HeaderText="Posição" SortExpression="Posicao" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Pe Preferido" HeaderText="Pé Preferido" SortExpression="Pé Preferido" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
<asp:BoundField DataField="Escalao" HeaderText="Escalao" SortExpression="Escalao" ItemStyle-BorderWidth="3px" HeaderStyle-BorderWidth="3px" ItemStyle-Font-Size="small" ItemStyle-HorizontalAlign="Center" HeaderStyle-ForeColor="#CD0000"/>
</Columns>
</asp:GridView>
</div>
</asp:Content>