in UltraWebGrid1_InitializeLayout event using

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

Hello,

DefaultValue cannot be set declaratively in the ASPX or in the designer because it is of type object - there is no way you can tell at design time what value gets there (it is a generic object) so the only way to specify it is programmatically. The  code samples above seem pretty good to me, InitializeLayout is a great event to place such code there.

The CRUD operations can be enabled using the Allow... properties on the display settings, for example:

<displaylayout bordercollapsedefault="Separate" name="UltraWebGrid1"  AllowDeleteDefault="Yes" AllowUpdateDefault="Yes" AllowAddNewDefault="Yes"

I should have been a bit more specific. How do you tell the UltraWebGrid to actually "save" the changes? I know I can code up a "submit" button to save the changes, but I thought I could somehow do it "code" less??? How do I turn on a "save" button?

(And as a side note: How do I also get it to show a "delete" (row) button? "Codeless" I mean...)

I tried this advice from the help info:

 Visual Studio's Properties Window

1. With WebGrid bound to the data source, click on the WebGrid control. In the Properties window, locate the Bands property. Click the ellipsis (…) button to expose the Bands Collection editor.
2. Click on the band that represents your data entity (e.g., Customers or whatever WebGrid is bound to) and locate the DataKeyField property. Click the dropdown button, which contains a list of fields that represent the bound data model, and select the field that represents the Primary Key.

Now that you have set the DataKeyField property on the WebGrid control, any updates, insertions, or deletions should be resolved to the back end (assuming the appropriate permissions on the database are also in place).

But, the "DefaultKeyField" combo doens't give me any choices. I manuuly typed my key field and it still doesn't automatically update the database.

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.

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.

Actaully, I did that first thing this morning, you guys are just usually quicker. :)