Welcome to C l e a r G l a s s

Subversion Addin for Visual Studio .NET
Ankh FAQ
Subversion Book
SVNServe -r hangs in Windows command. Use this instead:
Run SVNServe as a Service on Windows (svn://)

Source Code management and database deployment
VSS Tips & Tricks
Moving and copying files via File System Object

VBScript Code:


‘Before DataBind - Add New Rows Here for Each Sub Heading
Dim curCat As String
Dim prevCat As String
Dim row As TableRow
Dim i As Integer = 0
 
Do While i < = ds.Tables(0).Rows.Count - 1
curCat = ds.Tables(0).Rows(i).Item("CategoryName")
If curCat <> prevCat Then
prevCat = curCat
Dim shRow As DataRow = ds.Tables(0).NewRow
shRow("ProductName") = ds.Tables(0).Rows(i).Item(0)
shRow("UnitPrice") = “SubHead”
ds.Tables(0).Rows.InsertAt(shRow, i)
 
i += 1
End If
 
i += 1
Loop
‘End Insert SubHeadings
 
DataGrid1.DataSource = ds
DataGrid1.DataBind()
 
End Sub
 
Private Sub DataGrid1_ItemDataBound(sender As Object, e As DataGridItemEventArgs)
Select Case e.Item.ItemType
Case ListItemType.AlternatingItem, ListItemType.Item
If e.Item.Cells(1).Text.Equals("SubHead") Then
‘Format the data, and then align the text of each cell to the left.
e.Item.Cells(0).Attributes.Add("align", “Left")
e.Item.Cells(0).ColumnSpan = 3
e.Item.Cells(0).Font.Bold = True
e.Item.Cells.RemoveAt(2)
e.Item.Cells.RemoveAt(1)
e.Item.BackColor = Color.FromArgb(204,204,255)
End If
End Select
End Sub


References:

Including Subheadings in a Datagrid
Summarizing Data with ROLLUP, Part 2
Enhancing the DataGrid with Grouped Rows and Subheadings: ASPAlliance