hidden id column

[vandy]

I have try syncfusion SfGrid into my Blazor server project. I have used Guid as Primary key in my database table.

inside SfGrid, I have put the ID column Visible=false. the ID field will auto generate by api side.

I can add new record into my table as well include my id logic.

SfGrid automatically refresh data but new record always empty ID.

So that, my face problem is I cannot Edit the new record (new record that inserted always empty ID).

any idea to resolve this issue?

[Prathap Senthil]

Hi Vandy,

Greetings from Syncfusion support

Based on your reported issue, If the primary key column value is Auto Incremented in your database, kindly define the IsIdentity property of GridColumn as true for the PrimaryKey column. The IsIdentity is enabled, then it will be considered as a read-only column when editing and adding a record. Kindly refer to the below reference link for your reference.

Reference Link: https://help.syncfusion.com/cr/blazor/Syncfusion.Blazor.Grids.GridColumn.html?_ga=2.79589267.606636547.1668964143-1012522953.1649837807#Syncfusion_Blazor_Grids_GridColumn_IsIdentity

                         https://blazor.syncfusion.com/documentation/datagrid/editing

Regards,

Prathap S

[vandy]

Yes it was resolved now.

Thanks

[Suganya Gopinath]

Vandy,

We are glad that the provided solution worked to solve the issue. Please get back to us for further assistance. 

We are marking this ticket as solved.

Regards,

Suganya Gopinath.