Gridview update with sqldatasource and dropdown

[Will]

I have searched and solutions that I have found are not working, I have
a datagrid that will be updating a mysql db. Now I have a drop down
that has a static collection but is dynamically selected to a selected
value thats in the database. I click the edit button in the gridview
and the drop down shows up fine, I pick a number in the drop down and
hit update it says at that new number but the database never
updates.....hel p anyone know why? Is there anyway to print the
updatecommand to the screen to show what values are going to the
database?

############### ###CODE######## ############### #########
<asp:GridView ID="GridView1" AllowSorting="f alse"
AllowPaging="fa lse" Runat="server"
DataSourceID="S qlDataSource1" AutoGenerateEdi tButton="true"
DataKeyNames="T eam"
AutoGenerateCol umns="False">
<Columns>
<asp:BoundFie ld ReadOnly="true" HeaderText="Tea m"
DataField="Team " />
<asp:TemplateFi eld HeaderText="Ran k" >
<ItemTemplate >
<asp:Label Runat="server" Text='<%#
Bind("trank") %>' ID="label2"></asp:Label>
</ItemTemplate>
<EditItemTempla te>
<asp:DropDownLi st ID="ddlPr" runat="server"
DataTextField=" trank" DataValueField= "trank" SelectedValue=' <%#
Bind("trank") %>' >
<asp:ListItem>1 </asp:ListItem>
<asp:ListItem>2 </asp:ListItem>
<asp:ListItem>3 </asp:ListItem>
<asp:ListItem>4 </asp:ListItem>
<asp:ListItem>5 </asp:ListItem>
<asp:ListItem>6 </asp:ListItem>
<asp:ListItem>7 </asp:ListItem>
<asp:ListItem>8 </asp:ListItem>
<asp:ListItem>9 </asp:ListItem>
<asp:ListItem>1 0</asp:ListItem>
<asp:ListItem>1 1</asp:ListItem>
<asp:ListItem>1 2</asp:ListItem>
<asp:ListItem>1 3</asp:ListItem>
<asp:ListItem>1 4</asp:ListItem>
<asp:ListItem>1 5</asp:ListItem>
<asp:ListItem>1 6</asp:ListItem>
<asp:ListItem>1 7</asp:ListItem>
<asp:ListItem>1 8</asp:ListItem>
<asp:ListItem>1 9</asp:ListItem>
<asp:ListItem>2 0</asp:ListItem>
<asp:ListItem>2 1</asp:ListItem>
<asp:ListItem>2 2</asp:ListItem>
<asp:ListItem>2 3</asp:ListItem>
<asp:ListItem>2 4</asp:ListItem>
<asp:ListItem>2 5</asp:ListItem>
<asp:ListItem>2 6</asp:ListItem>
<asp:ListItem>2 7</asp:ListItem>
<asp:ListItem>2 8</asp:ListItem>
<asp:ListItem>2 9</asp:ListItem>
<asp:ListItem>3 0</asp:ListItem>
</asp:DropDownLis t>
</EditItemTemplat e>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>
<br />
<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:testConnecti onString %>"
ProviderName="< %$
ConnectionStrin gs:testConnecti onString.Provid erName %>"
SelectCommand=" Select prid, team, rank as trank, wins, loses, ties, otl
from power_rankings_ holder"
UpdateCommand=" UPDATE power_rankings_ holder SET rank =
@trank WHERE prid = @prid">
</asp:SqlDataSour ce>
############### ###/CODE########### ############### ######