Datagrids, repeaters, and rows oh my....

C

college_amy

Regular
Joined
Jan 3, 2004
Messages
83
Background:
I have a datagrid that displays information from a stored procedure.

Problem:
In this datagrid there are numerous instances of the same "main" title (see example)
Example Datagrid:
Field1 field 2 field 3
Data1 Data2 Unique Data
Data1 Data2 Different Data
Data1 Data2 More Unique Data

So basically.. Field1 and Field2 have different data from themselves, but the data throughout the field is the same. What I want to do is have only the FIRST row of data where Data1 and Data2 are the same (but unique to each other) display and all the other rows beneath them where Data1 and Data2 are the same be blank.

How do I do that?

(Here is an example of the output desired)
Example Datagrid:
Field1 field 2 field 3
Data1 Data2 Unique Data
Different Data
More Unique Data
Data3 Data4 UniqueData
Different Data
MoreUniqueData
Data5 Data6 etc. etc.....
 
My suggestion would be to use the ItemDataBound function with some Static variables. and do something like this... (untested because I don't have time to set up a database right now)

Visual Basic: 
Public Sub HideCells(ByVal sender As Object, _
    ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs)
  Static col1Value as String
  Static col2Value as String

  Dim dr as DataRow = CType(e.Item.DataItem, DataRow)

  If e.Item.ItemType = ListItemType.AlternatingItem Or _
      e.Item.ItemType = ListItemType.Item Then
    If dr.Item("col1Name") <> col1Value Then
      e.Item.FindControl("lblCol1").visible = true
      col1Value = dr.Item("col1Name")
      e.Item.FindControl("lblCol2").visible = true
      col2Value = dr.Item("col2Name")
    ElseIf dr.Item("col2Name") <> col2Value Then
      e.Item.FindControl("lblCol1").visible = false      
      e.Item.FindControl("lblCol2").visible = true
      col2Value = dr.Item("col2Name")
    Else
      e.Item.FindControl("lblCol1").visible = false      
      e.Item.FindControl("lblCol2").visible = false      
    End If
  End If
End Sub

if column 1 and column two always change together, you can probably get away with just the first and last part of the conditional. This loop will handle the following situation:
Code: 
Header1  Header2  Header3
asdf     qwer     1234
                  2345
         yuio     4564
                  3456
                  9876
hjkl     vbnm     7667
...
 
Back
Top