I can insert rows into my table outside of my app.
I can remove rows using my app.
I can edit rows in my app.
I cannot insert new rows in my app.
I used the wizard to create new blazor web assembly and added datasource with crud.
All works except for insert.
are you are using odata, versus efcore?
I don't know when you created your sample application, but what I'm telling you is that if i use the sql table i sent you and use your wizard, this is the result.
So using your "sample app" as proof, is not proof.
There could be a problem that was introduced into your "wizard" that is creating this issue.
Have you tested it on windows 10, iis 10 and .net 5 blazor web assembly using wizard with the table i sent?
If you have not, then i cannot accept that this is my problem, and not a problem with radzen wizard for sql tables.
sql version: Microsoft SQL Server 2019 (RTM-CU8) (KB4577194) - 15.0.4073.23 (X64) Sep 23 2020 16:03:08 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)
the table:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar] (50) NOT NULL,
[Dept] [nvarchar] (50) NOT NULL,
[CreatedDate] [datetime] NOT NULL,
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
i will see about getting the exception, i have tried, but still elusive, i'm not an expert at troubleshoting web apps. any tips?
Run the application with Visual Studio. It should break on unhandled exceptions by default. Radzen also logs all server exceptions in its Output window.
what i noticed about this issue is that i do get a bunch of exceptions....
all the exception files below are empty.
and it does not crash, it just gives that message i showed in my first post.
i decided to try again, and this time just chose the make crud pages and all defaults after that.
i decided to make a slightly different new table
The good news is that it worked.
Being that i didn't check all the boxes maybe had an effect, in that by checking those boxes it changes the functionality of the edit forms i'm guessing? Thanks for your support.
exept i used blazor server this time..ooops...trying again with web assembly.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserInfo](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [char] (100) NOT NULL,
[Date] [datetime] NOT NULL,
CONSTRAINT [PK_UserInfo] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO