| 24532 | Describes a problem that may occur in Access 2003. You may receive the Syntax error in INSERT INTO statement error message. Jet 4.0 reserved words that are used in the column names of your database table may cause this problem to occur. |
| 24533 | Explains that an exception occurs when you call an extended stored procedure from a ASP.NET Web application. Provides the file list that fixes the problem. |
| 24534 | Fixes a problem where a custom COM+ application runs slowly because the hash table size increases when you are running the .NET Framework 1.0 in Windows 2000. |
| 24535 | In an ADO.NET application, you may intermittently receive the following exception error message: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index |
| 24536 | After you rename the columns of a DataTable object in the DataSet , if you try to refer to the columns in case-insensitive manner, you receive the following exception: An unhandled exception of type 'System.ArgumentException' occurred in... |
| 24537 | Provides a fix for a problem that causes certain decimal values to be incorrectly rounded up with the SqlDecimal.Round method in ADO.NET. |
| 24538 | Explains how to use OpenXML with .NET providers to perform bulk updates and inserts in Visual Basic .NET. Requires SQL Server 2000 to perform this task. |
| 24539 | Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
| 24540 | XML is a fundamental part of Microsoft ADO.NET and XML Web Services. This article describes how to use XML in connected and disconnected ADO.NET applications: Connected ADO.NET applications can query Microsoft SQL Server to return an XML result and... |
| 24541 | This step-by-step article describes how to create a Windows form that displays a parent (or master) record and all the related child (or detail) records by using the Northwind Customers and Orders tables. This article also describes the... |
| 24542 | This article describes how to search for data in a Microsoft Windows Forms DataGrid control and how to synchronize the grid with the search results. In this sample, you programmatically retrieve data into a DataView class and then bind the DataView to... |
| 24543 | This article describes how to read and write data from LongVarBinary BLOB columns in a database table. This article contains examples of both the SqlDataAdapter class and the OleDbDataAdapter class. The only differences between the two classes, other... |
| 24544 | This step-by-step article discusses how to retrieve the identity column value from an Access database. Retrieving the Identity value from a Jet database is different from that of SQL Server, because a Jet database does not support multi-statement... |
| 24545 | When you delete the table that is bound to a control form of the DataSet Schema and then save the project in Microsoft Visual Studio .NET, you may receive the following error message when you open the form in Design view: Can't create a child list for... |
| 24546 | When you have a timestamp column in the query of the DataAdapter Wizard, the timestamp column is included in the InsertCommand property of the DataAdapter object. The DataAdapter Wizard uses OLE DB or Microsoft SQL Client .NET Data Providers. Although... |
| 24547 | When you use the ActiveX Data Objects (ADO) Connection object in Microsoft Visual Basic .NET to run a SQL query that is associated with the ADODB.Command object two times consecutively, you may receive the following error message: An unhandled... |
| 24548 | When you use an encrypted channel (for example, a connection that uses the HTTPS protocol) to make a request to a Microsoft SQL adapter, the SQL adapter may return the following error message: General network error. Check your network documentation. |
| 24549 | To make your data appear on a form, you bind a Microsoft Windows Forms DataGrid control to a DataTable object that is included in a DataSet object. After your data has appeared in the DataGrid control, you use the Tables.Clear method to remove the... |
| 24550 | In Microsoft Visual Studio .NET, when you try to debug an ADO.NET application, you cannot step into an associated Microsoft SQL Server stored procedure. You do not receive any error messages. However, the stored procedure window does not appear when... |
| 24551 | When you configure the OdbcDataAdapter using the Data Adapter Configuration Wizard, you may receive the following error message after you specify the SQL query string: No mapping exists from DbType Object to a known OdbcType. |
| 24552 | When you deserialize an ADO.NET DataSet from XML in the DiffGram format, null values are returned for fabricated DataColumns whose values are computed by using aggregate functions with expressions that reference columns in a child DataTable . The... |
| 24553 | This step-by-step article describes how to format DateTime and Date values in the XML that is extracted from an ADO.NET DataSet object. In ADO.NET, the DateTime and Date values of DataTable columns are written in the XSD DateTime and Date formats when... |
| 24554 | Performance of your computer system slows when you try to transform the XML representation of a DataSet that has multiple related DataTable objects whose DataRelation objects are not nested to reflect a hierarchical structure. |
| 24555 | This article describes how to display both SQL Server errors and warnings in ADO.NET. If you raise an error that has a severity level of 10 or less, which is a warning, no exception is raised. This warning is not populated into the SqlErrorCollection... |
| 24556 | Microsoft Visual Studio .NET Server Explorer generates SqlCommand objects that contain SqlParameter fields with incorrect data types when one of the following scenarios is true: You connect to the Microsoft SQL Server database by using Visual Studio... |
| 24557 | This article describes how to create a console application that uses COM Interop to create an earlier version of an ADO RecordSet object, to convert the RecordSet object to an ADO.NET DataSet object, and then to display the record count. back to the... |
| 24558 | This article points to a sample JoinView class that you can download, and then include in your Visual Basic .NET applications. The JoinView class is similar to the DataView class that permits you to join two or more DataTable objects together, and to... |
| 24559 | This step-by-step article explains how to retrieve the identity value when you add a record into a SQL Server table with an identity field. Requirements This sample uses the Northwind database in SQL Server and retrieves the identity values only for... |
| 24560 | This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass OracleType.Blob as an Input parameter to an Oracle stored procedure. Requirements The following list outlines the recommended hardware, software, network... |
| 24561 | This step-by-step article describes how to hide a column programatically in a Windows Form DataGrid by manipulating the properties of the DataGrid object. Requirements The following list outlines the recommended hardware, software, network... |
| 24562 | When you try to add, to update, or to delete records in an Excel workbook that uses the OLEDbDataAdapter with ADO.NET, you receive one of the following error messages: When you add a record: Syntax error in INSERT INTO statement. When you update a... |
| 24563 | This step-by-step article describes how to retrieve the identity value when you add a record into a SQL Server table with an identity field. Requirements This sample uses the Northwind database in SQL Server and retrieves the identity values only for... |
| 24564 | Extensible Markup Language (XML) is a fundamental part of ADO.NET and Web services. This article describes how to use XML in connected and disconnected ADO.NET applications: Connected ADO.NET applications can query SQL Server to return an XML result... |
| 24565 | This article demonstrates how to use ASP.NET and ADO.NET with Visual C# .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored... |
| 24566 | This step-by-step article describes how to query a database on a background thread, and how to use data binding to display the results of the query in a DataGrid object. When you run large queries to a database, your application may become... |
| 24567 | The step-by-step article demonstrates how to use the DataAdapter TableMappings collection to map the generic DataTable object names to the schema that is already defined in the typed DataSet object. When you use a DataAdapter object to fill a DataSet... |
| 24568 | When you bind a Windows Form DataGrid control, the DataGrid builds a DataGridTableStyle object that contains default properties of the grid column objects. However, you cannot access or modify a DataGridTableStyle object that is built this way. You... |
| 24569 | This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table. NOTES : This article provides examples of both the SqlClient and the OleDb DataAdapter . The only differences, apart from class names, are the... |
| 24570 | In ADO.NET, you can use the DataView.RowFilter property and the DataTable.Select method to filter a subset of records. However, the expressions that you can use have limitations. This article demonstrates three techniques to work around the... |
| 24571 | This step-by-step article demonstrates how to control editing tables in the DataGrid control on a table-by-table basis. The Navigate event of the DataGrid only fires when you move from DataTable object to DataTable object, not record to record. When... |
| 24572 | The ConnMaker tool is available for download to help users test connectivity through the .NET Data Providers to SQL Server, and to other server data sources. Source code for the tool is provided as a resource for programming connectivity and data... |
| 24573 | When you set some specific filter properties, the DataTable.Select method may leak memory. |
| 24574 | The OLE DB .NET managed provider does not support all OLE DB providers. |
| 24575 | This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains the unique values of a column of another DataTable object. To do this, you use the... |
| 24576 | This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the... |
| 24577 | This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an Input parameter, to retrieve a Ref Cursor from an Oracle stored procedure, and to display the information in a DataGrid object. Requirements The following... |
| 24578 | When you debug, you receive the following error message if you step over the SqlConnection.Open function in a Timer event: There is no source code for the current location. |
| 24579 | This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains the unique values of a column of another DataTable object. To do this, you use the... |
| 24580 | Use this step-by-step guide to write an XSD schema from a database. This article focuses on the following two scenarios: How to write an XSD schema from a DataSet object with one table where all columns are not required in the resulting XSD schema.... |
| 24581 | This step-by-step article describes how to fill a DataSet object with the results of one or more database queries and then how to access the data after the query is loaded in the DataSet object. DataSet objects are in-memory objects that can hold... |
| 24582 | Output parameters do not appear to be initialized or return a wrong value when you run an ADO.NET command. |
| 24583 | When you use the Microsoft ODBC .NET Managed Provider, and an intermittent network problem causes a loss of connection to your database server while you are trying to rollback the transaction, you may receive the following error message: Object... |
| 24584 | This step-by-step article describes how to use SQL stored procedures to dynamically page through a large result set in Microsoft ASP.NET. back to the top Methods of Implementation There are three main paging techniques that you can use in ASP.NET to... |
| 24585 | Support for the keyword encrypt has been added to the SqlConnection ConnectionString property. |
| 24586 | When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll... |
| 24587 | This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT, or the DELETE command) by using a Visual Basic .NET console application. back to the top Requirements The following list outlines... |
| 24588 | DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how... |
| 24589 | When you create a parameterized command against Microsoft SQL Server 7.0, if you call the Prepare method before you add parameters to the command, you receive the following error message: An unhandled exception of type... |
| 24590 | When you use a protocol other than Transmission Control Protocol/Internet Protocol (TCP/IP), SqlConnection.Open fails if you specify a port number other than 1433 to connect to an instance of Microsoft SQL Server. |
| 24591 | In Microsoft ADO.NET, an exception may occur when a transaction is committed or rolled back. When you call the Commit method of a transaction, you may encounter the following exception: The COMMIT TRANSACTION request has no corresponding BEGIN... |
| 24592 | On a computer that has Microsoft .NET Framework 1.0 installed (and that does not have Microsoft Visual Studio .NET installed), when you try to access data using ADO Interop on an ASP.NET page that resides at an identical site and that is hosted on the... |
| 24593 | On Windows Server 2003, if Microsoft Internet Information Services (IIS) 6.0 runs in non-legacy mode, you cannot step from managed code into a Microsoft SQL Server stored procedure while you debug in the Visual Studio .NET integrated development... |
| 24594 | This step-by-step article describes how to create a chart using the Office XP Chart Component with data from a DataSet . The solutions that this article presents use Visual Basic .NET and ASP.NET. Sources of Data for the Chart Component The Office XP... |
| 24595 | Output parameters do not appear to be initialized or return a wrong value when executing an ADO.NET command. |
| 24596 | This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and... |
| 24597 | The OleDbConnection class specifically prohibits you from using MSDASQL or data source names (DSNs) when you connect to your data sources in ADO.NET. If you try to use MSDASQL or DSNs, you receive the following error message: An unhandled exception of... |
| 24598 | When you create a parameterized command against Microsoft SQL Server 7.0, if you call the Prepare method before you add parameters to the command, you receive the following error message: An unhandled exception of type... |
| 24599 | This article describes how to format a string if there is a quotation mark in a member of the connection string. Description of the Technique The sample code demonstrates how to format a password that includes a quotation mark. Without the proper... |
| 24600 | Use this step-by-step guide to format a string if there is a quotation mark in a member of the connection string. Description of the Technique The sample explains how to format a password that includes a quotation mark. Without the proper formatting,... |
| 24601 | This step-by-step article provides guidelines about how to implement paging. This article provides a few examples of paging and describes the advantage of each method. Methods to Implement Paging There are many approaches to paging. Paging is... |
| 24602 | Use this step-by-step guide to extend the Windows Form DataGridTextBoxColumn control so that you can display data from other tables in the DataGrid , effectively joining two or more related DataTables for the purposes of display. NOTE : This technique... |
| 24603 | Use this step-by-step guide to extend the Windows Form DataGridTextBoxColumn control so that you can display data from other tables in the DataGrid , effectively joining two or more related DataTables for the purposes of display. NOTE : This technique... |
| 24604 | This step-by-step article describes how to use the ODBC .NET Managed Provider in Visual C# .NET. This article also includes samples connection strings that you can use to access your data. The ODBC .NET Data Provider is an add-on component to the... |
| 24605 | This step-by-step article describes how to use the ODBC .NET Managed Provider in Visual Basic .NET. This article also includes samples connection strings that you can use to access your data. The ODBC .NET Data Provider is an add-on component to the... |
| 24606 | The DataAdapter object throws generic exceptions when problems occur. Use this step-by-step guide to check for and report errors for each row and column in each table in a DataSet . You can use this information in update scenarios where it is... |
| 24607 | This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class. back to the top How to Copy DataRows Between DataTables Before you use the ImportRow method, you must ensure... |
| 24608 | This step-by-step article describes how to use the .NET Managed Provider for Oracle to pass an input parameter to retrieve a Ref Cursor from an Oracle stored procedure by using the OracleDataReader object. Requirements The following list outlines the... |
| 24609 | This step-by-step article demonstrates how to use an Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the... |
| 24610 | The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual J# .NET to read and write binary large object (BLOB) fields. Requirements The... |
| 24611 | This step-by-step article explains two ways that you can debug SQL Server stored procedures and the necessary configuration settings and steps for each approach. A Visual Studio .NET developer can use the Server Explorer to debug SQL Server stored... |
| 24612 | This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT or the DELETE command) by using a Visual J# .NET console application. Requirements The following list outlines the recommended... |
| 24613 | When you use the SQL Server ODBC driver, the SQL Server OLE DB provider, or the System.Data.SqlClient managed provider, you can disable connection pooling by using the respective application programming interfaces (APIs). When you disable pooling, the... |
| 24614 | When you try to set the ConnectionString property for a SqlConnection object at design time, the OLEDB DataLinks dialog box permits you to select any OLE DB provider on your system to generate a connection string for the SqlConnection object. When you... |
| 24615 | This step-by-step article describes how to convert an ADO.NET DataSet object to an ActiveX Data Objects (ADO) Recordset object. This article uses the XML approach to convert the DataSet to an ADO Recordset . The XML format that is persisted in ADO... |
| 24616 | This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception... |
| 24617 | This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception... |
| 24618 | This article describes how to retrieve a DataView object from a Windows Forms bound control. Description of the Technique To bind a data source to a Windows Forms control, you can code it yourself or use design-time binding. When the binding occurs at... |
| 24619 | The CurrencyManager object allows you to synchronize bound controls as a user browses through rows in a table. For example, CurrencyManager allows you to display the correct FirstName and LastName properties in separate, bound TextBox controls as a... |
| 24620 | When you call an OleDbDataReader object that invokes the Read method from a different single-threaded apartment (STA) thread than the object was created in, you receive the following exception: System.InvalidOperationException: The... |
| 24621 | This step-by-step article describes how to create a hierarchical DataSet object that you can use as a structure for your programs. You may not have the exact data or structure that you want to use for your project. You can use the method in this... |
| 24622 | If you create a strongly typed DataSet, the DataColumn.MaxLength property is not set. |
| 24623 | This article demonstrates how to use the GetOleDbSchemaTable method of the OleDbConnection object in ADO.NET to retrieve database schema information. Schema information in a data source includes databases or catalogs that are available from the data... |
| 24624 | This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
| 24625 | Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article shows how to gather this information. Requirements The following list outlines... |
| 24626 | This article describes how you can use ADO.NET to open a SQL Server database by using the SQL Server .NET data provider. ADO.NET gathers all of the classes that are required for data handling. The System.Data.SqlClient namespace describes a collection... |
| 24627 | In the following two MSDN links SqlDataReader.GetChars Method -and- OleDbDataReader.GetChars Method dataIndex is described as The index within the row from which to begin the read operation. The description for dataIndex should be The index within... |
| 24628 | This step-by-step article describes how to reuse the SqlCommand object in your Visual Basic .NET code. Description of the Technique You can reuse Command objects ( SqlCommand or OleDbCommand ) in code. That is, you can create one Command object and... |
| 24629 | This article describes how to retrieve a DataView object from a Windows Forms bound control. Description of the Technique To bind a data source to a Windows Forms control, you can code it yourself or use design-time binding. When the binding occurs at... |
| 24630 | When you run an ADO.NET command, the output parameters may not be initialized, or they may return an incorrect value. |
| 24631 | When you call the SqlConnection.BeginTransaction method and specify an isolation level in the IsolationLevel property, after the transaction is committed or rolled back, the IsolationLevel property is not reset to the default of... |
| 24632 | When you serialize a DBConcurrencyException object, the value of the Row property in the serialized version of the object is set to a null value and an exception occurs: An unhandled exception of type 'System.NullReferenceException' occurred in... |
| 24633 | Use this step-by-step guide to learn how to use base classes to reduce code forking with managed providers. Description of the Technique ADO.NET has different types of data providers (for example, SqlClient, OleDb, ODBC, and so on). If you choose the... |
| 24634 | This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a... |
| 24635 | Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class... |
| 24636 | Under the following circumstances An ASP.NET worker process (Aspnet_wp.exe) runs under the default ASPNET account. -and- You do not enable impersonation on that application. -and- You use the SQL Server .NET Data Provider or the OLE DB .NET Data... |
| 24637 | Use this step-by-step guide to copy hierarchical data into a DataSet by using the Fill method of the DataSet class. How to Read Hierarchical Data into a DataSet You can use hierarchical rowsets or chapters (OLE DB type DBTYPE_HCHAPTER and ADO type... |
| 24638 | This article demonstrates how to use the GetOleDbSchemaTable method of the OleDbConnection object in ADO.NET to retrieve database schema information. Schema information in a data source includes databases or catalogs that are available from the data... |
| 24639 | This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements. Description of the Technique ActiveX Data Objects (ADO) can... |
| 24640 | This article describes how to create a Windows form that displays a parent (or master) record and all of the related child (or detail) records by using the Northwind Customers and Orders tables. This article also describes the CurrencyManager object... |
| 24641 | This step-by-step article demonstrates how to create and test a Web service that returns a DataSet object to a client. This article also demonstrates how to reference the Web service in a client application and display the returned DataSet in a... |
| 24642 | The DataGrid Web control has built-in Automatic or Custom Paging functionalities; however, the DataGrid Windows control lacks these features. This article demonstrates how to create a simple paging mechanism for the DataGrid Windows control. The code... |
| 24643 | This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a... |
| 24644 | This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a... |
| 24645 | This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements. Description of the Technique ActiveX Data Objects (ADO) can... |
| 24646 | This step-by-step article demonstrates how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure,... |
| 24647 | This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual Basic .NET. Although executing a parameterized stored procedure using the ODBC .NET Provider is slightly different from... |
| 24648 | The GetSchemaTable method of the SqlDataReader object returns columns, the BaseServerName and BaseCatalogName properties. However, SqlDataReader.GetSchemaTable should only return BaseCatalogName. |
| 24649 | If you use the CommandBuilder object to explicitly get commands for the DataAdapter object as follows: da.InsertCommand = cb.GetInsertCommand and then run the following Visual Basic .NET code cb.DataAdapter = Nothing or the following Visual C# .NET... |
| 24650 | This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application... |
| 24651 | This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application... |
| 24652 | You can use ADO.NET DataTable objects to delete rows and mark them as Deleted. This article demonstrates how to retrieve the values of a row whose DataRowState enumeration is set to DataRowState.Deleted . Description of the Technique You can use the... |
| 24653 | This article lists the exceptions that can be raised when you invoke the Update method of a DataAdapter object to update a DataSet object or a DataTable object. These exceptions occur if the DataSet , the DataTable , or the UpdateCommand property is... |
| 24654 | The CurrencyManager object allows you to synchronize bound controls as a user browses through rows in a table. For example, CurrencyManager allows you to display the correct FirstName and LastName properties in separate, bound TextBox controls as a... |
| 24655 | ADO.NET provides new flexibility in how you update your data source. This article describes how you can update a data source that is different from the original data source that you use to create the DataSet object. Description of the Technique... |
| 24656 | ADO.NET provides new flexibility in how you update your data source. This article describes how you can update a data source that is different from the original data source that you use to create the DataSet object. Description of the Technique... |
| 24657 | This step-by-step article demonstrates how to use the OleDbDataAdapter class to obtain rows from an ADO Recordset object and insert them into a DataSet object. Note that you cannot do the reverse; that is, you cannot obtain rows from a DataSet object... |
| 24658 | This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a... |
| 24659 | This article demonstrates how to fill a DataSet object with the result set from an Oracle stored procedure. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident... |
| 24660 | This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
| 24661 | This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
| 24662 | The DataAdapter object is optimized for read-only scenarios by default. The Fill method only retrieves the amount of schema that is necessary to populate a DataSet object. To obtain the additional schema that are necessary to update or validate... |
| 24663 | This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual C# .NET. While executing a parameterized stored procedure using the ODBC .NET Provider is little different from... |
| 24664 | This step-by-step article demonstrates how to use a Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the... |
| 24665 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
| 24666 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and output parameters, including: Use a DataAdapter or DataSet object to gather the returned rows and to work with these rows in addition to the return... |
| 24667 | This article demonstrates how to persist an ADO.NET DataSet object to Extensible Markup Language (XML). Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that are required: A... |
| 24668 | This step-by-step article demonstrates how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure,... |
| 24669 | This step-by-step article describes how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure, and... |
| 24670 | This article demonstrates how to use the ADO.NET OleDbDataReader class to retrieve data from an Oracle database. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:... |
| 24671 | This article demonstrates how to fill a DataSet object with the resultset from an Oracle stored procedure. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident... |
| 24672 | This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application... |
| 24673 | This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a... |
| 24674 | This article describes the ActiveX Data Objects (ADO) SHAPE command syntax that produces hierarchical recordsets and explains how to traverse hierarchical recordsets. This article also provides sample code. You can use hierarchical recordsets as an... |
| 24675 | The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual C# .NET to read and write binary large object (BLOB) fields. Requirements The... |
| 24676 | This article describes how to create a Windows Form that displays a parent (or master) record and all of the related child (or detail) records by using the Northwind Customers and Orders tables. This article also describes the CurrencyManager object... |
| 24677 | This step-by-step article demonstrates how to create and test a Web service that returns a DataSet object to a client. This article also demonstrates how to reference the Web service in a client application and display the returned DataSet in a... |
| 24678 | This step-by-step article demonstrates how to use a Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the... |
| 24679 | The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update... |
| 24680 | This article demonstrates how to search for data in a Windows Form DataGrid control and synchronize the grid with the search results. In this sample, you programmatically retrieve data into a DataView class then bind the DataView to the DataGrid . The... |
| 24681 | This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual C# .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works best for... |
| 24682 | The DataGrid Web control has built-in Automatic or Custom Paging functionalities; however, the DataGrid Windows control lacks these features. This article demonstrates how to build a simple paging mechanism for the DataGrid Windows control. The code... |
| 24683 | This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains aggregate data (including optional rollup totals similar to the Microsoft SQL Server WITH... |
| 24684 | This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET. Create Sample Excel Worksheet Start Microsoft Excel, and create a new worksheet. Add the following... |
| 24685 | This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class. back to the top How to Copy DataRows Between DataTables Before you use the ImportRow method, you must ensure... |
| 24686 | Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article dicusses how to obtain the underlying provider errors when using ADO.NET in... |
| 24687 | This article describes the ActiveX Data Objects (ADO) SHAPE command syntax that produces hierarchical recordsets and explains how to traverse hierarchical recordsets. Sample code is also provided. You can use hierarchical recordsets as an alternative... |
| 24688 | This article explains how to use base classes to reduce code forking with managed providers. Description of the Technique ADO.NET has different types of data providers (for example, SqlClient, OleDb, ODBC, and so forth). If you choose the wrong .NET... |
| 24689 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
| 24690 | Extensible Markup Language (XML) is a fundamental part of ADO.NET and Web services. This article demonstrates how to use XML in connected and disconnected ADO.NET applications. Connected ADO.NET applications can query SQL Server to return an XML... |
| 24691 | This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual Basic .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works best... |
| 24692 | This article contains Microsoft Visual J# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the... |
| 24693 | This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, sometimes you may need to retrieve... |
| 24694 | This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this... |
| 24695 | This step-by-step article demonstrates how to perform a distributed transaction by using a .NET provider with the ServicedComponent class. Although this article uses the SqlClient .NET provider against a Microsoft SQL Server server, you can also use... |
| 24696 | This article provides a roadmap to learn and to master the DataSet objects and Extensible Markup Language (XML) Web services. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and... |
| 24697 | This step-by-step article describes how to copy an image stored in a database directly into a PictureBox control on a Windows Form without needing to save the image to a file. In Microsoft Visual Basic 6.0, the only way to display an image from a... |
| 24698 | This article demonstrates how to use ASP.NET and ADO.NET with Visual J# .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored... |
| 24699 | This article provides a roadmap to learn and master ADO.NET data providers. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to help you learn about a... |
| 24700 | This article provides a roadmap to learn and master ADO.NET DataAdapter objects. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to help you learn... |
| 24701 | This article provides a roadmap to learn and to master the ADO.NET DataSet , DataView , and DataViewManager objects. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft... |
| 24702 | This article provides a roadmap to learn and to master the Microsoft Visual Studio .NET Visual Database Tools and typed DataSet classes. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base... |
| 24703 | This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET. back to the top Create Sample Excel Worksheet Start Microsoft Excel, and then create a new worksheet. Add the... |
| 24704 | This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, you may have to retrieve a large... |
| 24705 | This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SQLClient managed provider, you can also use the OLEDB or the... |
| 24706 | This article contains Microsoft Visual Basic .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in... |
| 24707 | This article contains Microsoft Visual C# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the... |
| 24708 | The SqlDataAdapter object serves as a bridge between an ADO.NET DataSet object and a Microsoft SQL Server database. It is an intermediary object that you can use to do the following: Populate an ADO.NET DataSet with data retrieved from a SQL Server... |
| 24709 | This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Unlike with ADO 2.6 and later, ADO.NET does not support reading... |
| 24710 | This step-by-step article describes how to display an image that is stored in a database in a PictureBox control on a Windows Form. In Microsoft Visual Basic 6.0, the only way to display an image from a database in a PictureBox control, without the... |
| 24711 | Use this step-by-step guide to add a CheckBox control to a DataGrid control and bind it to the Authors table in the Microsoft SQL Server Pubs database. In Visual Studio .NET Web Forms, you can add controls to the DataGrid by using the TemplateColumn... |
| 24712 | This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 24713 | This article provides a roadmap to learn and to master data binding in Windows Forms applications. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to... |
| 24714 | This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 24715 | This article explains how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object. REQUIREMENTS The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 24716 | This article demonstrates how to persist an ADO.NET DataSet object to XML. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft Windows 2000 Professional,... |
| 24717 | This article demonstrates how to persist an ADO.NET DataSet object to Extensible Markup Language (XML). Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 24718 | DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article demonstrates how to fill a DataSet object with the results of one or more database queries... |
| 24719 | This step-by-step article demonstrates how to perform a distributed transaction by using a .NET provider with the ServicedComponent class. Although this article uses the SqlClient .NET provider against a Microsoft SQL Server server, you can also use... |
| 24720 | This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OLEDB or the... |
| 24721 | This step-by-step article describes how to copy an image stored in a database directly into a PictureBox control on a Windows Form without needing to save the image to a file. In Microsoft Visual Basic 6.0, the only way to display an image from a... |
| 24722 | The Microsoft Knowledge Base is categorized by keywords. The keywords help to refine the search criteria. This article lists the keywords that are used as metadata for .NET related Knowledge Base articles. The following .NET-related areas are included... |
| 24723 | This step-by-step article uses a Microsoft SQL Server TimeStamp field to detect update collisions in order to reduce the amount of data that is sent to the server. By default, the CommandBuilder object (both SqlClientCommandBuilder and... |
| 24724 | This step-by-step article describes how to display data from a hierarchical dataset by using the TreeView control in Microsoft Visual Basic .NET. To do this, you establish a parent, child, and grandchild relationship, and then fill the TreeView... |
| 24725 | This step-by-step article demonstrates how to handle optional input parameters for Microsoft SQL Server stored procedures in ADO.NET. Description of the Technique When you design stored procedures in SQL Server, it is typically good practice to... |
| 24726 | In Visual Studio .NET Server Explorer, a connection is established to a Microsoft SQL Server database. When you expand a table to view fields, or when you drag a table to the Form Designer, you may receive the following error message: ADO error:... |
| 24727 | When you are using the ODBC .NET Managed Provider and an intermittent network problem causes a loss of connection to your server, you may see a stack overflow issue. When you use the .NET Framework 1.0 Data Provider for ODBC (Microsoft.Data.Odbc.dll),... |
| 24728 | This article provides a roadmap to learn and master data binding using ASP.NET Web Forms. To assist you with learning a Microsoft product or technology, roadmap articles provide links to useful information, including online documentation, Microsoft... |
| 24729 | When you attempt to use the COMPUTE BY clause with the Microsoft SQL Server .NET Data Provider, you receive the following exception: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll. Additional information:... |
| 24730 | Programmers must frequently create databases programmatically. This step-by-step article describes how to use ADO.NET and Visual J# to programmatically create a Microsoft SQL Server database. Steps to Create the Sample Create a new Visual J# Windows... |
| 24731 | This article describes how to use the FileStream object and a byte array in ASP.NET to write binary large object (BLOB) data to Microsoft SQL Server. This article also describes how to load BLOB data from the SQL Server database and how to copy this... |
| 24732 | This step-by-step article describes how to call a parameterized Microsoft SQL Server stored procedure using the Open Database Connectivity (ODBC) .NET managed provider and Microsoft Visual C++ .NET. Executing a parameterized stored procedure by using... |
| 24733 | This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft SQL Server). This article also provides a Microsoft... |
| 24734 | This article demonstrates how to use the ADO.NET OLE DB managed provider to access an Oracle database. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 24735 | This step-by-step article uses a Microsoft SQL Server TimeStamp field to detect update collisions in order to reduce the amount of data sent to the server. By default, the CommandBuilder object (both SQLClient and OLEDB ) builds collision detection... |
| 24736 | The GetChunk and the AppendChunk methods are not available in ADO.NET to read and write binary large object (BLOB) fields. This article describes how to use the FileStream object and a byte array to read and to write BLOB data from Microsoft SQL... |
| 24737 | This article refers to the following Microsoft .NET Framework Class Library namespace: System.Data IN THIS TASK SUMMARY Additional Information About the Find Method Sample Code Troubleshoot REFERENCES This step-by-step article describes how to locate... |
| 24738 | This step-by-step article shows you how to create a Microsoft SQL Server database by using ADO.NET and Visual C# .NET because programmers often need to create Databases programmatically. Steps to Create a SQL Server Database To create the database,... |
| 24739 | You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can use this method to run... |
| 24740 | This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft SQL Server) and provides a Microsoft Access sample... |
| 24741 | The SqlDataAdapter.UpdateCommand Property MSDN documentation and the SqlDataAdapter.UpdateCommand Property topic in the Microsoft Visual Studio .NET Help documentation describe how to get or how to set a Transact-SQL statement to update records in a... |
| 24742 | This article describes the features and the limitations of the current version of the Microsoft .NET Managed Provider for Oracle. |
| 24743 | Use this step-by-step guide to retrieve table and column meta data from a Microsoft Excel data source by using the GetOleDbSchemaTable method with the Microsoft OLE DB Managed Provider and the Microsoft OLE DB Provider for Jet. The GetOleDbSchemaTable... |
| 24744 | When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message: System.Data.OleDb.OleDbException: Cannot start more transactions on this... |
| 24745 | This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET... |
| 24746 | You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can only use this method to run... |
| 24747 | This article provides a way to learn about ADO.NET. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers to help you learn about a Microsoft product or... |
| 24748 | This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET... |
| 24749 | When you use ASP.Net to retrieve data from Microsoft SQL Server, the Web server may acquire an accumulation of aspnet_wp processes that are not using the CPU and that have only a few remaining threads. During ASP.NET process recycling, an aspnet_wp... |
| 24750 | Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual Basic .NET to programmatically create a Microsoft SQL Server database. Steps to Create the Sample Create a new Visual Basic .NET Windows... |
| 24751 | When you try to enlist an Oracle connection in a distributed transaction by using the Microsoft .NET Framework Managed Provider for Oracle, you receive the following System.InvalidOperationException exception: Failed to initialize distributed... |
| 24752 | Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual C++ .NET to programmatically create a Microsoft SQL Server database. Steps to Create the Sample Start Microsoft Visual Studio .NET, and... |
| 24753 | When you try to open a connection in a deployed .NET application, you may encounter an exception similar to the following: The .NET Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components (MDAC) version 2.6 or later. |
| 24754 | This step-by-step article describes how to retrieve table and column metadata from Microsoft Excel data sources by using the GetOleDbSchemaTable method with the Microsoft OLE DB Managed Provider and the Microsoft OLE DB Provider for Jet. The... |
| 24755 | When you use the System.Data.SqlClient.SqlConnection class to connect to a Microsoft SQL Server database with protocol encryption enabled, one or more objects in the .NET-managed heap can be corrupted. This causes the Microsoft .NET application to... |
| 24756 | Programmers often need to create databases programmatically. Although neither ActiveX Data Objects (ADO) nor ADO.NET provide the means to create Microsoft Access databases automatically, you can use the Microsoft Jet OLE DB Provider and Microsoft ADO... |
| 24757 | Session Summary April 24, 2003 The objective of this session is to introduce ADO.NET and XML developers to the new features and changes in the System.Data and the System.Xml namespaces in version 1.1 of the Microsoft .NET Framework. This is a Level... |
| 24758 | Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual Basic... |
| 24759 | Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual C# .NET,... |
| 24760 | Session Summary During this session, we will illustrate ADO .NET components and some techniques you can use to programmatically achieve common database tasks. We will also discuss how ADO is different from ADO .NET, and when ADO can be used in .NET... |
| 24761 | Session Summary May 1, 2003 This Support WebCast session will discuss the concepts for handling ADO.NET concurrency using Microsoft Visual Basic Windows Forms in Visual Studio .NET. It will talk about the types of concurrency control, optimistic... |
| 24762 | This article describes how the Microsoft .NET Platform OLE DB types map to the Microsoft Access data types for columns. |
| 24763 | Programmers may have to create databases programmatically, but neither ActiveX Data Objects (ADO) nor ADO.NET provides the means to create Microsoft Access databases. However, you can create Access databases by using the Microsoft Jet OLE DB Provider... |
| 24764 | In Visual C# .NET, you can write multithreaded applications. This article describes how a simple Visual C# .NET application can create and manage threads. back to the top Requirements The following list outlines the recommended hardware, software,... |
| 24765 | When you configure the OdbcDataAdapter using the Data Adapter Configuration Wizard, you may receive the following error message after you specify the SQL query string: No mapping exists from DbType Object to a known OdbcType. |
| 24766 | When you execute an extended stored procedure against SQL Server 7.0 by using the .NET Framework Data Provider for SQL Server (SqlClient), you may receive the following error message: Timeout Expired The Timeout Expired error occurs when the... |
| 24767 | When you create a SqlDataAdapter object for a join query that has columns only from one table that is used in the query, the FillSchema method of the SqlDataAdapter object does not include the schema for the PrimaryKey column of the table. This... |
| 24768 | This step-by-step article describes how to fill a DataSet object with the results of one or more database queries and then how to access the data after the query is loaded in the DataSet object. DataSet objects are in-memory objects that can hold... |
| 24769 | When you set some specific filter properties, the DataTable.Select method may leak memory. |
| 24770 | This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains aggregate data from another DataTable object. To do this, use the following public methods:... |
| 24771 | This article describes how to search for data in a Windows Form DataGrid control and how to synchronize the grid with the search results. In this sample, you programmatically retrieve data into a DataView class, and then bind the DataView to the... |
| 24772 | Extensible Markup Language (XML) is a fundamental part of ADO.NET and Web services. This article describes how to use XML in connected and disconnected ADO.NET applications: Connected ADO.NET applications can query SQL Server to return an XML result... |
| 24773 | If more than one connection exists in Microsoft Visual Studio .NET Server Explorer, and if you cannot see Server Explorer in Visual Studio .NET, you may receive the following error message when you click Fill Dataset to preview the data in the Data... |
| 24774 | With Microsoft .NET Managed Provider for Oracle, when you try to execute an Oracle stored procedure that has more than one output parameter of data type Number , you receive the following error message: ORA-01458: invalid length inside variable... |
| 24775 | You deploy a Microsoft .NET Framework application that accesses a database on a computer. The computer only has the .NET Framework Redistributable package installed. When you run the application, you may receive the following error message: An... |
| 24776 | When you create a new data connection to an Oracle database with the ODBC Driver (Microsoft OLE DB Provider for ODBC Drivers) in Server Explorer, the data connection does not appear in the Data Adapter Configuration Wizard of the OdbcDataAdapter. |
| 24777 | When you try to update more than one column of a table by using a bound user control that has multiple bound properties, only the modified data for the first bound property is updated in the table. You may notice this behavior only for the first row... |
| 24778 | This step-by-step article discusses how to retrieve the identity column value from an Access database. Retrieving the Identity value from a Jet database is different from that of SQL Server, because a Jet database does not support multi-statement... |
| 24779 | Session Summary May 1, 2003 This Support WebCast session will discuss the concepts for handling ADO.NET concurrency using Microsoft Visual Basic Windows Forms in Visual Studio .NET. It will talk about the types of concurrency control, optimistic... |
| 24780 | When you call a Microsoft SQL Server user-defined function from a Microsoft ADO.NET application, the user-defined function returns 0 instead of the expected return value. This behavior occurs when you call a user-defined function by using SQL Server... |
| 24781 | When you have an application that uses ASP.NET and System.Data.SqlClient with the SqlConnection.ConnectionString property Pooling value set to true , you may receive the following exception error message during a call to... |
| 24782 | This article refers to the following Microsoft .NET Framework Class Library namespace: System.Data IN THIS TASK SUMMARY Additional Information About the Find Method Sample Code Troubleshoot REFERENCES This step-by-step article describes how to locate... |
| 24783 | Session Summary April 24, 2003 The objective of this session is to introduce ADO.NET and XML developers to the new features and changes in the System.Data and the System.Xml namespaces in version 1.1 of the Microsoft .NET Framework. This is a Level... |
| 24784 | When the UpdateCommand method of the SqlDataAdapter object uses a SQL Server stored procedure that raises an error after it returns a result set, the ADO.NET client application may not trap the error raised by SQL Server. However, you can use theSqlDataReader object to trap such error messages. This article describes how to use the SqlDatareader object to trap the |
| 24785 | When you debug, you receive the following error message if you step over the SqlConnection.Open function in a Timer event: There is no source code for the current location. |
| 24786 | When you use the System.Data.SqlClient.SqlConnection class to connect to a Microsoft SQL Server database with protocol encryption enabled, one or more objects in the .NET-managed heap can be corrupted. This causes the Microsoft .NET application to... |
| 24787 | The Microsoft Knowledge Base is categorized by keywords. The keywords help to refine the search criteria. This article lists the keywords that are used as metadata for .NET related Knowledge Base articles. The following .NET-related areas are included... |
| 24788 | This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a table from a comma-delimited list of field names and data types. This article includes a second method so that you can also... |
| 24789 | This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, you may have to retrieve a large... |
| 24790 | The Microsoft ODBC .NET managed provider always binds a decimal or numeric data type value with a precision of 28. Even if you manually set the precision of a decimal or numeric parameter to something other than 28, the ODBC .Net managed provider... |
| 24791 | ADO.NET does not throw any exceptions when it validates data that is newly inserted or modified in a DataRow. This is true if the DataRow violates XSD facets that are defined in an underlying XSD schema of the DataSet object. |
| 24792 | Programmers often need to create databases programmatically. Although neither ActiveX Data Objects (ADO) nor ADO.NET provide the means to create Microsoft Access databases automatically, you can use the Microsoft Jet OLE DB Provider and Microsoft ADO... |
| 24793 | On a computer that has Microsoft .NET Framework 1.0 installed (and that does not have Microsoft Visual Studio .NET installed), when you try to access data using ADO Interop on an ASP.NET page that resides at an identical site and that is hosted on the... |
| 24794 | When you bind a Windows Form DataGrid control, the DataGrid builds a DataGridTableStyle object that contains default properties of the grid column objects. However, you cannot access or modify a DataGridTableStyle object that is built this way. You... |
| 24796 | This step-by-step article describes how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure, and... |
| 24797 | This step-by-step article describes how to convert an ADO.NET DataSet object to an ActiveX Data Objects (ADO) Recordset object. This article uses the XML approach to convert the DataSet to an ADO Recordset . The XML format that is persisted in ADO... |
| 24798 | The ConnMaker tool is available for download to help users test connectivity through the .NET Data Providers to SQL Server, and to other server data sources. Source code for the tool is provided as a resource for programming connectivity and data... |
| 24799 | When you edit a child table row in a DataSet , you may receive the following error message. Object reference not set to an instance of an object. (91) This error occurs when the following conditions are true: The DataSet was contructed from XML that... |
| 24800 | SUMMARY Level:200 This Support WebCast session discusses the different team development models that you can use for Web project development using Microsoft Visual Studio .NET. It will cover various aspects of each model, such as how to set up each |
| 24801 | SUMMARY This step-by-step article describes how to implement and how use a DataSetHelper class that includes sample code to create a DataTable object from two or more related DataTable definitions and to copy records that are sorted and filtered |
| 24802 | This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains the unique values of a column of another DataTable object. To do this, you use the... |
| 24803 | When you use the SQL Server ODBC driver, the SQL Server OLE DB provider, or the System.Data.SqlClient managed provider, you can disable connection pooling by using the respective application programming interfaces (APIs). When you disable pooling, the... |
| 24804 | When you deserialize an ADO.NET DataSet from XML in the DiffGram format, null values are returned for fabricated DataColumns whose values are computed by using aggregate functions with expressions that reference columns in a child DataTable . The... |
| 24805 | This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object from an existing DataTable definition and to copy records that are sorted and filtered from the source... |
| 24806 | SYMPTOMS When you evaluate the expression that is specified in a computed column of a DataRow, incorrect results may be returned if the expression contains integer division. The resulting expression is rounded inconsistently. |
| 24807 | This article points to a sample JoinView class that you can download, and then include in your Visual Basic .NET applications. The JoinView class is similar to the DataView class that permits you to join two or more DataTable objects together, and to... |
| 24808 | On Windows Server 2003, if Microsoft Internet Information Services (IIS) 6.0 runs in non-legacy mode, you cannot step from managed code into a Microsoft SQL Server stored procedure while you debug in the Visual Studio .NET integrated development... |
| 24809 | If the Tag property of a Windows Forms control is bound to a read-only field in a DataSet object, you cannot move the focus away from the control, and you cannot close the form. |
| 24810 | This article contains Microsoft Visual J# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the... |
| 24811 | SUMMARY This step-by-step article shows you how to fully use Advanced Data Binding in the Visual Studio .NET IDE by using a DataAdapter, a Connection, and two DataSets. This article also shows you how to convert data source data to .NET |
| 24812 | This step-by-step article demonstrates how to create and test a Web service that returns a DataSet object to a client. This article also demonstrates how to reference the Web service in a client application and display the returned DataSet in a... |
| 24813 | This step-by-step article describes how to retrieve a DataSet object from a Web service, how to send DiffGram updates to the Web service, and then how to merge the updated DiffGram back into the client DataSet. This process involves the following... |
| 24814 | Performance of your computer system slows when you try to transform the XML representation of a DataSet that has multiple related DataTable objects whose DataRelation objects are not nested to reflect a hierarchical structure. |
| 24815 | When you try to recursively navigate an XmlDataDocument that has been synchronized with a filled ADO.NET DataSet, all of the data is not returned. |
| 24816 | This article describes how to use the FileStream object and a byte array in ASP.NET to write binary large object (BLOB) data to Microsoft SQL Server. This article also describes how to load BLOB data from the SQL Server database and how to copy this... |
| 24817 | This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains the unique values of a column of another DataTable object. To do this, you use the... |
| 24818 | This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object that contains aggregate data (including optional rollup totals similar to the Microsoft SQL Server WITH... |
| 24819 | SUMMARY This step-by-step article describes how to implement and how use a DataSetHelper class that includes sample code to create a DataTable objects from two or more related DataTable definitions and to copy records that are sorted and filtered |
| 24820 | SUMMARY This step-by-step article illustrates how to implement and how to use a DataSetHelper class that includes sample code to create a table from a comma-delimited list of field names and data types. This article includes a second method so that |
| 24821 | This step-by-step article describes how to implement and how to use a DataSetHelper class that includes sample code to create a DataTable object from an existing DataTable definition and to copy records that are sorted and filtered from the source... |
| 24822 | In ADO.NET, you can use the DataView.RowFilter property and the DataTable.Select method to filter a subset of records. However, the expressions that you can use have limitations. This article demonstrates three techniques to work around the... |
| 24823 | This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT or the DELETE command) by using a Visual J# .NET console application. Requirements The following list outlines the recommended... |
| 24824 | During this session, we will talk about working with ADO.NET datasets and typed datasets. The primary discussion will be about the programming aspects of datasets and Visual Basic .NET code snippets. |
| 24825 | In Visual Studio .NET Server Explorer, a connection is established to a Microsoft SQL Server database. When you expand a table to view fields, or when you drag a table to the Form Designer, you may receive the following error message: ADO error:... |
| 24826 | The "Synchronizing a DataSet with an XmlDataDocument" Microsoft Developer Network (MSDN) topic has the following information: |
| 24827 | Session Summary During this session, we will illustrate ADO .NET components and some techniques you can use to programmatically achieve common database tasks. We will also discuss how ADO is different from ADO .NET, and when ADO can be used in .NET... |
| 24828 | The objective of this session is to introduce the basics (and the architecture) of executing SQLXML queries in Microsoft .NET applications by using SQLXML Managed Classes. Code examples will be presented to illustrate how to execute differe |
| 24829 | When you try to enlist an Oracle connection in a distributed transaction by using the Microsoft .NET Framework Managed Provider for Oracle, you receive the following System.InvalidOperationException exception: Failed to initialize distributed... |
| 24830 | This step-by-step article demonstrates how to use an Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the... |
| 24831 | This step-by-step article describes how to display an image that is stored in a database in a PictureBox control on a Windows Form. In Microsoft Visual Basic 6.0, the only way to display an image from a database in a PictureBox control, without the... |
| 24832 | The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual J# .NET to read and write binary large object (BLOB) fields. Requirements The... |
| 24833 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
| 24834 | This article demonstrates how to use ASP.NET and ADO.NET with Visual J# .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the stored... |
| 24835 | The step-by-step article demonstrates how to use the DataAdapter TableMappings collection to map the generic DataTable object names to the schema that is already defined in the typed DataSet object. When you use a DataAdapter object to fill a DataSet... |
| 24836 | This article describes the features and the limitations of the current version of the Microsoft .NET Managed Provider for Oracle. |
| 24837 | This article describes how the Microsoft .NET Platform OLE DB types map to the Microsoft Access data types for columns. |
| 24838 | This article provides a roadmap to learn and to master the DataSet objects and Extensible Markup Language (XML) Web services. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and... |
| 24839 | You can use the XML Schema Definition Tool (Xsd.exe) to generate the common language runtime classes from an XML schema. When you do so, elements that have the |
| 24840 | This article describes how to fill a DataSet object with the result set from an Oracle stored procedure. The DataSet object is central to supporting disconnected, distributed-data scenarios with ADO.NET. The DataSet object is a memory-resident... |
| 24841 | This step-by-step article demonstrates how to control editing tables in the DataGrid control on a table-by-table basis. The Navigate event of the DataGrid only fires when you move from DataTable object to DataTable object, not record to record. When... |
| 24842 | This step-by-step article demonstrates how to control editing tables in the DataGrid control on a table-by-table basis. The Navigate event of the DataGrid only fires when you move from DataTable object to DataTable object, not record to record. When... |
| 24843 | If you try to open a |
| 24844 | This step-by-step article demonstrates how to handle optional input parameters for Microsoft SQL Server stored procedures in ADO.NET. Description of the Technique When you design stored procedures in SQL Server, it is typically good practice to... |
| 24845 | This article provides a roadmap to learn and to master the Microsoft Visual Studio .NET Visual Database Tools and typed DataSet classes. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base... |
| 24846 | Programmers may have to create databases programmatically, but neither ActiveX Data Objects (ADO) nor ADO.NET provides the means to create Microsoft Access databases. However, you can create Access databases by using the Microsoft Jet OLE DB Provider... |
| 24847 | If you create a strongly typed DataSet, the DataColumn.MaxLength property is not set. |
| 24848 | Programmers must frequently create databases programmatically. This step-by-step article describes how to use ADO.NET and Visual J# to programmatically create a Microsoft SQL Server database. Steps to Create the Sample Create a new Visual J# Windows... |
| 24849 | If you use an OLE DB managed provider, the OLE DB managed provider ignores the |
| 24850 | This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and... |
| 24851 | This step-by-step article describes how to create a chart using the Office XP Chart Component with data from a DataSet . The solutions that this article presents use Visual Basic .NET and ASP.NET. Sources of Data for the Chart Component The Office XP... |
| 24852 | This article provides a roadmap to learn and master data binding using ASP.NET Web Forms. To assist you with learning a Microsoft product or technology, roadmap articles provide links to useful information, including online documentation, Microsoft... |
| 24853 | When you try to add, to update, or to delete records in an Excel workbook that uses the OLEDbDataAdapter with ADO.NET, you receive one of the following error messages: When you add a record: Syntax error in INSERT INTO statement. When you update a... |
| 24854 | This step-by-step article describes how to display data from a hierarchical dataset by using the TreeView control in Microsoft Visual Basic .NET. To do this, you establish a parent, child, and grandchild relationship, and then fill the TreeView... |
| 24855 | This step-by-step article explains how to retrieve the identity value when you add a record into a SQL Server table with an identity field. Requirements This sample uses the Northwind database in SQL Server and retrieves the identity values only for... |
| 24856 | This step-by-step article describes how to retrieve the identity value when you add a record into a SQL Server table with an identity field. Requirements This sample uses the Northwind database in SQL Server and retrieves the identity values only for... |
| 24857 | In the MSDN Library Topic |
| 24858 | Under the following circumstances |
| 24859 | This article provides a roadmap to learn and to master data binding in Windows Forms applications. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to... |
| 24860 | This step-by-step article explains how to retrieve a DataSet from a Web Service, send DiffGram updates to the Web Service, and then merge the updated DiffGram back into the client DataSet . The client application retrieves a DataSet |
| 24861 | This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft SQL Server). This article also provides a Microsoft... |
| 24862 | If you try to use a custom expression for the value of the DisplayMember property of a bound control, the combo box does not accept any input other than a valid field name from the data source. |
| 24863 | The SqlDataAdapter.UpdateCommand Property MSDN documentation and the SqlDataAdapter.UpdateCommand Property topic in the Microsoft Visual Studio .NET Help documentation describe how to get or how to set a Transact-SQL statement to update records in a... |
| 24864 | This article demonstrates how to search for data in a Windows Form DataGrid control and synchronize the grid with the search results. In this sample, you programmatically retrieve data into a DataView class then bind the DataView to the DataGrid . The... |
| 24865 | When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message: System.Data.OleDb.OleDbException: Cannot start more transactions on this... |
| 24866 | When you execute the ChangeDatabase method of a Connection object, you may receive the following error message: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: |
| 24867 | When you try to set custom, provider-specific properties for the Microsoft OLE DB Provider for Jet in the ADO OLE DB connection string, you receive the following error message: Could not find installable ISAM Error Code: 0x80004005 (or |
| 24868 | This step-by-step article demonstrates how to perform a distributed transaction by using a .NET provider with the ServicedComponent class. Although this article uses the SqlClient .NET provider against a Microsoft SQL Server server, you can also use... |
| 24869 | This step-by-step article demonstrates how to use the OleDbDataAdapter class to obtain rows from an ADO Recordset object and insert them into a DataSet object. Note that you cannot do the reverse; that is, you cannot obtain rows from a DataSet object... |
| 24870 | If the header of an Extensible Markup Language (XML) file specifies an encoding type that contains a lowercase "i," and if you are running a Turkish version of Microsoft Windows, you receive the following error message when you try to read |
| 24871 | This article describes how to load hierarchical data into a DataSet by using the Fill method of the DataSet class. How to Read Hierarchical Data into a DataSet You can use hierarchical rowsets, or chapters (OLE DB type DBTYPE_HCHAPTER; ADO type... |
| 24872 | This article shows how to create and use a typed |
| 24873 | This step-by-step article describes how to create a hierarchical DataSet object that you can use as a structure for your programs. You may not have the exact data or structure that you want to use for your project. You can use the method in this... |
| 24874 | When you install the .NET Framework on a computer, a .NET CLR Data performance counter is added to Performance Monitor (Perfmon). If you use these counters, you may notice that the perfomance information is not reset when you close and then |
| 24875 | If you try to use the Microsoft Visual FoxPro (VFP) OLEDB Provider with the |
| 24876 | When you are using SET statements that are followed by resultsets that are returning statements such as SELECT, existing Microsoft SQL tools return non-resultset queries. This is not true when you are using |
| 24877 | If you call the |
| 24878 | When you update records with an |
| 24879 | Use this step-by-step guide to retrieve table and column meta data from a Microsoft Excel data source by using the GetOleDbSchemaTable method with the Microsoft OLE DB Managed Provider and the Microsoft OLE DB Provider for Jet. The GetOleDbSchemaTable... |
| 24880 | If you upgrade a Microsoft Visual Basic 6.0 project to Visual Basic .NET, and the project contains a DataGrid that was populated by using the |
| 24881 | Use this step-by-step guide to extend the Windows Form DataGridTextBoxColumn control so that you can display data from other tables in the DataGrid , effectively joining two or more related DataTables for the purposes of display. NOTE : This technique... |
| 24882 | Use this step-by-step guide to extend the Windows Form DataGridTextBoxColumn control so that you can display data from other tables in the DataGrid , effectively joining two or more related DataTables for the purposes of display. NOTE : This technique... |
| 24883 | When large queries to a database are executed, the application may become unresponsive for a long period of time. To avoid this behavior and decrease the waiting time of the user, the query can be executed on a background thread, releasing |
| 24884 | When large queries to a database are executed, the application may become unresponsive for a long period of time. To avoid this behavior and decrease the waiting time of the user, the query can be executed on a background thread, releasing |
| 24885 | This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual C# .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works best for... |
| 24886 | When you try to set the ConnectionString property for a SqlConnection object at design time, the OLEDB DataLinks dialog box permits you to select any OLE DB provider on your system to generate a connection string for the SqlConnection object. When you... |
| 24887 | This step-by-step article describes how to reuse the SqlCommand object in your Visual Basic .NET code. Description of the Technique You can reuse Command objects ( SqlCommand or OleDbCommand ) in code. That is, you can create one Command object and... |
| 24888 | This step-by-step article describes how to reuse the SqlCommand object in your Visual C# .NET code. Description of the Technique You can reuse Command objects ( SqlCommand or OleDbCommand ) in code. That is, you can create one Command object and then... |
| 24889 | This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this... |
| 24890 | Use this step-by-step guide to copy hierarchical data into a DataSet by using the Fill method of the DataSet class. How to Read Hierarchical Data into a DataSet You can use hierarchical rowsets or chapters (OLE DB type DBTYPE_HCHAPTER and ADO type... |
| 24891 | When you execute the |
| 24892 | This step-by-step article demonstrates how to perform a distributed transaction by using a .NET provider with the ServicedComponent class. Although this article uses the SqlClient .NET provider against a Microsoft SQL Server server, you can also use... |
| 24893 | This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a... |
| 24894 | Use this step-by-step guide to format a string if there is a quotation mark in a member of the connection string. Description of the Technique The sample explains how to format a password that includes a quotation mark. Without the proper formatting,... |
| 24895 | This step-by-step article describes how to copy an image stored in a database directly into a PictureBox control on a Windows Form without needing to save the image to a file. In Microsoft Visual Basic 6.0, the only way to display an image from a... |
| 24896 | This article provides a roadmap to learn and to master the ADO.NET DataSet , DataView , and DataViewManager objects. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft... |
| 24897 | This step-by-step article describes how to copy an image stored in a database directly into a PictureBox control on a Windows Form without needing to save the image to a file. In Microsoft Visual Basic 6.0, the only way to display an image from a... |
| 24898 | Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table. NOTES This article contains examples for both the SqlClient and the OleDb DataAdapter classes. The only differences, apart from the class... |
| 24899 | Use this step-by-step guide to add a CheckBox control to a DataGrid control and bind it to the Authors table in the Microsoft SQL Server Pubs database. In Visual Studio .NET Web Forms, you can add controls to the DataGrid by using the TemplateColumn... |
| 24900 | This step-by-step article describes how to extend the Windows Form DataGridTextBoxColumn control so that you can custom-format your data for display and editing in a Windows Form DataGrid. |
| 24901 | This step-by-step article describes how to hide a column programatically in a Windows Form DataGrid by manipulating the properties of the DataGrid object. Requirements The following list outlines the recommended hardware, software, network... |
| 24902 | In the |
| 24903 | Use this step-by-step guide to learn how to use base classes to reduce code forking with managed providers. Description of the Technique ADO.NET has different types of data providers (for example, SqlClient, OleDb, ODBC, and so on). If you choose the... |
| 24904 | Use this step-by-step guide to write an XSD schema from a database. This article focuses on the following two scenarios: How to write an XSD schema from a DataSet object with one table where all columns are not required in the resulting XSD schema.... |
| 24905 | This step-by-step article describes how to retrieve table and column metadata from Microsoft Excel data sources by using the GetOleDbSchemaTable method with the Microsoft OLE DB Managed Provider and the Microsoft OLE DB Provider for Jet. The... |
| 24906 | This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Because of network constraints, sometimes you may need to retrieve... |
| 24907 | This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table. NOTES : This article provides examples of both the SqlClient and the OleDb DataAdapter . The only differences, apart from class names, are the... |
| 24908 | This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table. Unlike with ADO 2.6 and later, ADO.NET does not support reading... |
| 24909 | The DataAdapter object throws generic exceptions when problems occur. Use this step-by-step guide to check for and report errors for each row and column in each table in a DataSet . You can use this information in update scenarios where it is... |
| 24910 | This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SQLClient managed provider, you can also use the OLEDB or the... |
| 24911 | When you try to compile the Visual Basic .NET sample code that is included in the |
| 24912 | When you try to compile the Visual C# .NET sample code that is included in the |
| 24913 | This step-by-step article explains two ways that you can debug SQL Server stored procedures and the necessary configuration settings and steps for each approach. A Visual Studio .NET developer can use the Server Explorer to debug SQL Server stored... |
| 24914 | This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception... |
| 24915 | This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception... |
| 24916 | This step-by-step article uses a Microsoft SQL Server TimeStamp field to detect update collisions in order to reduce the amount of data sent to the server. By default, the CommandBuilder object (both SQLClient and OLEDB ) builds collision detection... |
| 24917 | This step-by-step article uses a Microsoft SQL Server TimeStamp field to detect update collisions in order to reduce the amount of data that is sent to the server. By default, the CommandBuilder object (both SqlClientCommandBuilder and... |
| 24918 | This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application... |
| 24919 | This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application... |
| 24920 | This article describes how to retrieve a DataView object from a Windows Forms bound control. Description of the Technique To bind a data source to a Windows Forms control, you can code it yourself or use design-time binding. When the binding occurs at... |
| 24921 | This article describes how to retrieve a DataView object from a Windows Forms bound control. Description of the Technique To bind a data source to a Windows Forms control, you can code it yourself or use design-time binding. When the binding occurs at... |
| 24922 | When you set the |
| 24923 | When you set the scale for a parameter of type NUMBER, it does not affect the value of the parameter that is passed to the database. |
| 24924 | In the following two MSDN links SqlDataReader.GetChars Method -and- OleDbDataReader.GetChars Method dataIndex is described as The index within the row from which to begin the read operation. The description for dataIndex should be The index within... |
| 24925 | When you use a protocol other than Transmission Control Protocol/Internet Protocol (TCP/IP), SqlConnection.Open fails if you specify a port number other than 1433 to connect to an instance of Microsoft SQL Server. |
| 24926 | The DataGrid Web control has built-in Automatic or Custom Paging functionalities; however, the DataGrid Windows control lacks these features. This article demonstrates how to create a simple paging mechanism for the DataGrid Windows control. The code... |
| 24927 | This article demonstrates how to programmatically retrieve data from a Microsoft Access database and present the data to the user. The sample in this article uses the |
| 24928 | The GetChunk and the AppendChunk methods are not available in ADO.NET to read and write binary large object (BLOB) fields. This article describes how to use the FileStream object and a byte array to read and to write BLOB data from Microsoft SQL... |
| 24929 | When you set a property value on an ActiveX Data Objects (ADO) object to a string value, you may encounter the following exception: Unhandled Exception: System.Runtime.InteropServices.COMException (0x800A0BB9): Arguments are of the wrong type, are out... |
| 24930 | Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article dicusses how to obtain the underlying provider errors when using ADO.NET in... |
| 24931 | This article describes the ActiveX Data Objects (ADO) SHAPE command syntax that produces hierarchical recordsets and explains how to traverse hierarchical recordsets. Sample code is also provided. You can use hierarchical recordsets as an alternative... |
| 24932 | This article explains how to use base classes to reduce code forking with managed providers. Description of the Technique ADO.NET has different types of data providers (for example, SqlClient, OleDb, ODBC, and so forth). If you choose the wrong .NET... |
| 24933 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
| 24934 | When using the |
| 24935 | This article describes how to create a Windows Form that displays a parent (or master) record and all of the related child (or detail) records by using the Northwind Customers and Orders tables. This article also describes the CurrencyManager object... |
| 24936 | This article demonstrates how to query an |
| 24937 | This article demonstrates how to persist an ADO.NET DataSet object to Extensible Markup Language (XML). Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that are required: A... |
| 24938 | When you use the |
| 24939 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and return parameters, including: Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the... |
| 24940 | The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual C# .NET to read and write binary large object (BLOB) fields. Requirements The... |
| 24941 | This step-by-step article demonstrates how to create and test a Web service that returns a DataSet object to a client. This article also demonstrates how to reference the Web service in a client application and display the returned DataSet in a... |
| 24942 | This article contains Microsoft Visual Basic .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in... |
| 24943 | This step-by-step article demonstrates how to use a Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the... |
| 24944 | The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update... |
| 24945 | This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a... |
| 24946 | This article describes the ActiveX Data Objects (ADO) SHAPE command syntax that produces hierarchical recordsets and explains how to traverse hierarchical recordsets. This article also provides sample code. You can use hierarchical recordsets as an... |
| 24947 | When you use |
| 24948 | This article demonstrates how to fill a DataSet object with the resultset from an Oracle stored procedure. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident... |
| 24949 | This article demonstrates how to programmatically retrieve data from a Microsoft Access database and present the data to the user. The sample in this article uses the |
| 24950 | There are several ways to use ADO.NET to call a stored procedure and to get back return values and output parameters, including: Use a DataAdapter or DataSet object to gather the returned rows and to work with these rows in addition to the return... |
| 24951 | This step-by-step article demonstrates how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure,... |
| 24952 | This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a... |
| 24953 | This article demonstrates how to use an OLE DB Universal Data Link (.udl) file to specify the connection string that an ADO.NET OleDbConnection object uses to establish a database connection. OLE DB Universal Data Link (.udl) files provide a... |
| 24954 | This article contains Microsoft Visual C# .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the... |
| 24955 | The SqlDataAdapter object serves as a bridge between an ADO.NET DataSet object and a Microsoft SQL Server database. It is an intermediary object that you can use to do the following: Populate an ADO.NET DataSet with data retrieved from a SQL Server... |
| 24956 | This article describes how to create a Windows form that displays a parent (or master) record and all of the related child (or detail) records by using the Northwind Customers and Orders tables. This article also describes the CurrencyManager object... |
| 24957 | When you use |
| 24958 | This step-by-step article uses the DataReader object to retrieve data from an Oracle stored procedure. You can use the DataReader to retrieve a read-only, forward-only stream of data from a database. Using the DataReader can increase application... |
| 24959 | This step-by-step article demonstrates how to create and test a Web service that returns a DataSet object to a client. This article also demonstrates how to reference the Web service in a client application and display the returned DataSet in a... |
| 24960 | When you set a property value on an ActiveX Data Objects (ADO) object to a string value, you may encounter the following exception: Unhandled Exception: System.Runtime.InteropServices.COMException (0x800A0BB9): Arguments are of the wrong type, are out... |
| 24961 | This step-by-step article demonstrates how to use the Data Link Properties dialog box to programmatically create a connection string at design time. Requirements The following list outlines the recommended hardware, software, network infrastructure,... |
| 24962 | This article demonstrates how to use the GetOleDbSchemaTable method of the OleDbConnection object in ADO.NET to retrieve database schema information. Schema information in a data source includes databases or catalogs that are available from the data... |
| 24963 | Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. |
| 24964 | Managed providers can raise several exceptions. To obtain more detailed information about the cause, you need access to provider-specific error information. This article shows how to gather this information. Requirements The following list outlines... |
| 24965 | This article describes how you can use ADO.NET to open a SQL Server database by using the SQL Server .NET data provider. ADO.NET gathers all of the classes that are required for data handling. The System.Data.SqlClient namespace describes a collection... |
| 24966 | This article demonstrates how to fill a DataSet object with the result set from an Oracle stored procedure. The DataSet object is central to supporting disconnected, distributed data scenarios with ADO.NET. The DataSet is a memory-resident... |
| 24967 | This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
| 24968 | This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
| 24969 | The DataAdapter object is optimized for read-only scenarios by default. The Fill method only retrieves the amount of schema that is necessary to populate a DataSet object. To obtain the additional schema that are necessary to update or validate... |
| 24970 | This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual C# .NET. While executing a parameterized stored procedure using the ODBC .NET Provider is little different from... |
| 24971 | This step-by-step article demonstrates how to use a Web service to receive and to update data from a database by using a DataSet object. This article also demonstrates how to reference the Web service in a client application and how to display the... |
| 24972 | This article demonstrates how to use the GetOleDbSchemaTable method of the OleDbConnection object in ADO.NET to retrieve database schema information. Schema information in a data source includes databases or catalogs that are available from the data... |
| 24973 | This article demonstrates how to use the GetSchemaTable method of the DataReader object in ADO.NET to retrieve column schema information. Another name for a column's schema is its field properties. Column schema information includes the following... |
| 24974 | This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET... |
| 24975 | The |
| 24976 | If you use the CommandBuilder object to explicitly get commands for the DataAdapter object as follows: da.InsertCommand = cb.GetInsertCommand and then run the following Visual Basic .NET code cb.DataAdapter = Nothing or the following Visual C# .NET... |
| 24977 | The |
| 24978 | The OleDbConnection class specifically prohibits you from using MSDASQL or data source names (DSNs) when you connect to your data sources in ADO.NET. If you try to use MSDASQL or DSNs, you receive the following error message: An unhandled exception of... |
| 24979 | When you read Extensible Markup Language (XML) data from Microsoft SQL Server by using the |
| 24980 | This step-by-step article describes how to use the ODBC .NET Managed Provider in Visual Basic .NET. This article also includes samples connection strings that you can use to access your data. The ODBC .NET Data Provider is an add-on component to the... |
| 24981 | This step-by-step article describes how to use the ODBC .NET Managed Provider in Visual C# .NET. This article also includes samples connection strings that you can use to access your data. The ODBC .NET Data Provider is an add-on component to the... |
| 24982 | The CurrencyManager object allows you to synchronize bound controls as a user browses through rows in a table. For example, CurrencyManager allows you to display the correct FirstName and LastName properties in separate, bound TextBox controls as a... |
| 24983 | You may encounter an access violation and slower connectivity if you do not explicitly close the ActiveX Data Objects (ADO) |
| 24984 | The CurrencyManager object allows you to synchronize bound controls as a user browses through rows in a table. For example, CurrencyManager allows you to display the correct FirstName and LastName properties in separate, bound TextBox controls as a... |
| 24985 | When you attempt to use the COMPUTE BY clause with the Microsoft SQL Server .NET Data Provider, you receive the following exception: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll. Additional information:... |
| 24986 | This article demonstrates how to render DataTable columns as Extensible Markup Language (XML) attributes. A DataTable represents one table of in-memory relational data. You can create a DataTable and use it independently, or other Microsoft .NET... |
| 24987 | Under the following circumstances An ASP.NET worker process (Aspnet_wp.exe) runs under the default ASPNET account. -and- You do not enable impersonation on that application. -and- You use the SQL Server .NET Data Provider or the OLE DB .NET Data... |
| 24988 | DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article demonstrates how to fill a DataSet object with the results of one or more database queries... |
| 24989 | If you try to return an empty |
| 24990 | This article provides a roadmap to understand the integration of Extensible Markup Language with ADO.NET. |
| 24991 | When you use ASP.Net to retrieve data from Microsoft SQL Server, the Web server may acquire an accumulation of aspnet_wp processes that are not using the CPU and that have only a few remaining threads. During ASP.NET process recycling, an aspnet_wp... |
| 24993 | You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can use this method to run... |
| 24994 | This article contains frequently asked questions about Microsoft Product Activation (MPA). The questions are separated into the following categories: General Questions How MPA Works Privacy Activation and Product Licensing Policies Technical... |
| 24995 | This article describes how to use ADO.NET to connect to a database and to run a command (such as the UPDATE, the INSERT, or the DELETE command) by using a Visual Basic .NET console application. back to the top Requirements The following list outlines... |
| 24996 | In Microsoft ADO.NET, an exception may occur when a transaction is committed or rolled back. When you call the Commit method of a transaction, you may encounter the following exception: The COMMIT TRANSACTION request has no corresponding BEGIN... |
| 24997 | When you use Microsoft OLE DB Provider (MSDAORA) or the OLE DB .NET Data Provider for Oracle, if you use a LIKE statement to search fixed-length character types, Oracle does not find any rows if their padding is different. |
| 24998 | The GetSchemaTable method of the SqlDataReader object returns columns, the BaseServerName and BaseCatalogName properties. However, SqlDataReader.GetSchemaTable should only return BaseCatalogName. |
| 24999 | Cannot Create Calculated Expressions on Datasets in Schema Designer The information in this article applies to: |
| 25000 | When you call the SqlConnection.BeginTransaction method and specify an isolation level in the IsolationLevel property, after the transaction is committed or rolled back, the IsolationLevel property is not reset to the default of... |
| 25001 | DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how... |
| 25002 | The DataGrid Web control has built-in Automatic or Custom Paging functionalities; however, the DataGrid Windows control lacks these features. This article demonstrates how to build a simple paging mechanism for the DataGrid Windows control. The code... |
| 25003 | This step-by-step article describes several methods for transferring data to Excel 2002 from a Visual Basic .NET program. This article also presents the advantages and disadvantages of each method so that you can select the solution that works best... |
| 25004 | Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual C# .NET,... |
| 25005 | This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET. back to the top Create Sample Excel Worksheet Start Microsoft Excel, and then create a new worksheet. Add the... |
| 25006 | This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the... |
| 25007 | Extensible Markup Language (XML) is a fundamental part of ADO.NET and Web services. This article demonstrates how to use XML in connected and disconnected ADO.NET applications. Connected ADO.NET applications can query SQL Server to return an XML... |
| 25008 | Support for the keyword encrypt has been added to the SqlConnection ConnectionString property. |
| 25009 | This article describes how to format a string if there is a quotation mark in a member of the connection string. Description of the Technique The sample code demonstrates how to format a password that includes a quotation mark. Without the proper... |
| 25010 | This article provides a way to learn about ADO.NET. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers to help you learn about a Microsoft product or... |
| 25011 | The "DataSet.Clear Method" topic in the Microsoft .NET Framework Class Library documentation specifies that the |
| 25012 | When you serialize a DBConcurrencyException object, the value of the Row property in the serialized version of the object is set to a null value and an exception occurs: An unhandled exception of type 'System.NullReferenceException' occurred in... |
| 25013 | This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SqlClient managed provider, you can also use the OLEDB or the... |
| 25014 | Whe you try to insert an empty string into Memo, Text, nText or Blob columns by using the OleDb .NET data provider, you receive the following exception: |
| 25015 | Microsoft SQL Server .NET data provider (SqlClient) is slower than OLE DB .NET data provider (OleDb) when you use connection pooling with integrated security. |
| 25016 | This article describes how to replace special characters in an Extensible Markup Language (XML) file by using Visual Basic .NET. |
| 25017 | When you try to open a connection in a deployed .NET application, you may encounter an exception similar to the following: The .NET Data SQL Provider (System.Data.SqlClient) requires Microsoft Data Access Components (MDAC) version 2.6 or later. |
| 25018 | When you try to access the |
| 25019 | When you execute the code in the MSDN documentation for |
| 25020 | When you attempt to read an Extensible Markup Language (XML) schema into a |
| 25021 | This article provides a roadmap for learning and mastering how to use ActiveX Data Objects (ADO) via Component Object Model (COM) Interop on the Microsoft .NET platform. Roadmap articles provide links to useful information, including online... |
| 25022 | If you simulate a join query by using two |
| 25023 | When you call an OleDbDataReader object that invokes the Read method from a different single-threaded apartment (STA) thread than the object was created in, you receive the following exception: System.InvalidOperationException: The... |
| 25024 | You can use the ExecuteXmlReader method of the System.Data.SqlClient.SqlCommand class to load the results of SQL Extensible Markup Language (XML) queries from Microsoft SQL Server into a System.Xml.XmlReader object. You can only use this method to run... |
| 25025 | This article provides a roadmap to learn and master ADO.NET DataAdapter objects. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to help you learn... |
| 25026 | This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET. Create Sample Excel Worksheet Start Microsoft Excel, and create a new worksheet. Add the following... |
| 25027 | This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 25028 | The |
| 25029 | If you run commands or call methods of the |
| 25030 | ADO.NET provides new flexibility in how you update your data source. This article describes how you can update a data source that is different from the original data source that you use to create the DataSet object. Description of the Technique... |
| 25031 | This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object. If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a... |
| 25032 | When you reference the value of a |
| 25033 | After you use the |
| 25034 | When you use a DataAdapter object to write changes back to a database by means of a stored procedure, you may receive the following error message: An unhandled exception of type 'System.Data.DBConcurrencyException' occurred in system.data.dll... |
| 25035 | This article lists the exceptions that can be raised when you invoke the Update method of a DataAdapter object to update a DataSet object or a DataTable object. These exceptions occur if the DataSet , the DataTable , or the UpdateCommand property is... |
| 25036 | This article demonstrates how you can manage quotation marks in string values when you concatenate SQL statements. The article provides a sample solution that uses the Sql managed provider (Microsoft SQL Server) and provides a Microsoft Access sample... |
| 25037 | This article demonstrates how to use the ADO.NET OLE DB managed provider to access an Oracle database. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 25038 | If you create the |
| 25039 | This step-by-step describes how to call a parameterized SQL Server stored procedure using the ODBC .NET Managed Provider and Visual Basic .NET. Although executing a parameterized stored procedure using the ODBC .NET Provider is slightly different from... |
| 25040 | This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 25041 | This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class. back to the top How to Copy DataRows Between DataTables Before you use the ImportRow method, you must ensure... |
| 25042 | ADO.NET provides new flexibility in how you update your data source. This article describes how you can update a data source that is different from the original data source that you use to create the DataSet object. Description of the Technique... |
| 25043 | When you use DataSet column mapping in ADO.NET, an |
| 25044 | Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual C++ .NET to programmatically create a Microsoft SQL Server database. Steps to Create the Sample Start Microsoft Visual Studio .NET, and... |
| 25045 | This step-by-step article shows you how to create a Microsoft SQL Server database by using ADO.NET and Visual C# .NET because programmers often need to create Databases programmatically. Steps to Create a SQL Server Database To create the database,... |
| 25046 | When you use DataSet column mapping in ADO.NET, an |
| 25047 | This article demonstrates how to persist an ADO.NET DataSet object to XML. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft Windows 2000 Professional,... |
| 25048 | This article demonstrates how to use the ADO.NET OleDbDataReader class to retrieve data from an Oracle database. Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:... |
| 25049 | This article demonstrates how to persist an ADO.NET DataSet object to Extensible Markup Language (XML). Requirements The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 25050 | This step-by-step article describes how to call a parameterized Microsoft SQL Server stored procedure using the Open Database Connectivity (ODBC) .NET managed provider and Microsoft Visual C++ .NET. Executing a parameterized stored procedure by using... |
| 25051 | In Microsoft ActiveX Data Objects (ADO), you can use the |
| 25052 | When you create a trusted connection from ASP.NET to SQL Server, you may receive the following error message: Login failed for user 'MachineName\ASPNET For computers that run Internet Information Services (IIS) 6.0, you may receive the following error... |
| 25053 | This article provides a roadmap to learn and master ADO.NET data providers. Roadmap articles provide links to useful information, including online documentation, Microsoft Knowledge Base articles, and Microsoft white papers, to help you learn about a... |
| 25054 | Programmers often need to create databases programmatically. This article describes how to use ADO.NET and Visual Basic .NET to programmatically create a Microsoft SQL Server database. Steps to Create the Sample Create a new Visual Basic .NET Windows... |
| 25055 | This article demonstrates how to copy specific DataRow objects from one table to another by using the ImportRow method of the DataTable class. back to the top How to Copy DataRows Between DataTables Before you use the ImportRow method, you must ensure... |
| 25056 | Excel 2002 introduces functionality for opening files in the Extensible Markup Language (XML) format. An XML file that is well-formed can be opened directly in Excel 2002 or Excel 2003 by using either the user interface or code. With Visual Basic... |
| 25057 | This article explains how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object. REQUIREMENTS The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need: Microsoft... |
| 25058 | An unhandled exception may occur under the following circumstances: |
| 25059 | This article describes how to use the |
| 25060 | This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements. Description of the Technique ActiveX Data Objects (ADO) can... |
| 25061 | The OLE DB .NET managed provider does not support all OLE DB providers. |
| 25062 | When you create a parameterized command against Microsoft SQL Server 7.0, if you call the Prepare method before you add parameters to the command, you receive the following error message: An unhandled exception of type... |
| 25063 | This article describes how to use the |
| 25064 | This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements. Description of the Technique ActiveX Data Objects (ADO) can... |
| 25065 | You can use ADO.NET DataTable objects to delete rows and mark them as Deleted. This article demonstrates how to retrieve the values of a row whose DataRowState enumeration is set to DataRowState.Deleted . Description of the Technique You can use the... |
| 25066 | When you create a parameterized command against Microsoft SQL Server 7.0, if you call the Prepare method before you add parameters to the command, you receive the following error message: An unhandled exception of type... |
| 25067 | When you run an ADO.NET command, the output parameters may not be initialized, or they may return an incorrect value. |
| 25068 | Output parameters do not appear to be initialized or return a wrong value when you run an ADO.NET command. |
| 25069 | Output parameters do not appear to be initialized or return a wrong value when executing an ADO.NET command. |
| 25070 | The OLE DB .NET managed provider does not support all OLE DB providers. |