Application program interface for network software platform

[0001] This invention relates to network software, such as Web applications, and to computer software development of such network software. More particularly, this invention relates to an application program interface (API) that facilitates use of a network software platform by application programs and computer hardware.

[0002] Very early on, computer software came to be categorized as operating system software or application software. Broadly speaking, an application is software meant to perform a specific task for the computer user such as solving a mathematical equation or supporting word processing. The operating system is the software that manages and controls the computer hardware. The goal of the operating system is to make the computer resources available to the application programmer while at the same time, hiding the complexity necessary to actually control the hardware.

[0003] The operating system makes the resources available via functions that are collectively known as the Application Program Interface or API. The term API is also used in reference to a single one of these functions. The functions are often grouped in terms of what resource or service they provide to the application programmer. Application software requests resources by calling individual API functions. API functions also serve as the means by which messages and information provided by the operating system are relayed back to the application software.

[0004] In addition to changes in hardware, another factor driving the evolution of operating system software has been the desire to simplify and speed application software development. Application software development can be a daunting task, sometimes requiring years of developer time to create a sophisticated program with millions of lines of code. For a popular operating system such as Microsoft Windows, application software developers write thousands of different applications each year that utilize the operating system. A coherent and usable operating system base is required to support so many diverse application developers.

[0005] Often, development of application software can be made simpler by making the operating system more complex. That is, if a function may be useful to several different application programs, it may be better to write it once for inclusion in the operating system, than requiring dozens of software developers to write it dozens of times for inclusion in dozens of different applications. In this manner, if the operating system supports a wide range of common functionality required by a number of applications, significant savings in applications software development costs and time can be achieved.

[0006] Regardless of where the line between operating system and application software is drawn, it is clear that for a useful operating system, the API between the operating system and the computer hardware and application software is as important as efficient internal operation of the operating system itself Over the past few years, the universal adoption of the Internet, and networking technology in general, has changed the landscape for computer software developers. Traditionally, software developers focused on single-site software applications for standalone desktop_computers, or LAN-based computers that were connected to a limited number of other computers via a local area network (LAN). Such software applications were typically referred to as shrink wrapped products because the software was marketed and sold in a shrink-wrapped package. The applications utilized well-defined APIs to access the underlying operating system of the computer.

[0007] As the Internet evolved and gained widespread acceptance, the industry began to recognize the power of hosting applications at various sites on the World Wide Web (or simply the Web). In the networked world, clients from anywhere could submit requests to server-based applications hosted at diverse locations and receive responses back in fractions of a second. These Web applications, however, were typically developed using the same operating system platform that was originally developed for standalone computing machines or locally networked computers. Unfortunately, in some instances, these applications do not adequately transfer to the distributed computing regime. The underlying platform was simply not constructed with the idea of supporting limitless numbers of interconnected computers.

[0008] To accommodate the shift to the distributed computing environment being ushered in by the Internet, Microsoft Corporation is developing a network software platform known as the .NET platform (read as Dot Net). The platform allows developers to create Web services that will execute over the Internet. Such a dynamic shift requires a new ground-up design of an entirely new API.

[0009] In response to this challenge, the inventors developed a unique set of API functions for Microsoft's .NET platform.

[0010] An application program interface (API) provides a set of functions for application developers who build Web applications on a network platform, such as Microsoft Corporation's .NET platform.

[0011] The same numbers are used throughout the drawings to reference like features.

[0012] FIG. 1 illustrates a network architecture in which clients access Web services over the Internet using conventional protocols.

[0013] FIG. 2 is a block diagram of a software architecture for Microsoft's .NET platform, which includes an application program interface (API).

[0014] FIG. 3 is a block diagram of unique namespaces supported by the API, as well as function classes of the various API functions.

[0015] FIG. 4 is a block diagram of an exemplary computer that may execute all or part of the software architecture.

[0016] Accompanying this specification is a compact disc that stores a compiled HTML help file identifying the API (application program interface) for Microsoft's .NET network platform. The file is named cpref chm and was created on June 8, 2001. It is 30.81 Mbytes in size. The file can be executed on a Windows-based computing device (e.g., IBM-PC, or equivalent) that executes a Windows-brand operating system (e.g., Windows NT, Windows 98, Windows 2000, etc.). The compiled HTML help file stored on the compact disk is hereby incorporated by reference.

[0017] Additionally, the APIs contained in the compiled HTML help file are also provided in approximately 100 separate text files named NamespaceName.txt. The text files comply with the ASCII format.

[0018] The compact disc itself is a CD-ROM, and conforms to the ISO 9660 standard.

[0019] This disclosure addresses an application program interface (API) for a network platform upon which developers can build Web applications and services. More particularly, an exemplary API is described for the .NET platform created by Microsoft Corporation. The .NET platform is a software platform for Web services and Web applications implemented in the distributed computing environment. It represents the next generation of Internet computing, using open communication standards to communicate among loosely coupled Web services that are collaborating to perform a particular task.

[0020] In the described implementation, the .NET platform utilizes XML (extensible markup language), an open standard for describing data. XML is managed by the World Wide Web Consortium (W3C). XML is used for defining data elements on a Web page and business-to-business documents. XML uses a similar tag structure as HTML; however, whereas HTML defines how elements are displayed, XML defines what those elements contain. HTML uses predefined tags, but XML allows tags to be defined by the developer of the page. Thus, virtually any data items can be identified, allowing Web pages to function like database records. Through the use of XML and other open protocols, such as Simple Object Access Protocol (SOAP), the .NET platform allows integration of a wide range of services that can be tailored to the needs of the user. Although the embodiments described herein are described in conjunction with XML and other open standards, such are not required for the operation of the claimed invention. Other equally viable technologies will suffice to implement the inventions described herein.

[0021] As used herein, the phrase application program interface or API includes traditional interfaces that employ method or function calls, as well as remote calls (e.g., a proxy, stub relationship) and SOAP/XML invocations.

[0022] Exemplary Network Environment

[0023] FIG. 1 shows a network environment 100 in which a network platform, such as the .NET platform, may be implemented. The network environment 100 includes representative Web services 102(1), . . . , 102(N), which provide services that can be accessed over a network 104 (e.g., Internet). The Web services, referenced generally as number 102, are programmable application components that are reusable and interact programmatically over the network 104, typically through industry standard Web protocols, such as XML, SOAP, WAP (wireless application protocol), HTTP (hypertext transport protocol), and SMTP (simple mail transfer protocol) although other means of interacting with the Web services over the network may also be used, such as Remote Procedure Call (RPC) or object broker type technology. A Web service can be self-describing and is often defined in terms of formats and ordering of messages.

[0024] Web services 102 are accessible directly by other services (as represented by communication link 106) or a software application, such as Web application 110 (as represented by communication links 112 and 114). Each Web service 102 is illustrated as including one or more servers that execute software to handle requests for particular services. Such services often maintain databases that store information to be served back to requesters. Web services may be configured to perform any one of a variety of different services. Examples of Web services include login verification, notification, database storage, stock quoting, location directories, mapping, music, electronic wallet, calendar/scheduler, telephone listings, news and information, games, ticketing, and so on. The Web services can be combined with each other and with other applications to build intelligent interactive experiences. The network environment 100 also includes representative client devices 120(1), 120(2), 120(3), 120(4), . . . , 120(M) that utilize the Web services 102 (as represented by communication link 122) and/or the Web application 110 (as represented by communication links 124, 126, and 128). The clients may communicate with one another using standard protocols as well, as represented by an exemplary XML link 130 between clients 120(3) and 120(4). The client devices, referenced generally as number 120, can be implemented many different ways. Examples of possible client implementations include, without limitation, portable computers, stationary computers, tablet PCs, televisions/set-top boxes, wireless communication devices, personal digital assistants, gaming consoles, printers, photocopiers, and other smart devices. The Web application 110 is an application designed to run on the network platform and may utilize the Web services 102 when handling and servicing requests from clients 120. The Web application 110 is composed of one or more software applications 130 that run a top a programming framework 1-32, which are executing on one or more servers 134 or other computer systems. Note that a portion of Web application 110 may actually reside on one or more of clients 120. Alternatively, Web application 110 may coordinate with other software on clients 120 to actually accomplish its tasks.

[0025] The programming framework 132 is the structure that supports the applications and services developed by application developers. It permits multi-language development and seamless integration by supporting multiple languages. It supports open protocols, such as SOAP, and encapsulates the underlying operating system and object model services. The framework provides a robust and secure execution environment for the multiple programming languages and offers secure, integrated class libraries.

[0026] The framework 132 is a multi-tiered architecture that includes an application program interface (API) layer 142, a common language runtime (CLR) layer 144, and an operating system/services layer 146. This layered architecture allows updates and modifications to various layers without impacting other portions of the framework. A common language specification (CLS) 140 allows designers of various languages to write code that is able to access underlying library functionality. The specification 140 functions as a contract between language designers and library designers that can be used to promote language interoperability. By adhering to the CLS, libraries written in one language can be directly accessible to code modules written in other languages to achieve seamless integration between code modules written in one language and code modules written in another language. One exemplary detailed implementation of a CLS is described in an ECMA standard created by participants in ECMA TC39/TG3. The reader is directed to the ECMA web site at www.ecma.ch.

[0027] The API layer 142 presents groups of functions that the applications 130 can call to access the resources and services provided by layer 146. By exposing the API functions for a network platform, application developers can create Web applications for distributed computing systems that make full use of the network resources and other Web services, without needing to understand the complex interworkings of how those network resources actually operate or are made available. Moreover, the Web applications can be written in any number of programming languages, and translated into an intermediate language supported by the common language runtime 144 and included as part of the common language specification 140. . In this way, the API layer 142 can provide methods for a wide and diverse variety of applications.

[0028] Additionally, the framework 132 can be configured to support API calls placed by remote applications executing remotely from the servers 134 that host the framework. Representative applications 148(1) and 148(2) residing on clients 120(3) and 120(M), respectively, can use the API functions by making calls directly, or indirectly, to the API layer 142 over the network 104.

[0029] The framework may also be implemented at the clients. Client 120(3) represents the situation where a framework 150 is implemented at the client. This framework may be identical to server-based framework 132, or modified for client purposes. Alternatively, the client-based framework may be condensed in the event that the client is a limited or dedicated function device, such as a cellular phone, personal digital assistant, handheld computer, or other communication/computing device.

[0030] Developers' Programming Framework

[0031] FIG. 2 shows the programming framework 132 in more detail. The common language specification (CLS) layer 140 supports applications written in a variety of languages 130(1), 130(2), 130(3), 130(4), . . . 130(K). Such application languages include Visual Basic, C, C, COBOL, Jscript, Perl, Eiffel, Python, and so on. The common language specification 140 specifies a subset of features or rules about features that, if followed, allow the various languages to communicate. For example, some languages do not support a given type (e.g., an int* type) that might otherwise be supported by the common language runtime 144. In this case, the common language specification 140 does not include the type. On the other hand, types that are supported by all or most languages (e.g., the int type) is included in common language specification 140 so library developers are free to use it and are assured that the languages can handle it. This ability to communicate results in seamless integration between code modules written in one language and code modules written in another language. Since different languages are particularly well suited to particular tasks, the seamless integration between languages allows a developer to select a particular language for a particular code module with the ability to use that code module with modules written in different languages. The common language runtime 144 allow seamless multi-language development, with cross language inheritance, and provide a robust and secure execution environment for the multiple programming languages. For more information on the common language specification 140 and the common language runtime 144, the reader is directed to co-pending applications entitled Method and System for Compiling Multiple Languages, filed June 21, 2000 (serial No. 09/598,105) and Unified Data Type System and Method filed 7/10/2000 (Ser. No. 09/613,289), which are incorporated by reference.

[0032] The framework 132 encapsulates the operating system 146(1) (e.g., Windows-brand operating systems) and object model services 146(2) (e.g., Component Object Model (COM) or Distributed COM). The operating system 146(1) provides conventional functions, such as file management, notification, event handling, user interfaces (e.g., windowing, menus, dialogs, etc.), security, authentication, verification, processes and threads, memory management, and so on. The object model services 146(2) provide interfacing with other objects to perform various tasks. Calls made to the API layer 142 are handed to the common language runtime layer 144 for local execution by the operating system 146(1) and/or object model services 146(2).

[0033] The API 142 groups API functions into multiple namespaces. Namespaces essentially define a collection of classes, interfaces, delegates, enumerations, and structures, which are collectively called types, that provide a specific set of related functionality. A class represents managed heap allocated data that has reference assignment semantics. A delegate is an object oriented function pointer. An enumeration is a special kind of value type that represents named constants. A structure represents static allocated data that has value assignment semantics. An interface defines a contract that other types can implement.

[0034] By using namespaces, a designer can organize a set of types into a hierarchical namespace. The designer is able to create multiple groups from the set of types, with each group containing at least one type that exposes logically related functionality. In the exemplary implementation, the API 142 is organized into four root namespaces: a first namespace 200 for Web applications, a second namespace 202 for client applications, a third namespace 204 for data and XML, and a fourth namespace 206 for base class libraries (BCLs). Each group can then be assigned a name. For instance, types in the Web applications namespace 200 are assigned the name Web, and types in the data and XML namespace 204 can be assigned names Data and XML respectively. The named groups can be organized under a single global root namespace for system level APIs, such as an overall System namespace. By selecting and prefixing a top_level identifier, the types in each group can be easily referenced by a hierarchical name that includes the selected top_level identifier prefixed to the name of the group containing the type. For instance, types in the Web applications namespace 200 can be referenced using the hierarchical name System.Web. In this way, the individual namespaces 200, 202, 204, and 206 become major branches off of the System namespace and can carry a designation where the individual namespaces are prefixed with a designator, such as a System. prefix.

