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

RADGRID FOR AN EXCEL SHEET

2 Answers 31 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Syed M Ali Shah
Top achievements
Rank 1
Syed M Ali Shah asked on 17 Sep 2009, 11:34 AM

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

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 1
answered on 18 Sep 2009, 05:11 AM
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.

Princy
0
Syed M Ali Shah
Top achievements
Rank 1
answered on 15 Oct 2009, 04:52 AM
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.

Tags
Grid
Asked by
Syed M Ali Shah
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 1
Syed M Ali Shah
Top achievements
Rank 1
Share this question
or