Index_M

M

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