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? 76235 101 7 How can I list all of the Application variables on a Web page? 77615 142 7 How can I use application-level variables to cache information? 97894
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? 238089 26 1 How can I convert the contents of an array into a string? 69457 92 1 How can I determine the position of a particular string in an Array? 58403 21 1 How can I determine the upper or lower bounds of an array? 55032 84 1 How can I display all of the contents of a single-dimension array? 60990 97 1 How can I get a count of the number of dimensions in an array? 58949 93 1 How can I quickly determine if a string exists within an array? 73272 83 1 How can I quickly sort a VBScript array? 230033 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? 105385 190 1 How do I display data on a web page using arrays instead of Do...While...MoveNext...???... 186006 7 1 How do I dynamically resize an array? 71897 86 1 How do I extract the contents of an array without knowing the size of the array? 53906 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? 108962 146 1 How is a two-dimensional laid out in memory? 53696 145 1 How is an array stored in memory? I am interested in learning about the internals of an array! 56577
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. 964702 163 22 How do I convert a string into an Integer? 123762 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? 46764 202 22 I have installed the .NET Framework, but my Web server won't serve ASP.NET Web pages. Help! 84035 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? 73651 175 22 Is ASP.NET output compatible with all browsers? If not, what browsers is the output compatible with? 53711 162 22 What are the differences between ASP.NET Beta 1 and Beta 2? 52117 182 22 What are the differences between ASP.NET Beta 2 and Version 1.0? 43770 185 22 What are the differences between C# and VB.NET, and which language should I use to create my ASP.NET Web pages? 64405 158 22 What do I need to start working with ASP.NET? 51057 157 22 What is ASP.NET? 49574 159 22 Where can I learn more about ASP.NET? 55617
Cookies	FAQID FAQCategoryID Description ViewCount 41 11 How can I delete an existing cookie? 82522 29 11 How can I determine if a visitor has cookies support enabled in his/her browser? 94329 52 11 How can I display all of the cookies/cookie values for a user through a Web page? 59803 196 11 How can I share cookies between my server-side scripts (ASP) and my client-side scripts (e.g., JavaScript in the browswer)? 47592
Databases, Errors	FAQID FAQCategoryID Description ViewCount 107 21 ** UPDATED 24 June 2003 **: Why am I getting "Operation must use an updateable query" errors? 119416 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? 233530 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) 54771 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? 61107 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? 57541 137 21 Why do I get an error when I try to insert a value into a database that contains an apostrophe? 49332 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? 91729 81 21 Why do I get the message Microsoft JET Database Engine error ' 80040e14' Syntax error in INSERT INTO statement?? 61560 139 21 Why does the .RecordCount property return a value of -1? 63999

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]