Hi Rykunov,
We have analyzed your query. We have prepared a sample with the auto generated value in the server side for the column isIdentity column.
Refer the below code example.
|
[app.component.html]
<ej-grid #grid [dataSource]="gridData" [allowScrolling]=true >
<e-columns>
<e-column field="OrderID" [isPrimaryKey]="true" [isIdentity]="true" width="75" textAlign="right"></e-column>
<e-column field="EmployeeID" headerText="Employee ID" [validationRules] = "{ required: true, number: true }" width="75" textAlign="right"></e-column>
<e-column field="CustomerID" headerText="CustomerID" width="80"textAlign="right"></e-column>
</e-columns>
</ej-grid>
|
If you are using CRUD operations, we suggest to return the update records to client end. Since you are using the IsIdentity for the PrimaryKey column, the value in the client-side differs from the server-side and to notify the changes on the IsIdentity column you have to return them from server-end. Refer to the following code example.
|
[HomeController.cs]
public ActionResult Update(Orders value)
{
var data = order.ToList();
Orders result = data.Where(o => o.OrderID == value.OrderID).FirstOrDefault();
if (result != null)
{
result.OrderID = value.OrderID;
result.CustomerID = value.CustomerID;
result.EmployeeID = value.EmployeeID;
}
return Json(value, JsonRequestBehavior.AllowGet);
}
public ActionResult Insert(Orders value)
{
int generate = order.ToList().Count();
value.OrderID = ++generate; // set the auto generated value to the OrderID column
order.Insert(0, value);
return Json(value, JsonRequestBehavior.AllowGet);
}
public ActionResult Delete(int key)
{
var data = order.ToList();
Orders result = data.Where(o => o.OrderID == key).FirstOrDefault();
order.Remove(result);
return Json(data, JsonRequestBehavior.AllowGet);
}
|
We have prepared a sample and it can be downloadable from the below location.
We have included angular2 sample also with in the project.
Regards,
Thavasianand S.
