ASP.NET equivalent to CFQUERY GROUP

[Brent Mondoux]

Hey everyone,

I'm trying to find the best non-spaghetti code way to do the
equivalent of a ColdFusion CFQUERY GROUP command so that I can display
a FAQ with categories as follows:

-- Example: Begin --
General
- What is Enlighten?

Client Profile
- How do I add a new client?
- How do I update a client profile?

Programs & Activities
- How do I setup a new program?
- How do I add an activity to a program?
-- Example: End --

Any ideas? Please email me back at br***@mondoux.c om

Thanks.

Brent

[Brent Mondoux]

Found a solution to this, used a couple of queries to do the trick

<!-- #INCLUDE Virtual="../includes/header.aspx" -->
<!-- #INCLUDE Virtual="../includes/bofaq.aspx" -->

<script language="vb" runat="server">

Dim myFAQ As New boFAQ
Dim dstFAQCats As DataSet
Dim dstFAQs As DataSet
Dim dvwFAQs As DataView

Sub Page_Load
' Setup client object datasource
myFAQ.DSN = ConfigurationSe ttings.AppSetti ngs("enlightenD SN")

' In the event of a new FAQ item, place message on page
If Not Request.QuerySt ring("isnew") Is Nothing Then
lblStatusFAQ.Te xt = "FAQ item saved."
End If

If Not Page.IsPostBack Then
BuildList()
End If
End Sub

Sub BuildList()
dstFAQCats = myFAQ.getFAQCat egoriesWithItem s()
dstFAQs = myFAQ.getFAQSum mary()
dvwFAQs = dstFAQs.Tables( "tblFAQItem").D efaultView()

rptFAQs.DataSou rce = dstFAQCats
rptFAQs.DataMem ber = "tblFAQCategory "
rptFAQs.DataBin d()
End Sub

Function FilterFAQs(intC atID As Integer) As DataView
dvwFAQs.RowFilt er = "faqcategory_id =" & intCatID
Return dvwFAQs
End Function

</script>

<asp:label id="lblStatusFA Q" runat="server" Text="" />

<p><strong>Freq uently Asked Questions</strong></p>

<asp:Repeater ID="rptFAQs" RunAt="server">
<ItemTemplate >
<p><strong><% # Container.DataI tem("category_n ame") %></strong>
<asp:DataGrid Width="500" BorderWidth="0" CellPadding="3"
CellSpacing="0"
ShowHeader="Fal se" HeaderStyle-BackColor="#F6F 6F6"
AlternatingItem Style-BackColor="Alic eBlue"
AutoGenerateCol umns="False" DataKeyField="f aqitem_id"
DataSource='<%# FilterFAQs(
Container.DataI tem("faqcategor y_id") ) %>' runat="server">
<Columns>
<asp:BoundColum n Visible="False" HeaderText=""
DataField="faqi tem_id" SortExpression= "faqitem_id " />
<asp:HyperLinkC olumn DataTextField=" summary"
DataNavigateUrl Field="faqitem_ id"
DataNavigateUrl FormatString=". ./caseworker/faqitem.aspx?fi d={0}"
ItemStyle-Width="500px" HeaderText="Ite m" />
</Columns>
</asp:DataGrid></p>
</ItemTemplate>
</asp:Repeater>

On Wed, 23 Jun 2004 13:30:48 -0400, Brent Mondoux <br***@mondoux. com>
wrote:

Hey everyone,

I'm trying to find the best non-spaghetti code way to do the
equivalent of a ColdFusion CFQUERY GROUP command so that I can display
a FAQ with categories as follows:

-- Example: Begin --
General
- What is Enlighten?

Client Profile
- How do I add a new client?
- How do I update a client profile?

Programs & Activities
- How do I setup a new program?
- How do I add an activity to a program?
-- Example: End --

Any ideas? Please email me back at br***@mondoux.c om

Thanks.

Brent