How to use validation rules and create custom validation rules grid

[Angel]

Hello forum

I cant seem to find how to use validation rules and custom validation rules on aspnet core on a grid,

if anyone could help me out with this I would highly appreciate it

[Jayaprakash Kamaraj]

Hi Angel, 

 

Thank you for contacting Syncfusion support. 

 

We can set validation rules to Grid Columns using below code example. Please refer to the below help document and code example. 

 

https://help.syncfusion.com/aspnetmvc/grid/editing#column-validation 

 

@{Html.EJ().Grid<Object>("FlatGrid") 

            .Datasource((IEnumerable<object>)ViewBag.DataSource) 

            .AllowPaging() 

            .EditSettings(edit => { edit.AllowAdding().AllowDeleting().AllowEditing(); }) 

            .ToolbarSettings(toolbar => 

               { 

                   toolbar.ShowToolbar().ToolbarItems(items => 

                    { 

                        items.AddTool(ToolBarItems.Add); 

                        items.AddTool(ToolBarItems.Edit); 

                        items.AddTool(ToolBarItems.Delete); 

                        items.AddTool(ToolBarItems.Update); 

                        items.AddTool(ToolBarItems.Cancel); 

                    }); 

               }) 

            .Columns(col => 

              { 

                  col.Field("OrderID").HeaderText("Order ID").IsPrimaryKey(true).ValidationRules(v => v.AddRule("required", true).AddRule("number", true)).Add(); 

                  col.Field("CustomerID").HeaderText("Customer ID").ValidationRules(v => v.AddRule("required", true).AddRule("minlength", 3)).Add(); 

                  col.Field("ShipCity").HeaderText("Ship City").Add(); 

                  col.Field("Freight").HeaderText("Freight").EditType(EditingType.Numeric).ValidationRules(v => v.AddRule("range", "[0,1000]")).Add(); 

                  col.Field("ShipCountry").HeaderText("Ship Country").Add(); 

              }).Render(); 

} 

 

Online Demo sample: http://mvc.syncfusion.com/demos/web/grid/normalediting 

 

We need to refer  jquery.validate.min.js and jquery.validate.unobtrusive.min.js scripts for validation. So, please refer to these script files in your sample. 

 

Regards, 

 

Jayaprakash K. 

[Aravind Ashokkumar]

Hi Team,

Since Net core does not widely support Razor syntax, could you please help us provide more examples with Tag Helper Syntax.

I would nee your help for adding validation rules using Tag Helper syntax.

For example, for ej-grid the tag helper syntax is

<ej-grid id="grid_sample" allow-paging="true" allow-resize-to-fit="true" allow-resizing="true" allow-sorting="true" allow-multi-sorting="true" allow-scrolling="true" allow-searching="true" >

            <e-columns>

                <e-column field="ToolTip" header-text="ToolTip"></e-column>

                <e-column field="Remark" header-text="Remark"></e-column>

                <e-column field="RecordStatus" header-text="Record Status"></e-column>

            </e-columns>

            <e-filter-settings filter-type="Menu"></e-filter-settings>

            <e-page-settings page-size="14" page-count="5"></e-page-settings>

            <e-sort-settings>

                <e-sorted-columns>

                    ...

                </e-sorted-columns>

            </e-sort-settings>

        </ej-grid>

[Jayaprakash Kamaraj]

Hi Angel, 

 

We have created a ASP.NET core sample with validations using tag helpers. Please refer to the below code example and sample. 

 

 

<ej-grid id="FlatGrid" allow-paging="true"> 

    <e-datamanager url="//mvc.syncfusion.com/Services/Northwnd.svc/Orders/?$top=45" offline="true"></e-datamanager> 

    <e-edit-settings allow-adding="true" allow-deleting="true" allow-editing="true" edit-mode="Normal" /> 

    <e-toolbar-settings show-toolbar="true" toolbar-items='new List<string>() { "add", "edit", "delete", "update", "cancel", "search" }' /> 

    <e-columns> 

        <e-column field="OrderID" is-primary-key="true" header-text="Order ID" text-align="Right"  width="70"></e-column> 

        <e-column field="CustomerID" header-text="Customer ID" width="80" validation-rules='new Dictionary<string, object>() { { "required",true}, { "minlength",3} }' ></e-column> 

        .. 

 

   </e-columns> 

</ej-grid> 

 

 

 

 

Sample: http://www.syncfusion.com/downloads/support/forum/127659/ze/WebApplication8-49888808 

Regards, 

 

Jayaprakash K.