Telerik grid controls to display data from SQL Server

[Nicolas]

Hello:

 I need help to display Telerik grid controls to display data from SQL Server using a REST web service as a data source. Can anyone help me please.

Thanks

[Jayesh Goyani]

Hello,

Please check below link.
RadGrid with WCF Rest Service

Let me know if any concern.

Thanks,
Jayesh Goyani

[Nicolas]

I am getting the following error from your demo code:

Server Error in '/' Application.

---

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: The base class includes the field 'RadCodeBlock1', but its type (Telerik.Web.UI.RadCodeBlock) is not compatible with the type of control (Telerik.Web.UI.RadCodeBlock).

Source Error:

Line 7: <title></title> Line 8: <script src="http://code.jquery.com/jquery-1.6.2.min.js" type="text/javascript"></script> Line 9: <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> Line 10: <script type="text/javascript"> Line 11: var UrlForsetParameter = 'http://localhost/WcfService1/Service1.svc/SetParameter';

Source File: /RestServiceWithRadGrid.aspx    Line: 9

---

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18044 

[Nicolas]

Hello Jayesh:

   could you please change the code(implement REST web service) so that I may be able to display data from sql server. I used teleriks built in web part and displayed the data, but I need to know how to display data as a rest service from sql database. Any questions please let me know. This code works fine and displays data from customer table in my sql database, but I need rest service.

Thanks
Nicolas 

[Tsvetoslav]

Hello Nicolas,

Attached are a couple of samples - one binding the grid to a restful ODATA service; the other - to a wcf service. Hope it helps.

 

Regards,
Tsvetoslav
Telerik