O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Workshop

These quiz questions are designed to test your knowledge of the material covered in this chapter. The answers to the quiz questions can be found in Appendix A, “Answers to Quizzes.”

Quiz

1:What is the purpose of the ExecuteNonQuery() method of the Command object?
2:True or false: Using the ExecuteNonQuery() method to execute a query that returns data will result in an exception error being thrown from the data layer.

Exercise

Given that the SQL command to create a new table in your data source is

CREATE TABLE TableName
   (
    Field1 int,
    Field2 varchar(50),
    Field3 int
   )

Using the examples in this hour as a guide, create a Windows form or Web form that will enable you to create a database table. The table name and field names should be dynamically ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required