[Solved] Grid Headers Text from Database...

[Syed M Ali Shah]

Hi,

How can I create the grid row header text and column header text from the values in database as shown below:

	CHC	ROL	PAC	DAC
CHC		12	15	18
ROL			20	20
PAC				25
DAC

 
Cells in yellow color need to be editable. Price entered by the user will be stored in database.

The DB Table (ROUTEPRICETABLE) is as follows:
RoutePriceID     StartCityCode    EndCityCode    Price
1                                  CHC                ROL               

2                                  CHC                PAC

3                                  CHC                DAC

4                                  ROL                PAC

5                                  ROL                DAC

6                                  PAC                DAC

So the price field data which is editable will go into db field Price. I would really appreciate if you could make a small sample for showing how to do it? I am using RadGrid for telerik controls version .net 3.5. with sql server 2005.

Thanks
Syed.

So the price field data which is editable will go into db field Price. I would really appreciate if you could make a small sample for showing how to do it? I am using RadGrid for telerik controls version .net 3.5. with sql server 2005. ThanksSyed.

[Johny]

Hi Syed,

While I was looking through the Telerik documentation I found the following article that might be helpful to you:

http://www.telerik.com/help/aspnet-ajax/grdusingcolumns.html

The Excel like grid might also be helpful in your case:

http://www.telerik.com/community/code-library/aspnet-ajax/grid/excel-like-radgrid.aspx

I hope this helps.
Johny