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

Dev Articles
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 > Database > DataSet Object
Search:
What's New - What's Hot


How to marshal an object to a remote server by reference by using Visual Basic 2005 or Visual Basic .NET        
Total Hits: 21  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article demonstrates how to marshal an object by reference to a remote server. When you marshal an object by reference, the runtime creates a transparent proxy so that the server can make calls back to the object on the client. The only thing that is sent to the server is the proxy. The proxy marshals the call backs to the client....

HOW TO: Roll Back Updates After an Error When You Are Using a DataAdapter and a DataSet (Q310351)        
Total Hits: 654  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

If your client application uses an ADO.NET DataSet object to store changes that are made to data or to add new records, you can use a Transaction object, a DataSet object, and a DataAdapter object to roll back any changes if an error occurs. If you use a CommandBuilder object to generate INSERT, UPDATE, and DELETE commands, you must set the Transaction property of the SELECT command of the DataAdapter....

How To Update a SQL Server Database by Using the SqlDataAdapter Object in Visual Basic .NET        
Total Hits: 37  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article contains Microsoft Visual Basic .NET code samples that demonstrate how to use the SqlDataAdapter object to update a SQL Server database with data modifications that are run on a DataSet object that is populated with data from a table in the database....

How To Persist an ADO.NET DataSet as XML by Using Visual Basic .NET        
Total Hits: 47  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article demonstrates how to persist an ADO.NET DataSet object to XML.
The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:
• Microsoft Windows 2000 Professional, Windows 2000 Server, Windows 2000 Advanced Server, or Windows NT 4.0 Server
• Microsoft Visual Studio .NET
This article assumes that you are familiar with the following topics:
• Visual Studio .NET
• ADO.NET fundamentals and syntax
• XML fundam...

HOW TO: Make a Typed DataSet Return a Default Value Instead of DBNull by Using Visual Basic .NET        
Total Hits: 299  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article describes how to change the XML Schema file to make a typed DataSet return a default value instead of DBNULL. Visual Studio .NET may return an exception if the value of a DataRow is DBNULL, so you must handle the exception properly for values that are DBNULL. If you modify the default value for DBNULL fields, you can retrieve a value you specify other than DBNULL....

HOW TO: Retrieve DataView of a Windows Forms Bound Control in Visual Basic .NET        
Total Hits: 1214  |  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: Update a Database from a DataSet Object by Using Visual Basic .NET        
Total Hits: 3205  |  Today: 1       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: Fill a DataSet from a Data Source and Update Another Data Source by Using Visual Basic .NET        
Total Hits: 123  |  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...

How to populate a DataSet object from a database by using Visual Basic .NET        
Total Hits: 99  |  Today: 1 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: Change the Color and the Font of the StatusBarPanel Object by Using Visual Basic .NET        
Total Hits: 35  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article demonstrates how to programmatically set the color and the font of the StatusBarPanel object by using Visual Basic .NET.

The StatusBar control includes a Panels property, which is a collection of StatusBarPanel objects. The StatusBarPanel class does not have any members that allow you to change of the background color or the font. However, you can use GDI+ to paint the panel with a background color and to draw the text by using a font and a color that you specify...

How To Save a DataSet Class as XML in .NET Framework SDK        
Total Hits: 14  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

This document illustrates how to save relational data that is loaded into a DataSet class to a file as Extensible Markup Language (XML). This demonstrates the transition between relationally mapped data and XML data....

How to update a database from a DataSet object by using Visual Basic .NET        
Total Hits: 19  |  Today: 0 Author: Microsoft       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 find and use Office object model documentation        
Total Hits: 10  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article describes the resources and documentation available to you for automating Microsoft Office applications. This information can be applied regardless of the programming language you choose for automating an Office application. This article also illustrates how you can begin writing automation code by stepping you through the documentation to find the information you need to accomplish a specific task through automation....

HOW TO: Transform a DataSet to Spreadsheet XML for Excel by Using Visual Basic .NET and ASP .NET (Q319180)        
Total Hits: 3301  |  Today: 1 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article describes how to transform a DataSet to Spreadsheet XML that can be rendered in Excel. The Excel Spreadsheet XML format supports element tags and attributes for Excel functionality such as multi-sheet workbooks, formulas, and cell formatting....

HOW TO: Fill a DataSet from a Data Source and Update Another Data Source Using Visual Basic .NET (Q310347)        
Total Hits: 1409  |  Today: 0 Author: MSDN       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....

HOW TO: Read XML Data into a DataSet Using Visual Basic .NET (Q309702)        
Total Hits: 637  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article demonstrates how to read Extensible Markup Language (XML) data into an ADO.NET DataSet object....

How to populate a DataSet object from a database by using Visual Basic .NET        
Total Hits: 75  |  Today: 1 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 marshal an object to a remote server by value by using Visual Basic 2005 or Visual Basic .NET        
Total Hits: 19  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article demonstrates how to marshal an object by value to a remote server.

When you marshal an object by value, a copy of the object is created and serialized to the server. Any method calls made on that object are done on the server. Because the object must be serialized to the server, the class definition for the object you are passing must be annotated with the Serializable attribute....

How to update a database from a DataSet object by using Visual Basic .NET        
Total Hits: 48  |  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 Obtain Extended Error Information in the DataSet by Using Visual Basic .NET        
Total Hits: 10  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |   Your Rating: 

The DataAdapter class throws generic exceptions when problems occur. This article demonstrates how to obtain a descriptive error message for each row and column that is in fault in any table in a given DataSet class. This is very useful in update scenarios when it is important to check if there are errors in any row or column....


1  2  Next >> 


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