[0035] The Web applications namespace 200 pertains to Web based functionality, such as dynamically generated Web pages (e.g., Microsoft's Active Server Pages (ASP). It supplies types that enable browser/server communication. The client applications namespace 202 pertains to drawing and client side UI functionality. It supplies types that enable drawing of two-dimensional (2D), imaging, and printing, as well as the ability to construct window forms, menus, boxes, and so on.

[0036] The data and XML namespace 204 relates to connectivity to data sources and XML functionality. It supplies classes, interfaces, delegates, and enumerations that enable security, specify data types, and serialize objects into XML format documents or streams. The base class libraries (BCL) namespace 206 pertains to basic system and runtime functionality. It contains the fundamental types and base classes that define commonly-used value and reference data types, events and event handlers, interfaces, attributes, and processing exceptions.

[0037] In addition to the framework 132, programming tools 210 are provided to assist the developer in building Web services and/or applications. One example of the programming tools 200 is Visual Studio, a multi-language suite of programming tools offered by Microsoft Corporation.

[0038] Root API Namespaces

[0039] FIG. 3 shows the API 142 and its four root namespaces in more detail. In one embodiment, the namespaces are identified according to a hierarchical naming convention in which strings of names are concatenated with periods. For instance, the Web applications namespace 200 is identified by the root name System.Web. Within the Sytem.Web namespace is another namespace for Web services, identified as System.Web.Services, which further identifies another namespace for a description known as System.Web.Services.Description. With this naming convention in mind, the following provides a general overview of selected namespaces of the API 142, although other naming conventions could be used with equal effect.

[0040] The Web applications namespace 200 (System.Web) defines additional namespaces, including:

[0041] A services namespace 300 (System.Web.Services) containing classes that enable a developer to build and use Web services. The services namespace 300 defines additional namespaces, including a description namespace 302 (System.Web.Services.Description) containing classes that enable a developer to publicly describe a Web service via a service description language (such as WSDL, a specification available from the W3C), a discovery namespace 304 (System.Web.Services.Discovery) containing classes that allow Web service consumers to locate available Web Services on a Web server, and a protocols namespace 306 (System.Web.Services.Protocols) containing classes that define the protocols used to transmit data across a network during communication between Web service clients and the Web service itself.

[0042] A caching namespace 308 (System.Web.Caching) containing classes that enable developers to decrease Web application response time through temporarily caching frequently used resources on the server. This includes ASP.NET pages, web services, and user controls. (ASP.NET is the updated version of Microsoft's ASP technology.) Additionally, a cache dictionary is available for developers to store frequently used resources, such as hash tables and other data structures.

[0043] A configuration namespace 310 (System.Web.Configuration) containing classes that are used to read configuration data in for an application.

[0044] A UI namespace 312 (System.Web.UI) containing types that allow developers to create controls and pages that will appear in Web applications as user interfaces on a Web page. This namespace includes the control class, which provides all web based controls, whether those encapsulating HTML elements, higher level Web controls, or even custom User controls, with a common set of functionality. Also provided are classes which provide the web forms server controls data binding functionality, the ability to save the view state of a given control or page, as well as parsing functionality for both programmable and literal controls. Within the UI namespace 312 are two additional namespaces: an HTML controls namespace 314 (System.Web.UI.HtmlControls) containing classes that permit developers to interact with types that encapsulates html 3.2 elements create HTML controls, and a Web controls namespace 316 (System.Web.UI.WeblControls) Hcontaining classes that allow developers to create higher level Web controls.

[0045] A security namespace 318 (System.Web.Security) containing classes used to implement security in web server applications, such as basic authentication, challenge response authentication, and role based authentication.

[0046] A session state namespace 320 (System.Web.SessionState) containing classes used to access session state values (i.e., data that lives across requests for the lifetime of the session) as well as session-level settings and lifetime management methods.

[0047] The client applications namespace 202 is composed of two namespaces:

[0048] A windows forms namespace 322 (System.Windows.Forms) containing classes for creating Windows-based client applications that take full advantage of the rich user interface features available in the Microsoft Windows operating system, such as the ability to drag and drop-screen elements. Such classes may include wrapped APIs available in the Microsoft Windows operating system that are used in a windowing UI environment. Within this namespace are a design namespace 324 (System.Windows.Forms.Design) that contains classes to extend design-time support for Windows forms and a component model namespace 326 (System.Windows.Forms.ComponentModel) that contains the windows form implementation of the general component model defined in System.ComponentModel. This namespace contains designer tools, such as Visual Studio, which offer a rich experience for developers at design time.

[0049] A drawing namespace 328 (System.Drawing) containing classes for graphics functionality. The drawing namespace 328 includes a 2D drawing namespace 330 (System.Drawing.Drawing2D) that contains classes and enumerations to provide advanced 2-dimmensional and vector graphics functionality, an imaging namespace 332 (System.Drawing.Imaging) that contains classes for advanced imaging functionality, a printing namespace 334 (System.Drawing.Printing) that contains classes to permit developers to customize printing, and a text namespace 336 (System.Drawing.Text) that contains classes for advanced typography functionality.

[0050] The data and XML namespace 204 is composed of two namespaces:

[0051] A data namespace 340 (System.Data) containing classes that enable developers to build components that efficiently manage data from multiple data sources. It implements an architecture that, in a disconnected scenario (such as the Internet), provides tools to request, update, and reconcile data in multiple tier systems. The data namespace 340 includes a common namespace 342 that contains types shared by data providers. A data provider describes a collection of types used to access a data source, such as a database, in the managed space. The data namespace 340 also includes an OLE DB namespace 344 that contains types pertaining to data used in object-oriented databases (e.g., Microsoft's SQL Server), and a SQL client namespace 346 that contains types pertaining to data used by SQL clients. The data namespace also includes a SQL types namespace 348 (System.Data.SqlTypes) that contains classes for native data types within Microsoft's SQL Server. The classes provide a safer, faster alternative to other data types. Using the objects within this namespace helps prevent type conversion errors caused in situations where loss of precision could occur. Because other data types are converted to and from SQL types behind the scenes, explicitly creating and using objects within this namespace results in faster code as well.

[0052] An XML namespace 350 (System.XML) containing classes that provide standards-based support for processing XML. The supported standards include XML (e.g., version 1.0), XML Namespaces (both stream level and DOM), XML Schemas, XPath expressions, XSL/T transformations, DOM Level 2 Core, and SOAP (e.g., version 1.1). The XML namespace 350 includes an XSLT namespace 352 (System.XML.Xsl) that contains classes and enumerations to support XSLT (Extensible Stylesheet Language Transformations), an Xpath namespace 354 (System.XML.Xpath) that contains an XPath parser and evaluation engine, and a serialization namespace 356 (System.XML.Serialization) that contains classes used to serialize objects into XML format documents or streams.

[0053] The base class library namespace 206 (System) includes the following namespaces:

[0054] A collections namespace 360 (System.Collections) containing interfaces and classes that define various collections of objects, such as lists, queues, arrays, hash tables and dictionaries.

[0055] A configuration namespace 362 (System.Configuration) containing classes and interfaces that allow developers to programmatically access configuration settings and handle errors in configuration files.

[0056] A diagnostics namespace 364 (System.Diagnostics) containing classes that are used to debug applications and to trace code execution. The namespace allows developers to start system processes, read and write to event logs, and monitor system performance using performance counters.

[0057] A globalization namespace 366 (System.Globalization) containing classes that define culture-related information, including the language, the country/region, the calendars in use, the format patterns for dates, currency and numbers, and the sort order for strings.

[0058] An I/O namespace 368 (System.IO) containing the infrastructure pieces to operate with the input/output of data streams, files, and directories. This namespace includes a model for working with streams of bytes, higher level readers and writers which consume those bytes, various constructions or implementations of the streams (e.g., FileStream and MemoryStream) and, a set of utility classes for working with files and directories.

[0059] A net namespace 370 (System.Net) providing an extensive set of classes for building network-enabled application, referred to as the Net Class Libraries (NCL). One element to the design of the Net Class Libraries is an extensible, layered approach to exposing networking functionality. The NCL stack contains three basic layers. A base layer (System.Net.Socket) provides access to an interface to TCP/IP, the communications protocol of UNIX networks and the Internet. One example of such an interface is the WinSock API from Microsoft Corporation. The next layer is the Transport Protocol classes, which support such transport protocols as TCP and UDP. Developers may write their own protocol classes to provide support for protocols such as IGMP and ICMP. The third layer is the Web request, which provides an abstract factory pattern for the creation of other protocol classes. The NCL provides implementations for Hyper Text Transport Protocol (HTTTP).

[0060] A reflection namespace (System.Reflection) 372 containing types that provide a managed view of loaded types, methods, and fields, with the ability to dynamically create and invoke types.

[0061] A resources namespace 374 (System.Resources) containing classes and interfaces that allow developers to create, store and manage various culture-specific resources used in an application.

[0062] A security namespace 376 (System.Security) supporting the underlying structure of the security system, including interfaces, attributes, exceptions, and base classes for permissions.

[0063] A service process namespace 378 (System.ServiceProcess) containing classes that allow developers to install and run services. Services are long-running executables that run without a user interface. They can be installed to run under a system account that enables them to be started at computer reboot. Services whose implementation is derived from processing in one class can define specific behavior for start, stop, pause, and continue commands, as well as behavior to take when the system shuts down.

[0064] A text namespace 380 (System.Text) containing classes representing various types of encodings (e.g., ASCII, Unicode, UTF-7, and UTF-8), abstract base classes for converting blocks of characters to and from blocks of bytes, and a helper class that manipulates and formats string objects without creating intermediate instances.

[0065] A threading namespace 382 (System.Threading) containing classes and interfaces that enable multi-threaded programming. The threading namespace includes a ThreadPool class that manages groups of threads, a Timer class that enables a delegate to be called after a specified amount of time, and a Mutex class for synchronizing mutually-exclusive threads. This namespace also provides classes for thread scheduling, wait notification, and deadlock resolution.

[0066] A runtime namespace 384 (System.Runtime) containing multiple namespaces concerning runtime features, including an interoperation services namespace 386 (System.Runtime.InteropServices) that contains a collection of classes useful for accessing COM objects. The types in the InteropServices namespace fall into the following areas of functionality : attributes, exceptions, managed definitions of COM types, wrappers, type converters, and the Marshal class. The runtime namespace 384 further includes a remoting namespace 388 (System.Runtime.Remoting) that contains classes and interfaces allowing developers to create and configure distributed applications. Another namespace within the runtime namespace 384 is a serialization namespace 390 (System.Runtime.Serialization) that contains classes used for serializing and deserializing objects. Serialization is the process of converting an object or a graph of objects into a linear sequence of bytes for either storage or transmission to another location.

[0067] The data namespace (System.Data) contains classes that allow developers to build components to manage data from various data sources. The data namespace provides tools to request, update, and reconcile data in multiple tier systems. As discussed above, the data namespace 340 includes a common namespace 342 (System.Data.Common), an OLE DB namespace 344 (System.Data.OleDb), an SQL client namespace 346 (System.Data.SqlClient), and an SQL Types namespace 348 (System.Data.SqlTypes).

[0068] The data namespace 340 contains various classes, including a constraint class that contains rules to maintain the integrity of data in a data table. A data column class provides the fundamental components for creating the schema of a data table. This schema is built by adding together one or more data column objects. A data column collection class defines the schema of a data table and determines the type of data each data column can contain. A data relation class is used to relate two data table objects to one another through data column objects.

[0069] The data namespace 340 also includes a data row class that provides a primary component of the data table. A data row collection contains the actual data for the data table. A data row change event and a data column change event occur when a change is made to a data row's value or a data column's value, respectively.

[0070] The common namespace 342 contains types shared by multiple data providers. The common namespace 342 also includes various classes, such as a data adapter class that allows for the exchange of data between a data source and a data set. A data column mapping class maps column names from a data source to corresponding column names in a data table. A data table mapping class maps data returned from a query of a data source to a data table.

[0071] The OLE DB namespace 344 includes a command builder class that automatically generates SQL statements for data table updates and a connection class that provides connections to a data source, such as a network server.

[0072] The SQL client namespace 346 also includes a command builder class. Additionally, the SQL client namespace includes a connection class that represents a unique session to an SQL server data source and a data adapter class that exchanges data between a data set and an SQL server for retrieving and saving data.

[0073] The SQL Types namespace contains classes for native data types within Microsoft's SQL Server.

[0074] Using these classes helps prevent type conversion errors caused in situations where loss of precision could occur. Other data types are converted to and from SQL types (behind the scenes), such that explicitly creating and using objects in the data namespace results in faster code. Specific details regarding the System.Data namespace are provided below.

[0075] System.Data

[0076] Description

[0077] The System.Data namespace consists mostly of the classes that constitute the ADO.NET architecture. The ADO.NET architecture enables you to build components that efficiently manage data from multiple data sources. In a disconnected scenario (such as the Internet), ADO.NET provides the tools to request, update, and reconcile data in multiple tier systems. The ADO NET architecture is also implemented in client applications, such as Windows Forms, or HTML pages created by ASP.NET.

[0078] AcceptRejectRule enumeration (System.Data)

[0079] Description

[0080] Determines the action that occurs when the System.Data.DataSet.AcceptChanges or System.Data.DataTable.RejectChanges method is invoked on a System.Data.DataTable with a System.Data.ForeignKeyConstraint.

[0081] Changes to a System.Data.DataTable are not final until you call the System.Data.DataTable.AcceptChanges method. At that time, constraint-related errors can occur because any System.Data.ForeignKeyConstraint objects associated with a System.Data.DataTable are activated to allow deletions and edits to occur freely. Prior to that time, System.Data.ForeignKeyConstraint objects are inactive. When the System.Data.ForeignKeyConstraint becomes activated, and errors occur, System.Data.AcceptRejectRule is called to determine the next course of action.

[0082] C public const AcceptRejectRule Cascade;

[0083] C public: const AcceptRejectRule Cascade;

[0084] VB Public Const Cascade As AcceptRejectRule

[0085] JScript public var Cascade: AcceptRejectRule;

[0086] Description

[0087] Changes are cascaded across the relationship.

[0088] C public const AcceptRejectRule None;

[0089] C public: const AcceptRejectRule None;

[0090] VB Public Const None As AcceptRejectRule

[0091] JScript public var None: AcceptRejectRule;

[0092] Description

[0093] No action occurs.

[0094] Methods:

[0095] Commandehavior enumeration (System.Data)

[0096] ToString

[0097] Description

[0098] Specifies a description of the results and the affect on the database of the query command.

[0099] The System.Data.CommandBehavior values are used by the System.Data.IDbCommand.ExecuteReader method of System.Data.IDbCommand and any classes derived from it.

[0100] ToString

[0101] C public const CommandBehavior CloseConnection;

[0102] C public: const CommandBehavior CloseConnection;

[0103] VB Public Const CloseConnection As CommandBehavior

[0104] JScript public var CloseConnection: CommandBehavior;

[0105] Description

[0106] When the command is executed, the associated Connection object is closed when the associated DataReader object is closed.

[0107] ToString

[0108] C public const CommandBehavior Default;

[0109] C public: const CommandBehavior Default;

[0110] VB Public Const Default As CommandBehavior

[0111] JScript public var Default: CommandBehavior;

[0112] ToString

[0113] C public const CommandBehavior KeyInfo;

[0114] C public: const CommandBehavior KeyInfo;

[0115] VB Public Const KeyInfo As CommandBehavior

[0116] JScript public var KeyInfo: CommandBehavior;

[0117] Description

[0118] The query returns column and primary key information. The query is executed without any locking on the selected rows. When using System.Data.CommandBehavior.KeyInfo, the SQL Server NET Data Provider appends a FOR BROWSE clause to the statement being executed. The user should be aware of potential side effects, such as interference with the use of SET FMTONLY ON statements. See SQL Server Books Online for more information.

[0119] ToString

[0120] C public const CommandBehavior SchemaOnly;

[0121] C public: const CommandBehavior SchemaOnly;

[0122] VB Public Const SchemaOnly As CommandBehavior

[0123] JScript public var SchemaOnly : CommandBehavior;

[0124] Description

[0125] The query returns column information only and does not affect the database state.

[0126] ToString

[0127] C public const CommandBehavior SequentialAccess;

[0128] C public: const CommandBehavior SequentialAccess;

[0129] VB Public Const SequentialAccess As CommandBehavior

[0130] JScript public var SequentialAccess: CommandBehavior;

[0131] Description

[0132] The results of the query are read sequentially to the column level. This allows an application to read large binary values using the GetChars or GetBytes methods of a .NET data provider. Execution of the query may affect the database state.

[0133] ToString

[0134] C public const CommandBehavior SingleResult;

[0135] C public: const CommandBehavior SingleResult;

[0136] VB Public Const SingleResult As CommandBehavior

[0137] JScript public var SingleResult: CommandBehavior;

[0138] Description

[0139] The query returns a single result. Execution of the query may affect the database state.

[0140] ToString

[0141] C public const CommandBehavior SingleRow;

[0142] C public: const CommandBehavior SingleRow;

[0143] VB Public Const SingleRow As CommandBehavior

[0144] JScript public var SingleRow : CommandBehavior;

[0145] Description

[0146] The query is expected to return a single row. Execution of the query may affect the database state. Some NET data providers may, but are not required to, use this information to optimize the performance of the command. When you specify System.Data.CommandBehavior.SingleRow with the System.Data.OleDb.OleDbCommand.ExecuteReader method of the System.Data.OleDb.OleDbCommand object, the OLE DB .NET Data Provider performs binding using the OLE DB IRow interface if it is available. Otherwise, it uses the IRowset interface. If your SQL statement is expected to return only a single row, specifying System.Data.CommandBehavior.SingleRow can also improve application performance.

[0147] CommandType enumeration (System.Data)

[0148] ToString

[0149] Description

[0150] Specifies how a command string is interpreted.

[0151] When the System.Data.lDbCommand.CommandType property is set to StoredProcedure, set the System.Data.IDbCommand.CommandText property to the name of the stored procedure. The command executes this stored procedure when you call System.Data.lDbCommand.ExecuteReader.

[0152] ToString

[0153] C public const CommandType StoredProcedure;

[0154] C public: const CommandType StoredProcedure;

[0155] VB Public Const StoredProcedure As CommandType

[0156] JScript public var StoredProcedure: CommandType;

[0157] Description

[0158] The name of a stored procedure.

[0159] ToString

[0160] C public const CommandType TableDirect;

[0161] C public: const CommandType TableDirect;

[0162] VB Public Const TableDirect As CommandType

[0163] JScript public var TableDirect: CommandType;

[0164] Description

[0165] A table name whose columns are all returned (OLE DB .NET Data Provider only).

[0166] ToString

[0167] C public const CommandType Text;

[0168] C public: const CommandType Text;

[0169] VB Public Const Text As CommandType

[0170] JScript public var Text: CommandType;

[0171] Description

[0172] A SQL text command.

[0173] ConnectionState enumeration (System.Data)

[0174] ToString

[0175] Description

[0176] Returns the current state of the connection to a data source.

[0177] The System.Data.ConnectionState values are used by the System.Data.OleDb.OleDbConnection.State property of the System.Data.OleDb.OleDbConnection and System.Data.SqlClient.SqlConnection objects.

[0178] ToString

[0179] C public const ConnectionState Broken;

[0180] C public: const ConnectionState Broken;

[0181] VB Public Const Broken As ConnectionState

[0182] JScript public var Broken: ConnectionState;

[0183] Description

[0184] The object is broken. This can occur only after the connection has been opened. A connection in this state may be closed and then re-opened.

[0185] ToString

[0186] C public const ConnectionState Closed;

[0187] C public: const ConnectionState Closed;

[0188] VB Public Const Closed As ConnectionState

[0189] JScript public var Closed: ConnectionState;

[0190] Description

[0191] The object is closed.

[0192] ToString

[0193] C public const ConnectionState Connecting;

[0194] C public: const ConnectionState Connecting;

[0195] VB Public Const Connecting As ConnectionState

[0196] JScript public var Connecting: ConnectionState;

[0197] Description

[0198] The object is connecting.

[0199] ToString

[0200] C public const ConnectionState Executing;

[0201] C public: const ConnectionState Executing;

[0202] VB Public Const Executing As ConnectionState

[0203] JScript public var Executing: ConnectionState;

[0204] Description

[0205] The object is executing a command.

[0206] ToString

[0207] C public const ConnectionState Fetching;

[0208] C public: const ConnectionState Fetching;

[0209] VB Public Const Fetching As ConnectionState

[0210] JScript public var Fetching: ConnectionState;

[0211] Description

[0212] Data is being retrieved.

[0213] ToString

[0214] C public const ConnectionState Open;

[0215] C public: const ConnectionState Open;

[0216] VB Public Const Open As ConnectionState

[0217] JScript public var Open: ConnectionState;

[0218] Description

[0219] The object is open.

[0220] Constraint class (System.Data)

[0221] ToString

[0222] Description

[0223] Represents a constraint that can be enforced on one or more System.Data.DataColumn objects.

[0224] A constraint is a rule used to maintain the integrity of the data in the System.Data.DataTable. For example, when you delete a value that is used in one or more related tables, a System.Data.ForeignKeyConstraint determines whether the values in the related tables are also deleted, set to null values, set to default values, or whether no action occurs. A System.Data.UniqueConstraint, on the other hand, simply ensures that all values within a particular table are unique. For more information, see.

[0225] Constructors:

[0226] Constraint

[0227] Example Syntax:

[0228] ToString

[0229] C protected Constraint( );

[0230] C protected: Constraint( );

[0231] VB Protected Sub New( )

[0232] JScript protected function Constraint( );

[0233] Properties:

[0234] _DataSet

[0235] ToString

[0236] C protected internal virtual DataSet_DataSet get;

[0237] C internal: _roperty virtual DataSet_get_DataSet( );

[0238] VB Overridable Protected Friend ReadOnly Property_PataSet As DataSet

[0239] JScript package function get _DataSet( ) : DataSet;

[0240] Description

[0241] Gets the System.Data.DataSet to which this constraint belongs.

[0242] ConstraintName

[0243] ToString

[0244] C public virtual string ConstraintName get; set;

[0245] C public: _property virtual String* get_ConstraintName( );public: _property virtual void set_ConstraintName(String*);

[0246] VB Overridable Public Property ConstraintName As String

[0247] JScript public function get ConstraintNameo: String; public function set ConstraintName(String);

[0248] Description

[0249] The name of a constraint in the System.Data.ConstraintCollection

[0250] The System.Data.ConstraintCollection is returned by the System.Data.DataTable.Constraints property of the System.Data.DataTable class.

[0251] ExtendedProperties

[0252] ToString

[0253] C public PropertyCollection ExtendedProperties get;

[0254] C public: _property PropertyCollection* get_ExtendedProperties( );

[0255] VB Public ReadOnly Property ExtendedProperties As PropertyCollection

[0256] JScript public function get ExtendedProperties( ) : PropertyCollection;

[0257] Description

[0258] Gets the collection of customized user information.

[0259] Use the System.Data.DataTable.ExtendedProperties to add custom information to a System.Data.DataTable. Add information with the Add method. Retrieve information with the Item method.

[0260] Table

[0261] ToString

[0262] C public abstract DataTable Table get;

[0263] C public: _property virtual DataTable0;

[0264] VB MustOverride Public ReadOnly Property Table As DataTable

[0265] JScript public abstract function get Table( ) : DataTable;

[0266] Description

[0267] Gets the System.Data.DataTable to which the constraint applies. CheckStateForProperty

[0268] C protected void CheckStateForProperty( );

[0269] C protected: void CheckStateForProperty( );

[0270] VB Protected Sub CheckStateForProperty( )

[0271] JScript protected function CheckStateForProperty( );

[0272] Description

[0273] SetDataSet

[0274] C protected internal void SetDataSet(DataSet dataSet);

[0275] C protected public: void SetDataSet(DataSet* dataSet);

[0276] VB Protected Friend Dim Sub SetDataSet(ByVal dataSet As DataSet)

[0277] JScript package function SetDataSet(dataSet: DataSet);

[0278] Description

[0279] Sets the constraint's System.Data.DataSet. The System.Data.DataSet to which this constraint will belong.

[0280] ToString

[0281] C public override string ToString( );

[0282] C public: String* ToString( );

[0283] VB Overrides Public Function ToString( ) As String

[0284] JScript public override function ToString( ) : String;

[0285] Description

[0286] Gets the System.Data.Constraint.ConstraintName, if there its one, as a string.

[0287] Return Value: The string value of the System.Data.Constraint.ConstraintName

[0288] ConstraintCollection class (System.Data)

[0289] ToString

[0290] Description

[0291] Represents a collection of constraints for a System.Data.DataTable.

[0292] The System.Data.ConstraintCollection is accessed through the System.Data.DataTable.Constraints property.

[0293] Count

[0294] IsReadOnly

[0295] IsSynchronized

[0296] Item

[0297] ToString

[0298] Description

[0299] Gets the System.Data.Constraint from the collection with the specified name.

[0300] The System.Data.ConstraintCollection.Contains(System.Stiring) method can be used to test for the existence of a specific constraint. The System.Data.Constraint.ConstraintName of the constraint to return.

[0301] Item

[0302] ToString

[0303] C public virtual Constraint thisint index get;

[0304] C public: property virtual Constraint* get_Item(int index);

[0305] VB Overridable Public Default ReadOnly Property Item(ByVal index As Integer) As Constraint

[0306] JScript returnValueConstraintCollectionObject.Item(index); Gets the specified System.Data.Constraint

[0307] Description

[0308] Gets the System.Data.Constraint from the collection at the specified index.

[0309] The System.Data.ConstraintCollection.Contains(System.String) method can be used to test for the existence of a specific constraint. The index of the constraint to return. a List

[0310] ToString

[0311] C protected override ArrayList List get;

[0312] C protected: property virtual ArrayList* get List( );

[0313] VB Overrides Protected ReadOnly Property List As ArrayList

[0314] JScript protected function get List( ) : ArrayList;

[0315] Description

[0316] Gets the list of objects contained by the collection.

[0317] SyncRoot

[0318] ToString

[0319] Description

[0320] Occurs when the System.Data.ConstraintCollection is changed through additions or removals.

[0321] For more information about handling events, see.

[0322] Add

[0323] C public void Add(Constraint constraint);

[0324] C public: void Add(Constraint* constraint);

[0325] VB Public Sub Add(ByVal constraint As Constraint)

[0326] JScript public function Add(constraint: Constraint); Adds a constraint to the System.Data.ConstraintCollection.

[0327] Description

[0328] Adds the specified constraint to the collection.

[0329] If the collection is successfully changed by adding or removing constraints, the System.Data.ConstraintCollection.CollectionChanged event occurs. The System.Data.Constraint to add.

[0330] Add

[0331] C public virtual Constraint Add(string name, DataColumn column, bool primaryKey);

[0332] C public: virtual Constraint* Add(String* name, DataColumn* column, bool primaryKey);

[0333] VB Overridable Public Function Add(ByVal name As String, ByVal column As DataColumn, ByVal primaryKey As Boolean) As Constraint

[0334] JScript public function Add(name : String, column : DataColumn, primaryKey: Boolean) : Constraint;

[0335] Description

[0336] Constructs a new System.Data.UniqueConstraint, using the specified System.Data.DataColumn, and adds it to the collection.

[0337] The System.Data.ConstraintCollection.CollectionChanged event occurs if the constraint is added successfully. The name of the System.Data.UniqueConstraint. The System.Data.DataColumn affected by the constraint. Indicates whether the column is a primary key column.

[0338] Add

[0339] C public virtual Constraint Add(string name, DataColumn primaryKeyColumn, DataColumn foreignKeyColumn);

[0340] C public: virtual Constraint* Add(String* name, DataColumn* primaryKeyColumn, DataColumn* foreignKeyColumn);

[0341] VB Overridable Public Function Add(ByVal name As String, ByVal primaryKeyColumn As DataColumn, ByVal foreignKeyColumn As DataColumn) As Constraint

[0342] JScript public function Add(name : String, primaryKeyColumn : DataColumn, foreignKeyColumn : DataColumn) : Constraint;

[0343] Description

[0344] Constructs a new System.Data.ForeignKeyConstraint, with the specified parent and child columns, and adds the constraint to the collection.

[0345] A System.Data.ForeignKeyConstraint and System.Data.UniqueConstraint are both created and added automatically when a System.Data.DataRelation is added to a System.Data.DataSet object's System.Data.DataRelationCollection. The System.Data.ForeignKeyConstraint (which gets the same name as the System.Data.DataRelation ) is added to the child table's System.Data.ConstraintCollection, and the System.Data.UniqueConstraint is added to the parent table's System.Data.ConstraintCollection. The name of the System.Data.UniqueConstraint. The primary key System.Data.DataColumn. The foreign key System.Data.DataColumn.

[0346] Add

[0347] C public virtual Constraint Add(string name, DataColumn columns, bool primaryKey);

[0348] C public: virtual Constraint* Add(String* name, DataColumn* columns , bool primaryKey);

[0349] VB Overridable Public Function Add(ByVal name As String, ByVal columns( ) As DataColumn, ByVal primaryKey As Boolean) As Constraint

[0350] JScript public function Add(name : String, columns : DataColumn , primaryKey : Boolean) : Constraint;

[0351] Description

[0352] Constructs a new System.Data.UniqueConstraint using the specified array of System.Data.DataColumn objects, and adds it to the collection.

[0353] The System.Data.ConstraintCollection.CollectionChanged event occurs if the constraint is added succesfully. The name of the System.Data.UniqueConstraint. An array of System.Data.DataColumn objects that are affected by the constraint. Indicates whether the columns are primary key columns.

[0354] Add

[0355] C public virtual Constraint Add(string name, DataColumn primaryKeyColumns, DataColumn foreignKeyColumns);

[0356] C public: virtual Constraint* Add(String* name, DataColumn* primaryKeyColumns , DataColumn* foreignKeyColumns );

[0357] VB Overridable Public Function Add(ByVal name As String, ByVal primaryKeyColumns( ) As DataColumn, ByVal foreignKeyColumns( ) As DataColumn) As Constraint

[0358] JScript public function Add(name : String, primaryKeyColumns : DataColumn , foreignKeyColumns : DataColumn ) : Constraint;

[0359] Description

[0360] Constructs a new System.Data.ForeignKeyConstraint, with the specified parent columns and child columns, and adds the constraint to the collection.

[0361] A System.Data.ForeignKeyConstraint and a System.Data.UniqueConstraint are created automatically when you add a System.Data.DataRelation to a System.Data.DataSet. In that case, adding a second System.Data.ForeignKeyConstraint on the same columns will result in an exception. To avoid this, use the System.Data.ForeignKeyConstraint constructor to create the System.Data.ForeignKeyConstraint and test it against existing collection members with the System.Data.ForeignKeyConstraint.Equals(System.Object) method. The name of the System.Data.UniqueConstraint. An array of System.Data.DataColumn objects that are the primary key columns. An array of System.Data.DataColumn objects that are the foreign key columns.

[0362] AddRange

[0363] C< public void AddRange(Constraint constraints);

[0364] C public: void AddRange(Constrainlt* constraints );

[0365] VB Public Sub AddRange(ByVal constraints( ) As Constraint)

[0366] JScript public function AddRange(constraints: Constraint );

[0367] Description

[0368] Copies the elements of the specified System.Data.ConstraintlCollection array to the end of the collection. An array of System.Data.ConstraintCollection objects to add to the collection.

[0369] CanRemove

[0370] C public bool CanRemove(Constraint constraint);

[0371] C public: bool CanRemove(Constraint* constraint);

[0372] VB Public Function CanRemove(ByVal constraint As Constraint) As Boolean

[0373] JScript public function CanRemove(constraint: Constraint) : Boolean;

[0374] Description

[0375] Indicates if a System.Data.Constraint can be removed.

[0376] Return Value: Generates an exception if the System.Data.Constraint can't be removed from collection. Otherwise, true if the System.Data.Constraint can be removed.

[0377] When a System.Data.DataRelation is added to a System.Data.DataSet, a System.Data.ForeignKeyConstraint and System.Data.UniqueConstraint are added automatically to the parent table and the child table. The System.Data.UniqueConstraint is applied to the parent table's primary key column, and the System.Data.ForeignKeyConstraint is applied to the child table's foreign key column. In that case, attempting to remove the System.Data.UniqueConstraint will cause an exception to be thrown because the System.Data.ForeignKeyConstraint must be removed first. To avoid this, use the System.Data.ConstraintCollection.CanRemove(System.Data.Constraint) to determine if a System.Data.UniqueConstraint can be removed. The System.Data.Constraint to be tested for removal from the collection.

[0378] Clear

[0379] C public void Clear( );

[0380] C public: void Clear( );

[0381] VB Public Sub Clear( )

[0382] JScript public function Clear( );

[0383] Description

[0384] Clears the collection of any System.Data.Constraint objects.

[0385] The System.Data.ConstraintCollection.CollectionChanged occurs if this action is succesful.

[0386] Contains

[0387] C public bool Contains(string name);

[0388] C public: bool Contains(String* name);

[0389] VB Public Function Contains(ByVal name As String) As Boolean

[0390] JScript public function Contains(name : String) : Boolean;

[0391] Description

[0392] Indicates whether the System.Data.Constraint, specified by name, exists in the collection.

[0393] Return Value: true if the collection contains the specified constraint; otherwise, false.

[0394] Use the System.Data.ConstraintCollection.Contains(System.String) method to determine if the specified System.Data.Constraint exists before attempting to remove it from the collection. You can also use the System.Data.ConstraintCollection.CanRemove(System.Data.Constraint) method to determine if a System.Data.Constraint can be removed. The System.Data.Constraint.ConstraintName of the constraint. Indexf

[0395] C public int IndexOf(Constraint constraint);

[0396] C public: int IndexOf(Constraint* constraint);

[0397] VB Public Function IndexOf(ByVal constraint As Constraint) As Integer

[0398] JScript public function IndexOf(constraint: Constraint) : int;

[0399] Description

[0400] Gets the index of the specified System.Data.Constraint.

[0401] Return Value: The index of the System.Data.Constraint if it is in the collection; otherwise, 1.

[0402] Use the System.Data.ConstraintCollection.IndexOf(System.Data.Constraint) method to return an index to be used with either the System.Data.ConstraintCollection.Contains(System.String) or System.Data.ConstraintCollection.Remove(System.Data.Constraint) method. The System.Data.Constraint to search for.

[0403] IndexOf

[0404] C public virtual int IndexOf(string constraintName);

[0405] C public: virtual int IndexOf(String* constraintName);

[0406] VB Overridable Public Function IndexOf(ByVal constraintName As String) As Integer

[0407] JScript public function IndexOf(constraintName : String) : int; Gets the index of the specified System.Data.Constraint.

[0408] Description

[0409] Gets the index of the System.Data.Constraint, specified by name.

[0410] Return Value: The index of the System.Data.Constraint if it is in the collection; otherwise, 1.

[0411] Use the System.Data.ConstraintCollection.IndexOf(System.Data.Constraint) method to return an index to be used with either the System.Data.ConstraintCollection.Contains(System.String) or System.Data.ConstraintCollection.Remove(System.Data.Constraint) method. The name of the System.Data.Constraint.

[0412] OnCollectionChanged

[0413] C protected virtual void OnCollectionChanged(CollectionChangeEventArgs ccevent);

[0414] C protected: virtual void OnCollectionChanged(CollectionChangeEventArgs* ccevent);

[0415] VB Overridable Protected Sub OnCollectionChanged(ByVal ccevent As CollectionChangeEventArgs)

[0416] JScript protected function OnCollectionChanged(ccevent: CollectionChangeEventArgs);

[0417] Description

[0418] Raises the System.Data.ConstraintCollection.CollectionChanged event.

[0419] Raising an event invokes the event handler through a delegate. For more information, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[0420] Remove

[0421] C public void Remove(Constraint constraint);

[0422] C public: void Remove(Constraint* constraint);

[0423] VB Public Sub Remove(ByVal constraint As Constraint)

[0424] JScript public function Remove(constraint: Constraint); Removes a System.Data.Constraint from the System.Data.ConstraintCollection.

[0425] Description

[0426] Removes the specified System.Data.Constraint from the collection.

[0427] Use the System.Data.ConstraintCollection.Contains(System.String) method to determine if the collection contains the target System.Data.Constraint. The System.Data.Constraint to remove.

[0428] Remove

[0429] C public void Remove(string name);

[0430] C public: void Remove(String* name);

[0431] VB Public Sub Remove(ByVal name As String)

[0432] JScript public function Remove(name : String);

[0433] Description

[0434] Removes the constraint, specified by name, from the collection. Use the System.Data.ConstraintCollection.Contains(System.String) method to determine if the collection contains the target System.Data.Constraint. The name of the System.Data.Constraint to remove.

[0435] RemoveAt

[0436] C public void RemoveAt(int index);

[0437] C public: void RemoveAt(int index);

[0438] VB Public Sub RemoveAt(ByVal index As Integer)

[0439] JScript public function RemoveAt(index : int);

[0440] Description

[0441] Removes the constraint at the specified index from the collection.

[0442] The System.Data.ConstraintCollection.IndexOf(System.Data.Constraint) method returns the index of a given System.Data.Constraint. The index of the System.Data.Constraint to remove.

[0443] ConstraintException class (System.Data)

[0444] ToString

[0445] Description

[0446] Represents the exception that is thrown when attempting an action that violates a constraint.

[0447] ConstraintException

[0448] Example Syntax:

[0449] ToString

[0450] C public ConstraintException( );

[0451] C public: ConstraintException( );

[0452] VB Public Sub New( )

[0453] JScript public function ConstraintException( ); Initializes a new instance of the System.Data.ConstraintException class.

[0454] Description

[0455] Initializes a new instance of the System.Data.ConstraintException class.

[0456] ConstraintException

[0457] Example Syntax:

[0458] ToString

[0459] C public ConstraintException(string s);

[0460] C public: ConstraintException(String* s);

[0461] VB Public Sub New(ByVal s As String)

[0462] JScript public function ConstraintException(s : String);

[0463] Description

[0464] Initializes a new instance of the System.Data.ConstraintException class with the specified string. The string to display when the exception is thrown. ConstraintException

[0465] Example Syntax:

[0466] ToString

[0467] CH public ConstraintException(SerializationInfo info, StreamingContext context);

[0468] C public: ConstraintException(SerializationInfo* info, StreamingContext context);

[0469] VB Public Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)

[0470] JScript public function ConstraintException(info : SerializationInfo, context: StreamingContext); Initializes a new instance of the System.Data.ConstraintException class.

[0471] Description

[0472] Initializes a new instance of the System.Data.ConstraintException class. The data necessary to serialize or deserialize an object. Description of the source and destination of the specified serialized stream.

[0473] HelpLink

[0474] HResult

[0475] InnerException Message

[0476] Source

[0477] StackTrace

[0478] TargetSite

[0479] DataColumn class (System.Data)

[0480] ToString

[0481] Description

[0482] Represents the schema of a column in a System.Data.DataTable.

[0483] The System.Data.DataColumn is the fundamental building block for creating the schema of a System.Data.DataTable. You build the schema by adding one or more System.Data.DataColumn objects to the System.Data.DataColumnCollection. For more information, see.

[0484] DataColumn

[0485] Example Syntax:

[0486] ToString

[0487] C public DataColumn( );

[0488] C public: DataColumn( );

[0489] VB Public Sub New( )

[0490] JScript public function DataColumn( ); Initializes a new instance of the System.Data.DataColumn class.

[0491] Description

[0492] Initializes a new instance of a System.Data.DataColumn class.

[0493] When created, a new System.Data.DataColumn object has no default System.Data.DataColumn.ColumnName or System.Data.DataColumn.Caption. When added to a System.Data.DataColumnCollection, however, a default name (Column1, Column2, etc.) is given to the column.

[0494] DataColumn

[0495] Example Syntax:

[0496] ToString

[0497] C public DataColumn(string columnName);

[0498] C public: DataColumn(String* columnName);

[0499] VB Public Sub New(ByVal columnName As String)

[0500] JScript public function DataColumn(columnName : String);

[0501] Description

[0502] Inititalizes a new instance of the System.Data.DataColumn class using the specified column name.

[0503] By default, the name given to a column becomes the System.Data.DataColumn.Caption property value. A string that represents the name of the column to be created. If set to null or an empty string ( ), a default name will be given when added to the columns collection.

[0504] DataColumn

[0505] Example Syntax:

[0506] ToString

[0507] C public DataColumn(string columnName, Type dataType);

[0508] C public: DataColumn(String* columnName, Type* dataType);

[0509] VB Public Sub New(ByVal columnName As String, ByVal dataType As Type)

[0510] JScript public function DataColumn(columnName : String, dataType: Type);

[0511] Description

[0512] Inititalizes a new instance of the System.Data.DataColumn class using the specified column name and data type. A string that represents the name of the column to be created. If set to null or an empty string ( ), a default name will be given when added to the columns collection. A supported System.Data.DataColumn.DataType.

[0513] DataColumn

[0514] Example Syntax:

[0515] ToString

[0516] C public DataColumn(string columnName, Type dataType, string cxpr);

[0517] C public: DataColumn(String* columnName, Type* dataType, String* expr);

[0518] VB Public Sub New(ByVal columnName As String, ByVal dataType As Type, ByVal expr As String)

[0519] JScript public function DataColumn(columnName : String, dataTypei: Type, expr: String);

[0520] Description

[0521] Initializes a new instance of the System.Data.DataColumn class using the specified name, data type, and expression. A string that represents the name of the column to be created. If set to null or an empty string ( ), a default name will be given when added to the columns collection. A supported System.Data.DataColumn.DataType. The expression used to create this column. For more details, see the System.Data.DataColumn.Expression property.

[0522] DataColumn

[0523] Example Syntax:

[0524] ToString

[0525] C public DataColumn(string columnName, Type dataType, string expr, MappingType type);

[0526] C public: DataColumn(String* columnName, Type* dataType, String* expr, MappingType type);

[0527] VB Public Sub New(ByVal columnName As String, ByVal dataType As Type, ByVal expr As String, ByVal type As MappingType)

[0528] JScript public function DataColumn(columnName : String, dataType : Type, expr: String, type: MappingType);

[0529] Description

[0530] Initializes a new instance of the System.Data.DataColumn class using the specified name, data type, expression, and value that determines whether the column is an attribute.

[0531] The type argument sets the System.Data.DataColumn.ColumnMapping property. The property specifies how a System.Data.DataColumn is mapped when a System.Data.DataSet is transformed into an XML document. For example, if the the column is named fName, and the value it contains is Bob, and type is set to MappingType.Attribute, the XML element would be: For more details on how columns are mapped to elements or attributes, see the System.Data.DataColumn.ColumnMapping property. A string that represents the name of the column to be created. If set to null or an empty string ( ), a default name will be given when added to the columns collection. A supported System.Data.DataColumn.DataType. The expression used to create this column. For more details, see the System.Data.DataColumn.Expression property. One of the System.Data.MappingType values.

[0532] AllowDBNull

[0533] ToString

[0534] C public bool AllowDBNull get; set;

[0535] C public: _property bool get_AllowDBNull( );public:_property void set_AllowDBNull(bool);

[0536] VB Public Property AllowDBNull As Boolean

[0537] JScript public function get AllowDBNull( ) : Boolean; public function set AllowDBNull(Boolean);

[0538] Description

[0539] Gets or sets a value indicating whether null values are allowed in this column for rows belonging to the table.

[0540] AutoIncrement

[0541] ToString

[0542] C public bool AutoIncrement get; set;

[0543] C public: Property bool get_AutoIncrement( );public: _property void set_AutoIncrement(bool);

[0544] VB Public Property AutoIncrement As Boolean

[0545] JScript public function get AutoIncrement( ) : Boolean; public function set AutoIncrement(Boolean);

[0546] Description

[0547] Gets or sets a value indicating whether the column automatically increments the value of the column for new rows added to the table.

[0548] If the type of this column is not Int16, Int32, or Int64 when this property is set, the System.Data.DataColumn.DataType property is coerced to Int32. An exception is generated if this is a computed column (that is, the System.Data.DataColumn.Expression property is set.) The incremented value is used only if the row's value for this column, when added to the columns collection, is equal to the default value.

[0549] AutoIncrementSeed

[0550] ToString

[0551] C public long AutoIncrementSeed get; set;

[0552] C public: _property int64 get_AutoIncrementSeed( );public: _property void set_AutoIncrementSeed(_int64);

[0553] VB Public Property AutoIncrementSeed As Long

[0554] JScript public function get AutoIncrementSeed( ) : long; public function set AutoIncrementSeed(long);

[0555] Description

[0556] Gets or sets the starting value for a column that has its System.Data.DataColumn.AutoIncrement property set to true.

[0557] AutoIncrementStep

[0558] ToString

[0559] C public long AutoIncrementStep get; set;

[0560] C public: property _int64 get_AutoIncrementStep( );public: _property void set_AutoIncrementStep_int64);

[0561] VB Public Property AutoIncrementStep As Long

[0562] JScript public function get AutoIncrementStep( ) : long; public function set AutoIncrementStep(long);

[0563] Description

[0564] Gets or sets the increment used by a column with its System.Data.DataColumn.AutoIncrement property set to true.

[0565] Caption

[0566] ToString

[0567] C public string Caption get; set;

[0568] C public: property String* get_Caption( );public: _property void set_Caption(String*);

[0569] VB Public Property Caption As String

[0570] JScript public function get Caption( ) : String; public function set Caption(String);

[0571] Description

[0572] Gets or sets the caption for the column.

[0573] The System.Data.DataColumn.Caption value becomes visible in controls that support its display. For example, the System.Windows.Forms.Dat-aGrid control is capable of displaying captions for each column.

[0574] ColumnMapping

[0575] ToString

[0576] C public virtual MappingType ColumnMapping get; set;

[0577] C public: _property virtual MappingType get ColumnMapping( );public: _property virtual void set_ColumnMapping(MappingType);

[0578] VB Overridable Public Property ColumnMapping As MappingType

[0579] JScript public function get ColumnMapping( ) : MappingType; public function set ColumnMapping(MappingType);

[0580] Description

[0581] Gets or sets the System.Data.MappingType of the column.

[0582] The System.Data.DataColumn.ColumnMapping property determines how a System.Data.DataColumn is mapped when a System.Data.DataSet is saved as an XML document using the System.Data.DataSet.WriteXml(System.IO.Stream) method.

[0583] ColumnName

[0584] ToString

[0585] C public string ColumnName get; set;

[0586] C public: _property String* get ColumnName( );public: _property void set_ColumnName(String*);

[0587] VB Public Property ColumnName As String

[0588] JScript public function get ColumnName( ) : String; public function set ColumnName(String);

[0589] Description

[0590] Gets or sets the name of the column in the System.Data.DataColumnCollection.

[0591] When a System.Data.DataColumn is created, it has no System.Data.DataColumn.ColumnName value. When the System.Data.DataColumn is added to a System.Data.DataTable object's System.Data.DataColumnCollection, however, it is given a default name (Column1, Column2, etc.).

[0592] Container

[0593] DataType

[0594] ToString

[0595] Description

[0596] Gets or sets the type of data stored in the column.

[0597] Setting the System.Data.DataColumn.DataType value is critical to ensuring the correct creation and updating of data in a DBMS.

[0598] DefaultValue

[0599] ToString

[0600] C public object DefaultValue get; set;

[0601] C public: _property Object* get_DefaultValue( );public: _property void set_DefaultValue(Object*);

[0602] VB Public Property DefaultValue As Object

[0603] JScript public function get DefaultValue( ) : Object; public function set DefaultValue(Object);

[0604] Description

[0605] Gets or sets the default value for the column when creating new rows. A default value is the value that is automatically assigned to the column when a System.Data.DataRow is created. By setting a default value, you can give the user an idea of what information to input. On the other hand, you can use the System.Data.DataColumn.DefaultValue property to automatically insert a value that shouldn't be touched by the user; for example, the current date and time of the row's creation.

[0606] DesignMode

[0607] Events

[0608] Expression

[0609] ToString

[0610] Description

[0611] Gets or sets the expresssion used to filter rows, calculate the values in a column, or create an aggregate column.

[0612] One use of the System.Data.DataColumn.Expression property is to create calculated columns. For example, to calculate a tax value, the unit price is multiplied by a tax rate of a given region. Since tax rates vary from region to region, it would be impossible to put a single tax rate in a column; instead, the value is calculated using the System.Data.DataColumn.Expression property, as shown in the Visual Basic code below: DataSet1.Tables(Products).Columns(tax).ExpressionUnitPrice*0.086 A second use is to create an aggregate column. Similar to a calculated value, an aggregate performs an operation based on the entire set of rows in the System.Data.DataTable. A simple example is to count the number of rows returned in the set, which is the method you would use to count the number of transactions completed by a particular salesperson, as shown in this Visual Basic code: DataSet1.Tables(Orders).Columns(OrderCount).ExpressionCount(OrderID) EXPRESSION SYNTAX When creating an expression, use the System.Data.DataColumn.ColumnName property to refer to columns. For example, if the System.Data.DataColumn.ColumnName for one column is UnitPrice, and another Quantity, the expression would be: UnitPlice * Quantity When creating an expression for a filter, enclose strings with single quotes: LastNameJones The following characters are special characters and must be escaped, as explained below, if they are to be used in a column name : n (newline)t (tab)r (carriage return)( ) / > < * % & {circumflex over ()} If a column name contains one of the above characters, the name must be wrapped in brackets. For example to use a column named Column in an expression, you would write Column: Total*Column Because brackets are special characters, you must use a slash () to escape the bracket, if it is part of a column name. For example, a column named Column would be written: Total * Column (Only the second bracket must be escaped.) USER-DEFINED VALUES User-defined values may be used within expressions to be compared against column values. String values should be enclosed within single quotes. Date values should be enclosed within pound signs (). Decimals and scientific notation are permissible for numeric values. For example: FirstNameJohn Price <50.00 Birthdate <1/31/82 For columns that contain enumeration values, cast the value to an integer data type. For example: EnumColumn5 OPERATORS Concatenation is allowed using Boolean AND, OR, and NOT operators. You can use parentheses to group clauses and force precedence. The AND operator has precedence over other operators. For example: (LastNameSmith OR LastNameJones) AND FirstNameJohn When creating comparison expressions, the following operators are allowed: < ><>< >IN LIKE The following arithmetic operators are also supported in expressions: (addition) (subtraction) * (multiplication) / (division) % (modulus) STRING OPERATORS To concatenate a string, use the character. Whether string comparisons are casesensitive or not is determined by the value of the System.Data.DataSet class's System.Data.DataSet.CaseSensitive property. However, you can override that value with the System.Data.DataTable class's System.Data.DataTable.CaseSensitive property.

[0613] ExtendedProperties

[0614] ToString

[0615] C public PropertyCollection ExtendedProperties get;

[0616] C public: _property PropertyCollection* get_ExtendedProperties( );

[0617] VB Public ReadOnly Property ExtendedProperties As PropertyCollcction

[0618] JScript public function get ExtendedProperties( ) : PropertyCollection;

[0619] Description

[0620] Gets the collection of custom user information.

[0621] The System.Data.DataColumn.ExtendedProperties property allows you to store custom information with the object. For example, you may store a time when the data should be refreshed.

[0622] MaxLength

[0623] ToString

[0624] C public int MaxLength get; set;

[0625] C public: property int get_MaxLength( );public: _property void set_MaxLength(int);

[0626] VB Public Property MaxLength As Integer

[0627] JScript public function get MaxLength( ) : int; public function set MaxLength(int);

[0628] Description

[0629] Gets or sets the maximum length of a text column.

[0630] The System.Data.DataColumn.MaxLength property is ignored for nontext columns. Namespace

[0631] ToString

[0632] C public string Namespace get; set;

[0633] C public: _property String* get Namespace( );public: property void set_Namespace(String*);

[0634] VB Public Property Namespace As String

[0635] JScript public function get Namespace( ) : String; public function set Namespace(String);

[0636] Description

[0637] Gets or sets the namespace of the System.Data.DataColumn.

[0638] The System.Data.DataColumn.Namespace property is used when reading and writing an XML document into a System.Data.DataTable in the System.Data.DataSet using the System.Data.DataSet.ReadXml(System.Xml.XmlReader), System.Data.DataSet.WriteXml(System.IO.Stream), System.Data.DataSet.ReadXmlSchema(System.Xml.XmlReader), or System.Data.DataSet.WriteXmlSchema(System.IO.Stream) methods.

[0639] Ordinal

[0640] ToString

[0641] C public int Ordinal get;

[0642] C public: property int get Ordinal( );

[0643] VB Public ReadOnly Property Ordinal As Integer

[0644] JScript public function get Ordinal( ) : int;

[0645] Description

[0646] Gets the position of the column in the System.Data.DataColumnCollection collection.

[0647] Prefix

[0648] ToString

[0649] C public string Prefix get; set;

[0650] C public: _property String* get_Prefix( );public: _property void set_Prefix(String*);

[0651] VB Public Property Prefix As String

[0652] JScript public function get Prefix( ) : String; public function set Prefix(String);

[0653] Description

[0654] Gets or sets an XML prefix that aliases the namespace of the System.Data.DataTable.

[0655] The System.Data.DataTable.Prefix is used throughout an XML document to identify elements which belong to the System.Data.DataSet object's namespace (as set by the System.Data.DataSet.Namespace property).

[0656] ReadOnly

[0657] ToString

[0658] C public bool ReadOnly get; set;

[0659] C public: property bool get ReadOnly( );public: _Troperty void set_ReadOnly(bool);

[0660] VB Public Property ReadOnly As Boolean

[0661] JScript public function get ReadOnly( ) : Boolean; public function set ReadOnly(Boolean);

[0662] Description

[0663] Gets or sets a value indicating whether the column allows changes once a row has been added to the table.

[0664] Site

[0665] Table

[0666] ToString

[0667] Description

[0668] Gets the System.Data.DataTable to which the column belongs to.

[0669] Unique

[0670] ToString

[0671] C public bool Unique get; set;

[0672] C public: property bool get_Unique( );public: _property void set_Unique(bool);

[0673] VB Public Property Unique As Boolean

[0674] JScript public function get Unique( ) : Boolean; public function set Unique(Boolean);

[0675] Description

[0676] Gets or sets a value indicating whether the values in each row of the column must be unique.

[0677] You can also add a System.Data.UniqueConstraint to the System.Data.DataTable to which this column belongs to ensure the values are unique.

[0678] CheckNotAllowNull

[0679] C protected internal void CheckNotAllowNull( );

[0680] C protected public: void CheckNotAllowNull( );

[0681] VB Protected Friend Dim Sub CheckNotAllowNull( )

[0682] JScript package function CheckNotAllowNull( );

[0683] Description

[0684] CheckUnique

[0685] C protected void CheckUnique( );

[0686] C protected: void CheckUnique( );

[0687] VB Protected Sub CheckUnique( )

[0688] JScript protected function CheckUnique( );

[0689] Description

[0690] Throws an exception and the name of any column if its Unique property set to True and non-unique values are found in the column.

[0691] OnPropertyChanging

[0692] C protected internal virtual void

[0693] OnPropertyChanging(PropertyChangedEventArgs pcevent);

[0694] C protected public: virtual void OnPropertyChanging(PropertyChangedEventArgs* pcevent);

[0695] VB Overridable Protected Friend Dim Sub OnPropertyChanging(ByVal pcevent As PropertyChangedEventArgs)

[0696] JScript package function OnPropertyChanging(pcevent: PropertyChangedEventArgs);

[0697] Description

[0698] Raises the System.Data.DataColumn.OnPropertyChanging(System.ComponentModel.P ropertyChangedEventArgs) event.

[0699] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.PropertyChangedEveiutArgs that contains the event data.

[0700] RaisePropertyChanging

[0701] C protected internal void RaisePropertyChanging(string name);

[0702] C protected public: void RaisePropertyChanging(String* name);

[0703] VB Protected Friend Dim Sub RaisePropertyChanging(ByVal name As String)

[0704] JScript package function RaisePropertyChanging(name : String);

[0705] Description Sends notification that the specified System.Data.DataColumn property is about to change. The name of the property that is about to change.

[0706] ToString

[0707] C public override string ToString( );

[0708] C public: String* ToString( );

[0709] VB Overrides Public Function ToString( ) As String

[0710] JScript public override function ToString( ) : String;

[0711] Description

[0712] Gets the System.Data.DataColumn.Expression of the column, if one exists.

[0713] Return Value: The System.Data.DataColumn.Expression value, if the property is set; otherwise, the System.Data.DataColumn.ColumnName property.

[0714] DataColumnChangeEventArgs class (System.Data)

[0715] ToString

[0716] Description

[0717] Provides data for the System.Data.DataTable.ColumnChanging event.

[0718] The System.Data.DataTable.ColumnChanging event occurs when a change is made to a column's value in the System.Data.DataTable.

[0719] DataColumnChangeEventArgs

[0720] Example Syntax:

[0721] ToString

[0722] CH public DataColumnChangeEventArgs(DataRow row, DataColumn column, object value);

[0723] C public: DataColumnChangeEventArgs(DataRow* row, DataColumn* column, Object* value);

[0724] VB Public Sub New(ByVal row As DataRow, ByVal column As DataColumn, ByVal value As Object)

[0725] JScript public function DataColumnChangeEventArgs(row : DataRow, column : DataColumn, value : Object);

[0726] Description

[0727] Initializes a new instance of the System.Data.DataColumnChangeEventArgs class. The System.Data.DataRow with the changing value. The System.Data.DataColumn with the changing value. The new value.

[0728] Column

[0729] ToString

[0730] C public DataColumn Column get;

[0731] C public: property DataColumn* get_Column( );

[0732] VB Public ReadOnly Property Column As DataColumn

[0733] JScript public function get Column( ) : DataColumn;

[0734] Description

[0735] Gets the System.Data.DataColumn with a changing value.

[0736] ProposedValue

[0737] ToString

[0738] C public object ProposedValue get; set;

[0739] C public: _property Object* get_ProposedValue( );public: _property void set_ProposedValue(Object*);

[0740] VB Public Property ProposedValue As Object

[0741] JScript public function get ProposedValue( ) : Object; public function set ProposedValue(Object);

[0742] Description

[0743] Gets or sets the proposed value.

[0744] Row

[0745] ToString

[0746] C public DataRow Row get;

[0747] C public: _roperty DataRow* get_Row( );

[0748] VB Public ReadOnly Property Row As DataRow

[0749] JScript public function get Row( ) : DataRow;

[0750] Description

[0751] Gets the System.Data.DataRow with a changing value.

[0752] DataColumnChangeEventHandler delegate (System.Data)

[0753] ToString

[0754] Description

[0755] Represents the method that will handle the the System.Data.DataTable.ColumnChanging event. The source of the event. A System.Data.DataColumnChangeEventArgs that contains the event data.

[0756] When you create a System.Data.DataColumnChangeEventHandler delegate, you identify the method that will handle the event. To associate the event with your event handler, add an instance of the delegate to the event. The event handler is called whenever the event occurs, until you remove the delegate. For more information about delegates, see Represents the method that will handle the the System.Data.DataTable.ColumnChanging event.

[0757] DataColumnCollection class (System.Data)

[0758] ToString

[0759] Description

[0760] Represents a collection of System.Data.DataColumn objects for a System.Data.DataTable.

[0761] The System.Data.DataColumnCollection defines the schema of a System.Data.DataTable, and determines what kind of data each System.Data.DataColumn can contain. You can access the System.Data.DataColumnCollection through the System.Data.DataTable.Columns property of the System.Data.DataTable object.

[0762] Count

[0763] IsReadOnly

[0764] IsSynchronized

[0765] Item

[0766] ToString

[0767] System.Data.DataColumn

[0768] Description

[0769] Gets the System.Data.DataColumn from the collection at the specified index.

[0770] The System.Data.DataColumnCollection.Contains(System.String) method can be used to test for the existence of a column, which is useful before attempting to use System.Data.DataColumnCollection.Item(System.Int32). The zero-based index of the column to return.

[0771] Item

[0772] ToString

[0773] C public virtual DataColumn thisstring name get;

[0774] C public: _yroperty virtual DataColumn* get_Item(String* name);

[0775] VB Overridable Public Default ReadOnly Property Item(ByVal name As String) As DataColumn

[0776] JScript returnValueDataColumnCollectionObject.Item(name);

[0777] Description

[0778] Gets the System.Data.DataColumn from the collection with the specified name.

[0779] System.Data.DataColumnCollection.Item(System.Int32) is not case-sensitive when searching for column names. The System.Data.DataColumn.ColumnName of the column to return.

[0780] List

[0781] ToString

[0782] C protected override ArrayList List get;

[0783] C protected: property virtual ArrayList* get_List( );

[0784] VB Overrides Protected ReadOnly Property List As ArrayList

[0785] JScript protected function get List( ) : ArrayList;

[0786] Description

[0787] Gets the list of the collection items.

[0788] SyncRoot

[0789] ToString

[0790] Description Occurs when the columns collection changes, either by adding or removing a column.

[0791] The System.Data.DataColumnCollection.Contains(System.String) and System.Data.DataColumnCollection.CanRemove(System.Data.DataColumn) methods can be used to determine if a column exists and can be removed.

[0792] Add

[0793] C public virtual DataColumn Add( );

[0794] C public: virtual DataColumn* Add( );

[0795] VB Overridable Public Function Add( ) As DataColumn

[0796] JScript public function Add( ) : DataColumn;

[0797] Description

[0798] Creates and adds a System.Data.DataColumn to a System.Data.DataColumnCollection.

[0799] Return Value: The newly created System.Data.DataColumnn.

[0800] A default name (Column1, Column2, etc.) is given to the column.

[0801] Add

[0802] C public void Add(DataColumn column);

[0803] C public: void Add(DataColumn* column);

[0804] VB Public Sub Add(ByVal column As DataColumn)

[0805] JScript public function Add(column : DataColumn); Adds a System.Data.DataColumn to the System.Data.DataColumnCollectiion.

[0806] Description

[0807] Adds the specified System.Data.DataColumn to the System.Data.DataColumnCollection.

[0808] If the collection is successfuilly changed by adding or removing columns, the System.Data.DataColumnCollection.CollectionChanged event occurs. The System.Data.DataColumn to add.

[0809] Add

[0810] C public virtual DataColumn Add(string columnName);

[0811] C public: virtual DataColumn* Add(String* columnName);

[0812] VB Overridable Public Function Add(ByVal columnName As String) As DataColumn

[0813] JScript public function Add(columnName : String) : DataColumn;

[0814] Description

[0815] Creates and adds a System.Data.DataColumn with the specified name to the System.Data.DataColumnCollection.

[0816] Return Value: The newly created System.Data.DataColumn.

[0817] By default, the column's System.Data.DataColumn.DataTyple is string. The name of the column.

[0818] Add

[0819] C public virtual DataColumn Add(string columnName, Type type);

[0820] C public: virtual DataColumn* Add(String* columnName, Type* type);

[0821] VB Overridable Public Function Add(ByVal columnName As String, ByVal type As Type) As DataColumn

[0822] JScript public function Add(columnName : String, type : Type) : DataColumn;

[0823] Description

[0824] Creates and adds a System.Data.DataColumn with the specified name and type to the System.Data.DataColumnCollection.

[0825] Return Value: The newly created System.Data.DataColumn.

[0826] If null or an empty string ( ) is passed in for the name, a default name (Column1, Column2, etc.) is given to the column. The System.Data.DataColumn.ColumnName to create the column with. The column's System.Data.DataColumn.DataType.

[0827] Add

[0828] C public virtual DataColumn Add(string columnName, Type type, string expression);

[0829] C public: virtual DataColumn* Add(String* columnName, Type* type, String* expression);

[0830] VB Overridable Public Function Add(ByVal columnName As String, ByVal type As Type, ByVal expression As String) As DataColumn

[0831] JScript public function Add(columnName : String, type : Type, expression: String) : DataColumn;

[0832] Description

[0833] Creates and adds a System.Data.DataColumn with the specified name, type, and compute expression to the System.Data.DataColumnCollection.

[0834] Return Value: The newly created System.Data.DataColumn.

[0835] If null or an empty string ( ) is passed in for the name, a default name (Column1, Column2, etc.) is given to the column. The column name. The System.Data.DataColumn.DataType of the column. The expression to assign to the System.Data.DataColumn.Expression property.

[0836] AddRange

[0837] C public void AddRange(DataColumn columns);

[0838] C public: void AddRange(DataColumn* columns );

[0839] VB Public Sub AddRange(ByVal colurnns( ) As DataColumn)

[0840] JScript public function AddRange(columns : DataColumn );

[0841] Description

[0842] Copies the elements of the specified System.Data.DataColurmn array to the end of the collection. The array of System.Data.DataColumn objects to add to the collection.

[0843] CanRemove

[0844] C public bool CanRemove(DataColumn column);

[0845] C public: bool CanRemove(DataColurm* column);

[0846] VB Public Function CanRemove(ByVal column As DataColumn) As Boolean

[0847] JScript public function CanRemove(column : DataColumn) : Boolean;

[0848] Description

[0849] Checks whether a given column can be removed from the collection.

[0850] Return Value: true if the column can be removed; otherwise, false.

[0851] The System.Data.DataColumnCollection.CanRemove(System.Data.DataColumn) method performs several checks before returning a true or false including the following: whether the column exists, belongs to the table, or is involved in a constraint or relation. A System.Data.DataColumn in the collection.

[0852] Clear

[0853] C public void Clear( );

[0854] C public: void Clear( );

[0855] VB Public Sub Clear( )

[0856] JScript public function Clear( );

[0857] Description

[0858] Clears the collection of any columns.

[0859] If the collection is succesfully changed by adding or removing columns, the System.Data.DataColumnCollection.OnCollectionChanged(Systemr.Compone ntModel.CollectionChangeEventArgs) event occurs.

[0860] Contains

[0861] C public bool Contains(string name);

[0862] C public: bool Co-ntains(String* name);

[0863] VB Public Function Contains(ByVal name As String) As Boolean

[0864] JScript public function Contains(name : String) : Boolean;

[0865] Description

[0866] Checks whether the collection contains a column with the specified name.

[0867] Return Value: true if a column exists with this name; otherwise, false.

[0868] The System.Data.DataColumnCollection.Contains(System.String) method can confirm the existence of a column before performing further operations on the column. The System.Data.DataColumn.ColumnName of the column.

[0869] IndexOf

[0870] C public virtual int IndexOf(DataColumn column);

[0871] C public: virtual int IndexOf(DataColumn* column);

[0872] VB Overridable Public Function IndexOf(ByVal column As DataColumn) As Integer

[0873] JScript public function IndexOf(column : DataColumn) : int;

[0874] Description

[0875] Gets the index of a column specified by name.

[0876] Return Value: The index of the column specified by columnName if it is found; otherwise, 1.

[0877] The System.Data.DataColumnCollection.IndexOf(System.Data.DataColumn) method is not case-sensitive. IndexOf

[0878] C public int IndexOf(string columnName);

[0879] C public: int Indexof(String* columnName);

[0880] VB Public Function IndexOf(ByVal columnName As String) As Integer

[0881] JScript public function IndexOf(columnName : String) : int; Returns the index of a column specified by name. OnCollectionChanged

[0882] C protected virtual void OnCollectionChanged(CollectionChangeEventArgs ccevent);

[0883] C protected: virtual void OnCollectionChanged(CollectionChangeEventArgs* ccevent);

[0884] VB Overridable Protected Sub OnCollectionChanged(ByVal ccevent As CollectionChangeEventArgs)

[0885] JScript protected function OnCollectionChanged(ccevent: CollectionChangeEventArgs);

[0886] Description

[0887] Raises the System.Data.DataColumnCollection.OnCollectionChanged(Systelm.ComponentModel.CollectionChangeEventArgs) event. Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[0888] OnCollectionChanging

[0889] C protected internal virtual void OnCollectionChanging(CollectionChangeEventArgs ccevent);

[0890] C protected public: virtual void OnCollectionChanging(CollectionChangeEventArgs* ccevent);

[0891] VB Overridable Protected Friend Dim Sub OnCollectionChanging(ByVal ccevent As CollectionChangeEventArgs)

[0892] JScript package function OnCollectionChanging(ccevent : CollectionChangeEventArgs);

[0893] Description

[0894] Raises the System.Data.DataColumnCollection.OnCollectionChanging(System.ComponentModel.CollectionChangeEventArgs) event.

[0895] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[0896] Remove

[0897] C public void Remove(DataColumn column);

[0898] C public: void Remove(DataColumn* column);

[0899] VB Public Sub Remove(ByVal column As DataColumn)

[0900] JScript public function Remove(column : DataColumn); Removes a column from the collection.

[0901] Description

[0902] Removes the specified System.Data.DataColumn from the collection.

[0903] If the collection is succesfully changed by adding or removing columns, the System.Data.DataColumnCollection.OnCollectionChanged(System.ComponentModel.CollectionChangeEventArgs) event occurs. The System.Data.DataColumn to remove. Remove

[0904] C public void Remove(string name);

[0905] C public: void Remove(string* name);

[0906] VB Public Sub Remove(ByVal name As String)

[0907] JScript public function Remove(name : String);

[0908] Description

[0909] Removes the column with the specified name from the collection.

[0910] If the collection is succesfully changed by adding or removing columns, the System.Data.DataColumnCollection.OnCollectionChanged(System.ComponentModel.CollectionChangeEventArgs) event occurs. The name of the column to remove.

[0911] RemoveAt

[0912] C public void RemoveAt(int index);

[0913] C public: void RemoveAt(int index);

[0914] VB Public Sub RemoveAt(ByVal index As Integer)

[0915] JScript public function RemoveAt(index : int);

[0916] Description

[0917] Removes the column at the specified index from the collection.

[0918] If the collection is succesfully changed by adding or removing columns, the System.Data.DataColumnCollection.OnCollectionChanged(Systern.ComponentModel.CollectionChangeEventArgs) event occurs. The index of the column to remove.

[0919] DataException class (System.Data)

[0920] ToString

[0921] Description

[0922] Represents the exception that is thrown when errors are generated using ADO.NET components.

[0923] DataException

[0924] Example Syntax:

[0925] ToString

[0926] C public DataException( );

[0927] C public: DataException( );

[0928] VB Public Sub New( )

[0929] JScript public function DataException( );

[0930] Description

[0931] Initializes a new instance of the System.Data.DataException class.

[0932] DataException

[0933] Example Syntax:

[0934] ToString

[0935] C public DataException(string s);

[0936] C public: DataException(String* s);

[0937] VB Public Sub New(ByVal s As String)

[0938] JScript public function DataException(s : String);

[0939] Description

[0940] Initializes a new instance of the System.Data.DataException class with the specified string. The string to display when the exception is thrown.

[0941] DataException

[0942] Example Syntax:

[0943] ToString

[0944] C public DataException(SerializationInfo info, StreamingContext context);

[0945] C public: DataException(SerializationInfo* info, StreamingContext context);

[0946] VB Public Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)

