Gridview Checkbox Not Updating on RowCommand

[janetb99]

I have a gridview with an update capabilities - a textbox column (roomName), a dropdownlist(orgID), a dropdownlist(roomTypeID),a checkbox column (dialOut), a checkbox column (dialIn). When I try to add another checkbox column, the sql database isn't updated properly with a 0/1 or false/true but with null. I've tried everything I can think of. Can anyone help?

<asp:CommandField ShowEditButton="True" ValidationGroup="valGrp" CancelText="Cxl" EditText="Edit" UpdateText="Upd" />
<asp:BoundField DataField="roomID" />
<asp:TemplateField HeaderText="RoomName">
<EditItemTemplate>
<asp:TextBox ID="txtRoom" Columns="10" runat="server" SkinID="txtSm" Text='<%# Bind("roomname") %>' />
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblRoom" runat="server" Text='<%# Bind("roomName") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:Button ID="btnAdd" runat="server" skinID="btnGo" Text="Add" CommandName="Insert" />
<asp:TextBox ID="txtRoomAdd" Columns="10" runat="server" SkinID="txtSm" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Org">
<EditItemTemplate>
<asp:DropDownList ID="orgDDL" runat="server" SkinID="ddl" DataSourceID="orgDS"
DataTextField="org" DataValueField="orgID" SelectedValue='<%# Bind("orgID") %>'>
</asp:DropDownList><asp:SqlDataSource ID="orgDS" runat="server" ConnectionString="<%$ ConnectionStrings:Str %>"
SelectCommand="select statement"></asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblOrg" runat="server" Text='<%# Bind("org") %>'></asp:Label>
</ItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="orgDDLAdd" runat="server" SkinID="ddl" DataSourceID="orgAddDS2"
DataTextField="org" DataValueField="orgID">
</asp:DropDownList><asp:SqlDataSource ID="orgAddDS2" runat="server" ConnectionString="<%$ ConnectionStrings:Str %>"
SelectCommand="select statement">
</asp:SqlDataSource>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Type">
<EditItemTemplate>
<asp:DropDownList ID="typeDDL" runat="server" SkinID="ddl" DataSourceID="typeDS"
DataTextField="roomType" DataValueField="roomTypeID" SelectedValue='<%# Bind("roomTypeID") %>'>
</asp:DropDownList><asp:SqlDataSource ID="typeDS" runat="server" ConnectionStrin

[janetb99]

Not sure what I did wrong, still, but I deleted the aspx page and started over from scratch. Everything works fine now..... Scratchin' my head hard!