Repeat a header on a datagrid

dlsteve · Apr 28, 2012

Is this possible? I have a report that I'd like the header on the datagrid to simply repeat every six lines. I can't seem to get it to work no matter what I do. Thanks, paulHave you tried another control, such as the DataRepeater? Or are you bound by business case to the DataGrid?I thought the Repeater control might have something that the DataGrid didn't. doesn't look like it :::mumble, mumble::: should think before I post!The Code. <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Import Namespace="System.Xml" %> <%@ Import Namespace="System.Xml.Xsl" %> <script language="VB" runat="server"> sub Page_Load(sender as Object, e as EventArgs) GetData() end sub Sub GetData() Dim strConn as string strConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & _ "C:InetpubwwwrootNETDevdataDemo.mdb;" 'Open a connection Dim conn as OleDbConnection conn = new OleDbConnection(strConn) conn.open() 'specify your SQL Dim strSQL as string strSQL = "SELECT UserID, UserFName, UserMI, UserLName, UserEmail FROM tblUser" Dim dst AS dataset dst = new dataset() Dim odad as OledBDataAdapter odad = New OledBDataAdapter(strSQL, conn) odad.Fill(dst, "Users") XMLUsers.Document = New XmlDataDocument(dst) XMLUsers.TransformSource = "Perf.xsl" conn.close() End Sub </script> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <TITLE> Six! </TITLE> <META NAME="Generator" CONTENT="EditPlus"> <META NAME="Author" CONTENT="Avitar"> </HEAD> <BODY> <asp:Xml ID="XMLUsers" Runat="Server" /> </BODY> ...... The xsl <xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'> <xsl:template match="/"> <style> .value { width:"25%";font-family:courier new; font-size:.8em; white-space=pre;} </style> <table border="1" cellspacing="0" cellpadding="3" bordercolor="gainsboro"> <xsl:for-each select='NewDataSet/Users'> <xsl:variable name="myVar" select="position() mod 5=1" /> <xsl:choose> <xsl:when test='$myVar'> <tr> <th>ID</th> <th>First Name</th> <th>MI</th> <th>Last Name</th> <th>Email</th> </tr> </xsl:when> <xsl

therwise> </xsl

therwise> </xsl:choose> <tr> <td class="value"><xsl:value-of select='UserID'/></td> <td class="value"><xsl:value-of select='UserFName'/></td> <td class="value"><xsl:value-of select='UserMI'/></td> <td class="value"><xsl:value-of select='UserLName'/></td> <td class="value"><xsl:value-of select='UserEmail'/></td> </tr> </xsl:for-each> </table> </xsl:template> </xsl:stylesheet> ...... Bibliography (casual) http://www.dotnet101.com/articles/art027_UsingXMLASP1.asp by Scott Guthrie ASP.NET Unleased by Stephen Walther <a target="_blank" href=http://aspmessageboard.com/archive/index.php/"http://www.w3c.org/tr/xpath">The w3c standards on XPath, etc.</a> Sorry for the cruddy biblio. Please let me know if this works for you. Thanks -A-

Repeat a header on a datagrid

dlsteve

New Member