supress repeating rows in a datagrid?

[PisgahMan]

is there an easy way to supress repeating rows in a datagrid?

 

For example if 3 rows of data looks like this.

 

Acct No F.Name L.Name Address

---------------------------------------------------------------------------

123456 Johnny Speller 789 Elm Street

654311 Johnny Speller 789 Elm Street

241454 Johnny Speller 789 Elm Street

 

 

and I want it to display on the page like this:

 

 

Acct No F.Name L.Name Address

---------------------------------------------------------------------------

123456 Johnny Speller 789 Elm Street

654311

241454

[Robby]

Yes, but it's not easy. I deal with something similiar here http://www.xtremedotnettalk.com/showthread.php?threadid=78363

 

Online demo

[mr relaxo]

If you're using a dataset you could just loop through it and change repeating values to empty strings before you bind it to your grid. This assumes that you ORDER BY fname.

e.g

 

Dim dr As DataRow

       Dim thisrow, lastrow As String
        For Each dr In ds.Tables("yourdatatablename").Rows 
            lastrow = thisrow 'set variables to same value
            thisrow = dr.Item("fname")  'change thisrow to next  datarow in the loop
            If thisrow = lastrow Then 'if they're equal you have repeating values so...

                             dr.Item("fname") = ""
                             dr.Item("lname") = ""
                             etc...
             
           End If

 

kinda crude, but its easy.

[PisgahMan]

That worked mr relaxo, thanks