Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
Gets the size in bytes of network packets used to communicate with SQL Server.
|
SQLConnection.PacketSize
|
|
Gets the current state of a database connection.
|
SQLConnection.State
|
|
How can you encrypt connection Strings?
|
By referencing the name of the section in the <protectedData> section of the web.config file
|
|
If you are going to perform bulk operations in a database through a connection what should you do?
|
Increase the Packet size
|
|
Creates and returns a SQLCommand object associated with the connection
|
SQLConnection.CreateCommand()
|
|
What is the recommended way you should work with connection strings
|
Try
Catch Finally conn.close To make sure the connection is closed even if there is an error |
|
Gets or Sets how the SQLCommand.CommandText property is interpreted? What is the default?
|
SQLCommand.CommandType
|
|
What are the three possible values for the SQLCommand.CommandType
|
Text
StoredProcedure TableDirect |
|
Under what section in the web.config file are connection strings stored
|
<connectionStrings>
<add name=NWind.......... |
|
What is the name of the server control that can manage all aspects of data interaction, including connection and command execution.
|
Data Source object,
there are five I think |
|
Retrieve schema info for the specified scope or database
|
SQLConnection.Getschema
|
|
Gets or sets the statement or stored procedure name to execute
|
SQLCommand.CommandText
|
|
How can you query or use a connection string stored in the web.config file
|
string = ConfigurationManager.ConnectionStrings("NWind").ConnectionString
|
|
Gets the collection of parameters associated with a SQLCommand
|
SQLCommand.Parameters
|
|
If a SQLConnection goes out of scope it is closed, true or false
|
False, you must explicitly close the connection by calling Close or Dispose
|
|
Name 3 common methods of the SQLCommand Class
|
1.) ExecuteReader
2.) ExecuteNonQuery 3.) ExecuteScalar |
|
What SQLCommand method returns an integer respresenting the number of rows affected
|
ExecuteNonQuery
|
|
What are 4 common properties of the SQLCommand class
|
1.) Connection
2.) CommandText 3.) CommandType 4.) Parameters |
|
What are two common properties of the SQLDataReader class?
|
Item
FieldCount |
|
What are two common methods of the SQLDataReader class?
|
Read( reads the next row, true if more rows, false if no more)
Close Close the datarReader, not the connection |
|
What are two common methods of the SQLDataAdapter class?
|
Fill
Update |
|
What control is used to read data from a data source into memory and to write in-memory data back to a datasource
|
DataAdapter
|
|
What object do you use to fill a dataset?
|
SQLDataAdapter.Fill(ds,"MyTable")
|
|
The IListSource interface of the dataset makes it possible to do what?
|
return a data-bound list of elements
|
|
gets or sets a value othat indicates whether constraint rules are enforced when attempting an update operation
|
Dataset.EnforceConstraints
|