[Solved] Columns from database.

[GrZeCh]

Hello!
Is this possible to create columns from database? Lets say I have fileds in DB like this:

• shop (using GROUP BY)
• sum_of_money_from_one_day (using SUM)
• date

.. and now I want to have columns as shops names,one columnd with date and rows with date and sum_of_money_from_one_day for all shops.

How can this be done?

Thanks in advance

[Yavor]

Hello Grzesiek,

You can allow the control to autogenerate its structure, and pass it the necessary datasource, as a datasource object. The control would then automatically pick up the datatype and create the necessary columns. Additional information on the columns types, you can find in the following example. I hope this information helps.

Regards,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center