Deploying the Survey Application
You must follow a few steps to deploy the Survey application on your server:
All of this is easy so far, but here's the more difficult part. The application is using a Web Reference to the Web Service on the www.ASPNET-Solutions.com server. That's OK (except that you're using my bandwidth!), but any changes you make to the Web Service will have no effect when your application runs. To fix this, do the following:
Your Survey application should now be ready to use and ready to modify as you see fit.
This chapter gives you a starting point for the effective use of ADO.NET. You've learned how to use the SqlConnection, SqlCommand, and SqlDataReader objects. You've also learned how to add parameters to a command and how to call a stored procedure.
A complete and reusable application was introduced to
Although this chapter provides 90 percent of what you need for database access, Chapter 4 covers more advanced ADO.NET topics.
Chapter 4. Using ADO.NET: Creating a Technical Support Application
In This Chapter:
This chapter teaches additional ADO.NET techniques that you'll commonly use in application development. Whereas the Survey application in Chapter 3 used stored procedures throughout, this chapter and its featured application uses ad hoc queries. The DataAdapter and DataSet objects are discussed because these are extremely useful and flexible
A ready-to-use HelpDesk application illustrates the topics presented in the chapter. The application uses ad hoc queries instead of stored procedures, and it creates the queries with parametric and string concatenating techniques. The HelpDesk application offers users the capability to post problems they're experiencing for the purpose of seeking a resolution. Because a Web-based technical support solution is less expensive than a phone-based solution, this capability might save your company a lot of money. Users can also search on previously entered problems to find
Finally, hints on extending and modifying the HelpDesk application follow. These hints give you ways to adapt an already-useful application to your specific needs. A section covers deployment of the HelpDesk application so that you can easily use it in your Web application.