I have a stored procedure that returns one big table with Employee names, phone numbers, and their state.  I need to generate different tables (or GridViews, or Repeaters... not sure) for each state.  Here's an example:

My table has
ID     Employee_Name    Phone_Number     State

I need my web form to look like this:

California
ID    Employee_Name   Phone_Number
ID    Employee_Name   Phone_Number
ID    Employee_Name   Phone_Number
ID    Employee_Name   Phone_Number

Arizona
ID    Employee_Name   Phone_Number
ID    Employee_Name   Phone_Number
ID    Employee_Name   Phone_Number
ID    Employee_Name   Phone_Number

I've seen some posts regarding repeating a GridView (actually DataGrid, but I'm in 3.5) but I'm not sure I understand how to group that data by State.  Any suggestions?  Thanks in advance

What you need to use is the list view control which is new to asp.net 3.5, this tutorial is almost exactly what you are after http://aspnet.4guysfromrolla.com/articles/122607-1.aspx. Although I would save the data from your database into a list and then query it with LINQ. Let me know if you have any trouble getting it working.

Thanks for the response.  I might need some more help with this.  I'm still not sure how to group my data into individual repeater type controls on the page.  The DataTable that I have has records for employees from all states.  I need to take that data, and generate a repeater-looking control that lists employees for each State.  Can I do that with the ListView?  It looks like the header is static in this example, and my code is just returning a list, much like the Repeater.

Let me know if you need more info.  Thanks again.

This is working: http://datawebcontrols.com/faqs/DataLists/GroupingByCategory.shtml

Code Behind
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

          Dim empsByLocation = _
                  From em In Employee.getEmployees() _
                  Group em By Key = em.Location Into Group _
                  Select New With {.Key = Key, .emps = Group}

      Public Sub New(ByVal ID As Long, ByVal Name As String, ByVal Phone As String, ByVal Location As String)
           Me._Location = Location
           Me._Name = Name
           Me._Phone = Phone
           Me._ID = ID
      End Sub

      Public ReadOnly Property Name() As String
          Get
               Return _Name
          End Get
      End Property

      Public Shared Function getEmployees() As List(Of Employee)
 
            Dim employees As New List(Of Employee)
 
            employees.Add(New Employee(1, "Bob", "09809809", "California"))
            employees.Add(New Employee(2, "Jack", "3453465", "California"))
            employees.Add(New Employee(3, "Arnold", "7899878978", "California"))
            employees.Add(New Employee(4, "Barry", "2134678", "Arizona"))
            employees.Add(New Employee(5, "Titch", "454458", "Arizona"))
            employees.Add(New Employee(6, "Mick", "23432424", "Arizona"))

            Return employees
     End Function

Will produce the output:

Wow thanks.  I'm going to give it a try. 

Any change you can give me that Linq code in C#?  I can't find any code converters online that understand the Linq portion, and my version isn't working

var results = (from RE in DbDocument.GetSearchResults(type, _subType)
                              group RE by SUBTYPE into g
                              select new {.Key = Key, .emps = group});

You won't be able to use Linq with a datatable, you need a collection that implements IEnumerable. Here is an article to get around it - http://cs.rthand.com/blogs/blog_with_righthand/archive/2006/01/15/284.aspx, and its in C#

I ended up using that old school method (which works really well, considering it's an article from 2003) but I'll definitely try your method next time around.

Thanks again for all your help!