Search   Articles   Dev Forums   Personalize   Favorites   Member Login   ASP.Net Hosting
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Saturday, November 22, 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 > C-Sharp > Database
Search:
What's New - What's Hot
Listings for DataSet Object DataSet Object (48)
Listings for SQL Server SQL Server (21)


Outlook Drag and Drop in C#        
Total Hits: 72  |  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...

Simply Object-Oriented C        
Total Hits: 76  |  Today: 0 Author: Kenneth Kasajian       Rating:  
Read Reviews | Write Review |   Your Rating: 

This document describes a method by which features of Object-Oriented Programming (OOP) can be used in straight C, including Standard/ANSI C, and some variants of pre-ANSI C. The following compilers have been tested:

* Visual Studio 6.x +
* GCC
* LCC
* Turbo C 2.0

OOP constructs are implanted via C macros so that source code is easily readable. Knowledge of OOP is assumed as well as rudimentary knowledge of C++....

Add Build Date and Autoincrement Build Number        
Total Hits: 93  |  Today: 0 Author: gugulea       Rating:  
Read Reviews | Write Review |   Your Rating: 

There are many articles and applications posted here, but I couldn't find one that could do what I wanted. I don't want to add any plug-in to Visual Studio, or modify any .rc files that the IDE should maintain and modify. I want to add more version info like build date. Some of the solutions given here are good but are not complete. They represent only a starting point to my solution....

How to draw a rubber band or focus rectangle in Visual C++ .NET or in Visual C++ 2005        
Total Hits: 94  |  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 ....

How To Save a DataSet Class as XML in .NET Framework SDK        
Total Hits: 67  |  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....

Export a DataSet to Microsoft Excel without the use of COM objects        
Total Hits: 161  |  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...

How to manipulate hierarchical information in flat relational database tables (optionally industrial strength)        
Total Hits: 297  |  Today: 0 Author: Akshay Srinivasan2.       Rating:  
Read Reviews | Write Review |   Your Rating: 

A simple table in a relational database is the employees table. This has an employee ID and a reports to ID which is an employee ID. The normal way to fill your tree with this hierarchical information is to query for the root nodes i.e. nodes with no parents in this case null in reports to. Then subsequently query the table for all children of the node i.e. reports to ID equals root employee id. Keep doing this until you come to leaf nodes with empty results. I will describe a better technique t...

Reading and Writing images from SQL Server        
Total Hits: 936  |  Today: 0 Author: ra00l       Rating:  
Read Reviews | Write Review |   Your Rating: 

Today you will learn to write images to SQL Server and then read and display them. In order to follow this tutorial, you will need to have SQL Server, Visual Studio .NET and .NET Framework installed. Ensure that the SQL Server instance is running....

Use BindingManagerBase's EndCurrentEdit() before saving data via an Sql/OleDataAdapter        
Total Hits: 431  |  Today: 0 Author: Michael G.       Rating:  
Read Reviews | Write Review |   Your Rating: 

When a user places a cursor on a DataGrid cell in order to edit its contents, the grid is placed into an Edit mode state. If the user later clicks on a save button to commit the changes to a database, the changes may not be saved. This occurs because the DataGrid is still in Edit mode. For this reason, I recommend to all developers that the form, on which the DataGrid resides, be used to end the Edit mode session of the DataGrid. You can do this by issuing it a BindingManagerBase.EndCurrentEdit(...

HOW TO: Create and Use a Typed DataSet by Using Visual C# .NET (Q320714)        
Total Hits: 4625  |  Today: 0 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: 2484  |  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: Reuse the SqlCommand and OleDbCommand Objects in Visual C# .NET (Q317559)        
Total Hits: 1109  |  Today: 0 Author: MSDN       Rating:  
Read Reviews | Write Review |   Your Rating: 

This step-by-step article describes how to reuse the SqlCommand object in your Visual C# .NET code....



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