in UltraWebGrid1_InitializeLayout event using

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

Hello,

In two-way databinding (automaticallly updating the database), you will typically also need to have BaseTableName defined as well. For example:

<igtbl:UltraGridBand DataKeyField="CustomerID" BaseTableName="Customers">

Also, if you are using AccessDataSource, SqlDataSuorce, etc, make sure you generate the CRUD commands in design time by clicking the Advanced button and the selecting "Generate CRUD..." 

Here is more info on 2-way databinding:

2 Way DataBinding (Automatic Updating)

Did you know that the grid supports automatic data updating through the datasource control?  The days of complicated event handlers dealing with DataSets accepting and rejecting changes are over!!  Let's take a SqlDataSource for an example of how to use this feature. 

When you create the datasource be sure to click on the "advanced" when building the select statement.  You'll see a checkbox for "generate insert, update and delete".  Checking that box will enable the datasource to perform all of the 'crud' operations on your table.  The grid will automatically update the data, but first a 'postback' must occur.  I put a postback in quotes because it can be the traditional full page, or it can be an asynchronous AJAX style postback.  If you want the database to be updated with each row modification, you can add a server-side "RowUpdate" event handler.  Enabling the AJAX functionality of the grid (click the "Enable AJAX" checkbox in the smart tag at design-time, or set grid.DisplayLayout.LoadOnDemand=Xml) will make the updaterow happen asynchronously, making the entire update process transparent to the end user.  If you can't get updating working, check to be sure you set the grid's DataKeyField and BaseTableName properties (Yes, I'm speaking from experience).

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.

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

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.