Summary
In this chapter, you learned the following:
-
What an ADO.NET command is and does
-
How to create a command
-
How to associate a command with a connection
-
How to set command text
-
When to use the different command execution methods
-
How to use ExecuteScalar for queries that return single values
-
How to use ExecuteReader to process result sets
-
How to use ExecuteNonQuery for DML and DDL
-
How to create databases and tables using ExecuteNonQuery
-
What command parameters are and how to use them
-
How to use commands, specifically OleDbCommand and OdbcCommand, with other data providers
In the next chapter, you’ll look in more depth at data readers, which you created in some of the examples in this chapter with a call to ExecuteReader. Data readers give you the results of a SQL query that returns more than one item of data.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2005 Dan Maharry, James Huddleston, Ranga Raghuram, Scott Allen, Syed Fahad Gilani, Jacob Hammer Pedersen, Jon Reid
About this chapter
Cite this chapter
(2005). Introducing Commands. In: Beginning VB .NET 1.1 Databases. Apress. https://doi.org/10.1007/978-1-4302-0010-9_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0010-9_6
Publisher Name: Apress
Print ISBN: 978-1-59059-358-5
Online ISBN: 978-1-4302-0010-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books