Master/Detail Report Demo

Also, you may be wondering how to "pretty up" the FAQs "detail" DataGrid. You can programmatically set its aesthetic properties (such as the Font, HorizontalAlign, BackColor, etc.) in the ItemDataBound event handler. For example, if you wanted the "detail" DataGrid to have a red background you could add:

   dg.BackColor = System.Drawing.Color.Red

after the following line:

   Dim dg as New DataGrid()

Category	FAQs
Application Object	FAQID FAQCategoryID Description ViewCount 129 7 Can I create an application-level Dictionary object? 64799 101 7 How can I list all of the Application variables on a Web page? 66635 142 7 How can I use application-level variables to cache information? 86357
Arrays	FAQID FAQCategoryID Description ViewCount 161 1 How can I convert a Recordset into an array? Also, how can I convert an array into a Recordset? 222447 26 1 How can I convert the contents of an array into a string? 58051 92 1 How can I determine the position of a particular string in an Array? 47162 21 1 How can I determine the upper or lower bounds of an array? 44031 84 1 How can I display all of the contents of a single-dimension array? 49700 97 1 How can I get a count of the number of dimensions in an array? 48009 93 1 How can I quickly determine if a string exists within an array? 61819 83 1 How can I quickly sort a VBScript array? 215025 89 1 How can I sort a VB Script array in ways other than by case-sensitive alphanumeric order, like numeric value, length of string, or even randomly? 93936 190 1 How do I display data on a web page using arrays instead of Do...While...MoveNext...???... 171050 7 1 How do I dynamically resize an array? 60640 86 1 How do I extract the contents of an array without knowing the size of the array? 43064 63 1 How do I put an array into a Session or Application "variable"? How do I then use it on the next ASP page? 96091 146 1 How is a two-dimensional laid out in memory? 42898 145 1 How is an array stored in memory? I am interested in learning about the internals of an array! 45644
ASP.NET	FAQID FAQCategoryID Description ViewCount 181 22 How can I format numbers and date/times using ASP.NET? For example, I want to format a number as a currency. 913661 163 22 How do I convert a string into an Integer? 109782 177 22 How much will ASP.NET (the .NET Framework) cost once Microsoft is finished with Beta testing and ready to roll a "final" version? 36015 202 22 I have installed the .NET Framework, but my Web server won't serve ASP.NET Web pages. Help! 72567 187 22 If I deploy an ASP.NET Web application will the sysadmin of the Web server where the code in installed be able to see my ASP.NET Web page source code? 62429 175 22 Is ASP.NET output compatible with all browsers? If not, what browsers is the output compatible with? 42684 162 22 What are the differences between ASP.NET Beta 1 and Beta 2? 40974 182 22 What are the differences between ASP.NET Beta 2 and Version 1.0? 32986 185 22 What are the differences between C# and VB.NET, and which language should I use to create my ASP.NET Web pages? 53254 158 22 What do I need to start working with ASP.NET? 40079 157 22 What is ASP.NET? 38509 159 22 Where can I learn more about ASP.NET? 44274
Cookies	FAQID FAQCategoryID Description ViewCount 41 11 How can I delete an existing cookie? 70313 29 11 How can I determine if a visitor has cookies support enabled in his/her browser? 82724 52 11 How can I display all of the cookies/cookie values for a user through a Web page? 48711 196 11 How can I share cookies between my server-side scripts (ASP) and my client-side scripts (e.g., JavaScript in the browswer)? 36670
Databases, Errors	FAQID FAQCategoryID Description ViewCount 107 21 ** UPDATED 24 June 2003 **: Why am I getting "Operation must use an updateable query" errors? 107031 115 21 I am using Access and getting a 80004005 error (or a [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)' error) when trying to open a connection! How can I fix this problem? 220217 138 21 I'm getting an error (80020009) when trying to work with a value from a Memo (or text or blob) column. For example, I get this error when I do: Response.Write objRS(MemoColumnName) 43692 58 21 Why do I get a type mismatch error from my query? Why do I get the message Syntax error (missing operator) from my query? Why do I get a Too few parameters expected 1 error from my query? 50001 174 21 Why do I get a closed recordset from my stored procedure? Why don't I get the expected fields from the stored procedure? 46588 137 21 Why do I get an error when I try to insert a value into a database that contains an apostrophe? 38144 160 21 Why do I get the error "The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another" when I try to open a recordset? 80166 81 21 Why do I get the message Microsoft JET Database Engine error ' 80040e14' Syntax error in INSERT INTO statement?? 50615 139 21 Why does the .RecordCount property return a value of -1? 52873

Source Code

<%@ Import Namespace = "System.Data" %> <%@ Import Namespace = "System.Data.SQLClient" %> <script language="VB" runat="server"> Dim FAQsDS as New DataSet() Sub Page_Load(sender as Object, e as EventArgs) BindData() End Sub Sub BindData() '1. Create a connection Dim myConnection as New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) '2. Create the command object, passing in the SQL string Dim strCategorySQL, strFAQSQL as String strCategorySQL = "SELECT TOP 5 FAQCategoryID, Name FROM tblFAQCategory ORDER BY Name" strFAQSQL = "SELECT FAQID, FAQCategoryID, Description, ViewCount " & _ "FROM tblFAQ ORDER BY Description" Dim myCatCommand as New SqlCommand(strCategorySQL, myConnection) Dim myCatDA as New SqlDataAdapter(myCatCommand) Dim myFAQCommand as New SqlCommand(strFAQSQL, myConnection) Dim myFAQDA as New SqlDataAdapter(myFAQCommand) 'Fill the dataset myConnection.Open() myCatDA.Fill(FAQsDS, "Categories") myFAQDA.Fill(FAQsDS, "FAQs") myConnection.Close() 'Bind the Categories DataSet to the DataGrid dgFAQsByCategory.DataSource = FAQsDS.Tables("Categories") dgFAQsByCategory.DataBind() End Sub Sub buildFAQsDataGrid(sender as Object, e as DataGridItemEventArgs) If e.Item.ItemType = ListItemType.Item OR _ e.Item.ItemType = ListItemType.AlternatingItem then 'Build the DataGrid Dim dg as New DataGrid() 'Find out the CategoryID Dim CatID as Integer = e.Item.DataItem("FAQCategoryID") 'Create a DataView that has only the applicable FAQs Dim properFAQs as DataView = FAQsDS.Tables("FAQs").DefaultView properFAQs.RowFilter = "FAQCategoryID=" & CatID 'Bind the Data to the DataGrid dg.DataSource = properFAQs dg.DataBind() 'Add the DataGrid to the 2nd Column e.Item.Cells(1).Controls.Add(dg) End If End Sub </script> <asp:DataGrid runat="server" id="dgFAQsByCategory" AutoGenerateColumns="False" Font-Name="Verdana" Width="85%" Font-Size="11pt" HorizontalAlign="Center" ShowFooter="True" OnItemDataBound="buildFAQsDataGrid"> <HeaderStyle BackColor="Navy" ForeColor="White" HorizontalAlign="Center" Font-Size="14pt" Font-Bold="True" /> <FooterStyle BackColor="Navy" ForeColor="White" Font-Size="12pt" Font-Bold="True" HorizontalAlign="Right" /> <Columns> <asp:BoundColumn DataField="Name" HeaderText="Category" /> <asp:TemplateColumn HeaderText="FAQs"> <ItemTemplate> </ItemTemplate> </asp:TemplateColumn> </Columns> </asp:DataGrid>

[Return to the article]