[0947] JScript public function DataException(info : SerializationInfo, context: StreamingContext); Initializes a new instance of the System.Data.DataException class.

[0948] Description

[0949] Initializes a new instance of the System.Data.DataException class. The data necessary to serialize or deserialize an object. Description of the source and destination of the specified serialized stream.

[0950] DataException

[0951] Example Syntax:

[0952] ToString

[0953] C public DataException(string s, Exception innerException);

[0954] C public: DataException(String* s, Exception* innerException);

[0955] VB Public Sub New(ByVal s As String, ByVal innerException As Exception)

[0956] JScript public function DataException(s : String, innerException: Exception); Initializes a new instance of the System.Data.DataException class.

[0957] Description

[0958] Initializes a new instance of the System.Data.DataException class with the specified string and inner exception.

[0959] You can create a new exception that catches an earlier exception. The code that handles the second exception can make use of the additional information from the earlier exception, also called an inner exception, to examine the cause of the initial error. The string to display when the exception is thrown. A reference to an inner exception.

[0960] HelpLink

[0961] HResult

[0962] InnerException Message

[0963] Source

[0964] StackTrace

[0965] TargetSite

[0966] DataRelation class (System.Data)

[0967] ToString

[0968] Description

[0969] Represents a parent/child relationship between two System.Data.DataTable objects.

[0970] A System.Data.DataRelation is used to relate two System.Data.DataTable objects to each other through System.Data.DataColumn objects. For example, in a Customer/Orders relationship, the Customers table is the parent and the Orders table is the child of the relationship. This is similar to a primary key/foreign key relationship. For more information, see.

[0971] DataRelation

[0972] Example Syntax:

[0973] ToString

[0974] C public DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn);

[0975] C public: DataRelation(String* relationName, DataColumn* pare-ntColumn, DataColumn* childColumn);

[0976] VB Public Sub New(ByVal relationName As String, ByVal parentColumn As DataColumn, ByVal childColumn As DataColumn)

[0977] JScript public function DataRelation(relationName : String, parentColumn: DataColumn, childColumn : DataColumn); Initializes a new instance of the System.Data.DataRelation class.

[0978] Description

[0979] Initializes a new instance of the System.Data.DataRelation class using the specified System.Data.DataRelation name, and parent and child System.Data.DataColumn objects. The name of the System.Data.DataRelation If null or an empty string ( ), a default name will be given when the created object is added to the System.Data.DataRelationCollection. The parent System.Data.DataColumn in the relationship. The child System.Data.DataColumn in the relationship.

[0980] DataRelation

[0981] Example Syntax:

[0982] ToString

[0983] C public DataRelation(string relationName, DataColumn parentColumns, DataColumn childColumns);

[0984] C public: DataRelation(String* relationName, DataColumn* parentColumns , DataColumn* childColumns );

[0985] VB Public Sub New(ByVal relationName As String, ByVal parentColumns( ) As DataColumn, ByVal childColumns( ) As DataColumn)

[0986] JScript public function DataRelation(relationName : String, parentColumns: DataColumn , childColumns : DataColumn );

[0987] Description

[0988] Initializes a new instance of the System.Data.DataRelation class using the specified System.Data.DataRelation name and matched arrays of parent and child System.Data.DataColumn objects. The name of the relation. If null or an empty string ( ), a default name will be given when the created object is added to the System.Data.DataRelationCollection. An array of parent System.Data.DataColumn objects. An array of child System.Data.DataColumn objects.

[0989] DataRelation

[0990] Example Syntax:

[0991] ToString

[0992] C public DataRelation(string relationName, DataColumn parentColumn, DataColumn childColumn, bool createConstraints);

[0993] C public: DataRelation(String* relationName, DataColumn* parentColumn, DataColumn* childColumn, bool createConstraints);

[0994] VB Public Sub New(ByVal relationName As String, ByVal parentColumn As DataColumn, ByVal childColumn As DataColumn, ByVal createConstraints As Boolean)

[0995] JScript public function DataRelation(relationName : String, parentColumn: DataColumn, childColumn : DataColumn, createConstraints : Boolean);

[0996] Description

[0997] Initializes a new instance of the System.Data.DataRelation class using the specified name, parent and child System.Data.DataColumn objects, and a value indicating whether to create constraints. The name of the relation. If null or an empty string ( ), a default name will be given when the created object is added to the System.Data.DataRelationCollection. The parent System.Data.DataColumn in the relation. The child System.Data.DataColumn in the relation. A value indicating whether constraints are created.

[0998] DataRelation

[0999] Example Syntax:

[1000] ToString

[1001] C public DataRelation(string relationName, DataColumn parentColumns, DataColumn childColumns, bool createConstraints);

[1002] C public: DataRelation(String* relationName, DataColumn* parentColumns , DataColumn* childColumns , bool createConstraints);

[1003] VB Public Sub New(ByVal relationName As String, ByVal parentColumns( ) As DataColumn, ByVal childcolumns( ) As DataColumn, ByVal createConstraints As Boolean)

[1004] JScript public function DataRelation(relationName : String, parentColumns: DataColumn , childColumns : DataColumn , createConstraints : Boolean);

[1005] Description

[1006] Initializes a new instance of the System.Data.DataRelation class using the specified name, matched arrays of parent and child System.Data.DataColumn objects, and value indicating whether to create constraints. The name of the relation. If null or an empty string ( ), a default name will be given when the created object is added to the System.Data.DataRelationCollection. An array of parent System.Data.DataColumn objects. An array of child System.Data.DataColumn objects. A value indicating whether to create constraints.

[1007] DataRelation

[1008] Example Syntax:

[1009] ToString

[1010] C public DataRelation(string relationName, string parentTableNamne, string childTableName, string parentColumnNames, string childColumnnNames, bool nested);

[1011] C public: DataRelation(String* relationName, String* parentTableName, String* childTableName, String* parentColumnNames _gc , String* childColumnNames _gc , bool nested);

[1012] VB Public Sub New(ByVal relationName As String, ByVal parentTableName As String, ByVal childTableName As String, ByVal parentColumnNames( )As String, ByVal childColumnNames( ) As String, ByVal nested As Boolean)

[1013] JScript public function DataRelation(relationName : String, parentTableName: String, childTableName : String, parentColumnNames: String , childColumnNames: String , nested: Boolean);

[1014] Description

[1015] Initializes a new instance of the System.Data.DataRelation class using the specified System.Data.DataRelation name, parent and child System.Data.DataTable names, a matching array of parent and child System.Data.DataColumn objects, and a value indicating whether relationships are nested. The name of the relation. If null or an empty string ( ), a default name will be given when the created object is added to the System.Data.DataRelationCollection. The name of the System.Data.DataTable that is the parent table of the relation. The name of the System.Data.DataTable that is the child table of the relation. An array of System.Data.DataColumn object names in the parent System.Data.DataTable of the relation. An array of System.Data.DataColumn object namess in the child System.Data.DataTable of the relation. A value indicating whether relationships are nested.

[1016] ChildColumns

[1017] ToString

[1018] C public virtual DataColumn ChildColumns get;

[1019] C public: property virtual DataColumn* get_ChildColumns( );

[1020] VB Overridable Public ReadOnly Property ChildColumns As DataColumn

[1021] JScript public function get ChildColumns( ) : DataColumn ;

[1022] Description

[1023] Gets the child System.Data.DataColumn objects of this relation. ChildKeyConstraint

[1024] ToString

[1025] C public virtual ForeignKeyConstraint ChildKeyConstraint get;

[1026] C public: property virtual ForeignKeyConstraint* get_ChildKeyConstraint( );

[1027] VB Overridable Public ReadOnly Property ChildKeyConstraint As ForeignKeyConstraint

[1028] JScript public function get ChildKeyConstraint( ) : ForeigniKeyConstraint;

[1029] Description

[1030] Gets the System.Data.ForeignKeyConstraint for the relation.

[1031] ChildTable

[1032] ToString

[1033] C public virtual DataTable ChildTable get;

[1034] C public: property virtual DataTable* get_ChildTable( );

[1035] VB Overridable Public ReadOnly Property ChildTable As DataTable

[1036] JScript public function get ChildTable( ) : DataTable;

[1037] Description

[1038] Gets the child table of this relation. DataSet

[1039] ToString

[1040] C public virtual DataSet DataSet get;

[1041] C public: _property virtual DataSet* get_DataSet( );

[1042] VB Overridable Public ReadOnly Property DataSet As DataSet

[1043] JScript public function get DataSet( ) : DataSet;

[1044] Description

[1045] Gets the System.Data.DataSet to which the System.Data.DataRelation belongs.

[1046] The System.Data.DataRelationCollection associated with a System.Data.DataSet is accessed through the System.Data.DataSet.Relations property of the System.Data.DataSet object.

[1047] ExtendedProperties

[1048] ToString

[1049] C public PropertyCollection ExtendedProperties get;

[1050] C public: _property PropertyCollection* get_ExtendedProperties( );

[1051] VB Public ReadOnly Property ExtendedProperties As PropertyCollection

[1052] JScript public function get ExtendedProperties( ) : PropertyCollection;

[1053] Description

[1054] Gets the collection that stores customized properties.

[1055] Nested

[1056] ToString

[1057] C public virtual bool Nested get; set;

[1058] C public: _property virtual bool get_Nested( );public: property virtual void set_Nested(bool);

[1059] VB Overridable Public Property Nested As Boolean

[1060] JScript public function get Nested( ) : Boolean; public function set Nested(Boolean);

[1061] Description

[1062] Gets or sets a value indicating whether System.Data.DataRelation objects are nested.

[1063] You can use System.Data.DataRelation objects to define hierarchical relationships, such as those specified in XML. For more information, see.

[1064] ParentColumns

[1065] ToString

[1066] C public virtual DataColumn ParentColumns get;

[1067] C public: _property virtual DataColumn* get_ParentColumns( );

[1068] VB Overridable Public ReadOnly Property ParentColumns As DataColumn 0

[1069] JScript public function get ParentColumns( ) : DataColumn ;

[1070] Description

[1071] Gets an array of System.Data.DataColumn objects that are the parent columns of this System.Data.DataRelation.

[1072] ParentKeyConstraint

[1073] ToString

[1074] C public virtual UniqueConstraint ParentKeyConstraint get;

[1075] C public: _property virtual UniqueConstraint* get_ParentKeyConstraint( );

[1076] VB Overridable Public ReadOnly Property ParentKeyConstraint As UniqueConstraint

[1077] JScript public function get ParentKeyConstraint( ) : UniqueConstraint;

[1078] Description

[1079] Gets the System.Data.UniqueConstraint that ensures values in the parent column of a System.Data.DataRelation are unique.

[1080] ParentTable

[1081] ToString

[1082] C public virtual DataTable ParentTable get;

[1083] C public: property virtual DataTable* get_ParentTable( );

[1084] VB Overridable Public ReadOnly Property ParentTable As DataTable

[1085] JScript public function get ParentTable( ) : DataTable;

[1086] Description

[1087] Gets the parent System.Data.DataTable of this System.Data.DataRelation.

[1088] RelationName

[1089] ToString

[1090] C public virtual string RelationName get; set;

[1091] C public: property virtual String* get_RelationName( );public: _-Property virtual void set_RelationName(String*);

[1092] VB Overridable Public Property RelationName As String

[1093] JScript public function get RelationName( ) : String; public function set RelationName(String);

[1094] Description

[1095] Gets or sets the name used to retrieve a System.Data.DataRelation from the System.Data.DataRelationCollection. Use the System.Data.DataRelation.RelationName property to retrieve a System.Data.DataRelation from the System.Data.DataRelationCollection. CheckStateForProperty

[1096] C protected void CheckStateForProperty( );

[1097] C protected: void CheckStateForProperty( );

[1098] VB Protected Sub CheckStateForProperty( )

[1099] JScript protected function CheckStateForProperty( );

[1100] Description

[1101] Ensures that the System.Data.DataRelation is a valid object.

[1102] System.Data.DataRelation.CheckStateForProperty verifies the validity of a System.Data.DataRelation object, even if it does not belong to a System.Data.DataSet.

[1103] OnPropertyChanging

[1104] C protected internal void OnPropertyChanging(PropertyChangedEventArgs pcevent);

[1105] C protected public: void OnPropertyChanging(PropertyChangedEventArgs* pcevent);

[1106] VB Protected Friend Dim Sub OnPropertyChanging(ByVal pcevent As PropertyChangedEventArgs)

[1107] JScript package function OnPropertyChanging(pcevent: PropertyChangedEventArgs);

[1108] Description

[1109] RaisePropertyChanging

[1110] C protected internal void RaiseProperttChanging(string name);

[1111] C protected public: void RaisePropertyChanging(String* name);

[1112] VB Protected Friend Dim Sub RaisePropertyChanging(ByVal name As String)

[1113] JScript package function RaisePropertyChanging(name : String);

[1114] Description

[1115] ToString

[1116] C public override string ToString( );

[1117] C public: String* ToString( );

[1118] VB Overrides Public Function ToString( ) As String

[1119] JScript public override function ToString( ) : String;

[1120] Description

[1121] Gets the System.Data.DataRelation.RelationName, if one exists.

[1122] Return Value: The value of the System.Data.DataRelation.RelationName property. DataRelationCollection class (System.Data)

[1123] ToString

[1124] Description

[1125] Represents the collection of System.Data.DataRelation objects for this System.Data.DataSet.

[1126] A System.Data.DataRelationCollection object enables navigation between related parent/child System.Data.DataTable objects.

[1127] DataRelationCollection

[1128] Example Syntax:

[1129] ToString

[1130] C protected DataRelationCollection( );

[1131] C protected: DataRelationCollection( );

[1132] VB Protected Sub New( )

[1133] JScript protected function DataRelationCollection( );

[1134] Count

[1135] IsReadOnly

[1136] IsSynchronized

[1137] Item

[1138] ToString

[1139] Description

[1140] Gets the System.Data.DataRelation object specified by name. The name of the relation to find.

[1141] Item

[1142] ToString

[1143] C public abstract DataRelation thisint index get;

[1144] C public: _property virtual DataRelation* get Item(int index)0;

[1145] VB MustOverride Public Default ReadOnly Property Item(ByVal index As Integer) As DataRelation

[1146] JScript abstract returnValueDataRelationCollectionObject.Item(index); Gets the specified System.Data.DataRelation from the collection.

[1147] Description

[1148] Gets the System.Data.DataRelation object at the specified index. The zero-based index to find.

[1149] List

[1150] SyncRoot

[1151] ToString

[1152] Description

[1153] Occurs when the collection has changed.

[1154] Add

[1155] C public void Add(DataRelation relation);

[1156] C public: void Add(DataRelation* relation);

[1157] VB Public Sub Add(ByVal relation As DataRelation)

[1158] JScript public function Add(relation: DataRelation); Adds a System.Data.DataRelation to the System.Data.DataRelationCollection.

[1159] Description

[1160] Adds a System.Data.DataRelation to the System.Data.DataRelationCollection.

[1161] If the relation is sucessfully added to the collection, the System.Data.DataRelationCollection.CollectionChanged event fires. The DataRelation to add to the collection.

[1162] Add

[1163] C public virtual DataRelation Add(DataColumn parentColumn, DataColumn childColumn);

[1164] C public: virtual DataRelation* Add(DataColumn* parentColumn, DataColumn* childColumn);

[1165] VB Overridable Public Function Add(ByVal parentColumn As Data;Column, ByVal childColumn As DataColumn) As DataRelation

[1166] JScript public function Add(parentColumn : DataColumn, childColumn: DataColumn) : DataRelation;

[1167] Description

[1168] Creates a relation given the parameters and adds it to the collection. The name is defaulted. An ArgumentException is generated if this relation already belongs to this collection or belongs to another collection. An InvalidConstraintException is generated if the relation can't be created based on the parameters. The CollectionChanged event is fired if it succeeds.

[1169] Return Value: The created relation. parent column of relation. child column of relation.

[1170] Add

[1171] C public virtual DataRelation Add(DataColumn parentColumns, DataColumn childColumns);

[1172] C public: virtual DataRelation* Add(DataColumn* parentColumns , DataColumn* childColumns );

[1173] VB Overridable Public Function Add(ByVal parentColumns( ) As DataColumn, ByVal childColumns( ) As DataColumn) As DataRelation

[1174] JScript public function Add(parentColumns : DataColumn , childColumns: DataColumn ) : DataRelation;

[1175] Description

[1176] Creates a relation given the parameters and adds it to the collection. The name is defaulted. An ArgumentException is generated if this relation already belongs to this collection or belongs to another collection. An InvalidConstraintException is generated if the relation can't be created based on the parameters. The CollectionChanged event is fired if it succeeds.

[1177] Return Value: The created relation. parent columns of relation. child columns of relation.

[1178] Add

[1179] C public virtual DataRelation Add(string name, DataColumn parentColumn, DataColumn childColumn);

[1180] C public: virtual DataRelation* Add(String* name, DataColumnn parentColumn, DataColumn* childColumn);

[1181] VB Overridable Public Function Add(ByVal name As String, ByVal parentColumn As DataColumn, ByVal childColumn As DataColumn) As DataRelation

[1182] JScript public function Add(name : String, parentColumn : DataColumn, childColumn : DataColumn) : DataRelation;

[1183] Description

[1184] Creates a relation given the parameters and adds it to the collection. An ArgumentException is generated if this relation already belongs to this collection or belongs to another collection. A DuplicateNameException is generated if this collection already has a relation with the same name (case insensitive). An InvalidConstraintException is generated if the relation can't be created based on the parameters. The CollectionChanged event is fired if it succeeds.

[1185] Return Value: The created relation. The name of the relation. parent column of relation. child column of relation.

[1186] Add

[1187] C public virtual DataRelation Add(string name, DataColumn parentColumns, DataColumn childColumns);

[1188] C public: virtual DataRelation* Add(String* name, DataColumn parentColumns , DataColumn* childColumns );

[1189] VB Overridable Public Function Add(ByVal name As String, ByVal parentcolumns( ) As DataColumn, ByVal childColumns( ) As DataColumn) As DataRelation

[1190] JScript public function Add(name : String, parentColumns : DataColumn , childColumns : DataColumn ) : DataRelation;

[1191] Description

[1192] Creates a System.Data.DataRelation with the specified name, and arrays of parent and child columns, and adds it to the collection.

[1193] Return Value: The created DataRelation.

[1194] If the relation is successfully added to the collection, the System.Data.DataRelationCollection.CollectionChanged event fires. The name of the DataRelation to create. An array of parent System.Data.DataColumn objects. An array of child DataColumn objects.

[1195] Add

[1196] C public virtual DataRelation Add(string name, DataColumn parentColumn, DataColumn childColumn, bool createConstraints);

[1197] C public: virtual DataRelation* Add(String* name, DataColumn* parentColumn, DataColumn* childColumn, bool createConstraints);

[1198] VB Overridable Public Function Add(ByVal name As String, ByVal parentColumn As DataColumn, ByVal childColumn As DataColumn, ByVal createConstraints As Boolean) As DataRelation

[1199] JScript public function Add(name : String, parentColumn : DataColumn, childColumn : DataColumn, createConstraints: Boolean) : DataRelation;

[1200] Description

[1201] Creates a relation given the parameters and adds it to the collection. An ArgumentException is generated if this relation already belongs to this collection or belongs to another collection. A DuplicateNameException is generated if this collection already has a relation with the same name (case insensitive). An InvalidConstraintException is generated if the relation can't be created based on the parameters. The CollectionChanged event is fired if it succeeds.

[1202] Return Value: The created relation. The name of the relation. parent column of relation. child column of relation. whether to create a constraints Add

[1203] C public virtual DataRelation Add(string name, DataColumn parentColumns, DataColumn childColumns, bool createConstraints);

[1204] C public: virtual DataRelation* Add(String* name, DataColumn* parentColumns , DataColumn* childColumns , bool createConstraints);

[1205] VB Overridable Public Function Add(ByVal name As String, ByVal parentColumns( ) As DataColumn, ByVal childColumns( ) As DataColumn, ByVal createConstraints As Boolean) As DataRelation

[1206] JScript public function Add(name : String, parentColumns : DataColumn , childColumns : DataColumn , createConstraints : Boolean) : DataRelation;

[1207] Description Creates a System.Data.DataRelation with the specified name, arrays of parent and child columns, and value specifying whether to create a constraint, and adds it to the collection.

[1208] Return Value: The created relation. The name of the DataRelation to create. An array of parent System.Data.DataColumn objects. An array of child DataColumn objects. true to create a constraint; otherwise false.

[1209] AddCore

[1210] C protected virtual void AddCore(DataRelation relation);

[1211] C protected: virtual void AddCore(DataRelation* relation);

[1212] VB Overridable Protected Sub AddCore(ByVal relation As DataRelation)

[1213] JScript protected function AddCore(relation: DataRelation);

[1214] Description Performs verification on the table. An ArgumentNullException is generated if this relation is null. An ArgumentException is generated if this relation already belongs to this collection, belongs to another collection. A DuplicateNameException is generated if this collection already has a relation with the same name (case insensitive). The relation to check.

[1215] AddRange

[1216] C public virtual void AddRange(DataRelation relations);

[1217] C public: virtual void AddRange(DataRelation* relations );

[1218] VB Overridable Public Sub AddRange(ByVal relations( ) As DataRelation)

[1219] JScript public function AddRange(relations: DataRelation );

[1220] Description

[1221] Copies the elements of the specified System.Data.DataRelation array to the end of the collection. The array of System.Data.DataRelation objects to add to the collection.

[1222] CanRemove

[1223] C public virtual bool CanRemove(DataRelation relation);

[1224] C public: virtual bool CanRemove(DataRelation* relation);

[1225] VB Overridable Public Function CanRemove(ByVal relation As DataRelation) As Boolean

[1226] JScript public function CanRemove(relation : DataRelation) : Boolean; Verifies if a given relation can be removed from the collection.

[1227] Clear

[1228] C public virtual void Clear( );

[1229] C public: virtual void Clear( );

[1230] VB Overridable Public Sub Clear( )

[1231] JScript public function Clear( );

[1232] Description

[1233] Clears the collection of any relations.

[1234] Contains

[1235] C public virtual bool Contains(string name);

[1236] C public: virtual bool Contains(String* name);

[1237] VB Overridable Public Function Contains(ByVal name As String) As Boolean

[1238] JScript public function Contains(name : String) : Boolean;

[1239] Description

[1240] Gets a value of true if this collection has a relation with the given name (case insensitive), false otherwise.

