Blazor SERVER CRUD sample with datagrid
5 Replies
Hi Dan,
We tried adding our Grid and WebAPI controller codes in your shared application. But we could not access the DB in your shared application. Please refer the screenshot below,
So, we have created a sample with our own DB to render Grid with WebAPI and handling the data operations. Please download the sample from the link below,
Sample : https://www.syncfusion.com/downloads/support/directtrac/general/ze/EFGridFilterSort-1775235179
Note : A local MDF file is used in the above sample to assign and process the data. So before running the sample, please make sure the connection for this file is established and the correct connection string(local path of the MDF file in your machine) is provided in OrderContext.cs file in the application.
When using the WebAPI services, you need to handle these data operation actions at controller side based on the “Request.Query” you get from the request, just like the paging code we have handled in Get method of documentation using $skip and $top.
So, we suggest you to ensure to handle the filter/sorting in the HttpGet method of corresponding controller page, based on the “Request.Query” you get from the request. Please refer the codes below,
|
[DefaultController.cs]
[HttpGet]
public object Get()
{
try
{
Microsoft.AspNetCore.Http.IQueryCollection queryString = Request.Query;
...
StringValues sSkip, sTake, sFilter, sSort;
int skip = (queryString.TryGetValue("$skip", out sSkip)) ? Convert.ToInt32(sSkip[0]) : 0; //paging query
int top = (queryString.TryGetValue("$top", out sTake)) ? Convert.ToInt32(sTake[0]) : countAll;
string filter = (queryString.TryGetValue("$filter", out sFilter)) ? sFilter[0] : null; //filter or search query
string sort = (queryString.TryGetValue("$orderby", out sSort)) ? sSort[0] : null; //sort query
...
}
|
We suggest you to refer the above attached sample and handle your application’s controller page based on the above suggestions and sample.
Regards,
Renjith Singh Rajendran
SIGN IN To post a reply.
