|
|
|
|
 |
Running an Insert SQL Query with ADO.NET and VB.NET
|
| Total Hit (1611) |
If you have SQL server setup on your machine and the Northwind database then this example should work for you. You may have to change the password for the sa account as it's blank in the example.
|
Rating
 |
|
|
|
Load a DataGrid Contol with XML Data using ADO.NET
|
| Total Hit (1403) |
You will need to create a new Form, and then add three controls to it. A Button called btnImportXML, a DataGrid called DataGrid and a TextBox called txtPath.
Run the project and type the complete path to your XML document in the Textbox then click the Button. The DataGrid will be loaded with you
....Read More |
Rating
 |
|
|
|
|
|
|
|
Navigating Multiple Related Tables in an ADO.NET Dataset
|
| Total Hit (645) |
A dataset in ADO.NET is an in-memory representation of data that can contain multiple related data tables. This paper describes the methods of navigating these related data tables within a dataset. You will create a Windows® application in Visual Basic® .NET or Visual C#™ .NET that returns related r
....Read More |
| Rating
|
|
|
|
|
|
|
|
DataSets in Microsoft .NET - 2
|
| Total Hit (1305) |
In the previous part of this article we discussed different features and how to create a dataset in design time lets go further in detail. In this part I will discuss about sort, search and filtering support provided by dataset and data table object.
|
| Rating
|
|
|
|
DataSets in Microsoft .NET - 1
|
| Total Hit (1786) |
ADO.NET was designed to meet the needs of this new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to
....Read More |
| Rating
|
|
|
|
Understanding and Working with Oracle Data Provider for .NET
|
| Total Hit (1675) |
Oracle Data Provider for .NET (ODP.NET) is an implementation of a data provider for the Oracle database. ODP.NET uses Oracle native APIs to offer fast and reliable access to Oracle data and features from any .NET application.
|
| Rating
|
|
|
|
Typed DataSets in .NET by Ramaprasad Upadhyaya.
|
| Total Hit (683) |
As all of we know, we can specify the data type when we create a DataColumn for a DataTable. This is to enforce the runtime type-safety for the column so that only data of specified data type can be stored in the column.
|
| Rating
|
|
|
|
Updating with the SQLDataAdapter...
|
| Total Hit (907) |
Using the SQLDataAdapter's Update method is a very valuable and timesaving approach when synching a DataSet with a database. The SQLDataAdapter updates the SQL Server data source through the DataSet object, which tracks changes at the row level, through the RowState property. There are several metho
....Read More |
| Rating
|
|
|
|
ADO.NET: Use Database Transactions
|
| Total Hit (607) |
Database transactions are used to control data commitment to databases. For example, in standard account procedures, it is necessary to debit one account and credit another at the same time. Since computers break down on occasion (power outages, network outages, and so on) there is the potential for
....Read More |
| Rating
|
|
|
|
ADO.NET Overview
|
| Total Hit (586) |
ADO.NET is an evolution of the ADO data access model that directly addresses user requirements for developing scalable applications. It was designed specifically for the web with scalability, statelessness, and XML in mind.
ADO.NET uses some ADO objects, such as the Connection and Command object
....Read More |
| Rating
|
|
|
|
ADO.NET: Execute a Command
|
| Total Hit (844) |
Commands are issued against databases to take actions against data stores. For example, you could execute a command that inserts or deletes data. For more information on moving data into and out of databases, see "Update a Database from a DataSet". Commands include any command that can be issued aga
....Read More |
| Rating
|
|
|
|
ADO.NET: Get Out Parameters from a Stored Procedure
|
| Total Hit (552) |
Some stored procedures return values through parameters. When a parameter in a SQL statement or stored procedure is declared as "out", the value of the parameter is returned back to the caller; the value is stored in a parameter in the Parameters collection on the OleDbCommand or SqlCommand objects.
....Read More |
| Rating
|
|
|
|
ADO.NET: Populate a DataSet from a Database
|
| Total Hit (589) |
Getting data from a database is easy, and working with data is easier than before. If you want the results from a database as a forward only, read-only stream of data, you can execute a command and retrieve the results using the DataReader. For examples on how to use a DataReader, see Retrieve Data
....Read More |
| Rating
|
|
|
|
ADO.NET: Update a Database from a DataSet
|
| Total Hit (587) |
This topic illustrates how to update data in a database using a DataSet. It is important to remember that you can also insert, update, and delete data in a database directly using a SqlCommand. Understanding the concepts covered in Populate a DataSet from a Database will help you understand the curr
....Read More |
| Rating
|
|
|
|
ADO.NET: Handle Errors
|
| Total Hit (1102) |
In addition to Try/Catch and exceptions, the new ADO.NET data architecture allows you to add error messages to each row of Data in a DataSet. SqlDataAdapters attach error messages to Rows if updates or other actions fail. Furthermore, you can filter for rows in error to present them to the user, or
....Read More |
| Rating
|
|
|
|
ADO.NET: Work with Relational Data
|
| Total Hit (581) |
A DataSet can contain either unrelated tables or related tables. You can think of a DataSet as a document of data. In fact, an XML data document is like this, except it is based on a hierarchical paradigm. Because data is often stored in relational databases, the DataSet can handle both hierarchical
....Read More |
| Rating
|
|
|
|
ADO.NET: Work with Typed Data
|
| Total Hit (640) |
ADO classic code provides late-bound access to values within its recordset through weakly typed variables. ADO.NET code enables you to access the data held in the DataSet through a "strongly typed" metaphor. This means you can access tables and columns that are part of the DataSet with user-friendly
....Read More |
| Rating
|
|
|
|
ADO.NET: Filter Data
|
| Total Hit (551) |
There are many ways to filter data. One way is to filter data at the database command level, using a where clause on your query. A second way is to filter the data after it is in the DataSet. This topic covers filtering in the DataSet.
Once data is in a DataSet you can use methods on the DataSet t
....Read More |
| Rating
|
|
|
|
ADO.NET: Connection Pooling
|
| Total Hit (572) |
This sample illustrates how to construct a pool of connections to a datasource. You will want to do this to deploy high-performance applications. In this example the pool is established in the connection string and managed automatically by the SqlConnection.
....Read More |
| Rating
|
|
|
|
ADO.NET: Generate XML with data from SQL Server
|
| Total Hit (588) |
This sample illustrates how to produce XML from SQL Server using two different techniques. The first uses the ExecuteXmlReader method of SqlCommand to get an XmlTextReader, which is then populated into a DataSet using the ReadXml method of the DataSet class. The second uses the SqlDataAdapter to ext
....Read More |
| Rating
|
|
|
|
ADO.NET: Loading a native ADO recordset into a DataSet
|
| Total Hit (1350) |
This sample illustrates using ADO recordsets with managed Datasets. To provide access to ADO Recordset and Record objects from ADO.NET, the OLE DB .NET Data Provider overloads the Fill method of the OleDbDataAdapter to accept an ADO Recordset object or an ADO Record object. Filling a DataSet with th
....Read More |
| Rating
|
|
|
|
ADO.NET: Retrieve Data using OLE DB
|
| Total Hit (552) |
This sample illustrates how to read data from an OLE DB provider using the OleDbDataReader class. This class provides a way of reading a forward-only stream of data records from a data source. If you want to work with SQLServer 7.0 or higher, you should refer to the topic Retrieve Data from SQLServe
....Read More |
| Rating
|
|
|
|
ADO.NET: Retrieve Data from SQL Server
|
| Total Hit (581) |
This sample illustrates how to read data from SQL Server using the SqlDataReader class. This class provides a way of reading a forward-only stream of data records from a data source. If you want to work with databases that have OLE DB interfaces or versions of SQL Server prior to SQL Server 7.0, see
....Read More |
| Rating
|
|
|
|
ADO.NET: Convert an ADO Application to ADO.NET
|
| Total Hit (591) |
This is an example of an ADO application that has been ported to .NET without the original graphical interface. It also shows the usage of a forward-only read-only fast DataReader. It shows how to use a DataView class to take a table from a DataSet and operate on it in a fashion similar to the old A
....Read More |
| Rating
|
|