|
|
|
|
|
Total Hits: 2 | Today: 0
|
Author: Johnny Papa
|
Rating:
|
|
Your boss says, "We need our app to talk XML." Of course, XML is a solid data format, but what about the data formats that are already used by your company's applications? Your business applications may have a data access tier that reads and writes data to and from a database and sends the data back to the business services tier. What format does that data take? If you use an ActiveX® Data Objects (ADO) recordset, your business component is reliant upon the ADOR object library, which may or may ...
|
|
|
|
Total Hits: 88 | Today: 1
|
Author: Ged Mead
|
Rating:
|
|
One of the key mindset changes you have to make as part of your move from VB6 to VB.NET is the status of Windows Forms. In the early days of VB, Forms were King. Now, VB.NET changes the picture and - although they are still important in many applications - Windows Forms should in many cases be viewed as simply another class and be dealt with accordingly.
If you keep this in mind, many of the early learning curve problems of the move to VB.NET are easier to overcome. We dealt with how to l...
|
|
|
|
Total Hits: 69 | Today: 0
|
Author: Ged Mead
|
Rating:
|
|
One of the key mindset changes you have to make as part of your move from VB6 to VB.NET is the status of Windows Forms. In the early days of VB, Forms were King. Now, VB.NET changes the picture and - although they are still important in many applications - Windows Forms should in many cases be viewed as simply another class and be dealt with accordingly.
If you keep this in mind, many of the early learning curve problems of the move to VB.NET are easier to overcome. We dealt with how to l...
|
|
|
|
Total Hits: 110 | Today: 0
|
Author: Sanjay David
|
Rating:
|
|
This article demonstrates the transaction using the DataAccess objects....
|
|
|
|
Total Hits: 407 | Today: 0
|
Author: CodeProject
|
Rating:
|
|
This article explains how we can display data using DataSet and DataGrid control after the database is created....
|
|
|
|
Total Hits: 46 | Today: 0
|
Author: The Burger
|
Rating:
|
|
This is an article by Eric Keller and Joel Etherton about using generics to minimize duplicate code when using Table Adapters in a Data Access Layer (DAL)....
|
|
|
|
Total Hits: 62 | Today: 1
|
Author: Colt Kwong
|
Rating:
|
|
In Web Matrix, there is a new data access control - SqlDataSourceControl and we can use it to manipulate the datasource and databind to any data web controls, e.g. DropDownList, DataGrid, DataList, Repeater, etc. The beauty is that you can create and configurate the SqlDataSourceControl once easily, and then you can apply it to different data web controls immediately...
|
|
|
|
Total Hits: 39 | Today: 0
|
Author: David Wasserman
|
Rating:
|
|
In the more recent releases of Microsoft Access, great effort has gone into making this product a full-featured relational database system. Stored procedures, a functionality usually associated with enterprise database systems such as SQL Server, can now be found in Access. Stored procedures in Access have been available since Access 2000 and are native to the Jet 4 Database Engine. If you're accustomed to using stored procedures in SQL Server, then you'll be right at home with how they're used ...
|
|
|
|
Total Hits: 142 | Today: 0
|
Author: Michael Jones
|
Rating:
|
|
In March of this year, Amazon.com opened its servers to developers with an online-storage offering. As described in a previous DevX news article, Amazon.com's Simple Storage Service (S3) provides access to a large volume of storage capacity using a relatively simple Web-services API. Unofficial testing of the service proves that it is fast enough to support applications requiring near real-time access to data. Further, the service's pricing makes it a great option for a diverse set of applicatio...
|
|
|
|
Total Hits: 188 | Today: 0
|
Author: Michael bouck
|
Rating:
|
|
Another way to solve this problem is to utilize the System.Activator class and a factory pattern to create the concrete provider classes as was pointed-out in Dan Fox's article "Design an Effective Data-Access Architecture" (.netmagazine, vol. 2, no. 7). I took this idea and refined it a bit so that the only steps necessary to add a new provider to the factory is to add a new enum and the associated type values to the factory's static type arrays (a total of 5 lines of code)....
|
|
|
|
Total Hits: 261 | Today: 0
|
Author: CodeProject
|
Rating:
|
|
This article shows how to databind master and details DataGrids (Winforms) when using a cross reference table.
How to databind a master table to a details table when there is a third table that holds the cross references between them....
|
|
|
|
Total Hits: 30 | Today: 0
|
Author: Jon Wojtowicz
|
Rating:
|
|
In most applications database access is restricted to a single database type. If you are connecting to SQL Server Microsoft has the Data Access Application Block to eliminate most of the mundane code of database access. If you are connecting to a database other then SQL Server you can use the same pattern as Microsoft. This works well if you are connecting to a single type of data store. But what happens if you need to connect to multiple types of data store? Do you write a data access class for...
|
|
|
|
Total Hits: 21 | Today: 0
|
Author: MalakieUSN
|
Rating:
|
|
Code storage tool for any language but developed using Visual Basic .NET 2005. Includes syntax coloring for VB code and can load via the tools menu external option in Visual Studio 2005....
|
|
|
|
Total Hits: 53 | Today: 0
|
Author: Carvin Wilson
|
Rating:
|
|
By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo....
|
|
|
|
Total Hits: 12 | Today: 0
|
Author: Boris Makushkin
|
Rating:
|
|
Navision (former Navision Attain) together with Microsoft Great Plains, Axapta, Solomon, Microsoft CRM and Microsoft RMS are now supported by Microsoft Business Solutions. Navision has various customization options. Today we will describe simple case of using C/ODBC driver. This driver and technology allows you to work with Native or C/SIDE Navision database. Navision is also available on Microsoft SQL Server – in this case you use traditional Microsoft technologies, such as OLEDB or MS SQL Serv...
|
|
|
|
Total Hits: 8 | Today: 1
|
Author: Pawan Bangar
|
Rating:
|
|
Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access. Accessing data has become a major programming task for modern software programming, both for standardalone applications and for web based applications. Microsoft's ADO.NET technology offers a solution to many of the problems associated with data access....
|
|
|
|
Total Hits: 9 | Today: 0
|
Author: Chandu Thota
|
Rating:
|
|
Building Web Services to provide enterprise-level solutions is only the first step. You need to take care of the infrastructure aspects of your solution as well, including provisioning, billing, security, and reporting. In this article, the author uses the .NET Framework and SQL Server 2000 to design a provisioning system that will take care of all these housekeeping tasks. He discusses the general requirements of a Web Service provisioning system, walks through the implementation, and then outl...
|
|
|
|
Total Hits: 21 | Today: 0
|
Author: Josef Finsel
|
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...
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: Microsoft Corporation
|
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)....
|
|
|
|
Total Hits: 31 | Today: 0
|
Author: Alberto Venditti
|
Rating:
|
|
Do you know the Visual Studio .NET capability of extracting - at compile time - some formatted comments (you included in your source code) in the form of XML descriptive files, that you can later process with programs like NDoc in order to produce a CHM documentation of your assemblies and classes? Well, if your answer is "yes", and if you ever felt the lack of a similar feature in the Microsoft SQL Server 2000 suite, then you will easily understand the goal of DBdoc, the tool presented in this ...
|
|
|
|
|
|
