I am trying to enable 2 Way DataBinding and CRUD operations. So far I only have the "Update" working, the "Add" failes to save (I haven't tested delete). The culprit seems to be the fact that 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. As soon as I click the "Save" button (which is just a "submit" button, right?) the new row goes away. (Any row/field changes work great..)
I have also tried adding the "BaseTableName" to the asp code and still the Add doesn't work.
Any ideas?
This weekend I treid the online tutorial and the even bought the online class. I am still unable to implement a "basic" 2 way databind "add' feature. The Update and the delete works fine on all my tests. Could it be something with SQL? I have full control on the dbs I have created for test. I have tried Primary Keys with "Auto Generate" (Identity) and without Identity. I just dont get it. As soon as my postback fires the added row disappears from the grid. It really baffles me because the change and the deletse work great.
Update...
I did test "Delete" and it works. I just cant get the Add working, I even created a handler for "Updated" and the even isn't being fired by the "WebGrid".