FTPsql2012

IndexA,BActiveXDataObject(ADO).
SeeADO.
NETADO.
NET,171,213architecturalcomponentsconnection,176disconnection,176-177features,175commandcreationCommandTextproperty,214-216designview,214SQLstatement,216SqICommand,214-216string,216text,213databasesserve,171dataprovidersAPls,181differences,178.
NET,I77-178ODBC,180-181OLEDB,179-180SQLServer,178-179datareader,173datatable/set,173dBaseandParadox,172ExecuteNonOuerymethoddesignview,226,227-228insertion,230-231INSERTquery,231-232primarykey,230steps,225-231ExecuteReadermethoddatareader,224designview,221SqlDataReaderobject,224steps,221-224ExecuteScalarmethoddesignview,218scalarcommand,220steps,217-220TextBox'sAppendTextmethod,220-221executingcommandsExecuteNonOuerymethod,225-231ExecuteReadermethod,221-224ExecuteScalarmethod,217-220methods,217multipleresults,221nonquerystatements,224scalarquery,217features,172manageddataproviders,173motivation,172namespaces,173-175.
NETbaseclasslibrary,173-175n-tierprogrammingmodel,172OLEDB,172storedprocedureCREATEPROCEDUREstatement,233deleteoperation,232ExecuteNonQuerymethod,233-239SQLServerManagementStudio,232-233valuepassing,239XMLanddataaccess,172ADO.
NETentityframework5.
0.
SeeEntitydatamodel(EDM)ASP.
NET.
SeealsoDatacontrolsassemblies,317VI.
aspx,322designview,323loginform,323project,324Responseobject,326runningandtestingprogram,325webform,322-323webpages,316-317websitelayout,320-321web.
configfile,321409INDEXcC#.
SeeWindowsFormsapplicationsCascadingStyleSheets(CSS),102Commonlanguageruntime(CLR),3,395integrationcodemodification,397querywindow,396-397steps,396-397metadataandmainfest,395.
NETCLR,395storedprocedure,C#argumentexception,405-406codewindow,401-402DLL,398emptyprojectlist,399GetDateOfunction,403GetDateOmethod,406-407inputparameters,402-403InsertCurrency_CS,405-406newitem,399-400intoSQLserver,403-405VisualStudioenvironment,400-401WindowsFormsApplicationproject,398T-SQLlSQLCLR,396types,395Componentobjectmodel(COM)objects,173ConceptualSchemaDefinitionLanguage(CSDL),376Concurrency,308Connections,197dataprovidernamespacesandclasses,197meaning,197objectsConnectionStringproperty,208-210informationdisplay,206-208stringandconstructor,206SQLServer2012-SqlConnectionCloset),200-202database,199debugging,202-203.
(dot)and\(slash),200errormessage,199-200pooling,205process,200-202queries,198securityandpasswords,203string,200stringparameters,204-205usage,security,204410SQLServer-OleDbConnectiondataprovider,210informationdisplay,211-212namespace,212parameter,212steps,210-212Workstationldproperty,212DDataadapterscommandbuildersSqlCommandBuilder,305-308SQLstatements,304concurrency,308datasetscodeeditorwindow,282-283constructor,281creationandinitialization\r,284designview,282FillOmethod,284results,283steps,281datasourceInsertCommandproperties,301-304properties,300interactions,279-280Database,25arguments,32.
mdfand.
ldffiles,30-31MySQLDb,30properties,31SQLquerysyntax,32-34SQLServerManagementStudio,28-29steps,29Databaseadministrator(DBA),377Databasemanagementsystem(DBMS),15Datacontrols,315ASP.
NETUI,322-326webpages,316-317website,320-321lIS,315repeatercontrolsdatabasesteps,326-328datatable,330designview,327features,326markupview,328-329runningandtestingprogram,329-330VisualStudio2012websitefilesystem,318FTP,318HTTP,319-320lIS,317webfunctionalitiescommunicationprocess,315types,315webbrowserandHTTP,316webserver,316Datadefinitionlanguage(DDL),18Datamodificationlanguage(DML),19Datareaders,241columnnameindexers,250connectionstream,241-242datasourcecodeeditorwindow,261-263designview,260-261GetNamemethod,263-264metadatamethodsandproperties,258results,263resultset,259-261multipleresultsetscodeeditorwindow,270-271designview,269NextResultO,268-269queries,272-273results,271-272ordinalindexercoding,247-249DataReaderproject,246-247designview,247queries,249-250results,249retrievecolumn,246resultsetabstractclass,245-246DataLooperprogram,244-245designview,242-243Readmethod,246retrieverows,242-245tablescodeeditorwindow,266-267designview,265foreachloop,268GetSchemaTablemethod,265results,267schema,264typedaccessormethodscodeeditorwindow,255-256designview,255Getmethod,251OLEDBdatatypes,252-254results,257Sales.
CreditCardtable,257-258SQLserver,251-252steps,254-255table,254Datasets,277.
SeealsoDataadaptersconcurrency,308database,277datatablecodeeditorwindow,298-299datamodification,296designview,297NewRowmethod,300results,299rowupdation,297singledata,300dataviewcodeeditorwindow,293-294designview,292-293dynamicrepresentation,292meaning,292parameters,295results,294rowstates,295-296steps,292filteringandsortingdatacodeeditorwindow,286-288datatable,290designview,286FilterSort-PopDataSet,291queries,289-291results,288steps,285-286string,290objectmodelarchitecture,278-279datacolumn,280us.
datareaders,278datarow,281datatable,280datatables,278interactions,279-280offlinemode,278typedanduntypeddata,313-314XMLcodeeditorwindow,310-311dataandschema,309datatable,311-312designview,309INDEX411INDEXDatasets,XML(cant.
)methods,308-309queries,312-313results,311DatasourcelnsertCommandpropertiescodeeditorwindow,301-303datasetrow,301designview,301INSERTstatement,304results,303updatemethod,301UpdateCommandDe1eteCommand,304-308Dataviewcodeeditorwindow,293-294designview,292-293dynamicrepresentation,292meaning,292parameters,295results,294rowstates,295-296steps,292EEntitydatamodel(EDM),375ADO.
NETEntityFramework(EF)5.
0,375approach,375codesegment,376-377creationstepsApp.
configfile,388-389AWCurrencyModel.
edmx,378codetemplate,387connectionpropertiesdialogbox,381-382databaseobjectsscreen,383-384dataconnectionscreen,379-380datasourcedialogbox,381designview,385modelcontentsscreen,379properties,386PublishCurrencyform,387,388settingsdisplay,382-383solutionexplorer,384XMLmapping,386DBA,377EntityClient,375entity-relationshipmodel,377layers,376schemaabstraction412advantage,391C-Smappingsection,392-393exceptiondetails,390properties,389PublishCurrency.
cscode,389-390SSDLcontentsection,391-392sourcecode,377XMLmappingfile,377EXtensibleMarkupLanguage(XML),101advantages,101attributes,103benefits,102-103contentandvalue,103CSS,102datatypeDOMtree,111insert,112SQLServerdatatype,IIIstoringandretrievingdocuments,112-113tablecreation,111-112viewingdocuments,113declaration,104document,103-104emptyelementtag,104markuplanguages,101metalanguage,101multipurpose,102parentandchildelement,103relationaldataattribute-centric,105-106AUTOmodequeries,109-110element-centricraw,106-107rawformat,108-109rootelements,106rowelement,107-108SELETEquery,105well-formed,103XSD,102F,GFileTransferProtocol(FTP),318Filteringandsortingdata,datasetscodeeditorwindow,286-288datatable,290designview,286FilterSort-PopDataSet,291queries,289-291results,288steps,285-286string,290HHandlingexceptions,183file-handlingapplicationcatchblock,195creation,184designview,184-186filepath,186-187logfile,187null,196readandwritetextbox,188readfilebutton,194-195Streamobject,195wrongdirectoryname,195wrongfilepath/name,195properties,183details,193-194message,192StackTrace,192-193type,192situation,creationexceptiondialogoccurs,190programfrom,189VisualStudio,190-191wrongfilename,190System.
Exceptionclass,183-184HypertextTransferProtocol(HTTP),319-320Integrateddevelopmentenvironment(IDE),141IntermediateLanguage(lL),317InternetInformationServices(lIS),315J,KJoinsinnerjoinsFROMclause,79naturaljoins,77queries,78SELECT,79syntax,78outerjoinsCROSSJOIN,83FULLOUTERJOIN,83LEFTOUTERJOIN,80-81RIGHTOUTERJOIN,82-83types,80UNIONJOIN,83relationaloperation,77tablealiasing,78LLanguageIntegratedQuery(LINQ),357advantages,357architecture,359-360assemblies,358components,359differences,357projectstructureobjects,361-364queries,steps,360-361references,361SQL,364-370XML,370-374M,NManipulatingdatabasedata,43deletingdataSELECTstatement,49-50syntax,49insertingdataGetl'iatet).
44multiplerows,45-46MySqlTable,44-45row,43-44SELECTstatement,46-47syntax,43updatingdatamultiplecolumnsandrows,49row,48SELECTstatement,48SETkeyword,48syntax,47values,47MappingSchemaLanguage(MSL),376MicrosoftDistributedTransactionCoordinator(MSDTC),120MicrosoftIntermediateLanguage(MSIL),317Multipledocumentinterface(MDI)arrangechildforms,168-170implementation,162open,childform,165-167parentform,163-165INDEX413INDEXMultipledocumentinterface(cant.
)Showt)method,165,167-168oOnlinetransactionprocessing(OLTP),3Opendatabaseconnectivity(ODBCl,172pPessimisticconcurrency,308Projectstructure,LINQobjectsadvantages,361designview,362Linqsteps,362-363stringarray,364SQLcodingsteps,364-368datacontext,368-369designview,365entityclass,368queries,364queryexpression,369-370references,366XMLcodingsteps,371-373designview,372documents,370-371statement,373QQueryingdatabases.
SeealsoJoinsaggregatefunctionsCOUNT,67-68MIN,MAX,SUM,andAVG,66-67DATETIMEfunctions,68-70GROUPBYclauseaggregatevalues,59-60COUNTfunction,60uses,59listoperatorINoperator,70-71NOTINoperator,71-72NULLvaluesNOTNULLoperator,76-77NULLoperator,75-76patternmatchingbracket(Ill,63-64414percent(%l,61-62squarebracketandcaret([1\]),64-65underscoreU,62-63wildcardcharacters,61rangeoperatorBETWEEN,72-74NOTBETWEEN,74-75retrievingdatacomparisonoperators,55-57results,53SELETEandFROMstatement,51-52seletingcolumns,53-54WHEREclauses,54-55sortingdataASCorDESCkeyword,57filteringdata,58ORDERBYclause,57SELECTandWHEREclasses,58-59SQLServer,51RRelationaldatabasemanagementsystem(RDBMS)benefits,16-17meaning,15.
NETCLR,3Relationaldatabases,15candidatekey,22compositekey,22dataintegrity,22-23DBMSs,15desktopdatabases,17entityintegrity,22foreignkey,22fundamentalconcepts,15lifecycle,18-19datamodification,19databaseimplementation,18databasemonitoring,19logicalandphysicaldesign,18requirementsanalysis,18mappingcardinalitiesmany-to-manyrelationship,20-21one-to-manyrelationship,19-20tables,19meaning,15normalizationconcepts,23denormalization,24disadvantages,24firstnormalform(INF),23secondnormalform(2NF),23thirdnormalform(3NF),24primarykey,21-22RDBMS,15-17referentialintegrity,23serverdatabases,17-18spreadsheetapplication,16surrogatekey,22uses,16Repeatercontrolsdatatable,330databasesteps,326-328designview,327features,326markupview,328-329runningandtestingprogram,329-3305SchemaDefinitionLanguage(SSDL),376Singledocumentinterface(SOl),162Sortingimagesloadingimagebinarydatacodeeditor,335-337designview,335Executelnsertlmagesmethod,340imagedata,338LoadlmageFilemethod,340loop,338-340privateclass-levelmethod,339SQL2012Db,338steps,334-335viewingdata,338retrievingimagescodeeditor,342-344designview,342displayimages,344-345Getltowt),345-346resultset,345steps,340-341textcolumncodeview,352-354databasequeries,354-355designview,352results,354steps,351textdatacodeeditor,347-349designview,347LoadTextprogram,350-351results,349steps,346-347SQLcodingsteps,364-368datacontext,369designview,365entityclass,368queries,364queryexpression,369-370references,366SqlCommandBuilder,dataadapterscodeeditorwindow,305-307designview,305insertrows,307-308results,307steps,305SQLServer.
SeealsoCommonlanguageruntime(CLR)Server2012(seeTransactions)storedprocedure,C#deploymentprocess,405objectbrowser,404steps,403-404SQLServerdatabasesarchitecture,27-28logdatafiles,27primarydatafile,27typessystemdatabases,25-26userdatabases,26-27SQLServer2012ExpressAdventureWorksdatabaseattachdialog,9-10attachmentprocess,6databaseattachments,8-9error,7-8filelocations,10-11installationsteps,Slists,13-14.
mdfdatabasefiles,11-12progress,12-13Serverdialogconnection,6-7SQLServerManagementStudio,7developmenttools,3installationsteps,4-5SQLServerservicerunning,SSQLServerManagementStudio(SSMS)AdventureWorks2008database,6-14developmenttools,3INDEX415INDEXSQLServerManagementStudio(cant.
)tablesanddataabase,25SQLServertextandbinarydatatypes,333CHprogram,334column,333large-valuedatatypes,333sortingimagesloadingimagebinarydata,334-340retrievingimages,340-346textcolumns,351-355textdata,346-351StoredproceduresALTERPROCEDUREstatement,92-94ASkeyword,87-88COUNTfunction,92definition,94-96deleteoperation,98-99CH,232CREATEPROCEDUREstatement,233inputparameter,232-233dropprocedure,99ExecuteNonQuerymethodcurrency,239designview,235passingvalue,239queries,235-237referenceconstraint,237-238steps,233-239execution,87inputparameter,88-89metadataretrieval,94modifyingexecution,92-94outputparameter,89-92parameters,85procedurecreation,86rename,96-97RETURNstatement,92sp_helptextstatement,95SQLstatements,232Systemdatabase,25TTablefundamentalsALTERTABLE,37-38dropandre-create,38-39iDENTITYcolumn:,36-37insert,34-35nullvalues,35SQLServer416datatypes,35tablecreation,35-36Transactions,115ACiDpropertiesatomicity,116consistency,117design,117durability,117isolation,117types,117APIfunctionsandmethods,118autocommitmode,119batch-scopedmode,119boundaries,118concurrency,116distribution,120explicit,119implicitmode,119localtransactions,119MARS,120operations,115overview,115states,118storedprocedures,122T-SQLstatementsBEGIN,COMMITandROLLBACK,121coding,121,124-127databaseoption,118DELETEandINSERT,129firstoperation,129inputparameters,127-129insertrow,127parent-childrelationship,122-124personandPersonDetaiistables,124rolledback,132-133secondoperation,131spTransTest,125storedprocedureexcution,126two-phasecommit,120uses,116Typedaccessormethodscodeeditorwindow,255-256designview,255Getmethod,251OLEDBdatatypes,252-254results,257Sales.
CreditCardtable,257-258SQLserver,251-252steps,254-255table,254Typeddatasets,313-314uUntypeddatasets,313-314vVisualStudio2011installation,4.
NETframework,3softwarecomponents,4VisualStudio2012lIS,317websitefilesystem,318FTP,318HTTP,319-320wWindowsFormsapplications,137alphabeticalview,145anchorpropertiesintroduction,153labelcontrol,156resizedform,154-155buildingblocks,137categorizationview,144code/designview,142-143dockpropertiesintroduction,152labelcontrol,156resizedform,153-154fonts,140iDE,141label,TextBoxandbuttoncontrolscodeview,149-150GUldesign,149MessageBox.
showO,151-152output,150steps,147-148MOlapplicationarrangechildforms,168-170implementation,162open,childform,165-167parentform,menubar,163-165ShowOmethod,165,167-168picturesandicons,140projectandsolution,145-147propertieswindow,141sortingoptions,143templates,140toolboxtab,141-142userinterfacedesignaesthetics,139color,139consistency,139locationofcontrols,138-139principles,138simplicity,138WindowsprojectCheckBoxandRadioButton,160-161ClearO,161-162codefunction,159GUldesign,158ListBoxandComboBox,160start-upform,160-161steps,156-158WinFor~s.
SeeWindowsFormsapplicationsWorldWIdeWebConsortium(W3C),102X,Y,ZXML,370-374,SeealsoEXtensibleMarkupLanguage(XML)codeeditorwindow,310-311dataandschema,309datatable,311-312designview,309methods,308-309queries,312-313results,311XMLSchemaDefinition(XSD),102INDEX417