This is a create page meaning that both Bestiller and Kontaktpersoner are empty

I cant update data to the server on Kontaktperson when the foreign key Bestiller_ID is empty

Hi Christian,

Can you take my example (attached to this thread) and update it to reflect your scenario? Then send it back to me. It will be helpful to have a small running example of your scenario that I can use as part of my research into this matter.

Thanks!

I have attached a sample

Hi Christian,

Thank you for your sample. I believe all you need to do is set Bestiller_ID to be nullable. You can do this by using the nullable modifier when setting the property in your model.

Once you allow Bestiller_ID to accept a null value it should be possible to then update the data source.

I change the grid to this

@{

var data = Model.Kontaktperson.AsQueryable();

}

@(Html.Infragistics().Grid<intranet.mvc5.Models.Kontaktperson>(data)

.PrimaryKey("ID")

.ID("grdKontaktpersoner")

.ShowHeader(true)

.Columns(column =>

{

column.For(m => m.ID).Hidden(true);

column.For(m => m.Navn).HeaderText("Navn").Width("200px");

column.For(m => m.E_Mail).HeaderText("Email").Width("200px");

column.For(m => m.Tlfnr).HeaderText("Telefonnr.").Width("80px");

column.For(m => m.RefNr).HeaderText("Ref. Nr.").Width("100px");

})

.Features(feature =>

{

feature.Updating().ColumnSettings(cs =>

{

cs.ColumnSetting().ColumnKey("ID").ReadOnly(true);

cs.ColumnSetting().ColumnKey("Navn").EditorType(ColumnEditorType.Text).Required(true).TextEditorOptions(o => o.ValidatorOptions(vo => vo.MaxLength(50)));

cs.ColumnSetting().ColumnKey("E_Mail").EditorType(ColumnEditorType.Text).TextEditorOptions(o => o.ValidatorOptions(vo => vo.MaxLength(60)));

cs.ColumnSetting().ColumnKey("Tlfnr").EditorType(ColumnEditorType.Text).TextEditorOptions(o => o.ValidatorOptions(vo => vo.MaxLength(20)));

cs.ColumnSetting().ColumnKey("RefNr").EditorType(ColumnEditorType.Text).TextEditorOptions(o => o.ValidatorOptions(vo => vo.MaxLength(30)));

})

.CancelLabel("Afbryd")

.AddRowLabel("Tilføj kontaktperson")

.DeleteRowTooltip("Slet kontaktperson")

.DoneLabel("Gem")

.EditMode(GridEditMode.Row)

.EnableAddRow(true)

.EnableDeleteRow(true);

})

.AutoGenerateColumns(false)

.AutoAdjustHeight(true)

.AutoCommit(true)

.Width("100%")

.DataSource(data)

.UpdateUrl(Url.Action("KontaktPersonGem"))

.DataBind()

.Render()

)

model intranet.mvc5.Models.Bestiller

KontaktPersonGem never get called

Hi Christian,

There are a couple of things that I notice. The first is in your view where you set your UpdateUrl, I see you call KontaktPersonGem, but you don't seem to tell the updateurl where to find KontaktPersonGem. The UpdateUrl should look something like this:

         .UpdateUrl(Url.Action("KontaktPersonGem", "Home"))

Also I see you are calling AutoCommit(true) but you need to also call SaveChanges. So, something like this:

 <script type="text/javascript">        

          function saveChanges() {            

         $("#grid1").igGrid("saveChanges");        

   }       

</script>

<input type="button" id="saveChanges" value="Save Changes" onclick="saveChanges()" />

Finally, I don't have access to what you're doing in KontaktPersonGem, but if all is working there fine, the updates should successfully save.

Going with my example provided above, this is what I am doing in my UpdateGrid ActionResult that I pass into my UpdateUrl:

         public ActionResult UpdateGrid(string ig_transactions)

        {

            //postData = HttpContext.Request.Form["ig_transactions"];

            //ArrayList data = (ArrayList)Procurios.Public.JSON.JsonDecode(ig_transactions);

            GridModel m = new GridModel();

            List<Transaction<Wine>> transactions = m.LoadTransactions<Wine>(HttpContext.Request.Form["ig_transactions"]);

            ViewData["GenerateCompactJSONResponse"] = false;

            foreach (Transaction<Wine> t in transactions)

            {

                switch (t.type)

                {

                    case "row":

                        {

                            wl.UpdateWine(t.row);

                        }

                        break;

                    case "newrow":

                        {

                            wl.AddWine(t.row);

                        }

                        break;

                    case "deleterow":

                        {

                            wl.DeleteWine(Convert.ToInt32(t.rowId));

                        }

                        break;

                };

            }

            JsonResult result = new JsonResult();

            Dictionary<string, bool> response = new Dictionary<string, bool>();

            response.Add("Success", true);

            result.Data = response;

            return result;

        }

Please let me know if you need additional assistance.

Hi Christian,

I am still following this thread. Let me know if you need additional information. Thanks!