Forms Data Controls :: Update MySQL Database Checkbox Value In Gridview

I have been stuck on this for a while and I can't seem to get it to work despite looking for answers in books and all over the web, so I hope perhaps you all can help me figure this out...

Here's what I'm trying to do....

I have some information in a simple product database displaying in a gridview table. One of the columns is a row of checkboxes indicating whether the item has been discontinued or not. When the row gets updated, it needs to update the checkbox value in the database.

1. It needs to be disabled until the row is getting edited.

2. Send the string value of 0 or 1 to the database when the row is updated.

Here's the code for the sql datasource and the gridview part in question...

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:sqlDataMaster %>"
ProviderName="<%$ ConnectionStrings:sqlDataMaster.ProviderName %>"
SelectCommand="SELECT ID, ProductName, ListPrice, Discontinued FROM Products"
UpdateCommand="UPDATE Products SET ProductName=@ProductName, ListPrice=@ListPrice, Discontinued=@Discontinued WHERE ID=@ID"
DeleteCommand="DELETE FROM Products WHERE ID=@ID">
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="ProductName" Type="String" />
<asp:Parameter Name="ListPrice" Type="Double" />
<asp:Parameter Name="Discontinued" Type="Boolean" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="ProductName" Type="String" />
<asp:Parameter Name="ListPrice" Type="Double" />
<asp:Parameter Name="Discontinued" Type="Boolean" />
</DeleteParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AutoGenerateColumns="False" AllowSorting="True"
DataSourceID="SqlDataSource1" CellPadding="3"
GridLines="Vertical" BackColor="White" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px"
DataKeyNames = "ID">
<Columns>
<asp:CommandField ShowSelectButton="True" ShowEditButton="true" ShowDeleteButton="true" />
<asp:BoundField DataField="ID" HeaderText="Product ID" SortExpression="ID" ReadOnly="true" />
<asp:BoundField DataField="ProductName" HeaderText="Product Name"
SortExpression="ProductName" >
<ItemStyle HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="ListPrice" DataFormatString="{0:c}"
HeaderText="Unit Price" SortExpression="ListPrice" />
<asp:TemplateField HeaderText="Discontinued" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:CheckBox id="Discontinued" runat="server"
Checked='<%#Convert.ToBoolean(Eval("Discontinued")) %>' />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>

Here's a live version for you to look at...

http://homeworksite.mythandmagicstudios.com/homework4/proj3/default.aspx