Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > Visual Basic.Net > Database
Search:
What's New - What's Hot
Listings for ADO.NET ADO.NET (63)
Listings for Data Provider Data Provider (8)
Listings for DataSet Object DataSet Object (31)
More Categories for SQL Server SQL Server (1)


HOW TO: BETA: Avoid the Boxing Penalty When You Use the DataReader in Visual Basic. NET (Q310348)      
Total Hits: 133  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how to use the Getxxx methods (such as GetChar, GetDouble, and GetInt32) to avoid the boxing penalty when you use the DataReader object....

HOW TO: BETA: Handle Multiple Results Using the DataReader in Visual Basic .NET (Q309490)      
Total Hits: 176  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article contains a generic function that you can use to process multiple recordsets and other messages that are returned from stored procedures or the execution of batch SQL statements....

HOW TO: Page Through a Query Result for Better Performance     
Total Hits: 368  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article provides guidelines about how to implement paging. This article provides a few examples of paging and describes the advantage of each method....

HOW TO: Perform a Complex Filter in ADO.NET     
Total Hits: 379  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

In ADO.NET, you can use the DataView.RowFilter property and the DataTable.Select method to filter a subset of records. However, the expressions that you can use have limitations. This article demonstrates three techniques to work around the limitations of the filter expressions....

FIX: Cannot Close Form When Tag Property Is Bound to Read-Only Field     
Total Hits: 159  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

If the Tag property of a Windows Forms control is bound to a read-only field in a DataSet object, you cannot move the focus away from the control, and you cannot close the form....

HOW TO: Open a SQL Server Database by Using the SQL Server .NET Data Provider with Visual Basic .NET      
Total Hits: 395  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article describes how you can use ADO.NET to open a SQL Server database by using the SQL Server .NET data provider. ADO.NET gathers all of the classes that are required for data handling. The System.Data.SqlClient namespace describes a collection of classes that are used to programmatically access a SQL Server data source....

HOW TO: Use QueryPerformanceCounter to Time Code in Visual Basic .NET      
Total Hits: 709  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you test code to identify performance bottlenecks, it is best to use the highest resolution timer that the system has to offer. This step-by-step article describes how to use the QueryPerformanceCounter function to time application code.
...

HOW TO: Retrieve DataView of a Windows Forms Bound Control in Visual Basic .NET      
Total Hits: 1293  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET     
Total Hits: 10527  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET....

HOW TO: Retrieve an Identity Value from a Newly Inserted Record from SQL Server by Using Visual Basic .NET (Q320141)      
Total Hits: 1974  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to retrieve the identity value when you add a record into a SQL Server table with an identity field.
...

HOW TO: Update a Database from a DataSet Object by Using Visual Basic .NET     
Total Hits: 3304  |  Today: 0      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: Create a SQL Server Database Programmatically by Using ADO.NET and Visual Basic .NET (Q305079)     
Total Hits: 1777  |  Today: 0      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....

HOW TO: Automate Microsoft Access From Visual Basic .NET (Q317113)     
Total Hits: 2951  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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 top

Automation vs. ADO.NET

A developer can work ..Read More..

HOW TO: Connect to a Database and Run a Command by Using ADO.NET and Visual Basic .NET (Q301075)     
Total Hits: 3725  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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....

HOW TO: Persist an ADO.NET DataSet as XML by Using Visual Basic .NET (Q308064)     
Total Hits: 624  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to persist an ADO.NET DataSet object to XML....

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET (Q316887)     
Total Hits: 2261  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains how to read and write data from BLOB (LongVarBinary) columns in a database table....

HOW TO: Use ADO Recordsets in Visual Basic .NET (Q315974)      
Total Hits: 1482  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article explains how to create a small console application that uses COM Interop to create an earlier version ( legacy ) ADO RecordSet, convert it to an ADO.NET DataSet, and then display the record count. You will see how easy it is to use COM components from within Microsoft Visual Studio .NET....

HOW TO: Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET (Q316934)      
Total Hits: 4589  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source.
...

HOW TO: Create and Use a Typed DataSet by Using Visual Basic .NET (Q315678)     
Total Hits: 1067  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article shows how to create and use a typed DataSet in a small Web application. Typed DataSets , which inherit from the DataSet class, create first-class members of a DataSet 's DataTables and DataColumns , yielding the many benefits that come with the use of strong typing.

...

HOW TO: Programmatically Create a Hierarchical DataSet Object with ADO.NET in Visual Basic .NET (Q316260)     
Total Hits: 985  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to create a hierarchical DataSet object that you can use as a structure for your programs. You may not have the exact data or structure that you want to use for your project. You can use the method in this article to create prototypes for your examples. It may also be easier to submit only the data that you do have to the database without using the shape command syntax to send the data to the database....



Disclaimer - Privacy
© 2002-2017 DevASP.net