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, September 07, 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 > Articles & Samples > Visual Basic.Net > Database
Search:
What's New - What's Hot
Listings for ADO.NET ADO.NET (106)
Listings for Data Access Data Access (37)
Listings for Data-bound Controls Data-bound Controls (25)
Listings for DataSet Object DataSet Object (36)
Listings for Miscellaneous Miscellaneous (31)
Listings for SQL Server SQL Server (85)


Data Binding in Visual Basic .NET        
Total Hits: 12  |  Today: 0 Author: Ken Spencer       Rating:  
Read Reviews | Write Review |   Your Rating: 

How can I get the most out of data binding in the applications I write in Visual Basic® .NET? As I mentioned in last month's installment of Advanced Basics, data binding is alive and well in the Microsoft® .NET Framework and it's a great technology that makes dealing with data more useful in many types of applications. Let's pick up where I left off and look at some practical applications of data binding....

Building a Progress Bar that Doesn't Progress        
Total Hits: 5  |  Today: 0 Author: Duncan Mackenzie       Rating:  
Read Reviews | Write Review |   Your Rating: 

In many situations, accurately estimating the length of a certain process (copying a large file, loading data from a server, retrieving files from the Internet) would be both difficult and inefficient. What you end up with is a process that is going to take long enough to make the user wait, yet you have no easy way to indicate the percentage of the task that has completed. A regular progress bar would be rather meaningless, so you need some form of "Working..." indicator....

Custom Button Control with Gradient Colors and Extra Image (VB.NET)        
Total Hits: 9  |  Today: 0 Author: SSDiver2112       Rating:  
Read Reviews | Write Review |   Your Rating: 

The CButton is a simple custom button control written in VB.NET. Sorry I didn't realize the "C" prefix was a language specific thing when I started. It is just short for Custom Button. I won't let it happen agian. Good for a quick alternative to the plain button. It supports up to three color gradient options. Here is a list of the other features:
1. Change corners from square to arc to circle.
2. Text shadow and margin.
3. Adjustable rollover and click color change with simula...

Viewing the Values of a DataSet in a Debug Window        
Total Hits: 13  |  Today: 0 Author: msdn.microsoft       Rating:  
Read Reviews | Write Review |   Your Rating: 

While reading your column on debugging in the April issue, I realized I need to view the values of a DataSet in the debug window. It's too time-consuming to navigate the tree to find the value of a particular cell. Is there an easier way for this to be done? To demonstrate one approach to this problem, I took a program I created for the April column, did some tweaking, and added some debug code (see the Form_Load event in Figure 1)....

Tackle Data Concurrency Exceptions Using the DataSet Object        
Total Hits: 17  |  Today: 0 Author: David Burgett       Rating:  
Read Reviews | Write Review |   Your Rating: 

ADO.NET provides many techniques for improving the performance of data-intensive applications and for making them easier to build. The DataSet, the hallmark of the ADO.NET object model, serves as a miniature, disconnected facsimile of a data source. While using the DataSet improves performance by reducing expensive trips to the database server, it also introduces the possibility of multiple users attempting to change the same data simultaneously, thereby generating data concurrency exceptions. T...

Building a Custom Data Grid: Performing Ad Hoc Web Reporting with a VBScript 5.0 Class Object        
Total Hits: 11  |  Today: 0 Author: Randall Kindig       Rating:  
Read Reviews | Write Review |   Your Rating: 

A flexible, customizable grid for displaying data is a useful tool for ASP developers. It allows Web visitors to customize their view of your data. This article takes the data grid presented in "Ad Hoc Web Reporting with ADO 2.0" by Johnny Papa and Charles Caison (MIND, December 1998) and adds handy features such as a finds feature that supports multiple finds and a mode for adding and editing records. This version also improves response time by allowing asynchronous record download and it compo...

Building and Testing ADO Components with Visual Basic        
Total Hits: 8  |  Today: 0 Author: Ken Spencer       Rating:  
Read Reviews | Write Review |   Your Rating: 

In the April 2000 issue of MSDN™ Magazine, I discussed creating components in Visual Basic® for Microsoft® Transaction Services (MTS). This month I�ll take a step back and talk about the procedure involved in creating such components. In order to illustrate the process that I use to create powerful applications, I will build parts of a Web application that will allow a user to retrieve and update information from the Pubs sample database that ships with SQL Server™. When creati...

Build an Easy Maintenance Intranet Site: Using Office Docs, File System Object, and OLE Structured Storage        
Total Hits: 15  |  Today: 0 Author: Josef Finsel       Rating:  
Read Reviews | Write Review |   Your Rating: 

If you've ever needed to build an easy-to-maintain intranet site, here's a solution based on Microsoft Office documents. Many sites require constant updating of their HTML, but the use of Word documents can simplify the process. This article details the construction of a human resources site that exploits the File System Object (FSO), OLE Structured Storage, and ActiveX capabilities of Word documents. This allows the HR staff to copy their revised or newly created Word files to the site, dynamic...

Remote Data Access Synchronization with SQL Server 2005 Compact Edition and Visual Basic.NET        
Total Hits: 20  |  Today: 0 Author: Microsoft Corporation       Rating:  
Read Reviews | Write Review |   Your Rating: 

n this tutorial, you will learn how to create a Microsoft Windows Forms application using Microsoft Visual Basic.NET that synchronizes data between a Microsoft SQL Server 2005 database and a Microsoft SQL Server 2005 Compact Edition database using Microsoft SQL Server 2005 Compact Edition Remote Data Access (RDA)....

VBScript to back up SQL Server data to pure SQL        
Total Hits: 21  |  Today: 0 Author: alex turner       Rating:  
Read Reviews | Write Review |   Your Rating: 

Let us get one thing straight here - this is not an official technique. If you are administering an SQL Server database and you use this technique - you are totally on your own. Yes - I know there are all sorts of official tools like bulk copy and data translation services. However, this technique is useful sometimes and is flexible. The idea is simple, create one single SQL script that removes all the data from a database and then restores it all to a pre-recorded state. This boils down to a wh...

Setting and retrieving a Dataset in a Hashtable        
Total Hits: 23  |  Today: 1 Author: TiNgZ aBrAhAm       Rating:  
Read Reviews | Write Review |   Your Rating: 

This is a kindergarten tutorial on how to add a dataset as a hashtable entry item and how to retrieve the values from the hashtable. I was looking out for a class in .NET that resembled the propertyBag. What a relief when I found this class on msdn. Hashtable is a class in System.Collections. It is a collection of key-and-value pairs that are organized based on the hash code of the key....

Marshaling Structures        
Total Hits: 13  |  Today: 0 Author: Adnan Samuel       Rating:  
Read Reviews | Write Review |   Your Rating: 

You can combine data items of different types to create a structure. A structure associates one or more members with each other and with the structure itself. When you declare a structure, it becomes a composite data type, and you can declare variables of that type. A structure is a generalization of the user-defined type (UDT) supported by previous versions of Visual Basic. In addition to fields, structures can expose properties, methods, and events. A structure can implement one or more interf...


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