Search - Articles - Dev Forums - Favorites - Member Login  
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Thursday, July 29, 2010

Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

Build the right apps the right way with powerful development tools.
Visual Studio 2010. Learn more...

Home > Search > Knowledge Base > C-Sharp > Database > DataSet Object
Search:
What's New - What's Hot


Outlook Drag and Drop in C#        
Total Hits: 272  |  Today: 0 Author: David Ewen       Rating:  
Read Reviews | Write Review |   Your Rating: 

A project came up at work the other day requiring the ability to drag and drop any number of mail messages or mail message attachments from outlook into a WinForm application... Easy I thought, this has to be a common problem I will just jump on CodeProject find an example and with a bit of tweaking be running in no time. Now if your here I am sure you now know how little information there is available on this topic so I thought I would add to the very small pool with a complete example of how t...

How To Save a DataSet Class as XML in .NET Framework SDK        
Total Hits: 163  |  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: Get Extended Error Information for the DataSet in Visuall C++ .NET (Q308908)        
Total Hits: 198  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

Use this step-by-step guide to check for and report errors for each row and column in each table in a DataSet. You can use this information in update scenarios where it is important to check for errors in any row or column....

HOW TO: Perform Bulk Updates and Inserts Using OpenXML with .NET Providers in Visual C++ .NET (Q316245)        
Total Hits: 507  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article describes how to do bulk inserts and updates with different Microsoft .NET data providers by using the OpenXML method. Although the sample in this article uses the SQLClient managed provider, you can also use the OLEDB or the ODBC managed provider....

HOW TO: Make a Typed DataSet Return a Default Value Instead of DBNull by Using Visual C# .NET (Q318048)        
Total Hits: 1318  |  Today: 0 Author: MSDN       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....

HOW TO: Read and Write BLOB Data Using ADO.NET with Visual C# .NET (Q309158)        
Total Hits: 386  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual C# .NET to read and write binary large object (BLOB) fields....

HOW TO: Fill a DataSet from a Data Source and Update Another Data Source Using Visual C# .NET (Q313028)        
Total Hits: 2330  |  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 C# .NET (Q311566)        
Total Hits: 2113  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

You can use the ReadXml method to read XML schema and data into a DataSet. XML data can be read directly from a file, a Stream object, an XmlWriter object, or a TextWriter object....

HOW TO: Create and Use a Typed DataSet by Using Visual C# .NET (Q320714)        
Total Hits: 4874  |  Today: 1 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article shows you 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: Read Hierarchical Data into a DataSet in Visual C# .NET (Q318454)        
Total Hits: 2704  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article describes how to load hierarchical data into a DataSet by using the Fill method of the DataSet class....

HOW TO: Perform a Distributed Transaction with a .NET Provider by Using ServicedComponent (Q316247)        
Total Hits: 877  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article demonstrates how to perform a distributed transaction by using a .NET provider with the ServicedComponent class. Although this article uses the SqlClient .NET provider against a Microsoft SQL Server server, you can also use the ODBC or OLE DB .NET managed provider....

HOW TO: Roll Back Updates in Visual C# .NET (Q316024)        
Total Hits: 604  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article describes how to roll back updates after an error when you use a DataAdapter and a DataSet object....

HOW TO: Quote a Member of the Connection String in ADO.NET by Using Visual C# .NET (Q316367)        
Total Hits: 655  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

Use this step-by-step guide to format a string if there is a quotation mark in a member of the connection string....

HOW TO: Copy a Picture from a Database Directly to a PictureBox Control with Visual C# (Q317701)        
Total Hits: 1381  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article describes how to copy an image stored in a database directly into a PictureBox control on a Windows Form without needing to save the image to a file....

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and C++ (Q317017)        
Total Hits: 1222  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

Use this step-by-step guide to read and write data to and from BLOB (LongVarBinary) columns in a database table....

HOW TO: Populate a DataSet Object from a Database Using Visual C# .NET (Q314145)        
Total Hits: 908  |  Today: 0 Author: MSDN       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 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: Fill a DataSet from an Oracle Stored Procedure Using the OLE DB .NET Data Provider with Visual C# .NET (Q310101)        
Total Hits: 935  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This article demonstrates how to fill a DataSet object with the result set 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: Update a Database from a DataSet Object by Using Visual C# .NET        
Total Hits: 4378  |  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), how to modify that data, and then how to send it back to the database to update the original source....

How to draw a rubber band or focus rectangle in Visual C++ .NET or in Visual C++ 2005        
Total Hits: 207  |  Today: 0 Author: Microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

A rubber band, or focus rectangle, is a rectangle that tracks with the mouse pointer while you hold the left mouse button. This technique is used to delimit a selection in response to user mouse-pointer input. In the graphics device interface (GDI), these rectangles are implemented by using raster operations (ROPs). However, the System.Drawing method is based on GDI+ (the successor to GDI). GDI+ does not support ROPs. This article describes another approach to implement focus rectangles in the ....

Export a DataSet to Microsoft Excel without the use of COM objects        
Total Hits: 350  |  Today: 0 Author: Xodiak.       Rating:  
Read Reviews | Write Review |   Your Rating: 

This function takes in a DataSet and file name and writes the DataSet to an Excel worksheet. The code is pretty straightforward. Great thing about this function is that, it's technically an XML file that is saved as an XLS file. So it can be used as either file format. No more leading zero truncation on numbers that look like strings. Example, if you made a tab delimited file and put a field such as "00036" (a field that looks like a number but should be regarded as a string), MS Excel would tru...


1  2  3  Next >> 

DevASP.Net - Disclaimer - Privacy
© 2002-2010 DevASP.net