[1241] Return Value: Whether a relation exists with this name. name to test.

[1242] GetDataSet

[1243] C protected abstract DataSet GetDataSet( );

[1244] C protected: virtual DataSet* GetDataSet( ) 0;

[1245] VB MustOverride Protected Function GetDataSet( ) As DataSet

[1246] JScript protected abstract function GetDataSet( ) : DataSet;

[1247] Description

[1248] Gets the dataSet for this collection.

[1249] Return Value: The dataSet.

[1250] IndexOf

[1251] C public virtual int IndexOf(DataRelation relation);

[1252] C public: virtual int IndexOf(DataRelation* relation);

[1253] VB Overridable Public Function IndexOf(ByVal relation As DataRelation) As Integer

[1254] JScript public function IndexOf(relation : DataRelation) : int; Returns the index of a specified System.Data.DataRelation.

[1255] IndexOf

[1256] C public virtual int IndexOf(string relationName);

[1257] C public: virtual int IndexOf(String* relationName);

[1258] VB Overridable Public Function IndexOf(ByVal relationName As String) As Integer

[1259] JScript public function IndexOf(relationName : String) : int; Returns the index of the relation with the given name (case insensitive), or 1 if the relation doesn't exist in the collection.

[1260] OnCollectionChanged

[1261] C protected virtual void OnCollectionChanged(CollectionChangeEventArgs ccevent);

[1262] C protected: virtual void OnCollectionChanged(CollectionChangeEventArgs* ccevent);

[1263] VB Overridable Protected Sub OnCollectionChanged(ByVal ccevent As CollectionChangeEventArgs)

[1264] JScript protected function OnCollectionChanged(ccevent: CollectionChangeEventArgs);

[1265] Description

[1266] Raises the System.Data.DataRelationCollection.OllectionChanged(Systei.ComponentModel.CollectionChangeEventArgs) event.

[1267] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[1268] OnCollectionChanging

[1269] C protected internal virtual void OnCollectionChanging(CollectionChangeEventArgs ccevent);

[1270] C protected public: virtual void OnCollectionChanging(CollectionChangeEventArgs* ccevent);

[1271] VB Overridable Protected Friend Dim Sub OnCollectionChanging(ByVal ccevent As CollectionChangeEventArgs)

[1272] JScript package function OnCollectionChanging(ccevent: CollectionChangeEventArgs);

[1273] Description

[1274] Raises the System.Data.DataRelationCollection.OnCollectionChanging(System.ComponentModel.CollectionChangeEventArgs) event.

[1275] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[1276] Remove

[1277] C public void Remove(DataRelation relation);

[1278] C public: void Remove(DataRelation* relation);

[1279] VB Public Sub Remove(ByVal relation As DataRelation)

[1280] JScript public function Remove(relation: DataRelation); Removes the specified relation from the collection.

[1281] Description

[1282] Removes the specified relation from the collection. An ArgumentNullException is generated if this relation is null. An ArgumentException is generated if this relation doesn't belong to this collection. The CollectionChanged event is fired if it succeeds. The relation to remove.

[1283] Remove

[1284] C public void Remove(string name);

[1285] C public: void Remove(String* name);

[1286] VB Public Sub Remove(ByVal name As String)

[1287] JScript public function Remove(name : String);

[1288] Description

[1289] Removes the relation with the specified name from the collection. An IndexOutOfRangeException is generated if this collection doesn't have a relation with that name The CollectionChanged event is fired if it succeeds. The name of the relation to remove.

[1290] RemoveAt

[1291] C public void RemoveAt(int index);

[1292] C public: void RemoveAt(int index);

[1293] VB Public Sub RemoveAt(ByVal index As Integer)

[1294] JScript public function RemoveAt(index : int);

[1295] Description

[1296] Removes the relation at the specified index from the collection. An IndexOutOfRangeException is generated if this collection doesn't have a relation at this index. The CollectionChanged event is fired if it succeeds. The index at which to remove a relation.

[1297] RemoveCore

[1298] C protected virtual void RemoveCore(DataRelation relation);

[1299] C protected: virtual void RemoveCore(DataRelation* relation);

[1300] VB Overridable Protected Sub RemoveCore(ByVal relation As DataRelation)

[1301] JScript protected function RemoveCore(relation : DataRelation);

[1302] Description

[1303] Does verification on the relation. An ArgumentNullException is generated if this relation is null. An ArgumentException is generated if this relation doesn't belong to this collection. The relation to check.

[1304] DataRow class (System.Data)

[1305] ToString

[1306] Description

[1307] Represents a row of data in a System.Data.DataTable.

[1308] The System.Data.DataRow and System.Data.DataColumn objects are primary components of a System.Data.DataTable. Use the System.Data.DataRow object and its properties and methods to retrieve and evaluate; and insert, delete, and update the values in the System.Data.DataTable. The System.Data.DataRowCollection represents the actual System.Data.DataRow objects in the System.Data.DataTable, and the System.Data.DataColumnCollection contains the System.Data.DataColumn objects that describe the schema of the System.Data.DataTable. Use the overloaded System.Data.DataRow.Item(System.Int32) property to return or sets the value of a System.Data.DataColumn.

[1309] DataRow

[1310] Example Syntax:

[1311] ToString

[1312] C protected internal DataRow(DataRowBuider builder);

[1313] C internal: DataRow(DataRowBuilder* builder);

[1314] VB Protected Friend Sub New(ByVal builder As DataRowBuilder)

[1315] JScript package function DataRow(builder: DataRowBuilder);

[1316] Description

[1317] Initializes a new instance of the DataRow. builder

[1318] HasErrors

[1319] ToString

[1320] C public bool HasErrors get;

[1321] C public: property bool get HasErrors( );

[1322] VB Public ReadOnly Property HasErrors As Boolean

[1323] JScript public function get HasErrors( ) : Boolean;

[1324] Description

[1325] Gets a value indicating whether there are errors in a columns collection.

[1326] When validating data, you can set an error on any column in a row. Such a column, when displayed in the System.Windows.Forms.DataGrid control, is marked with a red exclamation point to signal the user that the column is in error.

[1327] Item

[1328] ToString

[1329] C public object thisstring columnName get; set;

[1330] C public: _property Object* get_Item(String* columnName);public: _roperty void set_Item(String* columnName, Object*);

[1331] VB Public Default Property Item(ByVal columnName As String) As; Object

[1332] JScript returnValueDataRowObject.Item(columnName); DataRowObject.Item(columnName)returnValue;

[1333] Description

[1334] Gets or sets the data stored in the column specified by name.

[1335] When setting the property, an exception is generated if an exception occurs in the System.Data.DataTable.ColumnChanging event. The name of the column.

[1336] Item

[1337] ToString

[1338] C public object thisDataColumn column get; set;

[1339] C public: _property Object* get_Item(DataColumn* column);public: _property void set_Item(DataColumn* column, Object*);

[1340] VB Public Default Property Item(ByVal column As DataColumn) As Object

[1341] JScript returnValueDataRowObject.Item(column); DataRowObject.Item(column)returnValue;

[1342] Description

[1343] Gets or sets the data stored in the specified System.Data.DataColumn.

[1344] When setting the property, an exception is generated if an exception occurs in the System.Data.DataTable.ColumnChanging event. A System.Data.DataColumn that contains the data.

[1345] Item

[1346] ToString

[1347] C public object thisint columnIndex get; set;

[1348] C public: property Object* get_Item(int columnIndex);public: property void set_Item(int columnIndex, Object*);

[1349] VB Public Default Property Item(ByVal columnIndex As Integer) As Object JScript returnValueDataRowObject.Item(columnIndex); DataRowObject.Item(columnIndex) returnValue; Gets or sets data stored in a specified column.

[1350] Description

[1351] Gets or sets the data stored in the column specified by index.

[1352] When setting the property, an exception is generated if an exception occurs in the System.Data.DataTable.ColumnChanging event. The zero-based index of the column

[1353] Item

[1354] ToString

[1355] C public object thisstring columnName, DataRowVersion version get;

[1356] C public: property Object* get Item(String* columnName, DataRowVersion version);

[1357] VB Public Default ReadOnly Property Item(ByVal columnName As String, ByVal version As DataRowVersion) As Object

[1358] JScript returnValueDataRowObject.Item(columnName, version);

[1359] Description

[1360] Gets the specified version of data stored in the named column.

[1361] The version shouldn't be confused with the System.Data.DataRow.RowState property. The version argument describes the state of the data contained by the column in relation to the column's original value. The System.Data.DataRow.RowState property describes the state of the entire row in relation to its parent System.Data.DataTable The name of the column. One of the System.Data.DataRowVersion values that specifies the desired row version. Possible values are Default, Original, Current, and Proposed.

[1362] Item

[1363] ToString

[1364] C public object thisDataColumn column, DataRowVersion versionr get;

[1365] C public: _property Object* get_Item(DataColumn* column, DataRowVersion version);

[1366] VB Public Default ReadOnly Property Item(ByVal column As DataColumn, ByVal version As DataRowVersion) As Object

[1367] JScript returnValueDataRowObject.Item(column, version);

[1368] Description

[1369] Gets the specified version of data stored in the specified System.Data.DataColumn.

[1370] The version shouldn't be confused with the System.Data.DataRow.RowState property. The version argument describes the state of the data contained by the column in relation to the column's original value. A System.Data.DataColumn that contains information about the column. One of the System.Data.DataRowVersion values that specifies the desired row version. Possible values are Default, Original, Current, and Proposed.

[1371] Item

[1372] ToString

[1373] C public object thisint columnIndex, DataRowVersion version get;

[1374] C public: _property Object* get Item(int columnlndex, DataRowVersion version);

[1375] VB Public Default ReadOnly Property Item(ByVal columnIndex As Integer, ByVal version As DataRowVersion) As Object

[1376] JScript returnValueDataRowObject.Item(columnIndex, version);

[1377] Description

[1378] Gets the data stored in the column, specified by index and version of the data to retrieve.

[1379] You can only create or update a row after calling the System.Data.DataRow.BeginEdit method; similarly, the System.Data.DataRow.EndEdit method must be called to commit the edit. After calling the System.Data.DataRow.EndEdit method, and before calling the System.Data.DataRow.AcceptChanges method, internal representations of the original and new proposed values are stored. Therefore, until you call the System.Data.DataRow.AcceptChanges, you can use the version argument to specify which version of a column's value you need, either the DataRowVersion.Original or DataRowVersion.Proposed. Once you call the System.Data.DataRow.AcceptChanges method, however, the version of the column reverts to DataRowVersion.Original. If the row is new, you can also pass DataRowVersion.Default for the parameter to retrieve the column's default value. When passing DataRowVersion.Current, the property will return the current value, whatever its version may be. The zero-based index of the column. One of the System.Data.DataRowVersion values that specifies the desired row version. Possible values are Default, Original, Current, and Proposed.

[1380] ItemArray

[1381] ToString

[1382] C public object ItemArray get; set;

[1383] C public: property Object* get_ItemArray( );public: _property void set_ItemArray(Object* _gc );

[1384] VB Public Property ItemArray As Object ( )

[1385] JScript public function get ItemArray( ) : Object ; public function set ItemArray(Object );

[1386] Description

[1387] Gets or sets all of the values for this row through an array.

[1388] If a System.Data.DataColumn has its System.Data.DataColumn.DefaultValue property set, pass a null in the array to set the default value for that column. Similarly, if a column has its System.Data.DataColumn.AutoIncrement property set to true, pass the null in the array to set the automatically generated value for the row.

[1389] RowError

[1390] ToString

[1391] C public string RowError get; set;

[1392] C public: property String* get_RowError( );public: _property void set_RowError(String*);

[1393] VB Public Property RowError As String

[1394] JScript public function get RowError( ): String; public function set RowError(String);

[1395] Description

[1396] Gets or sets the custom error description for a row.

[1397] Uses the System.Data.DataRow.HasErrors property to first determine if a System.Data.DataRow contains errors.

[1398] RowState

[1399] ToString

[1400] C public DataRowState RowState get;

[1401] C public: _property DataRowState get_RowState( );

[1402] VB Public ReadOnly Property RowState As DataRowState

[1403] JScript public function get RowState( ) : DataRowState;

[1404] Description

[1405] Gets the current state of the row in regards to its relationship to the System.Data.DataRowCollection.

[1406] The System.Data.DataRow.RowState property is used in conjunction with the System.Data.DataSet.GetChanges and System.Data.DataSet.HasChanges methods of the System.Data.DataSet.

[1407] Table

[1408] ToString

[1409] C public DataTable Table get;

[1410] C public: property DataTable* get_Table( );

[1411] VB Public ReadOnly Property Table As DataTable

[1412] JScript public function get Table( ) : DataTable;

[1413] Description

[1414] Gets the System.Data.DataTable for which this row has a schema.

[1415] A System.Data.DataRow does not necessarily belong to any table's collection of rows. This occurs when the System.Data.DataRow has been created but not added to the System.Data.DataRowCollection. If the System.Data.DataRow.RowState property returns DataRowState.Detached, the row is not in any collection.

[1416] AcceptChanges

[1417] C public void AcceptChanges( );

[1418] C public: void AcceptChanges( );

[1419] VB Public Sub AcceptChanges( )

[1420] JScript public function AcceptChanges( );

[1421] Description

[1422] Commits all the changes made to this row since the last time System.Data.DataRow.AcceptChanges was called.

[1423] When invoking System.Data.DataRow.AcceptChanges, the System.Data.DataRow.EndEdit method is implicitly called to end any edits. If the System.Data.DataRow.RowState of the row was Added or Modified, the System.Data.DataRow.RowState becomes Unchanged. If the System.Data.DataRow.RowState was Deleted, the row is removed.

[1424] BeginEdit

[1425] C public void BeginEdit( );

[1426] C public: void BeginEdit( );

[1427] VB Public Sub BeginEdit( )

[1428] JScript public function BeginEdit( );

[1429] Description

[1430] Begins an edit operation on a System.Data.DataRow object.

[1431] Use the System.Data.DataRow.BeginEdit method to put a System.Data.DataRow into edit mode. In this mode, events are temporarily suspended allowing the user to make multiple changes to more than one row without triggering validation rules. For example, if the values of several rows must add up to 100, you can put each of the rows into edit mode to suspend the validation of the row values until the user attempts to commit the values. While in edit mode, the The System.Data.DataRow.BeginEdit method is called implicitly when the user changes the value of a databound control; the System.Data.DataRow.EndEdit method is called implicitly when you invoke the System.Data.DataTable object's System.Data.DataTable.AcceptChanges method.) While in this edit mode, the System.Data.DataRow stores representations of the original and new proposed values Therefore, as long as the System.Data.DataRow.EndEdit method has not been called, you can retrieve either the original or proposed version by passing either DataRowVersion.Original or DataRowVersion.Proposed for the version parameter of the System.Data.DataRow.Item(System.Int32) properly. You can also cancel any edits at this time by invoking the System.Data.DataRow.CancelEdit method.

[1432] CancelEdit

[1433] C public void CancelEdit( );

[1434] C public: void CancelEdit( );

[1435] VB Public Sub CancelEdit( )

[1436] JScript public function CancelEdit( );

[1437] Description Cancels the current edit on the row.

[1438] See the System.Data.DataRow.BeginEdit method for more details.

[1439] ClearErrors

[1440] C public void ClearErrors( );

[1441] C public: void ClearErrors( );

[1442] VB Public Sub ClearErrors( )

[1443] JScript public function ClearErrors( );

[1444] Description

[1445] Clears the errors for the row, including the System.Data.DataRow.RowError and errors set with System.Data.DataRow.SetColumnError(System.Int32,System.String).

[1446] Use System.Data.DataRow.SetColumnError(System.Int32,System.String) and System.Data.DataRow.GetColumnError(System.Int32) to set and return errors for individual columns.

[1447] Delete

[1448] C public void Delete( );

[1449] C public: void Delete( );

[1450] VB Public Sub Delete( )

[1451] JScript public function Delete( );

[1452] Description

[1453] Deletes the row.

[1454] If the System.Data.DataRow.RowState of the row is Added, the row will be removed from the table.

[1455] EndEdit

[1456] C public void EndEdit( );

[1457] C public: void EndEdit( );

[1458] VB Public Sub EndEdit( )

[1459] JScript public function EndEdit( );

[1460] Description

[1461] Ends the edit occurring on the row.

[1462] When setting the property, an exception is generated if an exception occurs in the System.Data.DataTable.RowChanging event.

[1463] GetChildRows

[1464] C public DataRow GetChildRows(DataRelation relation);

[1465] C public: DataRow* GetChildRows(DataRelation* relation) ;

[1466] VB Public Function GetChildRows(ByVal relation As DataRelation) As DataRow( )

[1467] JScript public function GetChildRows(relation: DataRelation) : DataRow ;

[1468] Gets the child rows of a System.Data.DataRow.

[1469] Description

[1470] Gets the child rows of this System.Data.DataRow using the specified System.Data.DataRelation.

[1471] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1472] In a System.Data.DataSet, the collection of all System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetChildRelations method. The System.Data.DataRelation to use.

[1473] GetChildRows

[1474] C public DataRow GetChildRows(string relationName);

[1475] C public: DataRow* GetChildRows(String* relationName) ;

[1476] VB Public Function GetChildRows(ByVal relationName As String) As DataRow( )

[1477] JScript public function GetChildRows(relationName : String) : DataRow ; Gets the child rows in a related System.Data.DataTable of a System.Data.DataRow.

[1478] Description

[1479] Gets the child rows of a System.Data.DataRow using the specified System.Data.DataRelation.RelationName of a System.Data.DataRelation.

[1480] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1481] In a System.Data.DataSet, the collection of all System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetChildRelations method. The System.Data.DataRelation.RelationName of the System.Data.DataRelation to use.

[1482] GetChildRows

[1483] C public DataRow GetChildRows(DataRelation relation, DataRowVersion version);

[1484] C public: DataRow* GetChildRows(DataRelation* relation, DataRowVersion version) ;

[1485] VB Public Function GetChildRows(ByVal relation As DataRelation, ByVal version As DataRowVersion) As DataRow( )

[1486] JScript public function GetChildRows(relation: DataRelation, version: DataRowVersion) : DataRow ;

[1487] Description

[1488] Gets the child rows of a System.Data.DataRow using the specified System.Data.DataRelation, and System.Data.DataRowVersion.

[1489] Return Value: An array of System.Data.DataRow objects.

[1490] In a System.Data.DataSet, the collection of all System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetChildRelations method. The System.Data.DataRelation to use. One of the System.Data.DataRolwVersion values specifying the version of the data to get. Possible values are Default, Original, Current, and Proposed.

[1491] GetChildRows

[1492] C public DataRow GetChildRows(string relationName, DataRowVersion version);

[1493] C public: DataRow* GetChildRows(String* relationName, DataRowVersion version) ;

[1494] VB Public Function GetChildRows(ByVal relationName As String, ByVal version As DataRowVersion) As DataRow( )

[1495] JScript public function GetChildRows(relationName : String, version: DataRowVersion) : DataRow ;

[1496] Description

[1497] Gets the specified version of the child rows of a System.Data.DataRow using the specified System.Data.DataRelation.RelationName of a System.Data.DataRelation, and System.Data.DataRowVersion.

[1498] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1499] In a System.Data.DataSet, the collection of all System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetChildRelations method. The System.Data.DataRelation.RelationName of the System.Data.DataRelation to use. One of the System.Data.DataRowVersion values specifying the version of the data to get. Possible values are Default, Original, Current, and Proposed.

[1500] GetColumnError

[1501] C public string GetColumnError(DataColumn column);

[1502] C public: String* GetColumnError(DataColumn* column);

[1503] VB Public Function GetColumnError(ByVal column As DataColumn) As String

[1504] JScript public function GetColumnError(column : DataColumn) : String;

[1505] Description

[1506] Gets the error description of the specified System.Data.DataColumn

[1507] Return Value: The text of the error description.

[1508] Use the System.Data.DataRow.SetColumnError(System.Int32,System.String) method to set column errors. A System.Data.DataColumn.

[1509] GetColumnError

[1510] C public string GetColumnError(int columnIndex);

[1511] C public: String* GetColumnError(int columnIndex);

[1512] VB Public Function GetColumnError(ByVal columnIndex As Integer) As String

[1513] JScript public function GetColumnError(columnIndex : int) : String; Gets the error description for a column.

[1514] Description

[1515] Gets the error description for the column specified by index.

[1516] Return Value: The text of the error description.

[1517] Use the System.Data.DataRow.SetColumnError(System.Int32,System.String) method to set column errors. The zero-based index of the column.

[1518] GetColumnError

[1519] C public string GetColumnError(string columnName);

[1520] C public: String* GetColumnError(String* columnName);

[1521] VB Public Function GetColumnError(ByVal columnName As String) As String

[1522] JScript public function GetColumnError(columnName : String) : String;

[1523] Description

[1524] Gets the error description for a column, specified by name.

[1525] Return Value: The text of the error description.

[1526] Use the System.Data.DataRow.SetColumnError(System.Int32,System.String) method to set column errors. The name of the column.

[1527] GetColumnsInError

[1528] C public DataColumn GetColumnsInError( );

[1529] C public: DataColumn* GetColumnsInError( ) ;

[1530] VB Public Function GetColumnsInError( ) As DataColumn( )

[1531] JScript public function GetColumnsInError( ) : DataColumn ;

[1532] Description

[1533] Gets an array of columns that have errors.

[1534] Return Value: An array of System.Data.DataColumn objects that contain errors.

[1535] The System.Data.DataRow.GetColumnsInError allows you to reduce the number of System.Data.DataColumn objects that must be processed for errors by returning only those columns that have an error. Errors can be set to individual columns with the System.Data.DataRow.SetColumnError(System.Int32, System.String) method. To further reduce the number of processing, check the System.Data.DataRow class's System.Data.DataRow.HasErrors property to first determine if a System.Data.DataRow has errors before invoking System.Data.DataRow.GetColumnsInError.

[1536] GetParentRow

[1537] C public DataRow GetParentRow(DataRelation relation);

[1538] C public: DataRow* GetParentRow(DataRelation* relation);

[1539] VB Public Function GetParentRow(ByVal relation As DataRelation) As DataRow

[1540] JScript public function GetParentRow(relation: DataRelation) : DataRow;

[1541] Description

[1542] Gets the parent row of a System.Data.DataRow using the specified System.Data.DataRelation.

[1543] Return Value: The parent System.Data.DataRow of the current row.

[1544] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation to use.

[1545] GetParentRow

[1546] C public DataRow GetParentRow(string relationName);

[1547] C public: DataRow* GetParentRow(String* relationName);

[1548] VB Public Function GetParentRow(ByVal relationName As String) As DataRow

[1549] JScript public function GetParentRow(relationName : String) : DataRow; Gets the parent row of a System.Data.DataRow

[1550] Description

[1551] Gets the parent row of a System.Data.DataRow using the specified System.Data.DataRelation.RelationName of a System.Data.DataRelation.

[1552] Return Value: The parent System.Data.DataRow of the current row.

[1553] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation.RelationName of a System.Data.DataRelation.

[1554] GetParentRow

[1555] C public DataRow GetParentRow(DataRelation relation, DataRowVersion version);

[1556] C public: DataRow* GetParentRow(DataRelation* relation, DataRowVersion version);

[1557] VB Public Function GetParentRow(ByVal relation As DataRelation, ByVal version As DataRowVersion) As DataRow

[1558] JScript public function GetParentRow(relation : DataRelation, version: DataRowVersion) : DataRow;

[1559] Description

[1560] Gets the parent row of a System.Data.DataRow using the specified System.Data.DataRelation, and System.Data.DataRowVersion.

[1561] Return Value: The parent System.Data.DataRow of the current row.

[1562] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation to use. One of the System.Data.DataRowVersion values specifying the version of the data to get.

[1563] GetParentRow

[1564] C public DataRow GetParentRow(string relationName, DataRowVersion version);

[1565] C public: DataRow* GetParentRow(String* relationName, DataRowVersion version);

[1566] VB Public Function GetParentRow(ByVal relationName As String, ByVal version As DataRowVersion) As DataRow

[1567] JScript public function GetParentRow(relationName : String, version: DataRowVersion) : DataRow;

[1568] Description

[1569] Gets the parent row of a System.Data.DataRow using the specified System.Data.DataRelation.RelationName of a System.Data.DataRelation, and System.Data.DataRowVersion.

[1570] Return Value: The parent System.Data.DataRow of the current row.

[1571] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation.RelationName of a System.Data.DataRelation. One of the System.Data.DataRowVersion values.

[1572] GetParentRows

[1573] C public DataRow GetParentRows(DataRelation relation);

[1574] C public: DataRow* GetParentRows(DataRelation* relation)

[1575] VB Public Function GetParentRows(ByVal relation As DataRelation) As DataRow( )

[1576] JScript public function GetParentRows(relation: DataRelation) : DataRow ; Gets the parent rows of a System.Data.DataRow.

[1577] Description

[1578] Gets the parent rows of a System.Data.DataRow using the specified System.Data.DataRelation.

[1579] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1580] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation to use.

[1581] GetParentRows

[1582] C public DataRow GetParentRows(string relationName);

[1583] C public: DataRow* GetParentRows(String* relationName) ;

[1584] VB Public Function GetParentRows(ByVal relationName As String) As DataRow( )

[1585] JScript public function GetParentRows(relationName : String) : DataRow ; Gets the parent rows of a System.Data.DataRow.

[1586] Description

[1587] Gets the parent rows of a System.Data.DataRow using the specified System.Data.DataRelation.RelationName of a System.Data.DataRelation.

[1588] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1589] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation.RelationName of a System.Data.DataRelation.

[1590] GetParentRows

[1591] C public DataRow GetParentRows(DataRelation relation, DataRowVersion version);

[1592] C public: DataRow* GetParentRows(DataRelation* relation, DataRowVersion version) ;

[1593] VB Public Function GetParentRows(ByVal relation As DataRelation, ByVal version As DataRowVersion) As DataRow( )

[1594] JScript public function GetParentRows(relation : DataRelation, version: DataRowVersion) : DataRow ;

[1595] Description

[1596] Gets the parent rows of a System.Data.DataRow using the specified System.Data.DataRelation, and System.Data.DataRowVersion.

[1597] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1598] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation to use. One of the System.Data.DataRowVersion values specifying the version of the data to get.

[1599] GetParentRows

[1600] C public DataRow GetParentRows(string relationName, DataRowVersion version);

[1601] C public: DataRow* GetParentRows(String* relationName, DataRowVersion version) ;

[1602] VB Public Function GetParentRows(ByVal relationName As String, ByVal version As DataRowVersion) As DataRow( )

[1603] JScript public function GetParentRows(relationName : String, version: DataRowVersion) : DataRow ;

[1604] Description

[1605] Gets the parent rows of a System.Data.DataRow using the specified System.Data.DataRelation.RelationName of a System.Data.DataRelation, and System.Data.DataRowVersion.

[1606] Return Value: An array of System.Data.DataRow objects (or an array of length zero).

[1607] In a System.Data.DataSet, the collection of all parent System.Data.DataRelation objects for the data set is returned by the System.Data.DataSet.GetParentRelations(System.Data.DataTable) method. The System.Data.DataRelation.RelationName of a System.Data.DataRelation. One of the System.Data.DataRowVersion values specifying the version of the data to get. Possible values are Default, Original, Current, and Proposed.

[1608] HasVersion

[1609] C public bool HasVersion(DataRowVersion version);

[1610] C public: bool HasVersion(DataRowVersion version);

[1611] VB Public Function HasVersion(ByVal version As DataRowVersion) As Boolean

[1612] JScript public function HasVersion(version: DataRowVersion) : Boolean;

[1613] Description

[1614] Gets a value indicating whether a specified version exists.

[1615] Return Value: true if the version exists; otherwise, false.

[1616] See the System.Data.DataRow.BeginEdit method for more details. One of the System.Data.DataRowVersion values that specifies the row version. Possible values are Default, Original, Current, and Proposed.

[1617] IsNull

[1618] C public bool IsNull(DataColumn column);

[1619] C public: bool IsNull(DataColumn* column);

[1620] VB Public Function IsNull(ByVal column As DataColumn) As Boolean

[1621] JScript public function IsNull(column : DataColumn) : Boolean;

[1622] Description

[1623] Gets a value indicating whether the specified System.Data.DataColumn contains a null value.

[1624] Return Value: true if the column contains a null value; otherwise, false. A System.Data.DataColumn. IsNull

[1625] C public bool IsNull(int columnIndex);

[1626] C public: bool IsNull(int columnIndex);

[1627] VB Public Function IsNull(ByVal columnIndex As Integer) As Boolean

[1628] JScript public function IsNull(columnIndex : int) :Boolean; Gets a value indicating whether the specified column contains a null value.

[1629] Description

[1630] Gets a value indicating whether the column at the specified index contains a null value.

[1631] Return Value: true if the column contains a null value; otherwise, false. The zero-based index of the column.

[1632] IsNull

[1633] C public bool IsNull(string columnName);

[1634] C public: bool IsNull(String* columnName);

[1635] VB Public Function IsNull(ByVal columnName As String) As Boolean

[1636] JScript public function IsNull(columnName : String) : Boolean;

[1637] Description

[1638] Gets a value indicating whether the named column contains a null value.

[1639] Return Value: true if the column contains a null value; otherwise, false. The name of the column.

[1640] IsNull

[1641] C public bool IsNull(DataColumn column, DataRowVersion version);

[1642] C public: bool IsNull(DataColumn* column, DataRowVersion version);

[1643] VB Public Function IsNull(ByVal column As DataColumn, ByVal version As DataRowVersion) As Boolean

[1644] JScript public function IsNull(column : DataColumn, version : DataRowVersion) : Boolean;

[1645] Description

[1646] Gets a value indicating whether the specified System.Data.DataColumn and System.Data.DataRowVersion contains a null value.

[1647] Return Value: true if the column contains a null value; otherwise, false. A System.Data.DataColumn. One of the System.Data.DataRowVersion values that specifies the row version. Possible values are Default, Original, Current, and Proposed.

[1648] RejectChanges

[1649] C public void RejectChanges( );

[1650] C public: void RejectChanges( );

[1651] VB Public Sub RejectChanges( )

[1652] JScript public function RejectChanges( );

[1653] Description

[1654] Rejects all changes made to the row since System.Data.DataRow.AcceptChanges was last called.

[1655] When calling the System.Data.DataRow.RejectChanges method, the System.Data.DataRow.CancelEdit method is implicitly called to cancel any edits. If System.Data.DataRow.RowState is Deleted or Modified, the row reverts to its previous values, and System.Data.DataRow.RowState becomes Unchanged. If the System.Data.DataRow.RowState is Added, the row is removed.

[1656] SetColumnError

[1657] C public void SetColumnError(DataColumn column, string error);

[1658] C public: void SetColumnError(DataColumn* column, String* error);

[1659] VB Public Sub SetColumnError(ByVal column As DataColumn, ByVal error As String)

[1660] JScript public function SetColumnError(column : DataColumn, error: String);

[1661] Description Sets the error description for a column specified as a System.Data.DataColumn.

[1662] To examine error descriptions, use the System.Data.DataRow.GetColumnError(System.Int32) method. The System.Data.DataColumn to set the error description for. The error description.

[1663] SetColumnError

[1664] C public void SetColumnError(int columnIndex, string error);

[1665] C public: void SetColumnError(int columnIndex, String* error);

[1666] VB Public Sub SetColumnError(ByVal columnIndex As Integer, ByVal error As String)

[1667] JScript public function SetColumnError(columnIndex : int, error: String); Sets the error description for a column.

[1668] Description

[1669] Sets the error description for a column specified by index.

[1670] The method is used to set custom error descriptions on specified columns. You can use the System.Windows.Forms.ErrorProvider control to display the text of the error, or through by other reporting mechanisms. The zero-.based index of the column. The error description.

[1671] SetColumnError

[1672] C public void SetColumnError(string columnName, string error);

[1673] C public: void SetColumnError(String* columnName, String* error);

[1674] VB Public Sub SetColumnError(ByVal columnName As String, ByVal error As String)

[1675] JScript public function SetColumnError(columnName : String, error: String);

[1676] Description

[1677] Sets the error description for a column specified by name.

[1678] The name of a column is set with the System.Data.DataColumn class's System.Data.DataColumn.ColumnName property. The name of the column. The error description.

[1679] SetNull

[1680] C protected void SetNull(DataColumn column);

[1681] C protected: void SetNull(DataColumn* column);

[1682] VB Protected Sub SetNull(ByVal column As DataColumn)

[1683] JScript protected function SetNull(column : DataColumn);

[1684] Description

[1685] Sets the the value of the specified System.Data.DataColumn to a null value.

[1686] Use the System.Data.DataRow.IsNull(System.Int32) method to determine if a column contains a null value. A System.Data.DataColumn.

[1687] SetParentRow

[1688] C public void SetParentRow(DataRow parentrow);

[1689] C public: void SetParentRow(DataRow* parentrow);

[1690] VB Public Sub SetParentRow(ByVal parentRow As DataRow)

[1691] JScript public function SetParentRow(parentRow : DataRow); Sets the parent row of a System.Data.DataRow.

[1692] Description

[1693] Sets the parent row of a System.Data.DataRow with specified new parent System.Data.DataRow. The new parent System.Data.DataRow

[1694] SetParentRow

[1695] C public void SetParentRow(DataRow parentRow, DataRelation relation);

[1696] C) public: void SetParentRow(DataRow* parentRow, DataRelation* relation);

[1697] VB Public Sub SetParentRow(ByVal parentRow As DataRow, ByVal relation As DataRelation)

[1698] JScript public function SetParentRow(parentRow : DataRow, relation: DataRelation);

[1699] Description Sets the parent row of a System.Data.DataRow with specified new parent System.Data.DataRow and System.Data.DataRelation.

[1700] Need explanation of why we do this. The following example sets the parent row of a given child row. The new parent System.Data.DataRow. The relation System.Data.DataRelation to use.

[1701] DataRowAction enumeration (System.Data)

[1702] ToString

[1703] Description

[1704] Describes the action taken on a System.Data.DataRow

[1705] Use the members of this enumeration to determine the action that has occurred on a System.Data.DataRow with respect to the System.Data.DataTable to which it belongs.

[1706] ToString

[1707] C public const DataRowAction Add; -1 C public: const DataRowAction Add;

[1708] VB Public Const Add As DataRowAction

[1709] JScript public var Add: DataRowAction;

[1710] Description

[1711] The row has been added to the table.

[1712] ToString

[1713] C public const DataRowAction Change;

[1714] C public: const DataRowAction Change; IVB Public Const Change As DataRowAction

[1715] JScript public var Change : DataRowAction;

[1716] Description

[1717] The row has changed.

[1718] ToString

[1719] C public const DataRowAction Commit;

[1720] C public: const DataRowAction Commit;

[1721] VB Public Const Commit As DataRowAction

[1722] JScript public var Commit: DataRowAction;

[1723] Description

[1724] The row has been committed.

[1725] ToString

[1726] C public const DataRowAction Delete;

[1727] C public: const DataRowAction Delete;

[1728] VB Public Const Delete As DataRowAction

[1729] JScript public var Delete: DataRowAction;

[1730] Description

[1731] The row was deleted from the table.

[1732] ToString

[1733] C public const DataRowAction Nothing;

[1734] C public: const DataRowAction Nothing;

[1735] VB Public Const Nothing As DataRowAction

[1736] JScript public var Nothing: DataRowAction;

[1737] Description

[1738] The row has not changed.

[1739] ToString

[1740] C public const DataRowAction Rollback;

[1741] C public: const DataRowAction Rollback;

[1742] VB Public Const Rollback As DataRowAction

[1743] JScript public var Rollback: DataRowAction;

