|
|
main method, 181
MainMenu controls, 165
Manage Constraints option, 56
Manage Indexes option, 42
Manage Indexes/Keys option, 55
Manage Relationships option, 438
Manage Triggers option, 130
managed provider classes, 138-141, 139
Management folder, 32
Mapped value, 362
mapping tables and columns, 328-331, 329
Mappings.cs program, 330-331
marking modifications, 382
mathematical functions, 111-113
MAX function, 108, 110
max pool size setting, 192
Maximum Characters Per Column field, 569
MaxLength property, 350-351, 357
Merge.cs program, 319-321
Merge method, 301, 318
MergeFailed method, 302
merging objects, 318-321
Message property, 10
Meta Data Services folder, 32
metadata functions, 107
Microsoft Passport accounts, 628, 628
MIN function, 108, 110
minus signs (-)
for comments, 97
in pattern matching, 65
MissingMappingAction property, 295
MissingSchemaAction enumeration, 318-319
MissingSchemaAction property, 295
Mode column for transaction locks, 503
Mode property, 538
modes, XML, 227, 568-569, 569
Modified value, 379
ModifiedCurrent value, 368, 456
ModifiedOriginal value, 368, 456
ModifyDataRow method, 380-382, 395-396, 409-410
modifying data, 354
automatic generation of SQL statements, 398-399
DataAdapter events for, 399-404
DataColumn objects for, 349-350, 356-362
DataRow objects for, 347-349
DataRowView objects for, 467-472
DataTable objects for. See DataTable objects
FillSchema method for, 362-367
rows, 83-84, 84
stored procedures for, 386-397
with strongly typed DataSets, 413-415
tables, 90
transactions with, 412-413
update failures in, 408-412
VS.NET code, 21-22
ModifyRowsUsingUPDATE method, 409-410, 412
money type in SQL Server, 43, 269
money value in SqlDbType, 241
MONTH function, 116-117
MS_POSITIONING attribute, 522
multi-line comments, 97
multiple conditions, 71-72, 71-72
multiple DataAdapter objects, 316-318
multiple DataTable objects, 311-316
multiple SQL statements, 282-288
multiple tables
for populating objects, 303-304
retrieving rows from, 79-81, 80
MultipleDataTables.cs program, 312-314
MultipleDataTables2.cs program, 314-316
MultipleDataTables3.cs program, 316-318
multistatement table-valued functions, 119, 122-124, 123-124
My Profile link, 19
myButton_Click method, 157, 163
MyDataSet.cs program, 335-336
MyDataSet.xsd file, 332-335, 333
MySqlConnection.cs program, 191-192
myXmlFile.xml file, 322-323
myXmlFile2.xml file, 323-324
myXmlSchemaFile.xml file, 324-325
|
|