in UltraWebGrid1_InitializeLayout event using

e.Layout.Bands(0).Columns.FromKey("JobID").DefaultValue =

I am unable to get the BaseTableName to "stick" in the Designer for the Band Properties. As soon as I Save it and then go back in, it is gone.

I am under the "Edit Data Structure" -> "Bands and Columns" and I have the (only) Band selected. I have also tried prefixing the table name with "dbo." it still won't take it.

Here is my code.

I have tired SQL datasources and Access Datasources. No matter what I do the "BaseTableName" doesn't save. I can put it in the markup, but it still wont add records. (It will save and delete records from the grid, with or without the "BaseTableName" in the markup!)

   <asp:SqlDataSource ID="SqlDataSource1" runat="server"

        ConflictDetection="CompareAllValues"

        ConnectionString="<%$ ConnectionStrings:ShayneInfragisticsTestConnectionString %>"

        DeleteCommand="DELETE FROM [Orders] WHERE [ID] = @original_ID AND [OrderNum] = @original_OrderNum AND [OrderDescription] = @original_OrderDescription AND [Total] = @original_Total"

        InsertCommand="INSERT INTO [Orders] ([OrderNum], [OrderDescription], [Total]) VALUES (@OrderNum, @OrderDescription, @Total)"

        OldValuesParameterFormatString="original_{0}"

        SelectCommand="SELECT * FROM [Orders]"

        UpdateCommand="UPDATE [Orders] SET [OrderNum] = @OrderNum, [OrderDescription] = @OrderDescription, [Total] = @Total WHERE [ID] = @original_ID AND [OrderNum] = @original_OrderNum AND [OrderDescription] = @original_OrderDescription AND [Total] = @original_Total">

        <DeleteParameters>

            <asp:Parameter Name="original_ID" Type="Int32" />

            <asp:Parameter Name="original_OrderNum" Type="String" />

            <asp:Parameter Name="original_OrderDescription" Type="String" />

            <asp:Parameter Name="original_Total" Type="Decimal" />

        </DeleteParameters>

        <UpdateParameters>

            <asp:Parameter Name="OrderNum" Type="String" />

            <asp:Parameter Name="OrderDescription" Type="String" />

            <asp:Parameter Name="Total" Type="Decimal" />

            <asp:Parameter Name="original_ID" Type="Int32" />

            <asp:Parameter Name="original_OrderNum" Type="String" />

            <asp:Parameter Name="original_OrderDescription" Type="String" />

            <asp:Parameter Name="original_Total" Type="Decimal" />

        </UpdateParameters>

        <InsertParameters>

            <asp:Parameter Name="OrderNum" Type="String" />

            <asp:Parameter Name="OrderDescription" Type="String" />

            <asp:Parameter Name="Total" Type="Decimal" />

        </InsertParameters>

    </asp:SqlDataSource>

    <igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" Browser="Xml"

        DataKeyField="ID" DataSourceID="SqlDataSource1" Height="211px" Width="497px">

        <bands>

            <igtbl:UltraGridBand AllowAdd="Yes" AllowDelete="Yes" AllowUpdate="Yes"

                DataKeyField="ID" BaseTableName="Orders">

                <Columns>

                    <igtbl:UltraGridColumn BaseColumnName="ID" DataType="System.Int32"

                        IsBound="True" Key="ID">

                        <Header Caption="ID">

                        </Header>

                    </igtbl:UltraGridColumn>

                    <igtbl:UltraGridColumn BaseColumnName="OrderNum" IsBound="True" Key="OrderNum">

                        <Header Caption="OrderNum">

                            <RowLayoutColumnInfo OriginX="1" />

                        </Header>

                        <Footer>

                            <RowLayoutColumnInfo OriginX="1" />

                        </Footer>

                    </igtbl:UltraGridColumn>

                    <igtbl:UltraGridColumn BaseColumnName="OrderDescription" IsBound="True"

                        Key="OrderDescription">

                        <Header Caption="OrderDescription">

                            <RowLayoutColumnInfo OriginX="2" />

                        </Header>

                        <Footer>

                            <RowLayoutColumnInfo OriginX="2" />

                        </Footer>

                    </igtbl:UltraGridColumn>

                    <igtbl:UltraGridColumn BaseColumnName="Total" DataType="System.Decimal"

                        IsBound="True" Key="Total">

                        <Header Caption="Total">

                            <RowLayoutColumnInfo OriginX="3" />

                        </Header>

                        <Footer>

                            <RowLayoutColumnInfo OriginX="3" />

                        </Footer>

                    </igtbl:UltraGridColumn>

                </Columns>

                <addnewrow view="NotSet" visible="NotSet">

                </addnewrow>

            </igtbl:UltraGridBand>

        </bands>

        <displaylayout allowaddnewdefault="Yes" allowcolsizingdefault="Free"

            allowcolumnmovingdefault="OnServer" allowdeletedefault="Yes"

            allowsortingdefault="OnClient" allowupdatedefault="Yes"

            bordercollapsedefault="Separate" headerclickactiondefault="SortMulti"

            loadondemand="Xml" name="UltraWebGrid1" rowheightdefault="20px"

            rowselectorsdefault="No" selecttyperowdefault="Extended"

            stationarymargins="Header" stationarymarginsoutlookgroupby="True"

            tablelayout="Fixed" version="4.00" viewtype="OutlookGroupBy">

            <framestyle backcolor="Window" bordercolor="InactiveCaption"

                borderstyle="Solid" borderwidth="1px" font-names="Microsoft Sans Serif"

                font-size="8.25pt" height="211px" width="497px">

            </framestyle>

            <pager minimumpagesfordisplay="2">

                <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">

                <borderdetails colorleft="White" colortop="White" widthleft="1px"

                    widthtop="1px" />

                </PagerStyle>

            </pager>

            <editcellstyledefault borderstyle="None" borderwidth="0px">

            </editcellstyledefault>

            <footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">

                <borderdetails colorleft="White" colortop="White" widthleft="1px"

                    widthtop="1px" />

            </footerstyledefault>

            <headerstyledefault backcolor="LightGray" borderstyle="Solid"

                horizontalalign="Left">

                <borderdetails colorleft="White" colortop="White" widthleft="1px"

                    widthtop="1px" />

            </headerstyledefault>

            <rowstyledefault backcolor="Window" bordercolor="Silver" borderstyle="Solid"

                borderwidth="1px" font-names="Microsoft Sans Serif" font-size="8.25pt">

                <padding left="3px" />

                <borderdetails colorleft="Window" colortop="Window" />

            </rowstyledefault>

            <groupbyrowstyledefault backcolor="Control" bordercolor="Window">

            </groupbyrowstyledefault>

            <groupbybox>

                <boxstyle backcolor="ActiveBorder" bordercolor="Window">

                </boxstyle>

            </groupbybox>

            <addnewbox hidden="False">

                <boxstyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid"

                    borderwidth="1px">

                    <borderdetails colorleft="White" colortop="White" widthleft="1px"

                        widthtop="1px" />

                </boxstyle>

            </addnewbox>

            <activationobject bordercolor="" borderwidth="">

            </activationobject>

            <filteroptionsdefault>

                <filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid"

                    borderwidth="1px" customrules="overflow:auto;"

                    font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px" height="300px"

                    width="200px">

                    <padding left="2px" />

                </filterdropdownstyle>

                <filterhighlightrowstyle backcolor="#151C55" forecolor="White">

                </filterhighlightrowstyle>

                <filteroperanddropdownstyle backcolor="White" bordercolor="Silver"

                    borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;"

                    font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">

                    <padding left="2px" />

                </filteroperanddropdownstyle>

            </filteroptionsdefault>

        </displaylayout>

    </igtbl:UltraWebGrid>

    <asp:Button ID="Button1" runat="server" Text="Save" />

    </form>

OK, now I am more than a little confused.  The designer's description of the .BaseTableName property is "The name of the table in the data store."  This would make sense to me if you were binding your grid to a multi-table DataSet.  But you are binding a single-band grid to a SqlDataSource that returns a single table.  When I'm doing that, I never specify a .BaseTableName.

I don't know why your .BaseTableName is being dropped, but it could be because it is not appropriate in that context.

Fair enough and that explains why my Updates and Deletes work without that property set.

 The mystery is why the adds dont "save"... the rows get added visually and I populate the data (with the appropraite data), but when I do the post back the new rows just disappear.

Yep, I understand (and know that is general forum ettiquite). I just created a new thread because this one ventured off topic. :)

 But, we keep using it...lol