[1744] Description

[1745] The change has been rolled back.

[1746] DataRowBuilder class (System.Data)

[1747] ToString

[1748] Description

[1749] DataRowChangeEventArgs class (System.Data)

[1750] ToString

[1751] Description

[1752] Provides data for the System.Data.DataTable.RowChanged, System.Data.DataTable.RowChanging, System.Data.DataTable.OnRowDeleting(System.Data.DataRowChangeEvent Args), and System.Data.DataTable.OnRowDeleted(System.Data.DataRowChangeEvent Args) events.

[1753] The System.Data.DataTable.RowChanged, System.Data.DataTable.RowChanged, System.Data.DataTable.RowChanged, and System.Data.DataTable.RowChanged events occur when an action is performed on a System.Data.DataRow

[1754] DataRowChangeEventArgs

[1755] Example Syntax:

[1756] ToString

[1757] C public DataRowCangeEventArgs(DataRow row, DataRowAction action);

[1758] C public: DataRowChangeEventArgs(DataRow* row, DataRowAction action);

[1759] VB Public Sub New(ByVal row As DataRow, ByVal action As DataRowAction)

[1760] JScript public function DataRowChangeEventArgs(row : DataRow, action: DataRowAction);

[1761] Description

[1762] Initializes a new instance of the System.Data.DataRowChangeEventArgs class. The System.Data.DataRow upon which an action is occuring. One of the System.Data.DataRowAction values.

[1763] Action

[1764] ToString

[1765] C public DataRowAction Action get;

[1766] C public: _property DataRowAction get_Action( );

[1767] VB Public ReadOnly Property Action As DataRowAction

[1768] JScript public function get Action( ) : DataRowAction;

[1769] Description

[1770] Gets the action that has occurred on a System.Data.DataRow.

[1771] Row

[1772] ToString

[1773] C public DataRow Row get;

[1774] C public: property DataRow* get_Row( );

[1775] VB Public ReadOnly Property Row As DataRow

[1776] JScript public function get Row( ) : DataRow;

[1777] Description

[1778] Gets the row upon which an action has occurred.

[1779] DataRowChangeEventHandler delegate (System.Data)

[1780] ToString

[1781] Description

[1782] Represents the method that will handle the System.Data.DataTable.RowChanging, System.Data.DataTable.RowChanged, System.Data.DataTable.RowDeleting, and System.Data.DataTable.RowDeleted events of a System.Data.DataTable. The source of the event. A System.Data.DataRowChangeEventArgs that contains the event data.

[1783] When you create a System.Data.DataRowChangeEventHandler delegate, you identify the method that will handle the event. To associate the event with your event handler, add an instance of the delegate to the event. The event handler is called whenever the event occurs, until you remove the delegate. For more information about delegates, see.

[1784] DataRowCollection class (System.Data)

[1785] ToString

[1786] Description

[1787] Represents a collection of rows for a System.Data.DataTable.

[1788] The System.Data.DataRowCollection is a major component of the System.Data.DataTable. While the System.Data.DataColumnCollection defines the schema of the table, the System.Data.DataRowCollection contains the actual data for the table, where each System.Data.DataRow in the System.Data.DataRowCollection represents a single row.

[1789] Count

[1790] IsReadOnly

[1791] IsSynchronized

[1792] Item

[1793] ToString

[1794] Description

[1795] Gets the row at the specified index.

[1796] Use the System.Data.DataRowCollection.Contains(System.Object) method to determine if a given value exists in the key column of a row. The zerobased index of the row to return.

[1797] List

[1798] ToString

[1799] C protected override ArrayList List get;

[1800] C protected: Property virtual ArrayList* get List( );

[1801] VB Overrides Protected ReadOnly Property List As ArrayList

[1802] JScript protected function get List( ) : ArrayList;

[1803] Description

[1804] Gets the list of the collection items.

[1805] SyncRoot

[1806] Add

[1807] C public void Add(DataRow row);

[1808] C public: void Add(DataRow* row);

[1809] VB Public Sub Add(ByVal row As DataRow)

[1810] JScript public function Add(row : DataRow); Adds a System.Data.DataRow to the System.Data.DataRowCollection.

[1811] Description

[1812] Adds the specified System.Data.DataRow to the System.Data.DataRowCollection object.

[1813] To create a new System.Data.DataRow, you must use the System.Data.DataTable class's System.Data.DataTable.NewRow method. When you use the System.Data.DataTable.NewRow method, a new System.Data.DataRow object is returned using the schema of parent System.Data.DataTable. After you create the System.Data.DataRow object and set the values for each of its columns, use the System.Data.DataRowCollection.Add(System.Data.DataRow) method to add the object to the collection. The System.Data.DataRow to add.

[1814] Add

[1815] C public virtual DataRow Add(object values);

[1816] C public: virtual DataRow* Add(Object* values_gc );

[1817] VB Overridable Public Function Add(ByVal values( ) As Object) As DataRow

[1818] JScript public function Add(values : Object ) : DataRow;

[1819] Description

[1820] Creates a row using specified values and adds it to the System.Data.DataRowCollection.

[1821] If a System.Data.DataColumn object has its System.Data.DataColumn.AutoIncrement set to True, System.Object.Empty should be passed to get the default value for that column. The array of values that are used to create the new row.

[1822] Clear

[1823] C public void Clear( );

[1824] C public: void Clear( );

[1825] VB Public Sub Clear( )

[1826] JScript public function Clear( );

[1827] Description

[1828] Clears the collection of all rows.

[1829] To add a row to the collection, first use the System.Data.DataTable class's System.Data.DataTable.NewRow method to create the new row. Then add the new row using the System.Data.DataRowCollection.Add(System.Data.DataRow) method of the System.Data.DataRowCollection class.

[1830] Contains

[1831] C public bool Contains(object key);

[1832] C public: bool Contains(Object* key);

[1833] VB Public Function Contains(ByVal key As Object) As Boolean

[1834] JScript public function Contains(key : Object) : Boolean; Gets a value indicating whether any row in the collection contains a specified value in the primary key or keys column.

[1835] Description

[1836] Gets a value indicating whether the primary key of any row in the collection contains the specified value.

[1837] Return Value: true if the collection contains a System.Data.DataRow with the specified primary key value; otherwise, false.

[1838] To use the System.Data.DataRowCollection.Contains(System.Object) method, the System.Data.DataTable object to which the System.Data.DataRowCollection object belongs to must have at least one column designated as a primary key column. See the System.Data.DataTable.PrimaryKey property for details on creating a primary key column. The value of the primary key to test for.

[1839] Contains

[1840] C public bool Contains(object keys);

[1841] C public: bool Contains(Object* keys_gc );

[1842] VB Public Function Contains(ByVal keys( ) As Object) As Boolean is JScript public function Contains(keys : Object ) :Boolean;

[1843] Description

[1844] Gets a value indicating if the System.Data.DataRow with the specified primary key values exists.

[1845] Return Value: true if the System.Data.DataRowCollection contains a System.Data.DataRow with the specified key values; otherwise, false.

[1846] To use the System.Data.DataRowCollection.Contains(System.Object) method with an array of values, the System.Data.DataTable object to which the System.Data.DataRowCollection object belongs must have at an array of columns designated as a primary keys. See the System.Data.DataTable.PrimaryKey property for details on creating an array of primary key columns. The number of array elements must correspond to the number of primary key columns in the System.Data.DataTable. An array of primary key values to test for.

[1847] Find

[1848] C public DataRow Find(object key);

[1849] C public: DataRow* Find(Object* key);

[1850] VB Public Function Find(ByVal key As Object) As DataRow

[1851] JScript public function Find(key : Object) : DataRow; Gets a specified System.Data.DataRow.

[1852] Description

[1853] Gets the row specified by the primary key value.

[1854] Return Value: A System.Data.DataRow containing the primary key value specified; otherwise a null value if the primary key value does not exist in the System.Data.DataRowCollection.

[1855] To use the System.Data.DataRowCollection.Contains(System.Object) method, the System.Data.DataTable object to which the System.Data.DataRowCollection object belongs to must have at least one column designated as a primary key column. See the System.Data.DataTable.PrimaryKey property for details on creating a primary key column. The primary key value of the System.Data.DataRow to find.

[1856] Find

[1857] C public DataRow Find(object keys);

[1858] C public: DataRow* Find(Object* keys _gc );

[1859] VB Public Function Find(ByVal keys( ) As Object) As DataRow

[1860] JScript public function Find(keys: Object ) : DataRow;

[1861] Description

[1862] Gets the row containing the specified primary key values.

[1863] Return Value: An array of System.Data.DataRow objects containing the primary key values specified; otherwise a null value if the primary key values do not exist in the System.Data.DataRowCollection.

[1864] To use the System.Data.DataRowCollection.Find(System.Object) method, the System.Data.DataTable object to which the System.Data.DataRowCollection object belongs to must have at least one column designated as a primary key column. See the System.Data.DataTable.PrimaryKey property for details on creating a System.Data.DataTable.PrimaryKey column, or an array of System.Data.DataColumn objects when the table has more than one primary key. An array of primary key values to find. The type of the array is Object.

[1865] InsertAt

[1866] C public void InsertAt(DataRow row, int pos);

[1867] C public: void InsertAt(DataRow* row, int pos);

[1868] VB Public Sub InsertAt(ByVal row As DataRow, ByVal pos As Integer)

[1869] JScript public function InsertAt(row : DataRow, pos: int);

[1870] Description

[1871] Remove

[1872] C public void Remove(DataRow row);

[1873] C public: void Remove(DataRow* row);

[1874] VB Public Sub Remove(ByVal row As DataRow)

[1875] JScript public function Remove(row : DataRow); Removes a specific row from the System.Data.DataRowCollection.

[1876] Description

[1877] Removes the specified System.Data.DataRow from the collection.

[1878] When a row is removed, data in that row is lost. You can also call the System.Data.DataRow class's System.Data.DataRow.Delete method to simply mark a row for removal. The row is not actually removed until the System.Data.DataRow.AcceptChanges method is invoked. The System.Data.DataRow to remove.

[1879] RemoveAt

[1880] C public void RemoveAt(int index);

[1881] C public: void RemoveAt(int index);

[1882] VB Public Sub RemoveAt(ByVal index As Integer)

[1883] JScript public function RemoveAt(index : int);

[1884] Description Removes the row with the specified index from the collection.

[1885] When a row is removed, data in that row is lost. You can also call the System.Data.DataRow class's System.Data.DataRow.Delete method to simply mark a row for removal. The row is not actually removed until the System.Data.DataRow.AcceptChanges method is invoked. The index of the row to remove.

[1886] DataRowState enumeration (System.Data)

[1887] ToString

[1888] Description

[1889] Gets the state of a System.Data.DataRow object.

[1890] The System.Data.DataRowState enumeration is returned by the System.Data.DataRow.RowState property of the System.Data.DataRow class.

[1891] ToString

[1892] C public const DataRowState Added;

[1893] C public: const DataRowState Added;

[1894] VB Public Const Added As DataRowState

[1895] JScript public var Added : DataRowState;

[1896] Description

[1897] The row has been added to a System.Data.DataRowCollection, and System.Data.DataRow.AcceptChanges has not been called.

[1898] ToString

[1899] C public const DataRowState Deleted;

[1900] C public: const DataRowState Deleted;

[1901] VB Public Const Deleted As DataRowState

[1902] JScript public var Deleted : DataRowState;

[1903] Description

[1904] The row was deleted using the System.Data.DataRow.Delete method of the System.Data.DataRow.

[1905] ToString

[1906] C public const DataRowState Detached;

[1907] C public: const DataRowState Detached;

[1908] VB Public Const Detached As DataRowState

[1909] JScript public var Detached : DataRowState;

[1910] Description

[1911] The row has been created but is not part of any System.Data.DataRowCollection. A System.Data.DataRow is in this state immediately after it has been created and before it is added to a collection, or if it has been removed from a collection.

[1912] ToString

[1913] C public const DataRowState Modified;

[1914] C public: const DataRowState Modified;

[1915] VB Public Const Modified As DataRowState

[1916] JScript public var Modified : DataRowState;

[1917] Description

[1918] The row has been modified and System.Data.DataRow.AcceptChanges has not been called.

[1919] ToString

[1920] C public const DataRowState Unchanged;

[1921] C public: const DataRowState Unchanged;

[1922] VB Public Const Unchanged As DataRowState

[1923] JScript public var Unchanged : DataRowState;

[1924] Description

[1925] The row has not changed since System.Data.DataRow.AcceptChanges was last called.

[1926] DataRowVersion enumeration (System.Data)

[1927] ToString

[1928] Description

[1929] Describes the version of a System.Data.DataRow.

[1930] The System.Data.DataRowVersion values are used when retrieving the value found in a System.Data.DataRow using System.Data.DataRow.Item(System.Int32) or the System.Data.DataRow.GetChildRows(System.String) of the System.Data.DataRow object.

[1931] ToString

[1932] C public const DataRowVersion Current;

[1933] C public: const DataRowVersion Current;

[1934] VB Public Const Current As DataRowVersion

[1935] JScript public var Current : DataRowVersion;

[1936] Description

[1937] The row contains current values.

[1938] ToString

[1939] C public const DataRowVersion Default;

[1940] C public: const DataRowVersion Default;

[1941] VB Public Const Default As DataRowVersion

[1942] JScript public var Default : DataRowVersion;

[1943] Description

[1944] The row contains its default values.

[1945] ToString

[1946] C public const DataRowVersion Original;

[1947] C public: const DataRowVersion Original;

[1948] VB Public Const Original As DataRowVersion

[1949] JScript public var Original : DataRowVersion;

[1950] Description

[1951] The row contains its original values.

[1952] ToString

[1953] C public const DataRowVersion Proposed;

[1954] C public: const DataRowVersion Proposed;

[1955] VB Public Const Proposed As DataRowVersion

[1956] JScript public var Proposed : DataRowVersion;

[1957] Description

[1958] The row contains a proposed value. DataRowView class (System.Data)

[1959] ToString

[1960] Description

[1961] Represents a customized view of a System.Data.DataRow exposed as a fully featured Windows Forms control.

[1962] Whenever data is displayed (for example in a System.Windows.Forms.DataGrid control), only one version of each row can be displayed. The displayed row is a System.Data.DataRowView.

[1963] DataView

[1964] ToString

[1965] C public DataView DataView get;

[1966] C public: _property DataView* get_DataView( );

[1967] VB Public ReadOnly Property DataView As DataView

[1968] JScript public function get DataView( ) : DataView;

[1969] Description

[1970] Gets the System.Data.DataView to which this row belongs.

[1971] IsEdit

[1972] ToString

[1973] C public bool IsEdit get;

[1974] C public: _property bool get_IsEdit( );

[1975] VB Public ReadOnly Property IsEdit As Boolean

[1976] JScript public function get IsEdit( ) : Boolean;

[1977] Description

[1978] Indicates whether the row is in edit mode.

[1979] IsNew

[1980] ToString

[1981] C public bool IsNew get;

[1982] C public: _property bool get_IsNew( );

[1983] VB Public ReadOnly Property IsNew As Boolean

[1984] JScript public function get IsNew( ) : Boolean;

[1985] Description Indicates whether a System.Data.DataRowView is new.

[1986] Item

[1987] ToString

[1988] C public object thisstring property get; set;

[1989] C public: property Object* get_Item(String* property);public: _property ig void set_Item(String* property, Object*);

[1990] VB Public Default Property Item(ByVal property As String) As Object

[1991] JScript returnValue DataRowViewObject.Item(property); DataRowViewObject.Item(property) returnValue;

[1992] Description

[1993] Gets or sets a value in a specified column. String that contains the specified column.

[1994] Item

[1995] ToString

[1996] C public object thisint ndx get; set;

[1997] C public: property Object* get_Item(int ndx);public: _property void set_Item(int ndx, Object*);

[1998] VB Public Default Property Item(ByVal ndx As Integer) As Object

[1999] JScript returnValue DataRowViewObject.Item(ndx); DataRowViewObject.Item(ndx) returnValue; Gets or sets a value in a specified column.

[2000] Description

[2001] Gets or sets a value in a specified column. The specified column. Row

[2002] ToString

[2003] C public DataRow Row get;

[2004] C public: _property DataRow* get_Row( );

[2005] VB Public ReadOnly Property Row As DataRow

[2006] Script public function get Row( ) : DataRow;

[2007] Description

[2008] Gets the System.Data.DataRow being viewed.

[2009] RowVersion

[2010] ToString

[2011] C public DataRowVersion RowVersion get;

[2012] C public: Plroperty DataRowVersion get_RowVersion( );

[2013] VB Public ReadOnly Property RowVersion As DataRowVersion

[2014] JScript public function get RowVersion( ) : DataRowVersion;

[2015] Description

[2016] Gets the current version description of the System.Data.DataRow.

[2017] For more details, see System.Data.DataRowVersion.

[2018] BeginEdit

[2019] C public void BeginEdit( );

[2020] C public: _sealed void BeginEdit( );

[2021] VB NotOverridable Public Sub BeginEdit( )

[2022] JScript public function BeginEdit( );

[2023] Description

[2024] Begins an edit procedure.

[2025] The System.Data.DataRowView.BeginEdit method is identical to the System.Data.DataRow.BeginEdit method of the System.Data.DataRow. After calling System.Data.DataRowView.BeginEdit, any changes made to the System.Data.DataRowView can be rolled back by calling System.Data.DataRow.CancelEdit. Call the System.Data.DataRowView.BeginEdit method before allowing users to change row values. After values have been changed, you retrieve the new values by setting the System.Data.DataRowView.RowVersion to DataRowVersion.Proposed. Check the values with a business rule, and roll back the changes if needed by calling System.Data.DataRowView.CancelEdit, or call System.Data.DataRowView.EndEdit to accept the changes.

[2026] CancelEdit

[2027] C public void CancelEdit( );

[2028] C public: _sealed void CancelEdit( );

[2029] VB NotOverridable Public Sub CancelEdit( )

[2030] JScript public function CancelEdit( );

[2031] Description

[2032] Cancels an edit procedure.

[2033] After calling System.Data.DataRowView.CancelEdit, all changes to the row are rolled back. You can also roll back changes by calling System.Data.DataTable.RejectChanges on the parent System.Data.DataTable.

[2034] CreateChildView

[2035] C public DataView CreateChildView(DataRelation relation);

[2036] C public: DataView* CreateChildView(DataRelation* relation);

[2037] VB Public Function CreateChildView(ByVal relation As DataRelation) As DataView

[2038] JScript public function CreateChildView(relation : DataRelation) : DataView; Returns a System.Data.DataView for the child System.Data.DataTable.

[2039] Description

[2040] Returns a System.Data.DataView for the child System.Data.DataTable with the specified DataRelation. The System.Data.DataRelation object.

[2041] CreateChildView

[2042] C public DataView CreateChildView(string relationName);

[2043] C public: DataView* CreateChildView(String* relationNarne);

[2044] VB Public Function CreateChildView(ByVal relationName As String) As DataView

[2045] JScript public function CreateChildView(relationName : String) : DataView;

[2046] Description

[2047] Returns a System.Data.DataView for the child System.Data.DataTable with the specified DataRelation name. A string containing the System.Data.DataRelation name.

[2048] Delete

[2049] C public void Delete( );

[2050] C public: void Delete( );

[2051] VB Public Sub Delete( )

[2052] JScript public function Delete( );

[2053] Description

[2054] Deletes a row.

[2055] The row is not permanently deleted until System.Data.DataTable.AcceptChanges is invoked on the System.Data.DataTable that row belongs to.

[2056] EndEdit

[2057] C public void EndEdit( );

[2058] C public: _sealed void EndEdit( );

[2059] VB NotOverridable Public Sub EndEdit( )

[2060] JScript public function EndEdit( );

[2061] Description

[2062] Ends an edit procedure.

[2063] Equals

[2064] C public override bool Equals(object other);

[2065] C public: bool Equals(Object* other);

[2066] VB Overrides Public Function Equals(ByVal other As Object) As Boolean

[2067] JScript public override function Equals(other : Object) : Boolean;

[2068] Description

[2069] Gets a value indicating whether the current System.Data.DataRowView is identical to the specified object.

[2070] Return Value: true, if object is a System.Data.DataRowView and it returns the same row as the current System.Data.DataRowView; otherwise, false. An System.Object to be compared.

[2071] GetHashCode

[2072] C public override int GetHashCode( );

[2073] C public: int GetHashCode( );

[2074] VB Overrides Public Function GetHashCode( ) As Integer

[2075] JScript public override function GetHashCode( ) : int;

[2076] Description

[2077] Returns the hash code of the System.Data.DataRow object.

[2078] Return Value: A 32-bit signed integer hash code, one, which represents Boolean true if the value of this instance is nonzero; otherwise, the integer, zero, which represents Boolean false.

[2079] ICustomTypeDescriptor.GetAttributes

[2080] C AttributeCollection ICustomTypeDescriptor.GetAttributes( );

[2081] C AttributeCollection* ICustomTypeDescriptor::GetAttributes( );

[2082] VB Function GetAttributes( ) As AttributeCollection Implements CustomTypeDescriptor.GetAttributes

[2083] JScript function ICustomTypeDescriptor.GetAttributes( ) : AttributeCollection;

[2084] ICustomTypeDescriptor.GetClassName

[2085] C string ICustomTypeDescriptor.GetClassName( );

[2086] C String* ICustomTypeDescriptor::GetClassName( );

[2087] VB Function GetClassName( ) As String Implements ICustomTypeDescriptor.GetClassName

[2088] JScript function ICustomTypeDescriptor.GetClassName( ) : String;

[2089] ICustomTypeDescriptor.GetComponentName

[2090] C string ICustomTypeDescriptor.GetComponentName( );

[2091] C String* ICustomTypeDescriptor::GetComponentName( );

[2092] VB Function GetComponentName( ) As String Implements ICustomTypeDescriptor.GetComponentName

[2093] JScript function ICustomTypeDescriptor.GetComponentName( ) : String;

[2094] ICustomTypeDescriptor.GetConverter

[2095] C TypeConverter ICustomTypeDescriptor.GetConverter( );

[2096] C TypeConverter* ICustomTypeDescriptor::GetConverter( );

[2097] VB Function GetConverter( ) As TypeConverter Implements ICustomTypeDescriptor.GetConverter

[2098] JScript function ICustomTypeDescriptor.GetConverter( ) : TypeConverter;

[2099] ICustomTypeDescriptor.GetDefaultEvent

[2100] C EventDescriptor ICustomTypeDescriptor.GetDefaultEvent( );

[2101] C EventDescriptor* ICustomTypeDescriptor::GetDefaultEvent( );

[2102] VB Function GetDefaultEvent( ) As EventDescriptor Implements ICustomTypeDescriptor.GetDefaultEvent

[2103] JScript function ICustomTypeDescriptor.GetDefaultEvent( ) : EventDescriptor;

[2104] ICustomTypeDescriptor.GetDefaultProperty

[2105] C PropertyDescriptor ICustomTypeDescriptor.GetDefaultProperty( );

[2106] C PropertyDescriptor* ICustomTypeDescriptor::GetDefaultProperty( );

[2107] VB Function GetDefaultProperty( ) As PropertyDescriptor Implements ICustomTypeDescriptor.GetDefaultProperty

[2108] JScript function ICustomTypeDescriptor.GetDefaultProperty( ) : PropertyDescriptor;

[2109] ICustomTypeDescriptor.GetEditor

[2110] C object ICustomTypeDescriptor.GetEditor(Type editorBaseType);

[2111] C Object* ICustomTypeDescriptor::GetEditor(Type* editorBaseType);

[2112] VB Function GetEditor(ByVal editorBaseType As Type) As Object Implements ICustomTypeDescriptor.GetEditor

[2113] JScript function ICustomTypeDescriptor.GetEditor(editorBaseType: Type) : Object;

[2114] ICustomTypeDescriptor.GetEvents

[2115] C EventDescriptorCollection ICustomTypeDescriptor.GetEvents( );

[2116] C EventDescriptorCollection* ICustomTypeDescriptor::GetEvents( );

[2117] VB Function GetEvents(As EventDescriptorCollection Implements ICustomTypeDescriptor.GetEvents

[2118] JScript function ICustomTypeDescriptor.GetEvents( ) : EventDescriptorCollection;

[2119] ICustomTypeDescriptor. GetEvents

[2120] C EventDescriptorCollection ICustomTypeDescriptor.GetEvents(Attribute attributes);

[2121] C EventDescriptorCollection* ICustomTypeDescriptor::GetEvents(Attribute* attributes );

[2122] VB Function GetEvents(ByVal attributes( ) As Attribute) As EventDescriptorCollection Implements ICustomTypeDescriptor.GetEvents

[2123] JScript function ICustomTypeDescriptor.GetEvents(attributes Attribute ) : EventDescriptorCollection;

[2124] ICustomTypeDescriptor.GetProperties

[2125] C PropertyDescriptorCollection ICustomTypeDescriptor.GetProperties( );

[2126] C PropertyDescriptorCollection* ICustomTypeDescriptor::GetProperties( );

[2127] VB Function GetProperties( ) As PropertyDescriptorCollection Implements ICustomTypeDescriptor.GetProperties

[2128] JScript function ICustomTypeDescriptor.GetProperties( ) : PropertyDescriptorCollection;

[2129] ICustomTypeDescriptor.GetProperties

[2130] C PropertyDescriptorCollection ICustomTypeDescriptor.GetProperties(Attribute attributes);

[2131] C PropertyDescriptorCollection* ICustomTypeDescriptor::GetProperties(Attribute* attributes );

[2132] VB Function GetProperties(ByVal attributes( ) As Attribute) As PropertyDescriptorCollection Implements ICustomTypeDescriptor.GetProperties

[2133] JScript function ICustomTypeDescriptor.GetProperties(attributes : Attribute ) : PropertyDescriptorCollection;

[2134] ICustomTypeDescriptor.GetPropertyOwner

[2135] C object ICustomTypeDescriptor.GetPropertyOwner(PropertyDescriptor pd);

[2136] C Object* ICustomTypeDescriptor::GetPropertyOwner(PropertyDescriptor* pd);

[2137] VB Function GetPropertyOwner(ByVal pd As PropertyDescriptor) As Object Implements ICustomTypeDescriptor.GetPropertyOwner

[2138] JScript function ICustomTypeDescriptor.GetPropertyOwner(pd: PropertyDescriptor) Object;

[2139] DataSet class (System.Data)

[2140] ToString

[2141] Description

[2142] Represents an in-memory cache of data.

[2143] The System.Data.DataSet, which is an in-memory cache of data retrieved from a database, is a major component of the ADO.NET architecture. The System.Data.DataSet consists of a collection of System.Data.DataTable objects that you can relate to each other with System.Data.DataRelation objects. You can also enforce data integrity in the System.Data.DataSet by using the System.Data.UniqueConstraint and System.Data.ForeignKeyConstraint objects. For further details about working with System.Data.DataSet objects, see

[2144] DataSet

[2145] Example Syntax:

[2146] ToString

[2147] C public DataSet( );

[2148] C public: DataSet( );

[2149] VB Public Sub New( )

[2150] JScript public function DataSet( ); Initializes a new instance of the System.Data.DataSet class.

[2151] Description

[2152] Initializes a new instance of the System.Data.DataSet class.

[2153] This implementation of the System.Data.DataSet constructor takes no parameters, and creates a default name, NewDataSet, for the new instance.

[2154] DataSet

[2155] Example Syntax:

[2156] ToString

[2157] C public DataSet(string dataSetName);

[2158] C public: DataSet(Stning* dataSetName);

[2159] VB Public Sub New(ByVal dataSetName As String)

[2160] JScript public function DataSet(dataSetName : String);

[2161] Description

[2162] Initializes a new instance of a System.Data.DataSet class with the given name.

[2163] A name for the System.Data.DataSet is required to ensure that the XML representation of the System.Data.DataSet always has a name for the document element, which is the highest level element in a schema definition. The name of the System.Data.DataSet.

[2164] DataSet

[2165] Example Syntax:

[2166] ToString

[2167] C protected DataSet(SerializationInfo info, StreamingContext context);

[2168] C protected: DataSet(SerializationInfo* info, StreamingContext context);

[2169] VB Protected Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)

[2170] JScript protected function DataSet(info : SerializationInfo, context: StreamingContext);

[2171] Description

[2172] Initializes a new instance of the System.Data.DataSet class with the System.Runtime.Serialization.SerializationInfo and the System.Runtime.Serialization.StreamingContext.

[2173] This implemenation of the System.Data.DataSet constructor is required for System.Runtime.Serialization.ISerializable. The data needed to serialize or deserialize an object. The source and destination of a given serialized stream.

[2174] CaseSensitive

[2175] ToString

[2176] C public bool CaseSensitive get; set;

[2177] C public: property bool get_CaseSensitive( );public: property void set_CaseSensitive(bool);

[2178] VB Public Property CaseSensitive As Boolean

[2179] JScript public function get CaseSensitive( ) : Boolean; public function set CaseSensitive(Boolean);

[2180] Description

[2181] Gets or sets a value indicating whether string comparisons within System.Data.DataTable objects are case-sensitive.

[2182] The System.Data.DataSet.CaseSensitive property affects how sorting, searching, and filtering operations are performed on each System.Data.DataTable contained in a System.Data.DataSet when using the System.Data.DataTable.Select method.

[2183] Container

[2184] DataSetName

[2185] ToString

[2186] Description

[2187] Gets or sets the name of the current System.Data.DataSet.

[2188] DefaultViewManager

[2189] ToString

[2190] C public DataViewManager DefaultViewManager get;

[2191] C public: _property DataViewManager* get_DefaultViewManager( );

[2192] VB Public ReadOnly Property DefaultViewManager As DataViewManager

[2193] JScript public function get DefaultViewManager( ) : DataViewManager;

[2194] Description

[2195] Gets a custom view of the data contained by the System.Data.DataSet that allows filtering, searching, and navigating using a custom System.Data.DataViewManager.

[2196] The System.Data.DataViewManager returned by the System.Data.DataSet.DefaultViewManager property allows you to create custom settings for each System.Data.DataTable in the System.Data.DataSet. When you add System.Data.DataTable objects to the System.Data.DataTableCollection, each table is automatically configured to display rows according to the specified property settings of the System.Data.DataView, including sort order, filtering, and System.Data.DataViewRowState.

[2197] DesignMode

[2198] EnforceConstraints

[2199] ToString

[2200] Description

[2201] Gets or sets a value indicating whether constraint rules are followed when attempting any update operation.

[2202] See the System.Data.DataTable.Constraints property for more details.

[2203] Events

[2204] ExtendedProperties

[2205] ToString

[2206] Description

[2207] Gets the collection of custom user information.

[2208] The System.Data.DataSet.ExtendedProperties property allows you to store custom information with the object. For example, you may store a time when the data should be refreshed.

[2209] HasErrors

[2210] ToString

[2211] C public bool HasErrors get;

[2212] C public: property bool get_HasErrors( );

[2213] VB Public ReadOnly Property HasErrors As Boolean

[2214] JScript public function get HasErrors( ) : Boolean;

[2215] Description

[2216] Gets a value indicating whether there are errors in any of the rows in any of the tables of this System.Data.DataSet.

[2217] The System.Data.DataSet.HasErrors property is usually consulted after creating using the System.Data.DataSet.GetChanges method. Check the System.Data.DataSet.HasErrors property of the System.Data.DataSet created with the System.Data.DataSet.GetChanges method to determine if any errors exists. If so, you should reconcile the errors before proceeding to update the data source with the changes.

[2218] Locale

[2219] ToString

[2220] C public CultureInfo Locale get; set;

[2221] C public: _property CultureInfo* get Locale( );public: _property void set_Locale(CultureInfo*);

[2222] VB Public Property Locale As CultureInfo

[2223] JScript public function get Locale( ): CultureInfo; public function set Locale(CultureInfo);

[2224] Description

[2225] Gets or sets the locale information used to compare strings within the table.

[2226] The System.Data.DataSet.Locale property specifies the locale for which sorting will apply.

[2227] Namespace

[2228] ToString

[2229] C public string Namespace get; set;

[2230] C public: _property String* get_Namespace( );public: _property void

[2231] set_Namespace(String*);

[2232] VB Public Property Namespace As String

[2233] JScript public function get Namespace( ) : String; public function set Namespace(String);

[2234] Description

[2235] Gets or sets the namespace of the System.Data.DataSet

[2236] The System.Data.DataSet.Namespace property is used when reading and writing an XML document into the System.Data.DataSet using the System.Data.DataSet.ReadXml(System.Xml.XmlReader), System.Data.DataSet.WriteXml(System.IO.Stream), System.Data.DataSet.ReadXmlSchema(System.Xml.XmlReader), or System.Data.DataSet.WriteXmlSchema(System.IO.Stream) methods.

[2237] Prefix

[2238] ToString

[2239] C public string Prefix get; set;

[2240] C public: property String* get_Prefix( );public: property void set_Prefix(String*);

[2241] VB Public Property Prefix As String

[2242] JScript public function get Prefix( ) : String; public function set Prefix(String);

[2243] Description

[2244] Gets or sets an XML prefix that aliases the namespace of the System.Data.DataSet.

[2245] The System.Data.DataSet.Prefix is used throughout an XML document to identify elements which belong to the System.Data.DataSet object's namespace (as set by the System.Data.DataSet.Namespace property).

[2246] Relations

[2247] ToString

[2248] C public DataRelationCollection Relations get;

[2249] C public: _property DataRelationCollection* get_Relations( );

[2250] VB Public ReadOnly Property Relations As DataRelationCollection

[2251] JScript public function get Relations( ) : DataRelationCollection;

[2252] Description

[2253] Get the collection of relations that link tables and allow navigation from parent tables to child tables.

[2254] Site

[2255] ToString

[2256] C public override ISite Site get; set;

[2257] C public: _property virtual ISite* get Site( );public: _property virtual void set_Site(ISite*);

[2258] VB Overrides Public Property Site As ISite

[2259] JScript public function get Site( ) : ISite; public function set Site(ISite);

[2260] Description

[2261] Gets or sets an System.ComponentModel.ISite for the System.Data.DataSet.

[2262] Sites bind a System.ComponentModel.Component to a System.ComponentModel.Container and enable communication between them, as well as provide a way for the container to manage its components.

[2263] Tables

[2264] ToString

[2265] C public DataTableCollection Tables get;

[2266] C public: property DataTableCollection* get Tables( );

[2267] VB Public ReadOnly Property Tables As DataTableCollection

[2268] JScript public function get Tables( ) : DataTableCollection;

[2269] Description

[2270] Gets the collection of tables contained in the System.Data.DataSet

[2271] To add tables to the collection, use System.Data.DataTableCollection.Add(System.Data.DataTable) method of the System.Data.DataTableCollection. To remove tables, use the System.Data.DataTableCollection.Remove(System.Data.DataTable) method.

[2272] ToStnng

[2273] Description

[2274] Occurs when a target and source System.Data.DataRow have the same primary key value, and System.Data.DataSet.EnforceConstraints is set to true.

[2275] For more information about handling events, see.

[2276] AcceptChanges

[2277] C public void AcceptChanges( );

[2278] C public: void Acceptchanges( );

[2279] VB Public Sub AcceptChanges( )

[2280] JScript public function AcceptChanges( );

[2281] Description

[2282] Commits all the changes made to this System.Data.DataSet since it was loaded or the last time System.Data.DataSet.AcceptChanges was called.

