|
|
|
|
|
|
| | Total Hits: 107 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| | 
You can store XML data in a Microsoft Office Excel workbook or Microsoft Office Word document by creating a custom XML part in a document-level customization. For more information, see Custom XML Parts Overview.... |
| | 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: 44 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| |
In order to edit an existing row in a DataTable, you need to locate the DataRow you want to edit, and then assign the updated values to the desired columns.... |
| | 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: 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: 29 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
After the data in your dataset has been modified and validated, you probably want to send the updated data back to a database. In order to send the modified data to a database, you call the Update method of a TableAdapter or data adapter. The adapter's Update method updates a single data table and executes the correct command (INSERT, UPDATE, or DELETE) based on the RowState of each data row in the table.... |
| | Total Hits: 92 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
To insert new records into a database, you can use the TableAdapter.Update method, or one of the TableAdapter's DBDirect methods (specifically the TableAdapter.Insert method). For more information, see TableAdapter Overview.
If your application does not use TableAdapters, you can use command objects to interact and insert new records in your database (for example, SqlCommand).... |
| | 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: 19 | Today: 0 | Author: Microsoft Corporation | Rating:  |
| |
In addition to the InsertCommand, UpdateCommand, and DeleteCommand, TableAdapters are created with methods that can be executed directly against the database. These methods (TableAdapter.Insert, TableAdapter.Update, and TableAdapter.Delete) can be called directly to manipulate data in the database.... |
| | 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: 122 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
You can add custom data to ink that will be saved when the ink is saved as ink serialized format (ISF). You can save the custom data to the DrawingAttributes, the StrokeCollection, or the Stroke. Being able to save custom data on three objects gives you the ability to decide the best place to save the data. All three classes use similar methods to store and access custom data.... |
| | Total Hits: 141 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
The following example creates an application that enables the user to drag selected strokes from one InkCanvas to the other.... |
| | Total Hits: 373 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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 representation of data that provides a consistent, relational programming model regardless of the data source. The DataSet represents a complete set of data, including related tables, constraints, and relationships among the tables.... |
| | 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: 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: 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: 220 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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.
1. Create a new Visual Basic .NET Windows Application project. Form1 is added to the project by default.
2. Place a Command button on Form1, and change its Name property to btnCreateDatabase and its Text property to Create Database.... |
| | Total Hits: 248 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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.
The following list outlines the recommended hardware, software, network infrastructure, and service packs that are required:
• Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, or Microsoft... |
| | Total Hits: 405 | Today: 0 | Author: Microsoft Corporation | Rating: |
| |
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 stored procedure that you will create exists in the database. If the stored procedure does not exist, the code creates a stored procedure that takes one parameter to search the Authors table based on the last name and returns the matching rows and numb... |
| | Total Hits: 126 | 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 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.... |
|
|
|
|
|
|