This is a migrated thread and some comments may be shown as answers.

How To Load Data From Dataset Tables?

2 Answers 445 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
LEON
Top achievements
Rank 1
LEON asked on 20 Mar 2020, 05:58 PM

I recently trying to understand how Telerik reporting works, most of the tutorials are based on the SQL server. I am using MS Access for a small project where the embedded database needed. I have some business logic running on the background. All the customise data stored in a Dataset table. While working with MS RDLC I can easily bind the data source to that particular dataset from the Report Data tab. But don't understand how can I achieve the same using Telerik Reporting.

I already visited below forum thread from 2013, but still cant understood.

Is it possible to use a dataset as the datasource for a report with groups?

 

is there any step by step guide for the beginners? I have already read the Docks. it will be very helpful if someone uploads an example project.

2 Answers, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 25 Mar 2020, 08:26 AM

Hi Leon,

The recommended approach is to create a typed DataSet from the original data you have and use it in the ObjectDataSource Component. After selecting this component in the report designer a wizard will be started that will guide you through the steps of connecting to the required data. When using DataSet with ObjectDataSource, set the DataSource property to the method that returns the DataSet and the DataMember to the exact table to bind to.

We do not have a project that satisfies the specific requirements you mentioned, however, I can recommend reviewing the approaches for loading the MS Access data into a DataSet provided int the following external resources:

How to load an Access Database into a DataSet object in C#

Loading Access table into DataSet .NET 

 

Regards,
Katia
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
LEON
Top achievements
Rank 1
answered on 25 Mar 2020, 06:08 PM

Thanks Katia for replying. but I think you have not read my question properly. I already mentioned in the subject and inside the body of the message that all the data stored in a dataset table. I am not asking how to populate the dataset from database. I am asking how to bind the various parameter of the report to the dataset table.

anyway you answered my question, will look for "ObjectDataSource Component". If I stuck somewhere will update here.

Tags
General Discussions
Asked by
LEON
Top achievements
Rank 1
Answers by
Katia
Telerik team
LEON
Top achievements
Rank 1
Share this question
or