[2283] Both the System.Data.DataRow and System.Data.DataTable classes also have System.Data.DataSet.AcceptChanges methods. Invoking System.Data.DataSet.AcceptChanges on the System.Data.DataSet causes System.Data.DataTable.AcceptChanges to be called on each table in a System.Data.DataSet. Consequently, calling System.Data.DataTable.AcceptChanges on each System.Data.DataTable causes each System.Data.DataRow object's System.Data.DataRow.AcceptChanges method to be called. In this manner, you have multiple levels at which the method can be invoked. Calling the System.Data.DataSet.AcceptChanges of the System.Data.DataSet however, allows you to invoke the method on all subordinate objects (for example, tables and rows) with one call.

[2284] BeginInit

[2285] C public void BeginInit( );

[2286] C public: _sealed void BeginInit( );

[2287] VB NotOverridable Public Sub BeginInit( )

[2288] JScript public function Beginnit( );

[2289] Description

[2290] Begins the initialization of a System.Data.DataSet that is used on a form or used by another component. The initialization occurs at runtime.

[2291] The Visual Studio.NET design environment uses this method to start the initialization of a component that is used on a form or used by another component. The System.Data.DataSet.Endlnit method ends the initialization. Using the BeginInit and Endlnit methods prevents the control from being used before it is fully initialized.

[2292] Clear

[2293] C public void Clear( );

[2294] C public: void Clear( );

[2295] VB Public Sub Clear( )

[2296] JScript public function Clear( );

[2297] Description

[2298] Clears the System.Data.DataSet of any data by removing all rows in all tables. Clone

[2299] C public DataSet Clone( );

[2300] C public: DataSet* Clone( );

[2301] VB Public Function Clone( ) As DataSet

[2302] JScript public function Clone( ) : DataSet;

[2303] Description

[2304] Clones the structure of the System.Data.DataSet, including all System.Data.DataTable schemas, relations, and constraints.

[2305] Return Value: A new System.Data.DataSet with the same schema as the current System.Data.DataSet.

[2306] If these classes have been subclassed, the clone will also be of the same subclasses.

[2307] Copy

[2308] C public DataSet Copy( );

[2309] C public: DataSet* Copy( );

[2310] VB Public Function Copy( ) As DataSet

[2311] JScript public function Copy( ) : DataSet;

[2312] Description

[2313] Copies both the structure and data for this System.Data.DataSet.

[2314] Return Value: A new System.Data.DataSet with the same structure Stable schemas, relations, and constraints) and data as this System.Data.DataSet.

[2315] EndInit

[2316] C public void EndInit( );

[2317] C public: _sealed void EndInit( );

[2318] VB NotOverridable Public Sub EndInit( )

[2319] JScript public function EndInit( );

[2320] Description

[2321] Ends the initialization of a System.Data.DataSet that is used on a form or used by another component. The initialization occurs at runtime.

[2322] The Visual Studio.NET design environment uses this method to end the initialization of a component that is used on a form or used by another component. The System.Data.DataSet.BeginInit method starts the initialization. Using the BeginInit and EndInit methods prevents the control from being used before it is fully initialized.

[2323] GetChanges

[2324] C public DataSet GetChanges( );

[2325] C public: DataSet* GetChanges( );

[2326] VB Public Function GetChanges( ) As DataSet

[2327] JScript public function GetChanges( ) : DataSet; Gets a copy of the System.Data.DataSet containing all changes made to it since it was last loaded, or since System.Data.DataSet.AcceptChanges was called.

[2328] Description

[2329] Gets a copy of the System.Data.DataSet that contains all changes made to it since it was loaded or System.Data.DataSet.AcceptChanges was last called.

[2330] Return Value: A copy of the changes from this System.Data.DataSet that can have actions performed on it and subsequently be merged back in using System.Data.DataSet.Merge(System.Data.DataSet), or null if none are found.

[2331] Gets a copy of the System.Data.DataSet that contains all changes made to it since it was loaded or System.Data.DataSet.AcceptChanges was last called. This copy is particularly designed so that it can be merged back in to this original System.Data.DataSet. Relationship constraints may cause Unchanged parent rows to be included. If no rows of these rowStates are found, this method returns null.

[2332] GetChanges

[2333] C public DataSet GetChanges(DataRowState rowstates); at C public: DataSet* GetChanges(DataRowState rowStates);

[2334] VB Public Function GetChanges(ByVal rowStates As DataRowState) As DataSet

[2335] JScript public function GetChanges(rowStates : DataRowState) : DataSet;

[2336] Description

[2337] Gets a copy of the System.Data.DataSet containing all changes made to it since it was last loaded, or since System.Data.DataSet.AcceptChanges was called, filtered by System.Data.DataRowState.

[2338] Return Value: A filtered copy of the System.Data.DataSet that can have actions performed on it, and subsequently be merged back in using System.Data.DataSet.Merge(System.Data.DataSet). If no rows of the desired System.Data.DataRowState are found, the method returns null.

[2339] The System.Data.DataSet.GetChanges method is used to produce a second System.Data.DataSet object which contains only the changes introduced into the original. Use the rowStates argument to specify the type of changes the new object should include. One of the System.Data.DataRowState values.

[2340] GetNestedChanges

[2341] C public DataSet GetNestedChanges(DataRowState rowStates);

[2342] C public: DataSet* GetNestedChanges(DataRow State rowStates);

[2343] VB Public Function GetNestedChanges(ByVal rowStates As DataRowState) As DataSet

[2344] JScript public function GetNestedChanges(rowStates : DataRowState) : DataSet;

[2345] Description

[2346] GetSchemaSerializable

[2347] C protected virtual XrnlSchema GetSchemaSerializable( );

[2348] C protected: virtual XmlSchema* GetSchemaSerializable( );

[2349] VB Overridable Protected Function GetSchemaSerializable( ) As XmSchema

[2350] JScript protected function GetSchemaSerializable( ) : XmlSchema;

[2351] Description

[2352] Retrieves an System.Xml.XmlTextReader for the implementation of IXmlSerializable.

[2353] Return Value: An System.Xml.XmlTextReader.

[2354] A user should not call System.Data.DataSet.GetSchemaSerializable directly.

[2355] GetSerializationData

[2356] C protected void GetSerializationData(SerializationInfo info, StreamingContext context);

[2357] C protected: void GetSerializationData(SerializationInfo* info, StreamingContext context);

[2358] VB Protected Sub GetSerializationData(ByVal info As SerializationInfo, ByVal context As StreamingContext)

[2359] JScript protected function GetSerializationData(info : SerializationInfo, context: StreamingContext);

[2360] Description

[2361] Retrieves System.Runtime.Serialization.SerializationInfo and System.Runtime.Serialization.StreamingContext information for the implementation of IXmlSerializable.

[2362] Return Value: System.Runtime.Serialization.SerializationInfo and System.Runtime.Serialization.StreamingContext information.

[2363] A user should not call System.Data.DataSet.GetSerializationData(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext) directly. The data needed to serialize or deserialize an object. The source and destination of a given serialized stream.

[2364] GetXml

[2365] C public string GetXml( );

[2366] C public: String* GetXml( );

[2367] VB Public Function GetXml( ) As String

[2368] JScript public function GetXml( ) : String;

[2369] Description

[2370] Returns the XML representation of the data stored in the System.Data.DataSet.

[2371] Return Value: String that is a representation of the data stored in the System.Data.DataSet.

[2372] If the System.Data.DataSet has changes, calling this method is identical to calling System.Data.DataSet.WriteXml(System.IO.Stream) with XmlWriteMode set to DiffGram ; otherwise it is equivalent to calling System.Data.DataSet.WriteXml(System.IO.Stream) with XmlWriteMode set to IgnoreSchema.

[2373] GetXmlSchema

[2374] C public string GetXmlSchema( );

[2375] C public: String* GetXmlSchema( );

[2376] VB Public Function GetXmlSchema( ) As String

[2377] JScript public function GetXmlSchema( ) : String;

[2378] Description

[2379] Returns the XSD schema for the XML representation of the data stored in the System.Data.DataSet.

[2380] Return Value: String that is the XSD schema for the XML representation of the data stored in the System.Data.DataSet.

[2381] Calling this method is identical to calling System.Data.DataSet.WriteXmlSchema(System.IO.Stream), except that only the primary schema is written.

[2382] HasChanges

[2383] C public bool HasChanges( );

[2384] C public: bool HasChanges( );

[2385] VB Public Function HasChanges( ) As Boolean

[2386] JScript public function HasChanges( ) : Boolean; Gets a value indicating whether the System.Data.DataSet has changes, including new, deleted, or modified rows.

[2387] Description

[2388] Gets a value indicating whether the System.Data.DataSet has changes, including new, deleted, or modified rows.

[2389] Return Value: true, if the System.Data.DataSet has changes; otherwise, false HasChanges

[2390] C public bool HasChanges(DataRowState rowStates);

[2391] C public: bool HasChanges(DataRowState rowStates);

[2392] VB Public Function HasChanges(ByVal rowStates As DataRowState) As Boolean

[2393] JScript public function HasChanges(rowStates : DataRowState) : Boolean;

[2394] Description

[2395] Gets a value indicating whether the System.Data.DataSet has changes, including new, deleted, or modified rows, filtered by System.Data.DataRowState

[2396] Return Value: true, if the System.Data.DataSet has changes; otherwise, false.

[2397] Examine the System.Data.DataSet.HasChanges property before invoking System.Data.DataSet.GetChanges method. One of the System.Data.DataRowState values.

[2398] InferXmlSchema

[2399] C public void InferXmlSchema(Stream stream, string nsArray);

[2400] C public: void InferXmlSchema(Stream* stream, String* nsArra:i_gc );

[2401] VB Public Sub InferXmlSchema(ByVal stream As Stream, ByVal nsArray( ) As String)

[2402] JScript public function InferXmlSchema(stream: Stream, nsArray : String );

[2403] Description

[2404] Infers the XML schema from the specified System.IO.TextReader into the System.Data.DataSet. The System.IO.Stream from which to read. An array of namespace URI strings to be excluded from schema inference.

[2405] InferXmlSchema

[2406] C public void InferXmlSchema(string fileName, string nsArray);

[2407] C public: void InferXmlSchema(String* fileName, String* nsArray _gc );

[2408] VB Public Sub InferXmlSchema(ByVal fileName As String, ByVal nsArray( ) As String)

[2409] JScript public function InferXmlSchema(fileName : String, nsArray : String );

[2410] Description

[2411] Infers the XML schema from the specified file into the System.Data.DataSet. The file name (including the path) from which to read. An array of namespace URI strings to be excluded from schema inference.

[2412] InferXmlSchema

[2413] C public void InferXmlSchema(TextReader reader, string nsArray);

[2414] C public: void InferXmlSchema(TextReader* reader, String* nsArray _gC );

[2415] VB Public Sub InferXmlSchema(ByVal reader As TextReader, ByVal nsArray( ) As String)

[2416] JScript public function InferXmlSchema(reader: TextReader, nsArray: String );

[2417] Description

[2418] Infers the XML schema from the specified System.IO.TextReader into the System.Data.DataSet. The System.IO.TextReader from which to read. An array of namespace URI strings to be excluded from schema inference. InferXmlSchema

[2419] C public void InferXmlSchema(XmlReader reader, string nsArray);

[2420] C public: void InferXmlSchema(XmlReader* reader, String* nsarray _gc );

[2421] VB Public Sub InferXmlSchema(ByVal reader As XmlReader, ByVal nsArray( ) As String)

[2422] JScript public function InferXmlSchema(reader: XmlReader, nsArray: String ); Infers the XML schema from the specified System.IO.TextReader or file into the System.Data.DataSet.

[2423] Description

[2424] Infer the XML schema from the specified System.IO.TextReader into the System.Data.DataSet. The System.IO.TextReader from which to read. An array of namespace URI strings to be excluded from schema inference.

[2425] Merge

[2426] C public void Merge(DataRow rows);

[2427] C public: void Merge(DataRow* rows );

[2428] VB Public Sub Merge(ByVal rows( ) As DataRow)

[2429] JScript public function Merge(rows : DataRow );

[2430] Description

[2431] Merges this System.Data.DataSet with an array of System.Data.DataRow

[2432] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The array of System.Data.DataRow objects that will be merged into the System.Data.DataSet.

[2433] Merge

[2434] C public void Merge(DataSet dataSet);

[2435] C public: void Merge(DataSet* dataset);

[2436] VB Public Sub Merge(ByVal dataSet As DataSet)

[2437] JScript public function Merge(dataSet : DataSet); Merges this System.Data.DataSet with a specified System.Data.DataSet.

[2438] Description

[2439] Merges this System.Data.DataSet into a specified System.Data.DataSet.

[2440] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The System.Data.DataSet whose data and schema will be merged.

[2441] Merge

[2442] C public void Merge(DataTable table);

[2443] C public: void Merge(DataTable* table);

[2444] VB Public Sub Merge(ByVal table As DataTable)

[2445] JScript public function Merge(table : DataTable);

[2446] Description

[2447] Merges a System.Data.DataSet with a specified System.Data.DataTable.

[2448] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The System.Data.DataTable whose data and schema will be merged.

[2449] Merge

[2450] C public void Merge(DataSet dataSet, bool preserveChanges);

[2451] C public: void Merge(DataSet* dataSet, bool preservechanges);

[2452] VB Public Sub Merge(ByVal dataSet As DataSet, ByVal preserveChanges As Boolean)

[2453] JScript public function Merge(dataSet : DataSet, preserveChanges : Boolean);

[2454] Description

[2455] Merges this System.Data.DataSet with a specified System.Data.DataSet preserving changes according to the specified argument.

[2456] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The System.Data.DataSet whose data and schema will be merged. A value indicating whether changes made to the current System.Data.DataSet should be maintained.

[2457] Merge

[2458] C public void Merge(DataRow rows, bool preserveChanges, MissingSchemaAction missingSchemaAction);

[2459] C public: void Merge(DataRow* rows , bool preservechanges, MissingSchemaAction missingSchemaAction);

[2460] VB Public Sub Merge(ByVal rows( ) As DataRow, ByVal preserveChanges As Boolean, ByVal missingSchemaAction As MissingSchemaAction)

[2461] JScript public function Merge(rows : DataRow , preserveChanges: Boolean, missingSchemaAction: MissingSchemaAction);

[2462] Description

[2463] Merges this System.Data.DataSet with an array of System.Data.DataRow objects, preserving changes according to the specified argument, and handling an incompatible schema according to the specified argument.

[2464] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The array of System.Data.DataRow objects to merge with. true to preserve changes made to the System.Data.DataSet; otherwise, false. One of the System.Data.MissingSchemaAction values.

[2465] Merge

[2466] C public void Merge(DataSet dataSet, bool preserveChanges, MissingSchemaAction missingSchemaAction);

[2467] C public: void Merge(DataSet* dataSet, bool preservechanges, MissingSchemaAction missingSchemaAction);

[2468] VB Public Sub Merge(ByVal dataSet As DataSet, ByVal preserveClhanges As Boolean, ByVal missingSchemaAction As MissingSchemaAction)

[2469] JScript public function Merge(dataSet : DataSet, preserveChanges: Boolean, missingSchemaAction: MissingSchemaAction);

[2470] Description

[2471] Merges this System.Data.DataSet with a specified System.Data.DataSet preserving changes according to the specified argument, and handling an incompatible schema according to the specified argument.

[2472] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The System.Data.DataSet whose data and schema will be merged. A value indicating whether changes in the current (target) System.Data.DataSet should be maintained. One of the System.Data.MissingSchemaAction values. Merge

[2473] C public void Merge(DataTable table, bool preserveChanges, MissingSchemaAction missingSchemaAction);

[2474] C public: void Merge(DataTable* table, bool preserveChanges, MissingSchemaAction missingSchemaAction);

[2475] VB Public Sub Merge(ByVal table As DataTable, ByVal preserveChanges As Boolean, ByVal missingSchemaAction As MissingSchemaAction)

[2476] JScript public function Merge(table: DataTable, preserveChanges: Boolean, missingSchemaAction : MissiingSchemaAction);

[2477] Description

[2478] Merges this System.Data.DataTable with a specified System.Data.DataTable preserving changes according to the specified argument, and handling an incompatible schema according to the specified argument.

[2479] The System.Data.DataSet.Merge(System.Data.DataSet) method is used to merge two System.Data.DataSet objects that have largely similar schemas. A merge is typically used on a client application to incorporate the latest changes from a data source into an existing System.Data.DataSet. This allows the client application to have a refreshed System.Data.DataSet with the latest data from the data source. The System.Data.DataSet whose data and schema will be merged. Whether changes in the current (target) System.Data.DataSet should ibe maintained. One of the System.Data.MissingSchemaAction values.

[2480] OnPropertyChanging

[2481] C protected internal virtual void OnPropertyChanging(PropertyChangedEventArgs pcevent);

[2482] C protected public: virtual void OnPropertyChanging(PropertyChangedEventArgs* pcevent);

[2483] VB Overridable Protected Friend Dim Sub OnPropertyChanging(ByVal pcevent As PropertyChangedEventArgs)

[2484] JScript package function OnPropertyChanging(pcevent : PropertyChangedEventArgs);

[2485] Description

[2486] Raises the System.Data.DataSet.OnPropertyChanging(System.ComponentModel.Proper tyChangedEventArgs) event.

[2487] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.PropertyChangedEventArgs that contains the event data.

[2488] OnRemoveRelation

[2489] C protected virtual void OnRemoveRelation(DataRelation relation);

[2490] C protected: virtual void OnRemoveRelation(DataRelation* relation);

[2491] VB Overridable Protected Sub OnRemoveRelation(ByVal relation As DataRelation)

[2492] JScript protected function OnRemoveRelation(relation : DataRelation);

[2493] Description

[2494] This method should be overriden by subclasses to restrict tables being removed. The System.Data.DataRelation being removed.

[2495] OnRemoveTable

[2496] C protected virtual void OnRemoveTable(DataTable table);

[2497] C protected: virtual void OnRemoveTable(DataTable* table);

[2498] VB Overridable Protected Sub OnRemoveTable(ByVal table As DataTable)

[2499] JScript protected function OnRemoveTable(table : DataTable);

[2500] Description

[2501] Occurs when when a System.Data.DataTable is being removed.

[2502] This method can be overriden by subclasses to restrict tables from being removed. The System.Data.DataTable being removed.

[2503] RaisePropertyChanging

[2504] C protected internal void RaisePropertyChanging(string name);

[2505] C protected public: void RaisePropertyChanging(String* name);

[2506] VB Protected Friend Dim Sub RaisePropertyChanging(ByVal name As String)

[2507] JScript package function RaisePropertyChanging(name : String);

[2508] Description

[2509] Sends notification that the specified System.Data.DataSet property is about to change. The name of the property that is about to change.

[2510] ReadXml

[2511] C public XmlReadMode ReadXml(Stream stream);

[2512] C public: XmlReadMode ReadXml(Stream* stream);

[2513] VB Public Function ReadXml(ByVal stream As Stream) As XmlReadMode

[2514] JScript public function ReadXml(stream: Stream) : XmlReadMode;

[2515] Description

[2516] Reads XML schema and data into the System.Data.DataSet using the specified System.IO.Stream.

[2517] Use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method to read an XML document that includes both schema and data. An object that derives from System.IO.Stream.

[2518] ReadXml

[2519] C public XmlReadMode ReadXml(string fileName);

[2520] C public: XmlReadMode ReadXml(String* fileName);

[2521] VB Public Function ReadXml(ByVal fileName As String) As XmlReadMode

[2522] JScript public function ReadXml(fileName : String) : XmI ReadMode;

[2523] Description

[2524] Reads XML schema and data into the System.Data.DataSet using the specified file.

[2525] Use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method to read an XML document that includes both schema and data. The file name (including the path) from which to read.

[2526] ReadXml

[2527] C public XmlReadMode ReadXml(TextReader reader);

[2528] C public: XmlReadMode ReadXml(TextReader* reader);

[2529] VB Public Function ReadXml(ByVal reader As TextReader) As XmltReadMode

[2530] JScript public function ReadXml(reader: TextReader) : XmlReadMode;

[2531] Description

[2532] Reads XML schema and data into the System.Data.DataSet using the specified System.IO.TextReader.

[2533] Use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method to read an XML document that includes both schema and data. An object that derives from the System.IO.TextReader class.

[2534] ReadXml

[2535] C public XmlReadMode ReadXml(XmlReader reader);

[2536] C public: XmlReadMode ReadXml(XmlReader* reader);

[2537] VB Public Function ReadXml(ByVal reader As XmlReader) As XmlReadMode

[2538] JScript public function ReadXml(reader : XmlReader) : XmlReadMode; Reads XML schema and data into the System.Data.DataSet.

[2539] Description

[2540] Reads XML schema and data into the System.Data.DataSet using the specified System.Xml.XmlReader.

[2541] Use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method to read an XML document that includes both schema and data. The System.IO.TextReader from which to read. ReadXml

[2542] C public XmlReadMode ReadXml(Stream stream, XmlReadMode mode);

[2543] C public: YmlkeadMode ReadY-ml(Stream* stream, Y-mlReadMode mode);

[2544] VB Public Function ReadXml(ByVal stream As Stream, ByVal mode As. XmlReadMode) As XmlReadMode

[2545] JScript public function ReadXml(stream : Stream, mode : XmlRead.Mode) : XmlReadMode;

[2546] Description

[2547] Reads XML schema and data into the System.Data.DataSet using the specified System.IO.Stream and System.Data.XmlReadMode. The System.IO.Stream from which to read. One of the System.Data.XmlReadMode values. ReadXml

[2548] C public XmlReadMode ReadXml(string fileName, XmlReadMode mode);

[2549] C public: XmlReadMode ReadXml(String* fileName, XmlReadMode mode);

[2550] VB Public Function ReadXml(ByVal fileName As String, ByVal mode As XmlReadMode) As XmlReadMode

[2551] JScript public function ReadXml(fileName : String, mode : XmlReadMode) : XmlReadMode;

[2552] Description

[2553] Reads XML schema and data into the System.Data.DataSet using the specified file and System.Data.XmlReadMode. The file name (including the path) from which to read. One of the System.Data.XmlReadMode values.

[2554] ReadXml

[2555] C public XmlReadMode ReadXml(TextReader reader, XmlReadMode mode);

[2556] C public: XmlReadMode ReadXml(TextReader* reader, XmlReadMode mode);

[2557] VB Public Function ReadXml(ByVal reader As TextReader, ByVal mode As XmlReadMode) As XmlReadMode

[2558] JScript public function ReadXml(reader : TextReader, mode : XmlReadMode) XmlReadMode;

[2559] Description

[2560] Reads XML schema and data into the System.Data.DataSet using the specified System.IO.TextReader and System.Data.XmlReadMode. The System.IO.TextReader from which to read. One of the System.Data.XmlReadMode values.

[2561] ReadXml

[2562] C public XmlReadMode ReadXml(XmlReader reader, XmlReadMode mode);

[2563] C public: XmlReadMode ReadXml(XmlReader* reader, XmlReadMode mode);

[2564] VB Public Function ReadXml(ByVal reader As XmlReader, ByVal mode As XmlReadMode) As XmlReadMode

[2565] JScript public function ReadXml(reader : XmlReader, mode : XmlReadMode) : XmlReadMode; Writes the current schema and data for the System.Data.DataSet to an XML document using the specified System.Data.XmlReadMode.

[2566] Description

[2567] Writes schema and data for the DataSet. The System.IO.TextReader from which to read. One of the System.Data.XmlReadMode values.

[2568] ReadXmlSchema

[2569] C public void ReadXm.Schema(Stream stream);

[2570] C public: void ReadXmlSchema(Stream* stream);

[2571] VB Public Sub ReadXmlSchema(ByVal stream As Stream)

[2572] JScript public function ReadXmlSchema(stream : Stream);

[2573] Description

[2574] Reads the XML schema from the specified System.IO.Stream into the System.Data.DataSet.

[2575] Use the System.Data.DataSet.ReadXmlSchema(System.Xml.XmlReader) method to create the schema for a System.Data.DataSet. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. The System.IO.Stream from which to read.

[2576] ReadXmlSchema

[2577] C public void ReadXmlSchema(string fileName);

[2578] C public: void ReadXmlchema(String* fileName);

[2579] VB Public Sub ReadXmlSchema(ByVal fileName As String)

[2580] JScript public function ReadXmlSchema(fileName : String);

[2581] Description

[2582] Reads the XML schema from the specified file into the System.Data.DataSet.

[2583] Use the System.Data.DataSet.ReadXmlSchema(System.Xml.XmlReader) method to create the schema for a System.Data.DataSet. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. The file name (including the path) from which to read.

[2584] ReadXmlSchema

[2585] C public void ReadXmlSchema(TextReader reader);

[2586] C public: void ReadXmlSchema(TextReader* reader);

[2587] VB Public Sub ReadXmlSchema(ByVal reader As TextReader)

[2588] JScript public function ReadXmlSchema(reader : TextReader);

[2589] Description

[2590] Reads the XML schema from the specified System.IO.TextReader into the System.Data.DataSet.

[2591] Use the System.Data.DataSet.ReadXmlSchema(System.Xml.XmlReader) method to create the schema for a System.Data.DataSet. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. The System.IO.TextReader from which to read. ReadISchema

[2592] C public void ReadXmlSchema(XmlReader reader);

[2593] C public: void ReadXmlSchema(XrmlReader* reader);

[2594] VB Public Sub ReadXmISchema(ByVal reader As XmilReader)

[2595] JScript public function ReadXmlSchema(reader : XmlReader); Reads an XML schema into the System.Data.DataSet.

[2596] Description

[2597] Reads the XML schema from the specified System.Xmr.XmIReader into the System.Data.DataSet.

[2598] Use the System.Data.DataSet.ReadXmlSchema(System.Xml.XmIReader) method to create the schema for a System.Data.DataSet. The schema includes table, relation, and constraint definitions. The System.Xml.XmlReader from which to read.

[2599] ReadXmlSerializable

[2600] C protected virtual void ReadXmlSerializable(XmlReader reader);

[2601] C protected: virtual void ReadXmlSerializable(XmlReader* reader);

[2602] VB Overridable Protected Sub ReadXmlSerializable(ByVal reader As XmlReader)

[2603] JScript protected function ReadXmlSerializable(reader : XmlReader);

[2604] Description

[2605] Reads XML serialization information for the implementation of IXmlSerializable.

[2606] Return Value: An System.Xml.XmlTextReader object. A user should not call System.Data.DataSet.ReadXmlSerializable(System.Xml.XmlReader) directly. The System.Xml.XmlTextReader object.

[2607] RejectChanges

[2608] C public virtual void RejectChanges( );

[2609] C public: virtual void RejectChanges( );

[2610] VB Overridable Public Sub RejectChanges( )

[2611] JScript public function RejectChanges( );

[2612] Description

[2613] Rolls back all the changes made to the System.Data.DataSet since it was created, or since the last time System.Data.DataSet.AcceptChanges was called.

[2614] Invoke the System.Data.DataSet.RejectChanges to call the System.Data.DataTable.RejectChanges method on all System.Data.DataTable objects contained by the System.Data.DataSet. Additionally, any System.Data.Constraint rules contained by the System.Data.DataSet are enforced.

[2615] Reset

[2616] C public virtual void Reset( );

[2617] C public: virtual void Reset( );

[2618] VB Overridable Public Sub Reset( )

[2619] JScript public function Reset( );

[2620] Description

[2621] Resets the System.Data.DataSet to its original state. Subclasses should override System.Data.DataSet.Reset to restore a System.Data.DataSet to its original state.

[2622] ShouldSerializeRelations

[2623] C protected virtual bool ShouldSerializeRelations( );

[2624] C protected: virtual bool ShouldSerializeRelations( );

[2625] VB Overridable Protected Function ShouldSerializeRelations( ) As Boolean

[2626] JScript protected function ShouldSerializeRelations( ) : Boolean;

[2627] Description

[2628] Gets a value indicating whether System.Data.DataSet.Relatioins property should be persisted.

[2629] Return Value: true if the property value has been changed from its default; otherwise, false. You typically use this method if you are either creating a designer for the System.Data.DataSet, or creating your own control incorporating the System.Data.DataSet.

[2630] ShouldSerializeTables

[2631] C protected virtual bool ShouldSerializeTables( );

[2632] C protected: virtual bool ShouldSerializeTables( );

[2633] VB Overridable Protected Function ShouldSerializeTables( ) As Boolean

[2634] JScript protected function ShouldSerializeTables( ) : Boolean;

[2635] Description

[2636] Gets a value indicating whether System.Data.DataSet.Tables property should be persisted.

[2637] Return Value: true if the property value has been changed from its default; otherwise, false.

[2638] You typically use this method only if you are either creating a designer for the System.Data.DataSet, or creating your own control incorporating the System.Data.DataSet.

[2639] IListSource.GetList

[2640] C IList IListSource.GetList( );

[2641] C IList* IListSource::GetList( );

[2642] VB Function GetList( ) As IList Implements IListSource.GetList

[2643] JScript function IListSource.GetList( ) : IList;

[2644] ISerializable.GetObjectData

[2645] C void ISerializable.GetObjectData(SerializationInfo info, StreamingContext context);

[2646] C void ISerializable::GetObjectData(SerializationInfo* info, StreamingContext context);

[2647] VB Sub GetObjectData(ByVal info As SerializationInfo, ByVal context As StreamingContext) Implements ISerializable.GetObjectData

[2648] JScript function ISerializable.GetObjectData(info : SerializationInfo, context: StreamingContext);

[2649] IXmlSerializable.GetSchema

[2650] C XmlSchema IXmlSerializable.GetSchema( );

[2651] C XmlSchema* IXmlSerializable::GetSchema( );

[2652] VB Function GetSchema( ) As XmlSchema Implements IXmlSerializable.GetSchema

[2653] JScript function IXmlSerializable.GetSchema( ) : XmlSchema;

[2654] IXmlSerializable.ReadXml

[2655] C void IXmlSerializable.ReadXml(XmlReader reader);

[2656] C void IXmlSerializable::ReadXml(XmlReader* reader);

[2657] VB Sub ReadXml(ByVal reader As XmlReader) Implements IXmlSerializable.ReadXml

[2658] JScript function IXmlSerializable.ReadXml(reader : XmlReader);

[2659] IXmlSerializable.WriteXml

[2660] C void IXmlSerializable.WriteXml(XmlWriter writer);

[2661] C void IXmlSerializable::WriteXml(XmlWriter* writer);

[2662] VB Sub WriteXml(ByVal writer As XmlWriter) Implements IXmlSerializable.WriteXml

[2663] JScript function IXmlSerializable.WriteXml(writer: XmlWriter);

[2664] WriteXml

[2665] C public void WriteXml(Stream stream);

[2666] C public: void WriteXml(Stream* stream);

[2667] VB Public Sub WriteXml(ByVal stream As Stream)

[2668] JScript public function WriteXml(stream : Stream); Writes XML schema and data from the System.Data.DataSet.

[2669] Description

[2670] Writes the current schema and data for the System.Data.DataSet using the specified System.IO.Stream.

[2671] Use the System.Data.DataSet.WriteXml(System.IO.Stream) method to write an XML document that includes both schema and data of a System.Data.DataSet. To read an XML document, that includes schema and data, use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method. A System.IO.Stream object used to write to a file.

[2672] WriteXml

[2673] C public void WriteXml(string fileName);

[2674] C public: void WriteXmnl(String* fileName);

[2675] VB Public Sub WriteXml(ByVal fileName As String)

[2676] JScript public function WriteXml(fileName : String);

[2677] Description

[2678] Writes the current schema and data for the System.Data.DataSet to the specified file. The file name (including the path) to which to write.

[2679] WriteXml

[2680] C public void WriteXml(TextWriter writer);

[2681] C public: void WriteXml(TextWriter* writer);

[2682] VB Public Sub WriteXml(ByVal writer As TextWriter)

[2683] JScript public function WriteXml(writer : TextWriter);

[2684] Description

[2685] Writes the current schema and data for the System.Data.DataSet using the specified System.IO.TextWriter. The System.IO.TextWriter object with which to write.

[2686] WriteXml

[2687] C public void WrteXml(XmlWriter writer);

[2688] C public: void WriteXml(XmlWriter* writer);

[2689] VB Public Sub WriteXml(ByVal writer As XmlWriter)

[2690] JScript public function WriteXml(writer : XmlWriter);

[2691] Description

[2692] Writes the current schema and data for the System.Data.DataSet to the specified System.Xml.XmlWriter. The System.Xml.XmlWriter with which to write.

[2693] WriteXml

[2694] C public void WriteXml(Stream stream, XmlWriteMode mode);

[2695] C public: void WriteXml(Stream* stream, XmlWriteMode mode);

[2696] VB Public Sub WriteXml(ByVal stream As Stream, ByVal mode As XmlWriteMode)

[2697] JScript public function WriteXml(stream : Stream, mode : XmlWriteMode);

[2698] Description

[2699] Writes the current schema and data for the System.Data.DataSet using the specified System.IO.Stream and System.Data.XmlWriteMode. A System.IO.Stream object used to write to a file. One of the System.Data.XmlWriteMode values.

[2700] WriteXml

[2701] C public void Writexml(string fileName, XmlWriteMode mode);

[2702] C public: void WriteXml(string* fileName, XmlWriteMode mode);

[2703] VB Public Sub WriteXml(ByVal fileName As String, ByVal mode As XmlWriteMode)

[2704] JScript public function WriteXml(fileName : String, mode : XmlWriteMode);

[2705] Description

[2706] Writes the current schema and data for the System.Data.DataSet to the specified file using the specified System.Data.XmlWriteMode.

[2707] Use the System.Data.DataSet.WriteXml(System.IO.Stream)g method to write an XML document that includes both schema and data of a System.Data.DataSet. To read an XML document, that includes schema and data, use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method. The file name (including the path) to which to write. One of the System.Data.XmlWriteMode values.

[2708] WriteXml

[2709] C public void WriteXml(TextWriter writer, XmlWriteMode mode);

[2710] C public: void WriteXml(TextWriter* writer, XmlWriteMode mode);

[2711] VB Public Sub WriteXml(ByVal writer As TextWriter, ByVal mode As XmlWriteMode)

[2712] JScript public function WriteXml(writer : TextWriter, mode : XmlWriteMode);

[2713] Description

[2714] Writes the current schema and data for the System.Data.DataSet using the specified System.IO.TextWriter and System.Data.XmlWriteMode.

[2715] Use the System.Data.DataSet.WriteXml(System.IO.Stream) method to write an XML document that includes both schema and data of a System.Data.DataSet. To read an XML document, that includes schema and data, use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method. A System.IO.TextWriter object used to write the document. One of the System.Data.XmlWriteMode values.

[2716] WriteXml

[2717] C public void WriteXml(XmlWriter writer, XmlWriteMode mode);

[2718] C public: void WriteXml(XmlWriter* writer, XmlWriteMode mode);

[2719] VB Public Sub WriteXml(ByVal writer As XmlWriter, ByVal mode As XmlWriteMode)

[2720] JScript public function WriteXml(writer : XmlWriter, mode : XmlWriteMode);

[2721] Description

[2722] Writes the current schema and data for the System.Data.DataSet using the specified System.Xml.XmlWriter and System.Data.XmlWriteModie.

[2723] Use the System.Data.DataSet.WriteXml(System.IO.Stream) method to write an XML document that includes both schema and data of a System.Data.DataSet. To read an XML document, that includes schema and data, use the System.Data.DataSet.ReadXml(System.Xml.XmlReader) method. The System.Xml.XmlWriter with which to write. One of the System.Data.XmlWriteMode values.

[2724] WriteXmlSchema

[2725] C public void WriteXmlSchema(Stream stream);

[2726] C public: void WriteXmlSchema(Stream* stream);

[2727] VB Public Sub WriteXmlSchema(ByVal stream As Stream)

[2728] JScript public function WriteXmlSchema(stream : Stream); Writes the System.Data.DataSet structure as an XML schema.

[2729] Description

