Course Materials 01 Setup Development Environment, SQL Database, and Hello World" Page Mid-Term Survey 02 Basic Web Form and Displaying Results Resources Need Help? 03 Hello World and Using Variables and Strings 04 Using Loops and Arrays on Web Pages to Display Database Data 05 Build an Advanced Web Page 06 **No Course Project in Module 6* Purpose of Assignment: To display an understanding of creating loops and arrays to display database data. Instructions: For this assignment, you must write two C# programs (hint: you may repurpose the code from Mod3_Connect_CSharp_to_SQL.docx) that query your course project database: The first program must use one of the four types of loops you've learned about in this module to display the results of the SQL query (you must select at least 2 columns from the database), but then loop back through the program one time when the user presses a key. The second program must use an array (hint: the program already uses an array to display the results of the query). However, this time, the array must only display the first and last names. Format: Your submission must include 2 text files and a Word document: o The text files must contain the code from your C# loop program [insert filename format here] and C# array program [insert filename format here). o The Word document must contain (4) screenshots: (1) screenshot of your console application containing the loop program created in Visual Studio. . (1) screenshot of the loop program running in the Visual Studio console. - (1) screenshot of your console application containing the array program created in Visual Studio. . (1) screenshot of the array program running in the Visual Studio console. Course Materials 01 Setup Development Environment, SQL Database, and Hello World" Page Mid-Term Survey 02 Basic Web Form and Displaying Results Resources Need Help? 03 Hello World and Using Variables and Strings 04 Using Loops and Arrays on Web Pages to Display Database Data 05 Build an Advanced Web Page 06 **No Course Project in Module 6* Purpose of Assignment: To display an understanding of creating loops and arrays to display database data. Instructions: For this assignment, you must write two C# programs (hint: you may repurpose the code from Mod3_Connect_CSharp_to_SQL.docx) that query your course project database: The first program must use one of the four types of loops you've learned about in this module to display the results of the SQL query (you must select at least 2 columns from the database), but then loop back through the program one time when the user presses a key. The second program must use an array (hint: the program already uses an array to display the results of the query). However, this time, the array must only display the first and last names. Format: Your submission must include 2 text files and a Word document: o The text files must contain the code from your C# loop program [insert filename format here] and C# array program [insert filename format here). o The Word document must contain (4) screenshots: (1) screenshot of your console application containing the loop program created in Visual Studio. . (1) screenshot of the loop program running in the Visual Studio console. - (1) screenshot of your console application containing the array program created in Visual Studio. . (1) screenshot of the array program running in the Visual Studio console