Here's a cracker and i'm not sure if it's possible to do this in ASP.NET. Any tips would be very helpful.

Basically I have some data in a SQL server database like this:

StartPeriod, EndPeriod, LowerScore, HigherScore, PercentageRate
0 13 0 0 4.93
0 13 1 100 40.22
0 13 101 154 32.24
0 13 155 164 22.56
0 13 165 174 18.8
0 13 175 184 15.17
0 13 185 194 11.86
0 13 195 204 9.03
0 13 205 214 6.73
0 13 215 224 4.93
0 13 225 234 3.57
0 13 235 244 2.57
0 13 245 254 1.84
0 13 255 264 1.32
0 13 265 274 0.95
0 13 275 284 0.69
0 13 285 294 0.49
0 13 295 304 0.23
0 13 305 314 0.15
0 13 315 324 0.08
0 13 325 334 0.03
0 13 335 344 0.02
0 13 345 354 0
0 13 355 405 0
14 25 0 0 2.58
14 25 1 100 21
14 25 101 154 16.83
14 25 155 164 11.78
14 25 165 174 9.82
etc etc...

I'd like to display it in my web app Like this;

Score/Period 0 - 0 | 1 - 100 | 101 - 154 etc...
0 - 13 4.93 40.22 32.24
14 - 25 2.58 21 16.83
26 - 37 ... ... ...
etc...

and also be able to update the Percentage Rates. Something that would looks like an excel spreadsheet would be ideal.

Does anyone know if this is possible?

You can use a datagrid for this.

J

I thought that it might be a datagrid. It looks like quite a powerful component in .net.

It seems like it should be quite easy to populate it with results from a stored procedure, but how would you be able to update the data if it needed to be changed?

This is a 16 part tutorial that is excellent reading for datagrids.
I highly recommend it.
http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

However, it seems you wish to dispaly summerised data.
You can not ammend summerised data as it is mearly a reflection of the original data.
You could display the original results and modify/update and insert them, and this would automatically update you summarised data.
So essentially you are looking at two datagrids, one to display the data in is summerised form.
And one to manipulate the data in the database.

======================================
They say, best men are molded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================

Thanks Rod, i'll give it a go.