Poluate grid with stored procedure

[Nicholas Picardi]

Hi all,

It's possible populate a ej-grid with a stored procedure?

thanks,

Nicholas

[Venkatesh Ayothi Raman]

Hi Nicholas, 

Thanks for contacting Syncfusion support. 

The Grid will populate the data in the form of IEnumerable. we can retrieve the data source from stored procedure and change the stored procedure result as IEnumerable and then bound the data to Grid its works normally. Please refer to the following code example and online forum, 

Code example: 

[GRID] 

<ej-grid id="FlatGrid" datasource="ViewBag.dataSource" allow-paging="true" load="onLoad" > 

 

        <e-columns> 

        . . . 

</e-columns> 

</ej-grid> 

 

[Server side] 

public IActionResult Index() 

        { 

 

            IEnumerable data; 

             

            //Get the data source from stored procedure 

 

            ViewBag.dataSource = data;  

            return View(); 

 

        } 

 

Online reference: 

1)       http://stackoverflow.com/questions/28599404/how-to-run-stored-procedures-in-entity-framework-core 

2)      http://dotnetthoughts.net/how-to-execute-storedprocedure-in-ef-core/ 

Regards, 

Venkatesh Ayothiraman. 

[Nicholas Picardi]

Hi Venkatesh,

Thanks for the code.

It is what i needed.

Regards,

Nicholas

[Mohammed Farook J]

Hi Nicholas, 

  

Thanks for update. 

  

Regards, 

J.Mohammed Farook