SQL data into DataGrid

[Silviu]

I have a Windows 8.1 C#/XAML app and I would like to pull in data from a remote SQL server into a RadDataGrid control.

Where can I find some samples/getting started details on how to do that.

[Pavel R. Pavlov]

Hello Silviu,

Thank you for contacting us on that matter. The RadDataGrid component has a great feature allowing customers to easily connect to database. This is the DataStorageProvider. In our Getting Started article you can find our how you can utilize it in your project.

Please go through the articles and let us know if you need any further assistance.

Regards,
Pavel R. Pavlov
Telerik

[Silviu]

Thanks.

Do I need to install any other telerik tools than Telerik UI for Windows8.1 XAML for getting this to work?

[Silviu]

Also, does this work for local DB and SQLlite only because, I need remote access.

[Pavel R. Pavlov]

Hi,

In order to get advantage of the DataStorageProvider you need to have installed on your PC our UI for windows universal suite. You can see what steps should be taken in our Installation steps article. 

On the other hand you need to keep in mind that the DataStorage is only a local storage. In the cases where you need to connect to remote data base you will need to find another way to load the data into the RadDataGrid. 

Regards,
Pavel R. Pavlov
Telerik

[Silviu]

Yes I need remote SQL way of getting data, local is no good.

Are there any telerik controls that can facilitate that?

[Pavel R. Pavlov]

Hello,

We provide UI controls. The Data Access Layer of an application or any of its components are not part of our Windows Universal suite. It is up to you to decide how the data should be loaded into our controls in order to be visualized on screen.

However, you can try Telerik Data Access it is a separate from our Windows Universal product but it can be useful in your particular scenario. You can also go through its documentation and evaluate if it fits your case.

Regards,
Pavel R. Pavlov
Telerik