Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/25

Click to flip

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