[2730] Writes the System.Data.DataSet structure as an XML schema to using the specified System.IO.Stream object.

[2731] Use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method to write the schema for a System.Data.DataSet to an XML document. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. A System.IO.Stream object used to write to a file.

[2732] WriteXmlSchema

[2733] C public void WriteXmlSchema(string fileName);

[2734] C public: void WriteXmlSchema(String* fileName);

[2735] VB Public Sub WriteXmlSchema(ByVal fileName As String)

[2736] JScript public function WriteXmlSchema(fileName : String);

[2737] Description

[2738] Writes the System.Data.DataSet structure as an XML schema to a file.

[2739] Use the System.Data.DataSet.WriteXmISchema(System.IO.Stream) method to write the schema for a System.Data.DataSet to an XML document. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. The file name (including the path) to which to write.

[2740] WriteXmlSchema

[2741] C, public void WriteXmISchema(TextWriter writer);

[2742] C public: void WriteXmlSchema(TextWriter* writer);

[2743] VB Public Sub WriteXmlSchema(ByVal writer As TextWriter)

[2744] JScript public function WriteXmlSchema(writer : TextWriter);

[2745] Description

[2746] Writes the System.Data.DataSet structure as an XML schema to a System.IO.TextWriter object.

[2747] Use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method to write the schema for a System.Data.DataSet to an XML document. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. The System.IO.TextWriter object with which to write.

[2748] WriteXmlSchema

[2749] C public void WriteXmlSchema(XmlWriter writer);

[2750] C public: void WriteXmlSchema(XmlWriter* writer);

[2751] VB Public Sub WriteXmlSchema(ByVal writer As XmlWriter)

[2752] JScript public function WriteXmlSchema(writer : XmlWriter);

[2753] Description

[2754] Writes the System.Data.DataSet structure as an XML schema to an System.Xml.XmlWriter object.

[2755] Use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method to write the schema for a System.Data.DataSet to an XML document. The schema includes table, relation, and constraint definitions. To write a schema to an XML document, use the System.Data.DataSet.WriteXmlSchema(System.IO.Stream) method. The System.Xml.XmlWriter with which to write.

[2756] DataSysDescriptionAttribute class (System.Data)

[2757] WriteXmlSchema

[2758] Description

[2759] DescriptionAttribute marks a property, event, or extender with a description. Visual designers can display this description when referencing the member.

[2760] DataSysDescriptionAttribute

[2761] Example Syntax:

[2762] WriteXmlSchema

[2763] C public DataSysDescriptionAttribute(string description);

[2764] C public: DataSysDescriptionAttribute(String* description);

[2765] VB Public Sub New(ByVal description As String)

[2766] JScript public function DataSysDescriptionAttribute(description: String);

[2767] Description

[2768] Constructs a new sys description. description text.

[2769] Description

[2770] WriteXmlSchema

[2771] C public override string Description get;

[2772] C public: _property virtual String* get Description( );

[2773] VB Overrides Public ReadOnly Property Description As String

[2774] JScript public function get Description( ) : String;

[2775] Description

[2776] Retrieves the description text.

[2777] Return Value: description Retrieves the description text.

[2778] DescriptionValue

[2779] TypeId

[2780] DataTable class (System.Data)

[2781] ToString

[2782] Description

[2783] Represents one table of in-memory data.

[2784] The System.Data.DataTable is a central object in the ADO.NET library. Other objects that use the System.Data.DataTable include the System.Data.DataSet and the System.Data.DataView.

[2785] ToString

[2786] C protected internal bool finitInProgress;

[2787] C protected public: bool finitInProgress;

[2788] VB Internal finitInProgress As Boolean

[2789] JScript package var finitInProgress: Boolean;

[2790] Description

[2791] DataTable

[2792] Example Syntax:

[2793] ToString

[2794] C public DataTable( );

[2795] C public: DataTable( );

[2796] VB Public Sub New( )

[2797] JScript public function DataTable( ); Initializes a new instance of the System.Data.DataTable class.

[2798] Description

[2799] Initializes a new instance of the System.Data.DataTable class with no arguments.

[2800] The constructor sets initial values for all properties of the System.Data.DataTable object. The following table shows the properties and their default values. When an instance System.Data.DataTable is created, the following read/write properties are set to initial values.

[2801] DataTable

[2802] Example Syntax:

[2803] ToString

[2804] C public DataTable(string tableName);

[2805] C public: DataTable(String* tableName);

[2806] VB Public Sub New(ByVal tableName As String)

[2807] JScript public function DataTable(tableName : String);

[2808] Description

[2809] Intitalizes a new instance of the System.Data.DataTable class with the specified table name. The name to give the table. If null or an empty string, a default name will be given when added to the System.Data.DataTableCollection.

[2810] DataTable

[2811] Example Syntax:

[2812] ToString

[2813] C protected DataTable(SerializationInfo info, StreamingContext context);

[2814] C protected: DataTable(SerializationInfo* info, StreamingContext context);

[2815] VB Protected Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)

[2816] JScript protected function DataTable(info : SerializationInfo, context: StreamingContext);

[2817] Description

[2818] Initializes a new instance of the System.Data.DataTable class with the System.Runtime.Serialization.SerializationInfo and the System.Runtime.Serialization.StreamingContext.

[2819] This implemenation of the System.Data.DataTable constructor is required for System.Runtime.Serialization.ISerializable. The data needed to serialize or deserialize an object. The source and destination of a given serialized stream.

[2820] CaseSensitive

[2821] ToString

[2822] C public bool CaseSensitive get; set;

[2823] C public: _property bool get_CaseSensitive( );public: _property void set_CaseSensitive(bool);

[2824] VB Public Property CaseSensitive As Boolean

[2825] JScript public function get CaseSensitive( ) : Boolean; public function set CaseSensitive(Boolean);

[2826] Description

[2827] Indicates whether string comparisons within the table are case-sensitive.

[2828] The System.Data.DataTable.CaseSensitive property affects string comparisons in sorting, searching, and filtering.

[2829] ChildRelations

[2830] ToString

[2831] C public DataRelationCollection ChildRelations get;

[2832] C public: _property DataRelationCollection* get ChildRelations( );

[2833] VB Public ReadOnly Property ChildRelations As DataRelationCollection

[2834] JScript public function get ChildRelations( ) : DataRelationCollection;

[2835] Description

[2836] Gets the collection of child relations for this System.Data.DataTable.

[2837] A System.Data.DataRelation defines the relationship between two tables. Typically, two tables are linked through a single field that contains the same data. For example, a table which contains address data may have a single field containing codes that represent countries/regions. A second table that contains country/region data will have a single field that contains the code that identifies the country/region, and it is this code which is inserted into the corresponding field in the first table. A System.Data.DataRelation, then, contains at least four pieces of information: (1) the name of the first table, (2) the column name in the first table, (3) the name of the second table, and (4) the column name in the second table.

[2838] Columns

[2839] ToString

[2840] C public DataColumnCollection Columns get;

[2841] C public: _property DataColumnCollection* get_Columns( );

[2842] VB Public ReadOnly Property Columns As DataColumnCollection

[2843] JScript public function get Columns( ) : DataColumnCollection;

[2844] Description

[2845] Gets the collection of columns that belong to this table.

[2846] The System.Data.DataColumnCollection determines the schema of a table by defining the data type of each column.

[2847] Constraints

[2848] ToString

[2849] C public ConstraintCollection Constraints get;

[2850] C public: _property ConstraintCollection* getConstraints( );

[2851] VB Public ReadOnly Property Constraints As ConstraintCollection

[2852] JScript public function get Constraints( ) : ConstraintCollection;

[2853] Description

[2854] Gets the collection of constraints maintained by this table.

[2855] A System.Data.ForeignKeyConstraint restricts the action performed when a value in a column (or columns) is either deleted or updated. Such a constraint is intended to be used with primary key columns. In a parent/child relationship between two tables, deleting a value from the parent table can affect the child rows in one of the following ways.

[2856] Container

[2857] DataSet

[2858] ToString

[2859] Description

[2860] Gets the System.Data.DataSet that this table belongs to.

[2861] If a control is data bound to a System.Data.DataTable, and the table belongs to a System.Data.DataSet, you can get to the System.Data. DataSet through this property.

[2862] DefaultView

[2863] ToString

[2864] C public DataView DefaultView get;

[2865] C public: _property DataView* get_DefaultView( );

[2866] VB Public ReadOnly Property DefaultView As DataView

[2867] JScript public function get DefaultView( ) : DataView;

[2868] Description

[2869] Gets a customized view of the table which may include a filtered view, or a cursor position.

[2870] The System.Data.DataTable.DefaultView property returns a System.Data.DataView you can use to sort, filter, and search a System.Data.DataTable

[2871] DesignMode

[2872] DisplayExpression

[2873] ToString

[2874] Description

[2875] Gets or sets the expression that will return a value used to represent this table in the user interface.

[2876] For rules on forming the expression string, see the System.Data.DataColumn.Expression property.

[2877] Events

[2878] ExtendedProperties

[2879] ToString

[2880] Description

[2881] Gets the collection of customized user information.

[2882] Use the System.Data.DataTable.ExtendedProperties to add custom information to a System.Data.DataTable. Add information with the Add method. Retrieve information with the Item method.

[2883] HasErrors

[2884] ToString

[2885] C public bool HasErrors get;

[2886] C public: _property bool get_HasErrors( );

[2887] VB Public ReadOnly Property HasErrors As Boolean

[2888] JScript public function get HasErrors( ) : Boolean;

[2889] Description

[2890] Gets a value indicating whether there are errors in any of the rows in any of the tables of the System.Data.DataSet to which the table belongs.

[2891] As users work on a set of data contained in a System.Data.DataSet, you can mark each change with an error if the change causes some validation failure. You can mark an entire System.Data.DataRow with an error message using the System.Data.DataRow.RowError property. You can also set errors on each column of the row with the System.Data.DataRow.SetColumnError(System.Int32,System.String) method.

[2892] Locale

[2893] ToString

[2894] C public CultureInfo Locale get; set;

[2895] C public: _property CultureInfo* get_Locale( );public: _property void set_Locale(CultureInfo*);

[2896] VB Public Property Locale As CultureInfo

[2897] JScript public function get Locale( ) : CultureInfo; public function set Locale(CultureInfo);

[2898] Description

[2899] Gets or sets the locale information used to compare strings within the table.

[2900] A System.Globalization.CultureInfo represents the software preferences of a particular culture or community.

[2901] MinimumCapacity

[2902] ToString

[2903] C public int MinimumCapacity get; set;

[2904] C public: _property int get_MinimumCapacity( );public: _property void set_MinimumCapacity(int);

[2905] VB Public Property MinimumCapacity As Integer

[2906] JScript public function get MinimumCapacity( ) : int; public function set MinimumCapacity(int);

[2907] Description

[2908] Gets or sets the initial starting size for this table.

[2909] The System.Data.DataTable.MinimumCapacity allows the system to create an appropriate set of resources before fetching data. In a situation when performance is critical, setting this property can optimize performance.

[2910] Namespace

[2911] ToString

[2912] C public string Namespace get; set;

[2913] C public: property String* get Namespace( );public: property void set_Namespace(String*);

[2914] VB Public Property Namespace As String

[2915] JScript public function get Namespace( ) : String; public function set Namespace(String);

[2916] Description

[2917] Gets or sets the namespace for the XML represenation of the data stored in the System.Data.DataTable.

[2918] ParentRelations

[2919] ToString

[2920] C public DataRelationCollection ParentRelations get;

[2921] C public: _property DataRelationCollection* get_ParentRelations( );

[2922] VB Public ReadOnly Property ParentRelations As DataRelationCollection

[2923] JScript public function get ParentRelations( ) : DataRelationCollection;

[2924] Description

[2925] Gets the collection of parent relations for this System.Data.DaitaTable.

[2926] Prefix

[2927] ToString

[2928] C public string Prefix get; set;

[2929] C public: _property String* get_Prefix( );public: _property void set_Prefix(String*);

[2930] VB Public Property Prefix As String

[2931] JScript public function get Prefix( ) : String; public function set Prefix(String);

[2932] Description

[2933] Gets or sets the namespace for the XML represenation of the data stored in the System.Data.DataTable

[2934] PrimaryKey

[2935] ToString

[2936] C public DataColumn PrimaryKey get; set;

[2937] C public: property DataColumn* get PrimaryKey( );public: property void set PrimaryKey(DataColumn* );

[2938] VB Public Property PrimaryKey As DataColumn

[2939] JScript public function get PrimaryKey( ) : DataColumn ; public function set PrimaryKey(DataColumn );

[2940] Description

[2941] Gets or sets an array of columns that function as primary keys for the data table.

[2942] The primary key of a table must be unique to identify the record in the table. It's also possible to have a table with a primary key made up of two or more columns. This occurs when a single column can't contain enough unique values. For example, a two column primary key might consist of a FirstName and LastName column. Because primary keys can be made up of more than one column, the System.Data.DataTable.PrimaryKey property consists of an array of System.Data.DataColumn objects.

[2943] Rows

[2944] ToString

[2945] C public DataRowCollection Rows get;

[2946] C public: _property DataRowCollection* get_Rows( );

[2947] VB Public ReadOnly Property Rows As DataRowCollection

[2948] JScript public function get Rows( ) : DataRowCollection;

[2949] Description

[2950] Gets the collection of rows that belong to this table.

[2951] To create a new System.Data.DataRow, you must use the System.Data.DataTable.NewRow method to return a new object. Such an object is automatically configured with according to the schema defined for the System.Data.DataTable through its collection of System.Data.DataColumn objects. After creating a new row and setting the values for each column in the row, add the row to the DataRowCollection using the Add method.

[2952] Site

[2953] ToString

[2954] C public override ISite Site get; set;

[2955] C public: _property virtual ISite* get_Site( );public: _property virtual void set_Site(ISite*);

[2956] VB Overrides Public Property Site As ISite

[2957] JScript public function get Site( ) : ISite; public function set Site(ISite);

[2958] Description

[2959] Gets or sets an System.ComponentModel.ISite for the System.Data.DataTable.

[2960] Sites bind a System.ComponentModel.Component to a System.ComponentModel.Container and enable communication between them, as well as provide a way for the container to manage its components.

[2961] TableName

[2962] ToString.

[2963] C public string TableName get; set;

[2964] C public: _property String* get_TableName( );public: _property void set_TableName(String*);

[2965] VB Public Property TableName As String

[2966] JScript public function get TableName( ) : String; public function set TableName(String);

[2967] Description

[2968] Gets or sets the name of the the System.Data.DataTable. The System.Data.DataTable.TableName is used to return this table from the parent System.Data.DataSet object's System.Data.DataTableCollection (returned by the System.Data.DataSet.Tables property).

[2969] ToString

[2970] C public event DataColumnChangeEventHandler ColumnChangedL;

[2971] C public: _event DataColumnChangeEventHandler* ColumnChianged;

[2972] VB Public Event ColumnChanged As DataColumnChangeEventHandler

[2973] Description

[2974] Occurs when after a value has been changed for the specified System.Data.DataColumn in a System.Data.DataRow.

[2975] ToString

[2976] C public event DataColumnChangeEventHandler ColumnChanging;

[2977] C public: event DataColumnChangeEventHandler* ColumnChanging;

[2978] VB Public Event ColumnChanging As DataColumnChangeEventHandler

[2979] Description

[2980] Occurs when a value is being changed for the specified System.Data.DataColumn in a System.Data.DataRow.

[2981] ToString

[2982] Description

[2983] Occurs after a System.Data.DataRow has been changed successfully.

[2984] ToString

[2985] C public event DataRowChangeEventHandler RowChanging;

[2986] C public: _event DataRowchangeEventHandler* RowChanging;

[2987] VB Public Event RowChanging As DataRowChangeEventHandler

[2988] Description

[2989] Occurs when a System.Data.DataRow is changing.

[2990] ToString

[2991] C public event DataRowChangeEventHandler RowDeleted;

[2992] C public: _event DataRowChangeEventHandler* RowDeleted;

[2993] VB Public Event RowDeleted As DataRowChangeEventHandler

[2994] Description

[2995] Occurs after a row in the table has been deleted.

[2996] ToString

[2997] C public event DataRowChangeEventHandler RowDeleting;

[2998] C public: _event DataRowChangeEventHandler* RowDeleting;

[2999] VB Public Event RowDeleting As DataRowChangeEventHandler

[3000] Description

[3001] Occurs before a row in the table is about to be deleted. AcceptChanges

[3002] C public void AcceptChanges( );

[3003] C public: void AcceptChanges( );

[3004] VB Public Sub AcceptChanges( )

[3005] JScript public function AcceptChanges( );

[3006] Description

[3007] Commits all the changes made to this table since the last time System.Data.DataTable.AcceptChanges was called.

[3008] When System.Data.DataTable.AcceptChanges is called, any System.Data.DataRow object still in edit mode successfully ends its edits. The System.Data.DataRowState also changes: all Added and Modified rows become Unchanged; Deleted rows are removed.

[3009] BeginInit

[3010] C public void BeginInit( );

[3011] C public: _sealed void BeginInit( );

[3012] VB NotOverridable Public Sub BeginInit( )

[3013] JScript public function BeginInit( );

[3014] Description

[3015] Begins the initialization of a System.Data.DataTable that is used on a form or used by another component. The initialization occurs at runtirne.

[3016] The Visual Studio.NET design environment uses this method to start the initialization of a component that is used on a form or used by another component. The System.Data.DataTable.EndInit method ends the initialization. Using the BeginInit and EndInit methods prevents the control from being used before it is fully initialized.

[3017] BeginLoadData

[3018] C public void BeginLoadData( );

[3019] C public: void BeginLoadData( );

[3020] VB Public Sub BeginLoadData( )

[3021] JScript public function BeginLoadData( );

[3022] Description

[3023] Turns off notifications, index maintenance, and constraints while loading data.

[3024] Use System.Data.DataTable.BeginLoadData in conjunction with System.Data.DataTable.LoadDataRow(System.Object ,System.Boolean) and System.Data.DataTable.EndLoadData.

[3025] Clear

[3026] C public void Clear( );

[3027] C public: void Clear( );

[3028] VB Public Sub Clear( )

[3029] JScript public function Clear( );

[3030] Description

[3031] Clears the System.Data.DataTable of all data.

[3032] All rows in all tables are removed. An exception is generated if the table has any enforced child relations that would cause child rows to be stranded.

[3033] Clone

[3034] C public DataTable Clone( );

[3035] C public: DataTable* Clone( );

[3036] VB Public Function Clone( ) As DataTable

[3037] JScript public function Clone( ) : DataTable;

[3038] Description

[3039] Clones the structure of the System.Data.DataTable, including all System.Data.DataTable schemas, relations, and constraints.

[3040] Return Value: A new System.Data.DataTable with the same schema as the current System.Data.DataTable. If these classes have been subclassed, the clone will also be of the same subclasses. Compute

[3041] C public object Compute(string expression, string filter);

[3042] C public: Object* Compute(String* expression, String* filter);

[3043] VB Public Function Compute(ByVal expression As String, ByVal filter As String) As Object

[3044] JScript public function Compute(expression: String, filter: String) : Object;

[3045] Description

[3046] Computes the given expression on the current rows that pass the filter criteria.

[3047] Return Value: An System.Object, set to the result of the computation. The expression parameter requires an aggregate function. For example, the following is a legal expression: Count(Quantity) But this expression is not: Sum (Quantity * UnitPrice) If you must perform an operation on two or more columns, you should create a System.Data.DataColumn, set its System.Data.DataColumn.Expression property to an appropriate expression, and use an aggregate expression on the resulting column. In that case, given a System.Data.DataColumn with the name total, and the System.Data.DataColumn.Expression property set to: Quantity * UnitPrice The expression argument for the System.Data.DataTable.Compute(System.String,System.String) method would then be: Sum(total) The second parameter filter determines which rows are used in the expression. For example, if the table contains a date column named colDate, you could limit the rows with the following expression: colDate>1/1/99 AND colDate <17/1/99 For rules on creating expressions for both parameters, see the System.Data.DataColumn.Expression property of the System.Data.DataColumn class. The expression to compute. The filter to limit the rows that evaluate in the expression.

[3048] Copy

[3049] C public DataTable Copy( );

[3050] C public: DataTable* Copy( );

[3051] VB Public Function Copy( ) As DataTable

[3052] JScript public function Copy( ) : DataTable;

[3053] Description Copies both the structure and data for this System.Data.DataTable.

[3054] Return Value: A new System.Data.DataTable with the same structure (table schemas, relations, and constraints) and data as this System.Data.DaltaTable.

[3055] EndInit

[3056] CH public void EndInit( );

[3057] C public: _sealed void EndInit( );

[3058] VB NotOverridable Public Sub EndInit( )

[3059] JScript public function EndInit( );

[3060] Description

[3061] Ends the initialization of a System.Data.DataTable that is used on a form or used by another component. The initialization occurs at runtime.

[3062] The Visual Studio.NET design environment uses this method to end the initialization of a component that is used on a form or used by another component. The System.Data.DataTable.BeginInit method starts the initialization. Using the BeginInit and EndInit methods prevents the control from being used before it is fully initialized.

[3063] EndLoadData

[3064] C public void EndLoadData( );

[3065] C public: void EndLoadData( );

[3066] VB Public Sub EndLoadData( )

[3067] JScript public function EndLoadData( );

[3068] Description

[3069] Turns off notifications, index maintenance, and constraints while loading data.

[3070] Use System.Data.DataTable.EndLoadData in conjunction with System.Data.DataTable.LoadDataRow(System.Object ,System.Boolean) and System.Data.DataTable.BeginLoadData.

[3071] GetChanges

[3072] C public DataTable GetChanges( );

[3073] C public: DataTable* GetChanges( );

[3074] VB Public Function GetChanges( ) As DataTable

[3075] JScript public function GetChanges( ) : DataTable; Gets a copy of the System.Data.DataTable containing all changes made to it since it was last loaded, or since System.Data.DataTable.AcceptChanges was called.

[3076] Description

[3077] IS Gets a copy of the System.Data.DataTable that contains all changes made to it since it was loaded or System.Data.DataTable.AcceptChanges was last called.

[3078] Return Value: A copy of the changes from this System.Data.DataTalble that can have actions performed on it and subsequently be merged back in using System.Data.DataSet.Merge(System.Data.DataSet), or null if none are found.

[3079] Gets a copy of the System.Data.DataTable that contains all changes made to it since it was loaded or System.Data.DataTable.AcceptChanges was last called. This copy is particularly designed so that it can be merged back in to this original System.Data.DataTable. Relationship constraints may cause Unchanged parent rows to be included. If no rows of these rowStates are found, this method returns null.

[3080] GetChanges

[3081] C public DataTable GetChanges(DataRowState rowStates);

[3082] C public: DataTable* GetChanges(DataRowState rowstates);

[3083] VB Public Function GetChanges(ByVal rowStates As DataRowState) As DataTable

[3084] JScript public function GetChanges(rowStates : DataRowState) : DataTable;

[3085] Description

[3086] Gets a copy of the System.Data.DataTable containing all changes made to it since it was last loaded, or since System.Data.DataTable.AcceptChanges was called, filtered by System.Data.DataRowState.

[3087] Return Value: A filtered copy of the System.Data.DataTable that can have actions performed on it, and subsequently be merged back in using System.Data.DataSet.Merge(System.Data.DataSet). If no rows of the desired System.Data.DataRowState are found, the method returns null.

[3088] The System.Data.DataTable.GetChanges method is used to produce a second System.Data.DataTable object which contains only the changes introduced into the original. Use the rowStates argument to specify the type of changes the new object should include. One of the System.Data.DataRowState values.

[3089] GetErrors

[3090] C public DataRow GetErrors( );

[3091] C public: DataRow* GetErrors( );

[3092] VB Public Function GetErrors( ) As DataRow( )

[3093] JScript public function GetErrors( ) : DataRow ;

[3094] Description

[3095] Gets an array of System.Data.DataRow objects that contain errors.

[3096] Return Value: An array of System.Data.DataRow objects that have errors.

[3097] Invoke System.Data.DataTable.GetErrors after invoking the System.Data.DataSet class's System.Data.DataSet.GetChanges method. Also, be sure you don't invoke the System.Data.DataTable.AcceptChanges on the System.Data.DataTable until after all errors have been succesfully resolved, and the System.Data.DataSet re-submitted for updating.

[3098] GetRowType

[3099] C protected virtual Type GetRowType( );

[3100] C protected: virtual Type* GetRowType( );

[3101] VB Overridable Protected Function GetRowType( ) As Type

[3102] JScript protected function GetRowType( ) : Type;

[3103] Description

[3104] Gets the row type.

[3105] Return Value: The System.Type of the row.

[3106] ImportRow

[3107] C public void ImportRow(DataRow row);

[3108] C public: void ImportRow(DataRow* row);

[3109] VB Public Sub ImportRow(ByVal row As DataRow)

[3110] JScript public function ImportRow(row : DataRow);

[3111] Description

[3112] Copies a System.Data.DataRow, including original and current values, System.Data.DataRowState values, and errors, into a System.Data.DataTable.

[3113] A System.Data.DataRow, including original and current values, System.Data.DataRowState values, and errors.

[3114] LoadDataRow

[3115] C public DataRow LoadDataRow(object values, bool fAcceptChanges);

[3116] C public: DataRow* LoadDataRow(Object* values _gc , bool fAcceptChanges);

[3117] VB Public Function LoadDataRow(ByVal values( ) As Object, ByVal fAcceptChanges As Boolean) As DataRow

[3118] JScript public function LoadDataRow(values : Object , fAcceptChanges: Boolean) : DataRow;

[3119] Description

[3120] Finds and updates a specific row. If no matching row is found, a new row is created using the given values.

[3121] Return Value: The new System.Data.DataRow.

[3122] The System.Data.DataTable.LoadDataRow(System.Object;System.Boolean) method takes an array of values and finds the matching value(s) in the primary key column(s). An array of values used to create the new row. true to accept changes; otherwise, false.

[3123] NewRow

[3124] C public DataRow NewRow( );

[3125] C public: DataRow* NewRow( );

[3126] VB Public Function NewRow( ) As DataRow

[3127] JScript public function NewRow( ) : DataRow;

[3128] Description

[3129] Creates a new System.Data.DataRow with the same schema as the table.

[3130] Return Value: A System.Data.DataRow with the same schema as the System.Data.DataTable.

[3131] You must use the System.Data.DataTable.NewRow method to create new System.Data.DataRow objects with the same schema as the System.Data.DataTable. After creating a System.Data.DataRow, you can add it to the System.Data.DataRowCollection, through the System.Data.DataTable object's System.Data.DataTable.Rows property.

[3132] NewRowArray

[3133] C protected internal DataRow NewRowArray(int size);

[3134] C protected public: DataRow* NewRowArray(int size) ;

[3135] VB Protected Friend Dim Function NewRowArray(ByVal size As Integer) As DataRow( )

[3136] JScript package function NewRowArray(size: int) : DataRow ;

[3137] Description

[3138] NewRowFromBuilder

[3139] C protected virtual DataRow NewRowFromBuilder(DataRowBuilder builder);

[3140] C protected: virtual DataRow* NewRowFromBuilder(DataRowBuilder* builder);

[3141] VB Overridable Protected Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow

[3142] JScript protected function NewRowFromBuilder(builder: DataRowBuilder) : DataRow;

[3143] Description

[3144] This is what a subclassed dataSet overrides to create a new row.

[3145] OnColumnChanged

[3146] C protected virtual void OnColumnChanged(DataColumnChangeEventArgs*);

[3147] C protected: virtual void OnColumnChanged(DataColumnChangeEventArgs*e);

[3148] VB Overridable Protected Sub OnColumnChanged(ByVal e As DataColumnChangeEventArgs)

[3149] JScript protected function OnColumnChanged(e: DataColumnChangeEventArgs);

[3150] Description

[3151] Raises the System.Data.DataTable.ColumnChanged event.

[3152] Raising an event invokes the event handler through a delegate. For an overview, see. A System.Data.DataColumnChangeEventArgs that contains the event data.

[3153] OnColumnChanging

[3154] C protected virtual void OnColumnChanging(DataColumnChangeEventArgs e);

[3155] C protected: virtual void OnColumnChanging(DataColumnChangeEventArgs* e);

[3156] VB Overridable Protected Sub OnColumnChanging(ByVal e As DataColumnChangeEventArgs)

[3157] JScript protected function OnColumnChanging(e: DataColumnChangeEventArgs);

[3158] Description

[3159] Raises the System.Data.DataTable.ColumnChanging event.

[3160] Raising an event invokes the event handler through a delegate. For an overview, see. A System.Data.DataColumnChangeEventArgs that contains the event data.

[3161] OnPropertyChanging

[3162] C protected internal virtual void OnPropertyChanging(PropertyChangedEventArgs pcevent);

[3163] C protected public: virtual void OnPropertyChanging(PropertyChangedEventArgs* pcevent);

[3164] VB Overridable Protected Friend Dim Sub OnPropertyChanging(ByVal pcevent As PropertyChangedEventArgs)

[3165] JScript package function OnPropertyChanging(pcevent : PropertyChangedEventArgs);

[3166] Description

[3167] Raises the System.Data.DataTable.OnPropertyChanging(System.ComponentModel.Pro pertyChangedEventArgs) event.

[3168] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.PropertyChangedEvelitArgs that contains the event data.

[3169] OnRemoveColumn

[3170] C protected internal virtual void OnRemoveColumn(DataColumn column);

[3171] C protected public: virtual void OnRemoveColumn(DataColumn* column);

[3172] VB Overridable Protected Friend Dim Sub OnRemoveColumn(ByVal column As DataColumn)

[3173] JScript package function OnRemoveColumn(column : DataColumn);

[3174] Description

[3175] Notifies the System.Data.DataTable that a System.Data.DataColumn is being removed.

[3176] Raising an event invokes the event handler through a delegate. For more information, see. The System.Data.DataColumn being removed.

[3177] OnRowChanged

[3178] C protected virtual void OnRowChanged(DataRowChangeEventArgs e);

[3179] C protected: virtual void OnRowChanged(DataRowChangeEventArgs* e);

[3180] VB Overridable Protected Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)

[3181] JScript protected function OnRowChanged(e: DataRowChangeEventArgs);

[3182] Description

[3183] Raises the System.Data.DataTable.RowChanged event.

[3184] Raising an event invokes the event handler through a delegate. For an overview, see. A System.Data.DataRowChangeEventArgs that contains the event data.

[3185] OnRowChanging

[3186] C protected virtual void OnRowChanging(DataRowChangeEventArgs e);

[3187] C protected: virtual void OnRowChanging(DataRowChangeEventArgs* e);

[3188] VB Overridable Protected Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)

[3189] JScript protected function OnRowChanging(e : DataRowChangeEventArgs);

[3190] Description

[3191] Raises the System.Data.DataTable.RowChanging event.

[3192] Raising an event invokes the event handler through a delegate. For an overview, see. A System.Data.DataRowChangeEventArgs that contains the event data.

[3193] OnRowDeleted

[3194] C protected virtual void OnRowDeleted(DataRowChangeEventArgs e);

[3195] C protected: virtual void OnRowDeleted(DataRowChangeEventArgs* e);

[3196] VB Overridable Protected Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)

[3197] JScript protected function OnRowDeleted(e: DataRowChangeEventArgs);

[3198] Description

[3199] Raises the System.Data.DataTable.RowDeleted event.

[3200] Raising an event invokes the event handler through a delegate. For an overview, see. A System.Data.DataRowChangeEventArgs that contains the event data.

[3201] OnRowDeleting

[3202] C protected virtual void OnRowDeleting(DataRowChangeEventArgs e);

[3203] C protected: virtual void OnRowDeleting(DataRowChangeEventArgs* e);

[3204] VB Overridable Protected Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)

[3205] JScript protected function OnRowDeleting(e: DataRowChangeEventArgs);

[3206] Description

[3207] Raises the System.Data.DataTable.OnRowDeleting(System.Data.DataRowChangeEvent Args) event.

[3208] Raising an event invokes the event handler through a delegate. For an overview, see. A System.Data.DataRowChangeEventArgs that contains the event data.

[3209] RejectChanges

[3210] C public void RejectChanges( );

[3211] C public: void RejectChanges( );

[3212] VB Public Sub RejectChanges( )

[3213] JScript public function RejectChanges( );

[3214] Description

[3215] Rolls back all changes that have been made to the table since it was loaded, or the last time System.Data.DataTable.AcceptChanges was called.

[3216] When System.Data.DataTable.RejectChanges is called, any System.Data.DataRow objects that are still in edit-mode cancel their edits. New rows are removed. Rows with the System.Data.DataRowState set to Modified or Deleted return back to their original state.

[3217] Reset

[3218] C public virtual void Reset( );

[3219] C public: virtual void Reset( );

[3220] VB Overridable Public Sub Reset( )

[3221] JScript public function Reset( );

[3222] Description

[3223] Resets the System.Data.DataTable to its original state.

[3224] Select

[3225] C public DataRow Select( );

[3226] C public: DataRow* Selecto ;

[3227] VB Public Function Select( ) As DataRow( )

[3228] JScript public function Select( ) : DataRow ; Gets an array of System.Data.DataRow objects.

[3229] Description

[3230] Gets an array of all System.Data.DataRow objects.

[3231] Return Value: An array of System.Data.DataRow objects.

[3232] The method returns the current rows in order of primary key (or lacking one, order of addition.) The following example returns an array of System.Data.DataRow objects through the System.Data.DataTable.Select method.

[3233] Select

[3234] C public DataRow Select(string filterExpression);

[3235] C public: DataRow* Select(String* filterExpression)

[3236] VB Public Function Select(ByVal filterExpression As String) As DataRow( )

[3237] JScript public function Select(filterExpression : String) : DataRow ;

[3238] Description

[3239] Gets an array of all System.Data.DataRow objects that match the filter criteria in order of primary key (or lacking one, order of addition.)

[3240] Return Value: An array of System.Data.DataRow objects.

[3241] To create thefilterExpression argument, use the same rules that apply to the System.Data.DataColumn class's System.Data.DataColumn.Expression property value for creating filters. The criteria to use to filter the rows.

[3242] Select

[3243] C public DataRow Select(string filterExpression, string sort);

[3244] C public: DataRow* Select(String* filterExpression, String* sort) ;

[3245] VB Public Function Select(ByVal filterExpression As String, ByVal sort As String) As DataRow( )

[3246] JScript public function Select(filterExpression : String, sort: String) : DataRow ;

[3247] Description

[3248] Gets an array of all System.Data.DataRow objects that match the filter criteria, in the the specified sort order.

[3249] Return Value: An array of System.Data.DataRow objects matching the filter expression.

[3250] To form the filterExpression argument, use the same rules for creating the System.Data.DataColumn class's System.Data.DataColumn.Expression property value. The Sort argument also uses the same rules for creating class's System.Data.DataColumn.Expression strings. The criteria to use to filter the rows. A string specifying the column and sort direction.

[3251] Select

[3252] C public DataRow Select(string filterExpression, string sort, DataViewRowState recordStates);

[3253] C public: DataRow* Select(String* filterExpression, String* sort, DataViewRowState recordStates) ;

[3254] VB Public Function Select(ByVal filterExpression As String, ByVal sort As String, ByVal recordStates As DataViewRowState) As DataRow( )

[3255] JScript public function Select(filterExpression : String, sort: String, recordStates : DataViewRowState) : DataRow ;

[3256] Description

[3257] Gets an array of all System.Data.DataRow objects that match the filter in the order of the sort, that match the specified state.

[3258] Return Value: An array of System.Data.DataRow objects.

