How can I accomplish this?

[tryston02]

Hey guys, I am writing a web app in C# using ASP.NET 2.0 and am quite sure how to go about doing something.
Here's what's going on:

I display a set of records from our database, and then when it comes to a different value in a certain field, I need it to display a blank row to separate them. Here's a look:


ID Air Base
------ -------------
1 Scott
2 Scott
3 Scott
//this is a blank line
4 Lackland
5 Lackland
6 Lackland
7 Lackland
//this is a blank line


I need it to display a blank line when the value of Air Base changes to a different value. The question is, how can I go about this? What would I need to do? Would using DataTables and DataRows solve this? Is so, can someone give me a brief code example to get me started (I'm pretty new) ?

Thanks guys!