|
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Johnny Papa
|
Rating:
|
|
Your boss says, "We need our app to talk XML." Of course, XML is a solid data format, but what about the data formats that are already used by your company's applications? Your business applications may have a data access tier that reads and writes data to and from a database and sends the data back to the business services tier. What format does that data take? If you use an ActiveX® Data Objects (ADO) recordset, your business component is reliant upon the ADOR object library, which may or may ...
|
|
|
|
Total Hits: 169 | Today: 0
|
Author: easerve
|
Rating:
|
|
Adding records to Access database using ADO.NET a fairly strait forward process and is much like adding records to SQL Server 2000.
First, you will need to import the System.Data.OleDb name space at the top of your page....
|
|
|
|
Total Hits: 84 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from SQL Server 2000 Database....
|
|
|
|
Total Hits: 74 | Today: 0
|
Author: easerve
|
Rating:
|
|
Deleting records from SQL Server 2000 database using ADO.NET a fairly strait forward process, much like deleting records from Access Database.
First, you will need to import the System.Data.SqlClient namespace at the top of your page....
|
|
|
|
Total Hits: 467 | Today: 1
|
Author: DevASP
|
Rating:
|
|
In this simple article you will learn that how you can SEARCH values from database on Run time depend upon value in text box. Simply just create New Project of console application in VB. Drag one text box, one Combo box on form. In this sample I am using MS Access database and getting values from access on run time. This is a good example for beginners....
|
|
|
|
Total Hits: 794 | Today: 0
|
Author: rmortega77.
|
Rating:
|
|
Sometimes we want to do tricks with the Crystal Reports engine, like profiting from the Exporting functions to create Word, Excel, or PDF files. What if we don't read the data from a database? This article shows the details on creating a Crystal Reports sub report, and how to fill it from code, without a database....
|
|
|
|
Total Hits: 259 | Today: 0
|
Author: Anthony Queen.
|
Rating:
|
|
This article will attempt to explain and demonstrate how Microsoft has simplified the approach to writing provider-independent code. Switching between Oracle, SQL, or any Oledb or Odbc data source is now as easy as changing a configuration setting....
|
|
|
|
Total Hits: 330 | Today: 0
|
Author: Sujith C Jose.
|
Rating:
|
|
This is a simple article which describes how to use a Stored Procedure in Visual Basic 6.0 using the Microsoft ActiveX Data Objects(ADO)....
|
|
|
|
Total Hits: 473 | Today: 0
|
Author: Anand Narayanaswamy
|
Rating:
|
|
This article, part one of a series, discusses the workings of ADO.NET. With the help of an example application, you will learn to manipulate data in a Microsoft Access database, including how to insert, search, and navigate records. In this article, you will learn about the workings of ADO.NET with the help of a Windows Forms project titled Customer Database Application. The application uses a Microsoft Access database to manipulate data and Visual Basic .NET as the programming language....
|
|
|
|
Total Hits: 2435 | Today: 0
|
Author: MSDN
|
Rating:
|
|
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 and insert them into an ADO Recordset object....
|
|
|
|
Total Hits: 338 | Today: 1
|
Author: MSDN
|
Rating:
|
|
Use this step-by-step guide to implement key-based dependencies for data caching in an ASP.NET application....
|
|
|
|
Total Hits: 1596 | Today: 0
|
Author: MSDN
|
Rating:
|
|
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 the application for other tasks until the data is returned from the database and databinding is performed....
|
|
|
|
Total Hits: 839 | Today: 1
|
Author: MSDN
|
Rating:
|
|
Use this step-by-step guide to copy hierarchical data into a DataSet by using the Fill method of the DataSet class....
|
|
|
|
Total Hits: 847 | Today: 1
|
Author: MSDN
|
Rating:
|
|
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 based on all field values. By using a custom UpdateCommand, we can specify only the columns that we wish to use....
|
|
|
|
Total Hits: 1244 | Today: 1
|
Author: MSDN
|
Rating:
|
|
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 performance and reduce system overhead because only one row is ever in memory....
|
|
|
|
Total Hits: 4513 | Today: 0
|
|
Rating:
|
|
The Microsoft .NET Framework provides an extremely powerful and flexible mechanism for binding data to properties of controls. Although in the majority of cases you will bind to the displayed value of a control—for example, the DisplayMember property of a ListBox control or the Text property of a TextBox control—you can bind any property of a control to a data source....
|
|
|
|
Total Hits: 2856 | Today: 1
|
|
Rating:
|
|
This article provides step-by-step samples that show you how to automate Microsoft Access from Visual Basic .NET. The topics and the sample code show you how to do the following:- Open a database in Access
- Print or preview an Access report
- Show and edit an Access form
- Avoid dialog boxes when you open a password-protected database or when user-level security is turned on
- Automate the Access Runtime
back to the topAutomation vs. ADO.NETA developer can work ..Read More..
|
|
|
|
Total Hits: 3580 | Today: 1
|
|
Rating:
|
|
This article describes how to use ActiveX Data Objects (ADO) .NET to connect to a database and run a command (such as UPDATE, INSERT and DELETE) by using a Visual Basic .NET console application....
|
|
|
|
Total Hits: 1909 | Today: 0
|
|
Rating:
|
|
Learn to connect to an OLE DB data source and read data into a dataset using ADO.NET.
...
|
|
|
|
Total Hits: 46 | Today: 1
|
Author: Mahesh Chand
|
Rating:
|
|
This program shows how access an access database using ADO. I have an Access 2000 database in project\bin\debug directory. My database name is mcTest.MDB. You can create your own database and copy in your project's debug directory. I am not attaching database with this code because of size problem....
|
|
|
|
|
|
