|
|
|
|
|
| | Total Hits: 60 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| | 
If a dataset contains constraints (such as a foreign-key constraint) it is possible to cause exceptions to be thrown depending on the order of operations performed against the dataset. For example, loading child records before loading the related parent records can violate the constraint and cause an exception. As soon as you load a child record the constraint checks for the related parent record and raises an error. If there were no mechanism to allow temporary constraint suspension, an error w... |
| | Total Hits: 709 | Today: 0 | Author: MSDN | Rating: |
| |
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 Transaction object, a DataSet object, and a DataAdapter object to roll back any changes if an error occurs. If you use a CommandBuilder object to generate INSERT, UPDATE, and DELETE commands, you must set the Transaction property of the SELECT command of the DataAdapter.... |
| | Total Hits: 48 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| |
The phrase "filling a dataset with data" refers to loading data into the individual DataTable objects that make up the dataset. You fill the data tables by executing TableAdapter queries or by executing data adapter (for example, SqlDataAdapter) commands.... |
| | Total Hits: 22 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
To delete records from a database, use the TableAdapter.Update method or the TableAdapter.Delete method. Or, if your application does not use TableAdapters, you can use command objects to delete records from a database (for example, ExecuteNonQuery). The TableAdapter.Update method is typically used when your application uses datasets to store data, whereas the TableAdapter.Delete method is typically used when your application uses objects to store data.... |
| | Total Hits: 181 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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 to access that data after it is loaded into the DataSet object.... |
| | Total Hits: 51 | Today: 0 | Author: Microsoft | Rating: |
| |
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 take a DataSet that contains data (which is loaded from a database), modify that data, and then send it back to the database to update the original source.... |
| | Total Hits: 99 | Today: 0 | Author: Microsoft | Rating: |
| |
This article demonstrates how to marshal an object by reference to a remote server. When you marshal an object by reference, the runtime creates a transparent proxy so that the server can make calls back to the object on the client. The only thing that is sent to the server is the proxy. The proxy marshals the call backs to the client.... |
| | Total Hits: 41 | Today: 0 | Author: Microsoft | Rating: |
| |
This article describes the resources and documentation available to you for automating Microsoft Office applications. This information can be applied regardless of the programming language you choose for automating an Office application. This article also illustrates how you can begin writing automation code by stepping you through the documentation to find the information you need to accomplish a specific task through automation.... |
| | Total Hits: 365 | Today: 0 | Author: Microsoft | Rating: |
| |
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 properly for values that are DBNULL. If you modify the default value for DBNULL fields, you can retrieve a value you specify other than DBNULL.... |
| | Total Hits: 3351 | Today: 0 | Author: MSDN | Rating: |
| |
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 cell formatting.... |
| | Total Hits: 1465 | Today: 0 | Author: MSDN | Rating: |
| |
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.... |
| | Total Hits: 682 | Today: 0 | Author: MSDN | Rating: |
| |
This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object.... |
| | Total Hits: 1276 | Today: 0 | | Rating: |
| |
This article describes how to retrieve a DataView object from a Windows Forms bound control.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 design time, you may need to access the DataView that the bound control uses. However, the DataView is not exposed by default in design-time binding.... |
| | Total Hits: 3267 | Today: 0 | | Rating: |
| |
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 take a DataSet that contains data (which is loaded from a database), modify that data, and then send it back to the database to update the original source.... |
| | Total Hits: 38 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| |
As you make changes to records in a dataset by updating, inserting, and deleting records, the dataset maintains original and current versions of the records. In addition, each row's RowState property keeps track of whether the records are in their original state or have been updated, inserted, or deleted. This information is useful when you need to find a particular version of a row. Typically, you would get a subset of all changed records to send to another process. For more information, see Ho... |
| | Total Hits: 43 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
When editing values in data-bound controls, users must navigate off the current record to commit the updated value to the underlying data source that the control is bound to. When you drag items from the Data Sources Window onto a form, the first item that you drop generates code into the save button click event of the BindingNavigator. This code calls the EndEdit method of the BindingSource. Therefore, the call to the EndEdit method is generated only for the first BindingSource that is added to... |
| | Total Hits: 274 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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. Earlier versions of Microsoft ActiveX Data Objects (ADO) allow you to update records in a data source other than the original data source of those records, though this is difficult to do. Because ADO.NET is a truly disconnected model and because ADO.NET introduces the DataAdapter obj... |
| | Total Hits: 143 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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 to access that data after it is loaded into the DataSet object.... |
| | Total Hits: 105 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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 the database.... |
| | Total Hits: 116 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
This article demonstrates how to persist an ADO.NET DataSet object to XML.
The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:
• Microsoft Windows 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, or Windows NT 4.0 Server
• Microsoft Visual Studio .NET
This article assumes that you are familiar with the following topics:
• Visual Studio .NET
• ADO.NET fundamentals and syntax
• XML fundam... |
|
|
|
|
|
|
|
|
|
|
|
|
|