Index S

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

sample code
       aggregate commands  
       BLOBs, writing to file  
       changes, committing/ discarding  
        columns   2nd   3rd  
       concurrency handling  
       connections, opening/testing  
       constraints  
       data, updating   2nd   3rd  
       DataReaders, fast-forward  
       DataSets   2nd  
               strongly typed  
       DataTable events  
       DataViews, displaying multiple  
       DiffGram format  
       FillError event  
       FillSchema( ) method  
       isolation levels  
       list binding
               ASP.NET  
               Windows  
       ListViews, filling with all columns  
       many-to-many relationships[sample code
               many to many relationships  
       mapping tables/columns  
       master-detail form  
       master-detail data binding  
       native SQL data types, using  
       navigational control  
       parameterized queries  
       parameters  
       PositionChanged event  
       primary key  
       records, updating   2nd   3rd  
       relational filter expressions  
       rows   2nd  
               errors in  
               update event handlers for  
       savepoints  
       schema information, retrieving  
       SQL Server 2000 support for XML  
       stored procedures  
               for commands  
               queries for  
               updating records with  
               with output parameters  
               with return values  
       tables   2nd  
       templates and styles  
       transactions  
               automatic  
               using DataAdapters  
       TreeViews, hierarchical  
       UniqueConstraint objects  
       update objects  
       Update( ) method  
       values, formatting/parsing  
       web service code  
       web service returning modified DataSet  
Save( ) method, for savepoints   2nd  
savepoints  
schema inference  
schema information, retrieving  
       from data source  
schemas
       ADO.NET objects and  
       cloning  
               for DataTables  
       XML and  
SchemaType enumeration
       DataAdapter class  
       System.Data namespace  
Select( ) method, rows and   2nd   3rd  
SelectCommand objects  
SelectCommand property  
SelectedValue property  
semicolon (;)
       in C# syntax  
       in connection strings  
ServerVersion property  
SetAbort( ) method, for automatic transactions  
SetColumnError( ) method   2nd  
SetColumnNameNull( ) method   2nd  
SetComplete( ) method, for automatic transactions  
SetParentRow( ) method   2nd  
single-value binding  
sorting data  
SQL Server
       connection strings and  
       migrating MSDE database to  
       schema tables, retrieving with  
       stored procedures and  
       XML extensions for  
SQL Server .NET provider   2nd  
       connection pooling and   2nd  
       recommendations for selecting  
SQL Server Books Online  
SQL statements, benefits of vs. stored procedures  
SqlBinary structure  
SqlBoolean structure  
SqlByte structure  
SqlClientPermission class  
SqlClientPermissionAttribute class  
SqlCommand class  
SqlCommandBuilder class   2nd  
SqlCompareOptions enumeration  
SqlConnection class  
SqlDataAdapter class  
SqlDataReader class  
SqlDateTime structure  
SqlDbType enumeration  
SqlDecimal structure  
SqlDouble structure  
SqlError class  
SqlErrorCollection class  
SqlException class  
SqlGuid structure  
SqlInfoMessageEventArgs class  
SqlInfoMessageEventHandler delegate  
SqlInt16 structure  
SqlInt32 structure  
SqlInt64 structure  
SqlMoney structure  
SqlNullValueException class  
SqlParameter class  
SqlParameterCollection class  
SqlRowUpdatedEventArgs class  
SqlRowUpdatedEventHandler delegate  
SqlRowUpdatingEventArgs class  
SqlRowUpdatingEventHandler delegate  
SqlSingle structure  
SqlString structure  
SqlTransaction class  
SqlTruncateException class  
SqlTypeException class  
SQLXML data provider  
SQLXML Managed Classes  
SqlXmlCommand class  
State property  
StateChange event  
StateChangeEventArgs class  
StateChangeEventHandler delegate  
StatementType enumeration  
stored procedures  
       benefits of  
               vs. SQL statements  
       DataReader column order and  
       with DataReaders  
       drawbacks of  
       executing  
       SQL Server  
       system  
       updating data source and  
       using to retrieve data from data source  
strongly typed DataSet objects   [See DataSet objects, strongly typed]
StrongTypingException class  
structs, namespace quick reference and  
structures, C#/Visual Basic and  
styles, templates and  
subsets of rows  
SyntaxErrorException class  
system stored procedures  
System.Data namespace  
System.Data.Common namespace  
System.Data.OleDb namespace  
System.Data.SqlClient namespace  
System.Data.SqlTypes namespace  
System.DBNull class