Search   Articles   Dev Forums   Personalize   Favorites   Member Login   ASP.Net Hosting
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, May 13, 2008

Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 
FREE 12 month online training for ASP.NET & MS Expression Studio and a Free copy of MS Expression Web with Windows Server Purchase

Home > Search > Knowledge Base > Visual Basic.Net
Search:
What's New - What's Hot
Listings for Automation Automation (17)
Listings for Base Class Libraries Base Class Libraries (10)
Listings for Compiling Compiling (2)
Listings for Component Component (12)
More Categories for Database Database (95)
Listings for Debugging Debugging (3)
Listings for Error Handling Error Handling (7)
More Categories for Errors and Bugs Errors and Bugs (69)
Listings for Exceptions Exceptions (8)
More Categories for File Management File Management (15)
Listings for Migration to VB.NET Migration to VB.NET (11)
Listings for Miscellaneous Miscellaneous (38)
Listings for Object Pooling Object Pooling (15)
More Categories for Office Documents Office Documents (27)
Listings for Operating System Operating System (17)
Listings for Reference Reference (2)
Listings for Regular Expression Regular Expression (4)
Listings for Server Application Server Application (12)
More Categories for Server Controls Server Controls (22)
Listings for Threading Threading (7)
Listings for User Controls User Controls (9)
Listings for VB.Net and XML VB.Net and XML (70)
Listings for Windows Form Windows Form (36)
 

How To Fill a DataSet from an Oracle Stored Procedure Using the OLE DB .NET Data Provider with Visual Basic .NET        
Total Hits: 36  |  Today: 1 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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....

HOW TO: Fill a DataSet from a Data Source and Update Another Data Source by Using Visual Basic .NET        
Total Hits: 22  |  Today: 1 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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...

Developing the Components for the Middle Tier in visual basic .Net        
Total Hits: 12  |  Today: 0 Author: VK Infotek Inc.       Rating:  
Read Reviews | Write Review |              Your Rating: 

Middle tier equates to the Business tier or Application tier or Logical tier and contains the logic of the application. Middle tier simplifies the client´s access to the database (SQL Server) by isolating the business services from the Database and Presentation tiers. The components of the Application or Business tier are frequently called business services. Middle tier runs on a server and is often called the application server....

How to populate a DataSet object from a database by using Visual Basic .NET        
Total Hits: 16  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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....

How to populate a DataSet object from a database by using Visual Basic .NET        
Total Hits: 14  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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....

How to create a SQL Server database programmatically by using ADO.NET and Visual Basic .NET        
Total Hits: 23  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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....

How To Copy DataRows Between DataTables by Using Visual Basic .NET        
Total Hits: 34  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your Rating: 

Before you use the ImportRow method, you must ensure that the target table has the identical structure as the source table. This sample uses the Clone method of DataTable class to copy the structure of the DataTable, including all DataTable schemas, relations, and constraints. This sample uses the Products table that is included with the Microsoft SQL Server Northwind database. The first five rows are copied from the Products table to another table that is created in memory....

How to connect to a database and run a command by using ADO.NET and Visual Basic .NET        
Total Hits: 19  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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...

How to call SQL Server stored procedures in ASP.NET by using Visual Basic .NET        
Total Hits: 43  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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...

How To Retrieve Values from DataRows That Are Marked "Deleted" by Using Visual Basic .NET        
Total Hits: 17  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your Rating: 

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.You can use the DataRowVersion.Original enumeration value to retrieve the values of a row that has the DataRowState.Deleted enumeration value. You must use DataRowVersion.Original because the values of a deleted row are not available for the current state (DataRowVersion.Current)....

How to update a database from a DataSet object by using Visual Basic .NET        
Total Hits: 21  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your 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....

HOW TO: Locate a Specified DataRow by Using the Find Method of DataRowCollection in Visual Basic .NET        
Total Hits: 12  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |              Your Rating: 

The Find method queries the primary key column of the DataTable, and locates the record that exactly matches the value that is passed in the search criteria. If the DataTable does not have a primary key, a MissingPrimaryKeyException is raised. The Find method has the following limitations:
• The Find method is not case sensitive.
• You cannot use Wildcard characters in the Find method. For example, when you use the following code, you may not find all the rows starting with Ch. Instead, yo...



DevASP.Net - Disclaimer - Privacy
Copyright © 2008 DevASP.net