[3259] To form the filterExpression argument, use the same rules for creating the System.Data.DataColumn class's System.Data.DataColumn.Expression property value. The Sort argument also uses the same rules for creating class's System.Data.DataColumn.Expression strings. The criteria to use to filter the rows. A string specifying the column and sort direction. One of the System.Data.DataViewRowState values.

[3260] IListSource.GetList

[3261] C IList IListSource.GetList( );

[3262] C IList* IListSource::GetList( );

[3263] VB Function GetList( ) As IList Implements IListSource.GetList

[3264] JScript function IListSource.GetList( ) : IList;

[3265] ISerializable.GetObjectData

[3266] C void ISerializable.GetObjectData(SerializationInfo info, StreamingContext context);

[3267] C void ISerializable::GetObjectData(SerializationInfo* info, StreamingContext context);

[3268] VB Sub GetObjectData(ByVal info As SerializationInfo, ByVal context As StreamingContext) Implements ISerializable.GetObjectData

[3269] JScript function ISerializable.GetObjectData(info : SerializationInfo, context: StreamingContext);

[3270] ToString

[3271] C public override string ToString( );

[3272] C public: String* ToString( );

[3273] VB Overrides Public Function ToString( ) As String

[3274] JScript public override function ToString( ) : String;

[3275] Description

[3276] Gets the System.Data.DataTable.TableName and System.Data.DataTable.DisplayExpression, if there is one as a concatenated string.

[3277] Return Value: A string consisting of the System.Data.DataTable.TableName and the System.Data.DataTable.DisplayExpression values.

[3278] Gets the System.Data.DataTable.TableName and System.Data.DataTable.DisplayExpression for the System.Data.DataTable.

[3279] DataTableCollection class (System.Data)

[3280] ToString

[3281] Description

[3282] Represents the collection of tables for the System.Data.DataSet.

[3283] The System.Data.DataTableCollection contains all of the System.Data.DataTable objects for a System.Data.DataSet. To access the System.Data.DataTableCollection of a System.Data.DataSet, use the System.Data.DataSet.Tables property.

[3284] Count

[3285] IsReadOnly

[3286] IsSynchronized

[3287] Item

[3288] ToString

[3289] System.Data.DataTable

[3290] Description

[3291] Gets the System.Data.DataTable specified by its index.

[3292] The System.Data.DataTableCollection.Contains(System.String) method. can be used to determine if a table with a specified index exists. The zero-based index of the System.Data.DataTable to find.

[3293] Item

[3294] ToString

[3295] C public DataTable thisstring name get;

[3296] C public: _property DataTable* get_Item(String* name);

[3297] VB Public Default ReadOnly Property Item(ByVal name As String) As DataTable

[3298] JScript returnvalue DataTableCollection( )bject.Item(name);

[3299] Description

[3300] Gets the System.Data.DataTable in the collection with the given name (not case-sensitive).

[3301] The System.Data.DataTableCollection.Contains(System.String) method can be used to determine if a table with a specified name or index exists. The name of the table to find.

[3302] List

[3303] ToString

[3304] C protected override ArrayList List get;

[3305] C protected: _property virtual ArrayList* get_List( );

[3306] VB Overrides Protected ReadOnly Property List As ArrayList

[3307] JScript protected function get List( ) : ArrayList;

[3308] Description

[3309] Gets the tables in the collection as an object.

[3310] SyncRoot

[3311] ToString

[3312] Description

[3313] Occurs when the collection is changed.

[3314] ToString

[3315] C public event CollectionChangeEventHandler CollectionChanging;

[3316] C public: _event CollectionChangeEventHandler* CollectionChanging;

[3317] VB Public Event CollectionChanging As CollectionChangeEventHandler

[3318] Description

[3319] Occurs when the collection is changing.

[3320] To abort the change, the user should throw an exception in a System.Data.DataColumnChangeEventHandler event handler, and then catch the exception.

[3321] Add

[3322] C public virtual DataTable Add( );

[3323] C public: virtual DataTable* Add( );

[3324] VB Overridable Public Function Add( ) As DataTable

[3325] JScript public function Add( ) : DataTable;

[3326] Description

[3327] Creates a new table with a default name and adds it to the collection.

[3328] Return Value: The newly created System.Data.DataTable.

[3329] Because no name is specified, the table is created with a default name, relative to its order of addition. The default name is Table where ia new 1based index.

[3330] Add

[3331] C public virtual void Add(DataTable table);

[3332] C public: virtual void Add(Datafable * table);

[3333] VB Overridable Public Sub Add(ByVal table As DataTable)

[3334] JScript public function Add(table : DataTable); Adds a System.Data.DataTable to the collection.

[3335] Description

[3336] Adds the specified System.Data.DataTable to the collection. The System.Data.Data TableCollection. On Collection Changed(System. ComponentModel.CollectionChangeEventArgs) event occurs when a table is succefully added. System.Data.DataTable to add.

[3337] Add

[3338] C public virtual Data Table Add(string name);

[3339] C public: virtual DataTable Add(String* name);

[3340] VB Overridable Public Function Add(ByVal name As String) As DataTable

[3341] JScript public function Add(name : String) DataTable;

[3342] Description

[3343] Creates a table with the given name and adds it to the collection.

[3344] Return Value: The newly created System.Data.DataTable.

[3345] If either a null or an empty string ( ) is passed in, a default name is given to the newly created System.Data.DataTable. The name to give the created System.Data.DataTable. AddRange

[3346] C public void AddRange(DataTable tables);

[3347] C public: void AddRange(DataTable* tables );

[3348] VB Public Sub AddRange(ByVal tables( ) As DataTable)

[3349] JScript public function AddRange(tables: DataTable );

[3350] Description

[3351] Copies the elements of the specified System.Data.DataTable array to the end of the collection. The array ofSystem.Data.DataTable objects to add to the collection.

[3352] CanRemove

[3353] C public bool CanRemove(DataTable table);

[3354] C public: bool CanRemove(DataTable* table);

[3355] VB Public Function CanRemove(ByVal table As DataTable) As Boolean

[3356] JScript public function CanRemove(table : DataTable) : Boolean;

[3357] Description

[3358] Verifies if the specified System.Data.DataTable can be removed from the collection.

[3359] Return Value: true if the table can be removed; otherwise, false. A System.Data.DataTable in the collection.

[3360] Clear

[3361] C public void Clear( );

[3362] C public: void Clear( );

[3363] VB Public Sub Clear( )

[3364] JScript public function Clear( );

[3365] Description

[3366] Clears the collection of any tables.

[3367] Contains

[3368] C public bool Contains (string name);

[3369] C public: bool Contains (String * name);

[3370] VB Public Function Contains (ByVal name As String) As Boolean

[3371] JScript public function Contains(name :String) :Boolean;

[3372] Description

[3373] Checks if a table, specified by name, exists in the collection.

[3374] Return Value: true if the specified table exists; otherwise, false.

[3375] The System.Data.DataTable object's name is specified by the System.Data.Data Table. TableNam eproperty. Jfyou add a System.Data.DataTable to the System.Data.DataTableCollection with the System.Data.DataTableCollection.Add(System.Data.Data Table) method, passing no arguments, the table is given a default name such as Table1, Table2, and so on. The table name to check for.

[3376] IndexOf

[3377] C public virtual int IndexOf(Data Table table);

[3378] C public: virtual int Indexof(DataTable * table);

[3379] VB Overridable Public Function IndexOf(ByVal table As Data Table,) As Integer

[3380] JScript public function IndexOf(table : Data Table) : int; Gets the index of a specified table.

[3381] Description

[3382] Gets the index of a specified System.Data.DataTable.

[3383] Return Value: The O-based index of the table, or 1 if the table isn't found in the collection.

[3384] Use the System.Data.DataTableCollection.IndexOf(System.Data.DataTable) method when it's necessary to know the exact index of a given table. The System.Data.DataTable to search for.

[3385] IndexOf

[3386] C public virtual int IndexOf(string tableName);

[3387] C public: virtual intIndexOf(String* tableName);

[3388] VB Overridable Public Function IndexOf(ByVal tableName As String) As Integer

[3389] JScript public function IndexOf(tableName : String) : int;

[3390] Description

[3391] Gets the index of the table with the given name (case insensitive), or 1 if the table doesn't exist in the collection.

[3392] Return Value: The index of the table with the name, or 1 if the table doesn't exist in the collection.

[3393] The name of a System.Data.DataTable is set with the System.Data.DataTable.TableName property. The name to look for.

[3394] OnCollectionChanged

[3395] C protected virtual void OnCollectionChanged(CollectionChangeEventArgs ccevent);

[3396] C protected: virtual void OnCollectionChanged(CollectionChangeEventArgs * ccevent);

[3397] VB Overridable Protected Sub OnCollectionChanged(ByVal ccevent As CollectionChangeEventArgs)

[3398] JScript protectedfunction OnCollectionChanged(ccevent: CollectionChangeEventArgs);

[3399] Description

[3400] Raises the System.Data.DataTableCollection. On Collection Changed(System. ComponentMo del.CollectionChangeEventArgs) event.

[3401] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[3402] On Collection Changing

[3403] C protected internal virtual void OnCollectionChanging(CollectionChangeEventArgs ccevent);

[3404] C protected public: virtual void OnCollectionChanging(CollectionChangeEventArgs* ccevent);

[3405] VB Overridable Protected Friend Dim Sub OnCollectionChanging(ByVal cceventAs CollectionChangeEventArgs)

[3406] JScript package function OnCollectionChanging(ccevent: CollectionChangeEventArgs);

[3407] Description

[3408] Raises the System.Data.DataTableCollection.OnCollectionChanging(System.ComponentModel.CollectionChangeEventArgs) event.

[3409] Raising an event invokes the event handler through a delegate. For an overview, see. A System.ComponentModel.CollectionChangeEventArgs that contains the event data.

[3410] Remove

[3411] C public void Remove(Data Table table);

[3412] C public: void Remove(DataTable* table);

[3413] VB Public Sub Remove(ByVal table As DataTable)

[3414] JScript public function Remove(table : DataTable); Removes a table from the collection.

[3415] Description

[3416] Removes the specified table from the collection.

[3417] The System.Data.Data TableCollection.On Collection Changed(System.ComponentMo del. CollectionChangeEventArgs) event occurs when a table is succesfully removed. The System.Data.DataTable to remove.

[3418] Remove

[3419] C public void Remove(string name);

[3420] C public: void Remove(String * name);

[3421] VB Public Sub Remove(ByVal name As String)

[3422] JScript public function Remove(name : String);

[3423] Description

[3424] Removes the table with a specified name from the collection.

[3425] The System.Data.DataTableCollection.OnCollectionChanged(System. ComponentModel.CollectionChangeEventArgs) event occurs when a table is succesfully removed. The name of the System.Data.DataTable to remove.

[3426] RemoveAt

[3427] C public void RemoveAt(int index);

[3428] C public: void RemoveAt(int index);

[3429] VB Public Sub RemoveAt(ByVal index As Integer)

[3430] JScript public function RemoveAt(index : int);

[3431] Description

[3432] Removes the table at the given index from the collection The collection doesn't have a table at this index.

[3433] The System.Data.DataTableCollection.On Collection Changed(System.ComponentModel.CollectionChangeEventArgs) event occurs when a table is successfully removed. The index at which to remove a table.

[3434] Data View class (System.Data)

[3435] ToString

[3436] Description

[3437] Represents a data bindable, customized view of a System.Data.DataTable for sorting, filtering, searching, editing, and navigation.

[3438] A major function of the System.Data.DataView is to allow data binding on both Windows Forms and Web Forms.

[3439] DataView

[3440] Example Syntax:

[3441] ToString

[3442] C public Data View( );

[3443] C public: Data View( );

[3444] VB Public Sub New( )

[3445] JScript public function Data View( ); Initializes a new instance of the System.Data.DataView class.

[3446] Description

[3447] Initializes a new instance of the System.Data.DataView class.

[3448] DataView

[3449] Example Syntax:

[3450] ToString

[3451] C public DataView(DataTable table);

[3452] C public: DataView(DataTable* table);

[3453] VB Public Sub New(ByVal table As DataTable)

[3454] JScript public function DataView(table : DataTable);

[3455] Description

[3456] Initializes a new instance of the System.Data.DataView class with the specified System.Data.DataTable. A System.Data.DataTable to add to the System.Data.DataView.

[3457] DataView

[3458] Example Syntax:

[3459] ToString

[3460] C public DataView(DataTable table, string RowFilter, string Sort, DataViewRowState RowState);

[3461] C public: DataView(DataTable * table, String* RowFilter, String* Sort, DataViewRowState RowState);

[3462] VB Public Sub New(ByVal table As DataTable, ByVal RowFilter As String, ByVal Sort As String, ByVal RowState As DataViewRowState)

[3463] JScript public function DataView(table : DataTable, RowFilter : String, Sort: String, RowState : DataViewRowState); Initializes a new instance of the System.Data.DataView class with the specified System.Data.DataTable.

[3464] AllowDelete

[3465] ToString

[3466] C public bool AllowDelete get,; set

[3467] C public: _property bool get_AllowDelete( );public: _property void set_AllowDelete(bool);

[3468] VB Public Property AllowDelete As Boolean

[3469] JScript public function get AllowDelete( ) Booleanpublic function set AllowDelete (Boolean);

[3470] Description

[3471] Sets or gets a value indicating whether deletes are allowed.

[3472] AllowEdit

[3473] ToString

[3474] C public bool AllowEdit get; set;

[3475] C public: _property bool get AllowEdit( );public: _property void set_AllowEdit(bool);

[3476] VB Public Property AllowEdit As Boolean

[3477] JScript public function get AllowEdit( ) : Boolean;public function set AllowEdit(Boolean);

[3478] Description

[3479] Gets or sets a value indicating whether edits are allowed.

[3480] AllowNew

[3481] ToString

[3482] C public bool AllowNew get; set;

[3483] C public: _property bool get_AllowNew( );public: _property void

[3484] set_AllowNew(bool);

[3485] VB Public Property AllowNew As Boolean

[3486] JScript public function get AllowNew( ) : Boolean;public function set AllowNew(Boolean);

[3487] Description

[3488] Gets or sets a value indicating whether the new rows can be added using the System.Data.DataView.AddNew method. ApplyDefaultSort

[3489] ToString

[3490] C public bool ApplyDefaultSort get; set;

[3491] C public: _property bool get_ApplyDefaultSorto,-public: _property void set_ApplyDefaultSort(bool);

[3492] VB Public Property ApplyDefaultSort As Boolean

[3493] JScript public function get ApplyDefaultSort( ) : Boolean;,public function set ApplyDefaultSort(Boolean);

[3494] Description

[3495] Gets or sets a value indicating whether to use the default sort.

[3496] Container

[3497] Count

[3498] ToString

[3499] Description

[3500] Gets the number of records in the System.Data.DataView after System.Data.DataView.RowFilter and System.Data.DataView.RowStateFitter have been applied.

[3501] DataViewManager

[3502] ToString

[3503] C public DataViewManager DataViewManager get;

[3504] C public: _property DataViewManager* get_DataViewManager( );

[3505] VB Public ReadOnly Property DataViewManager As DataViewManager

[3506] JScript public function get DataViewManager( ) : DataViewManager;

[3507] Description

[3508] Gets the System.Data.DataView associated with this view.

[3509] DesignMode

[3510] Events

[3511] IsOpen

[3512] ToString

[3513] Description

[3514] Gets a value indicating whether the data source is currently open and projecting views of data on the System.Data.DataTable.

[3515] A System.Data.DataView is a view on a System.Data.DataTable because it provides custom sorting and filtering of the data. The System.Data.DataView.IsOpen property can be queried to determine if a System.Data.DataView has been opened using the System.Data.DataView. Open method.

[3516] Item

[3517] ToString.

[3518] C public DataRow View thisint recordIndex get;

[3519] C public: _property DataRowView* get Item(int recordIndex);

[3520] VB Public Default ReadOnly Property Item (ByVal recordindex As Integer) As DataRowView.

[3521] JScript return Value DataViewObject.Item(recordIndex);

[3522] Description

[3523] Gets a row of data from a specified table. The index of a record in the System.Data.DataTable.

[3524] RowFilter

[3525] ToString

[3526] C public virtual string RowFilter get; set;

[3527] C public: _roperty virtual String* get_RowFilter( );public: _property virtual void set_RowFilter(String*);

[3528] VB Overridable Public Property RowFilter As String

[3529] JScript public function get RowFilter( ) : String,public function set RowFilter(String);

[3530] Description

[3531] Gets or sets the expression used to filter which rows are viewed in the System.Data.DataView.

[3532] To form a System.Data.DataView.RowFilter value, specify the name of a column followed by an operator and a value to filter on. The value must be in quotes. For example: LastName Smith See the System.Data.DataColumn class's System.Data.DataColumn.Expression property for more information.

[3533] RowStateFilter

[3534] ToString

[3535] C public DataViewRowState RowStateFilter get; set;

[3536] C public: _property DataViewRowState get RowStateFilter( );public: Property void set_RowStateFilter(DataViewRowState);

[3537] VB Public Property RowStateFilterAs DataViewRowState

[3538] JScriptpublic function get RowStateFilter( ) : DataViewRowState; public function set RowStateFilter(DataViewRowState);

[3539] Description

[3540] Gets or sets the row state filter used in the System.Data.DataView.

[3541] Only rows that have been deleted using the System.Data.DataView.Delete(System.Int32) method will have their System.Data.DataView.RowStateFilter value set to Deleted. Those rows added using the System.Data.DataView.AddNew method will similarly have the property set to Added.

[3542] Site

[3543] Sort

[3544] ToString

[3545] Description

[3546] Gets or sets the sort column or columns, and sort order for the table.

[3547] See the System.Data.DataColumn.Expression property of System.Data.DataColumn for more details on forming a System.Data.DataView.Sort expression.

[3548] Table

[3549] ToString

[3550] C public DataTable Table get; set;

[3551] C public: _property DataTable* get Table( );public: _property void set_Table(DataTable *);

[3552] VB Public Property Table As DataTable

[3553] JScript public function get Table( ) : DataTable;public function set

[3554] Table(DataTable);

[3555] Description

[3556] Gets or sets the source System.Data.DataTable.

[3557] The System.Data.DataTable also has a System.Data.DataTable.DefauftView property which returns the default System.Data.DataView for the table. For example, if you wish to create a custom view on the table, set the System.Data.DataView.RowFilter on the System.Data.DataView returned by the System.Data.DataTable.DefaultView

[3558] ToString

[3559] Description

[3560] Occurs when the list managed by the System.Data.DataView changes.

[3561] AddNew

[3562] C public virtual DataRowView AddNew( );

[3563] C public: virtual DataRowView* AddNew( );

[3564] VB Overridable Public Function AddNew( ) As DataRow View

[3565] JScript public function AddNew( ) : DataRowView;

[3566] Description

[3567] Adds a new row to the System.Data.DataView.

[3568] Return Value: A System.Data.DataRowView.

[3569] BeginInit

[3570] C public void BeginInit( );

[3571] C public: _sealed void BeginInit( );

[3572] VB NotOverridable Public Sub BeginInit( )

[3573] JScript public function BeginInit( );

[3574] Description

[3575] Begins the initialization of a System.Data.DataView that is used on a form or used by another component. The initialization occurs at runtime.

[3576] The Visual Studio.NET design environment uses this method to start the initialization of a component that is used on a form or used by another component. The System.Data.DataView.EndInit method ends the initialization. Using the BeginInit and EndInit methods prevents the control from being used before it is fully initialized.

[3577] Close

[3578] C protected void Close( );

[3579] C protected: void Close( );

[3580] VB Protected Sub Close( )

[3581] JScript protected function Close( );

[3582] Description

[3583] Closes the System.Data.DataView.

[3584] The method allows you to manually close the System.Data.DataView in derived classes. Use the corresponding System.Data.DataView. Open method to open the System.Data.DataView.

[3585] ColumnCollectionChanged

[3586] Ca protected virtual void ColumnCollectionChanged(object sender, CollectionChangeEventArgs e);

[3587] C protected: virtual void ColumnnCollectionChanged(Object* sender, CollectionChangeEventArgs* e);

[3588] VB Overridable Protected Sub ColumnCollectionChanged(ByVal sender As Object, ByVal e As CollectionChangeEventArgs)

[3589] JScript protected function ColumnCollectionChanged(sender: Object, e: CollectionChangeEventArgs);

[3590] Description

[3591] Occurs after a System.Data.DataColumnCollection has been changed successfully. The source of the event. A System.ComponentModel.ListChangedEventArgs that contains the event data.

[3592] CopyTo

[3593] C public void CopyTo(Array array, int index);

[3594] C public: _sealed void CopyTo(Array* array, int index);

[3595] VB NotOverridable Public Sub CopyTo(ByVal array As Array, ByVal index As Integer)

[3596] JScript public function CopyTo(array : Array, index : int);

[3597] Description

[3598] Copies items into an array. Only for Web Forms Interfaces. array to copy into. index to start at.

[3599] Delete

[3600] C public void Delete(int index);

[3601] C public: void Delete(int index);

[3602] VB Public Sub Delete(ByVal index As Integer)

[3603] JScript public function Delete(index : int);

[3604] Description

[3605] Deletes a row at the specified index.

[3606] After deleting a System.Data.DataRow, its state changes to DataViewRowState.Deleted. You can roll back the deletion by calling System.Data.DataTable.RejectChanges on the System.Data.DataTable. The index of the row to delete.

[3607] Dispose

[3608] C protected override void Dispose(bool disposing);

[3609] C protected: void Dispose(bool disposing);

[3610] VB Overrides Protected Sub Dispose(ByVal disposing As Boolean)

[3611] JScript protected override function Dispose(disposing: Boolean);

[3612] Description

[3613] Disposes of the resources (other than memory) used by the System.Data.DataView object.

[3614] Property change notifications between the System.Data.DataView and the underlying System.Data.DataTable stop_after this method is called.

[3615] EndInit

[3616] C public void EndInit( );

[3617] C public: _sealed void EndInit( );

[3618] VB NotOverridable Public Sub EndInit( )

[3619] JScript public function EndInit( );

[3620] Description

[3621] Ends the initialization of a System.Data.DataView that is used on a form or used by another component. The initialization occurs at runtime.

[3622] The Visual Studio.NET design environment uses this method to end the initialization of a component that is used on a form or used by another component. The System.Data.DataView.BeginInit method starts the initialization. Using the BeginInit and EndInit methods prevents the control from being used before it is fully initialized.

[3623] Find

[3624] C public int Find(object key);

[3625] C public: int Find(Object* key);

[3626] VB Public Function Find(ByVal key As Object) As Integer

[3627] JScript public function Find(key : Object) : int; Finds a row in the System.Data.DataView by the specified primary key value.

[3628] Description

[3629] Finds a row in the System.Data.DataView by the specified primary key value.

[3630] Return Value: The index of the row in the System.Data.DataView containing the primary key value specified; otherwise a null value if the primary key value does not exist. The object to search for.

[3631] Find

[3632] C public int Find(object key);

[3633] C public: int Find(Object* key _gc );

[3634] VB Public Function Find(ByVal key( ) As Object) As Integer

[3635] JScript public function Find(key : Object ) int;

[3636] Description

[3637] Finds an array of rows in the System.Data.DataView by the specified primary key values.

[3638] Return Value: The array of row indexes in the System.Data.DataView containing the primary key values specified; otherwise a null value if the primary key values do not exist. An array of values, typed as System.Object.

[3639] FindRows

[3640] C public DataRowView FindRows(object key);

[3641] C public: DataRowView* FindRows (Object* key) ;

[3642] VB Public Function FindRows (ByVal key As Object) As DataRowView( )

[3643] JScript public function FindRows(key : Object) : DataRowView ; Finds a row in the System.Data.DataView by the specified primary key value.

[3644] FindRows

[3645] C public DataRowView FindRows(object key);

[3646] C public: DataRowView* FindRows(Object* key _c ,

[3647] VB Public Function FindRows(ByVal key( ) As Object) As DataRowView( )

[3648] JScript public function FindRows(key : Object ) : DataRowView ; Finds a row in the System.Data.DataView by the specified primary key values.

[3649] GetEnumerator

[3650] C public lEnumerator GetEnumerator( );

[3651] C public: _sealed IEnumerator* GetEnumerator( );

[3652] VB NotOverridable Public Function GetEnumerator( ) As IEnumerator

[3653] JScript public function GetEnumerator( ) : IEnumerator;

[3654] Description

[3655] Gets an enumerator for this System.Data.DataView.

[3656] Return Value: An System.Collections.IEnumerator for navigating through the list IndexListChanged

[3657] C protected virtual void IndexListChanged(object sender, ListChangedEventArgs e);

[3658] C protected: virtual void IndexListChanged(Object* sender, ListChangedEventArgs* e);

[3659] VB Overridable Protected Sub IndexListChanged(ByVal sender As Object, ByVal e As ListChangedEventArgs)

[3660] JScript protected function IndexListChanged(sender: Object, e: ListChangedEventArgs);

[3661] Description

[3662] Occurs after a System.Data.DataView has been changed successfully. The source of the event. A System.ComponentModel.ListChangedEventArgs that contains the event data. OnListChanged

[3663] C protected virtual void OnListChanged(ListChangedEventArgs e);

[3664] C protected: virtual void OnListChanged(ListChangedEventArgs* e);

[3665] VB Overridable Protected Sub OnListChanged(ByVal e As ListChangedEventArgs)

[3666] JScript protectedfunction OnListChanged(e ListChangedEventArgs);

[3667] Description

[3668] Raises the System.Data.DataView.ListChanged event. A System. ComponentModel.ListChangedEventArgs that contains the event data.

[3669] Open

[3670] C protected void Open( );

[3671] C protected: void Open( );

[3672] VB Protected Sub Open( )

[3673] JScript protectedfunction Open( );

[3674] Description

[3675] Opens a System.Data.DataView.

[3676] The method allows you to manually open the System.Data.DataView in derived classes. Use the corresponding System.Data.DataView. Close method to close the System.Data.DataView. Reset

[3677] C protected void Reset( );

[3678] C protected: void Reset( );

[3679] VB Protected Sub Reset( )

[3680] JScript protected function Reset( );

[3681] Description

[3682] Reserved for internal use only.

[3683] IList.Add

[3684] C int IList.Add(object value);

[3685] C int IList::Add(Object* value);

[3686] VB Function Add(ByVal value As Object) As Integer Implements IList.Add

[3687] JScript function IList.Add(value : Object) : int; IList. Clear

[3688] C void IList.Clear( );

[3689] C void IList::Clear( );

[3690] VB Sub Clear( ) Implements IList. Clear

[3691] JScript function IList. Clear( );

[3692] IList. Contains

[3693] C bool IList: Contains(object value);

[3694] C bool IList::Contains(Object* value);

[3695] VB Function Contains(ByVal value As Object) As Boolean Implements IList. Contains

[3696] JScript function IList. Contains(value : Object) : Boolean;

[3697] IList.IndexOf

[3698] C int IList.IndexOf(object value);

[3699] C int IList::IndexOf(Object* value);

[3700] VB Function IndexOf(ByVal value As Object) As Integer Implements IList.IndexOf

[3701] JScript function IList.IndexOf(value : Object) int;

[3702] IList.Insert

[3703] C void IList.Insert(int index, object value);

[3704] C void IList::Insert(int index, Object* value);

[3705] VB Sub Insert(ByVal index As Integer, ByVal value As Object) Implements IList.Insert

[3706] JScript function IList.Insert(index : int, value : Object);

[3707] IList.Remove

[3708] C void IList.Remove(object value);

[3709] C void IList::Remove(Object* value);

[3710] VB Sub Remove(ByVal value As Object) Implements IList.Remove

[3711] JScript function IList.Remove(value : Object);

[3712] IList.RemoveAt

[3713] C void IList.RemoveAt(int index);

[3714] C void IList::RemoveAt(int index);

[3715] VB Sub RemoveAt(ByVal index As Integer) Implements IList.Remove(At

[3716] JScript function IList.RemoveAt(index : int);

[3717] IBindingList.AddIndex

[3718] C void IBindingList.AddIndex(PropertyDescriptor property);

[3719] C void IBindingList::AddIndex(PropertyDescriptor* property);

[3720] VB Sub AddIndex(ByVal property As PropertyDescriptor) Implements IBindingList.AddIndex

[3721] JScript function IBindingList.AddIndex(property : PropertyDescriptor);

[3722] IBindingList.AddNew

[3723] C object IBindingList.AddNew( );

[3724] C Object* IBindingList::AddNew( );

[3725] VB Function AddNew( ) As Object Implements IBindingList.AddNew

[3726] JScript function IBindingList.AddNew( ) : Object;

[3727] IBindingList.ApplySort

[3728] C void IBindingList.ApplySort(PropertyDescriptor property, ListSortDirection direction);

[3729] C void IBindingList::ApplySort(PropertyDescriptor* property, ListSortDirection direction);

[3730] VB Sub ApplySort(ByVal property As PropertyDescriptor, ByVal direction As ListSortDirection) Implements IBindingList.ApplySort

[3731] JScript function IBindingList.ApplySort(property PropertyDescriptor, direction : ListSortDirection); IBindingList.Find

[3732] Cint IBindingList.Find(PropertyDescriptor property, object key);

[3733] C int IBindingList :Find(PropertyDescriptor property, Object key);

[3734] VB Function Find(ByValpropertyAs PropertyDescriptor, ByVal key As Object) As Integer Implements IBindingList.Find

[3735] JScript function IBindingList.Find(property : PropertyDescriptor, key : Object) : int;

[3736] IBindingList.RemoveIndex

[3737] C void IBindingList.RemoveIndex(PropertyDescriptor property);

[3738] C void IBindingList::RemoveIn dex (PropertyDescriptor* property);

[3739] VB Sub RemoveIndex(ByVal property As PropertyDescriptor) Implements IBindingList.RemoveIndex

[3740] JScript function IBindingList.RemoveIndex(property : PropertyDescriptor); IBindingList.RemoveSort

[3741] C void IBindingList.RemoveSort( );

[3742] C void IBindingList:.RemoveSort( );

[3743] VB Sub RemoveSort( ) Implements IBindingList.RemoveSort

[3744] JScript function IBindingList.RemoveSort( );

[3745] ITypedList. GetItemProperties

[3746] C PropertyDescriptorCollection ITypedList. GetItemProperties(PropertyDescriptor listAccessors);

[3747] C PropertyDescriptorCollection*

[3748] ITypedList:: GetItemProperties(PropertyDescriptor* listAccessors );

[3749] VB Function GetItemProperties(ByVal listAccessors( ) As PropertyDescriptor) As PropertyDescriptorCollection Implements ITypedList. GetItemProperties

[3750] JScript function ITypedList. GetItemProperties(listAccessors: PropertyDescriptor ) : PropertyDescriptorCollection;

[3751] ITypedList. GetListName

[3752] C string ITypedList. GetListName(PropertyDescriptor listAccessors);

[3753] C String* ITypedList:: GetListName(PropertyDescriptor* listA ccessors );

[3754] VB Function GetListName(ByVal listAccessors( ) As PropertyDescriptor) As String Implements ITypedList. GetListName

[3755] JScript function ITypedList. GetListName(listAccessors : PropertyDescriptor ) : String;

[3756] UpdateIndex

[3757] C protected void UpdateIndex( );

[3758] C protected: void UpdateIndex( );

[3759] VB Protected Sub UpdateIndex( )

[3760] JScript protected function UpdateIndex( ); Reserved for internal use only.

[3761] Description

[3762] Reserved for internal use only.

[3763] UpdateIndex.

[3764] Cprotected virtual void UpdateIndex(bool force);

[3765] C protected: virtual void UpdateIndex(bool force);

[3766] VB Overridable Protected Sub UpdateIndex(ByVal force As Boolean)

[3767] JScript protected function UpdateIndex(force: Boolean);

[3768] Description

[3769] Reserved for internal use only. Reserved for internal use only.

[3770] DataViewManager class (System.Data)

[3771] UpdateIndex

[3772] Description

[3773] Contains a default System.Data.DataViewSettingCollection for each System.Data.DataTable in a System.Data.DataSet DataViewManager

[3774] Example Syntax:

[3775] UpdateIndex

[3776] C public DataViewManager( );

[3777] C public: DataViewManager( );

[3778] VB Public Sub New( )

[3779] JScript public function DataViewManager( ); Initializes a new instance of the System.Data.DataViewManager class.

[3780] Description

[3781] Initializes a new instance of the System.Data.DataViewManager class.

[3782] DataViewManager

[3783] Example Syntax:

[3784] UpdateIndex

[3785] C public DataViewManager(DataSet dataSet);

[3786] C public: DataViewManager(DataSet* dataSet);

[3787] VB Public Sub New(ByVal dataSet As DataSet)

[3788] JScript public function DataViewManager(dataSet : DataSet);

[3789] Description

[3790] Initializes a new instance of the System.Data.DataViewManager class for the specified System.Data.DataSet. The name of the System.Data.DataSet to use.

[3791] Container

[3792] DataSet

[3793] UpdateIndex

[3794] Description

[3795] Gets or sets the name of the System.Data.DataSet to use with the System.Data.DataViewManager.

[3796] DataViewSettingCollectionString

[3797] UpdateIndex

[3798] C public string DataViewSettingCollectionString get; set;

[3799] C public: _property String* get DataViewSettingCollectionString( );public: _property void set_DataViewSettingCollectionString(String*);

[3800] VB Public Property DataViewSettingCollectionString As String

[3801] JScript public function get DataViewSettingCollectionString( ) : String;public function set DataViewSettingCollectionString(String);

[3802] Description

[3803] Gets or sets a value used for code persistence.

[3804] A user should not call System.Data.DataViewManager.DataViewSettingCollectionString directly.

[3805] DataViewSettings

[3806] UpdateIndex

[3807] C public DataViewSettingCollection DataViewSettings get;

[3808] C public: _property DataViewSettingCollection* get_DataViewSettings( );

[3809] VB Public ReadOnly Property DataViewSettings As DataViewSettingCollection

[3810] JScript public function get DataViewSettings( ) : DataViewSettingCollection;

[3811] Description

[3812] Gets the System.Data.DataViewSettingCollection for each System.Data.DataTable in the System.Data.DataSet.

[3813] DesignMode

[3814] Events

[3815] Site

[3816] UpdateIndex

[3817] Description

[3818] Occurs a row is added to or deleted from a System.Data.DataView.

[3819] CreateDataView

[3820] C public DataView CreateDataView(DataTable table);

[3821] C public: DataView* CreateDataView(DataTable* table);

[3822] VB Public Function CreateDataView(ByVal table As DataTable) As DataView

[3823] JScript public function CreateDataView(table : DataTable) : DataView;

[3824] Description

[3825] Creates a System.Data.DataView for the specified System.Data.DataTable. The name of the System.Data.DataTable to use in the System.Data.ADataView.

[3826] OnListChanged

[3827] C protected virtual void OnListChanged(ListChangedEventArgs e);

[3828] C protected: virtual void OnListChanged(ListChangedEventArgs* e);

[3829] VB Overridable Protected Sub OnListChanged(ByVal e As ListChangedEventArgs)

[3830] JScript protected function OnListChanged(e: ListChangedEventArgs);

[3831] Description

[3832] Raises the System.Data.DataViewManager.ListChanged event. A System. ComponentModel.ListChangedEventArgs that contains the event data.

[3833] Relation Collection Changed

[3834] C protected virtual void RelationCollectionChanged(object sender, CollectionChangeEventArgs e);

[3835] C protected: virtual void RelationCollectionChanged(Object* sender, CollectionChangeEventArgs* e);

[3836] VB Overridable Protected Sub RelationCollectionChanged(ByVal sender As Object, ByVal e As Collection ChangeEventArgs)

[3837] JScript protected function RelationCollectionChanged(sender: Object, e: CollectionChangeEventArgs);

[3838] Description