RADGRID FOR AN EXCEL SHEET

[Syed M Ali Shah]

Hi,

I have to create a grid given below from data by using RadGrid. Cells in yellow color are editable. Top and Left headers are city codes extracted from Database, while the price entered by user will be stored in database. I am also looking for copy feature for the values provided by the user, so that user may copy values from cells to other cells as in excel.

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

DB structure is as follows;

RoutePriceID     StartRouteID    EndRouteID    Price

Please guide how can I do it using Radgrid.

Thanks

Cheers,
S

[Princy]

Hi Syed,

Here is a code library submission which explains how to implement an excel like RadGrid. You may refer that as a start up.

Excel-like RadGrid

Princy

[Syed M Ali Shah]

Hi,

Thanks for pointing to a sample application to develop an excel like grid in rad controls. However my problem is a little different because I want the header/column titles from database and also row titles from database, as shown below:

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

 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.