Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z] access rights for parameter-based queries accessing ADO classic ADTG Recordset flat files JETdatabases Accumulate function action commands INSERT Identity values NULL and DEFAULT values UPDATE BLOBs concurrency decimal and floating point numbers parameter-based updates SET clause strings strongly typed data columns activating connection pools performance counters ad hoc queries, integrating into applications 2nd adCriteriaAllCols setting (Update Criteria property) adCriteriaKey setting (Update Criteria property) adCriteriaTimeStamp setting (Update Criteria property) adCriteriaUpdCols setting (Update Criteria property) Add method 2nd Add New Table dialog AddingNew event AddLoan stored procedure AddRange method 2nd addressing objects AddTrustedCodeModuleInCurrentAppDomain method administration administrative functions Auto Close option backups importing/exporting data .MDFdatabase files, attaching DBMSs SQL Server Express Edition 2nd ADO ADTG Recordset, accessing class diagrams data sources history of overview of ADO and ADO.NET Examples and Best Practices ADO.NET class names CLR executables Querying data returning data/messages SqlContext connection transactions CommandBuilder concurrency management example data access providers DataColumn objects DataRow objects DataSet objects overview of 2nd populating strongly typed DataSets DataTable objects DataColumns DataRows joins overview of 2nd populating DataSets with populating from SqlDataReader DataView class exploring with Visual Studio Object Browser history of 2nd Identity values, managing Multiple Active Result Sets (MARS) namespaces Imports statement Microsoft.SQL Server.Server System.Data 2nd System.Data.SqlClient System.Data.SqlTypes object instantiation constructors overview of scope Using block overview of populating data structures DataSet Load method DataTable Load method design hard-coding DataTable objects InfoMessage messages OUTPUT and RETURN value parameters overview of resultset elements 2nd SqlDataAdapter Fill method server-side cursors creating disadvantages of dynamic cursors fetching data from fetching entire cursor forward-only cursors implementing importance of keyset cursors managing opening, closing, and reopening connections static cursors updating SqlBulkCopy class SqlClient performance counters SQLClientFactory class SqlCommand class [See SqlCommand objects.] SqlConnection class SqlConnectionStringBuilder class SqlDataAdapter class Fill method properties Update method updates SqlDataReader class SqlDependency class SqlError class SqlErrorCollection class SqlException class SqlParameter class SqlParameterCollection class SqlTransaction class TableAdapter objects Advanced Properties dialog Advanced Services options (SQL Server) aggregates 2nd CLR SUMUSD example definition of testing aliases ConnectionString creating 2nd AllowDelete property (DataView class) AllowEdit property (DataView class) AllowNew property (DataView class) ALTER PROCEDURE statement ampersand (&) ANSI compared to Unicode data types ANSI_NULLS setting Append method AppendFormat method Appleman, Dan application architectures [See architectures, choosing.] application design [See also application architectures; architectures, choosing; DBMSs (database management systems), overview of.] application settings client/server applications connection pools definition of CLR executables concurrency constraints data access architectures ASP browser-based architectures database-agnostic applications multi-tiered design overview of stand-alone applications 2nd stand-alone applications (client/server architectures) XMLWeb Service architectures data restoration backup and deployment issues importance of security Data Sources, importing development costs example applications aliases, creating chapter-specific configuration issues installing goals of human element multi-user issues overview of population project specifications relational databases resource management scalability security SqlDataReader UpdateEvents application 2nd batch mode updates CustomerUpdate stored procedure DataRow versions RowUpdated event, trapping RowUpdating event, trapping Update method web applications Application Name property (SQL Profiler) ApplyDefaultSort property (DataView class) approximate numbers architectures ADO [See ADO, ADTG Recordset, accessing.] ADO.NET [See ADO.NET, class names.] choosing DAO (Data Access Objects) data access architectures ASP browser-based architectures database-agnostic applications multi-tiered design overview of stand-alone (client/server) applications XMLWeb Service architectures JET ODBC (Open Database Connectivity) OLEDB Reporting Services scalability ASP browser-based architectures 2nd assemblies, managing with Server Explorer AsyncCallback objects asynchronous execution of SqlCommand objects BeginExecuteNonQuery function BeginExecuteReader function BeginExecuteScalar function BeginExecuteXmlReader function callback 2nd cautions IAsyncResult interface overview of polling threads WaitHandle objects 2nd AsyncState property (IAsyncResult interface) AsyncWaitHandle property (IAsyncResult interface) AttachDBFilename keyword attaching example databases .MDFdatabase files authentication (SQL Server) 2nd authorization (SQL Server) Auto Close option |