 |
SQL Server API Server Cursors
|
| Total Hit (946) |
Defines the attributes of an API server cursor, such as its scrolling behavior and the statement used to build the result set on which the cursor operates, then populates the cursor. The statement can contain embedded parameters.
|
Rating
 |
|
|
|
Importing XML into SQL Server 2000
|
| Total Hit (2525) |
One of the frequently asked questions on SQL Server newsgroups is "How to import XML data into SQL Server 2000?" There are various ways in which XML data can be imported into SQL Server 2000 database tables. In this article, we'll look at some of these options. More specifically, we'll explore the f
....Read More |
| Rating
|
|
|
|
Exporting SQL Data as XML
|
| Total Hit (3332) |
In my last article, Importing XML into SQL Server 2000, we looked at various techniques to import the XML data into SQL Server. To complement that, this article will focus on some of the methods that you can use to export relational SQL data to the XML format.
More specifically, we'll explore th
....Read More |
| Rating
|
|
|
|
Export SQL data to XML File (3 different ways)
|
| Total Hit (13881) |
Many times we need to export sql server data to some form of XML. As we know that SQL Server can output data in XML format when you use "FOR XML" clause. You can use ADO and MSXML along with "FOR XML" sql query to generate XML files from SQL Server data. The following script is pure VB Script so if
....Read More |
Rating
 |
|
 |
Developing A Newsletter Subscription Web Service
|
| Total Hit (822) |
Web services offer their functionality over the web via standards like HTTP and XML. There are many models suggested for implementing the business functionality via web services. One of them is subscription based services. Such services allow the users to subscribe or unsubscribe to the service as p
....Read More |
| Rating
|
|
|
|
Introduction To XSL
|
| Total Hit (650) |
XSL is a powerful way to transform XML documents into other formats. This article explains what XSL is and how to use it for common tasks. More emphasis is on transforming XML documents into XHTML documents
|
| Rating
|
|
|
|
Introduction to XML Namespaces & Schema
|
| Total Hit (643) |
Traditionally XML document structures are defined using DTD - Document Type Definition. However DTDs suffer for many limitations like :
|
| Rating
|
|
|
|
|
|
Single Database or Multiple Databases
|
| Total Hit (1434) |
Which is the way to better performance with Microsoft SQL Server 7.0: using a single database with lots and lots of tables or logically grouping data into multiple databases each with a significantly fewer number of tables? The system is comprised of one server with two hard drives that are mirrored
....Read More |
| Rating
|
|
|
|
|
|
 |
XML Web Services (RPC the Easy Way)
|
| Total Hit (2338) |
This sample chapter covers following things
«LI»The Role of XML Web Services in a Distributed System
«LI».NET Remoting vs. XML Web Services
«LI»XML Web Service Plumbing
«LI»The Role of IIS
«LI»Creating a Virtual Directory
«LI»The XML Web Service File Format
«LI»Creating an XML Web Service
....Read More |
| Rating
|
|
|
|
Console Enhancements
|
| Total Hit (2237) |
System.Console is a class provided by the framework to handle console I/O and redirection. The Win32 API also supports a set of console APIs. Win32 supports a single console for each application (process), even a Windows Forms Application. Consoles support a number of features such as buffering, ful
....Read More |
| Rating
|
|
|
|
|
|
|
|
Working with OwnerDraw Menus in VB.NET
|
| Total Hit (2157) |
When a menu is constructed with the VS IDE menu editor, it's very easy to add menu items and set up the hierarchy of the menu structure. Using just a few mouse clicks and a few keystrokes, your whole menu structure can created in just a few minutes. "So", you may ask, "how do we get these cool image
....Read More |
| Rating
|
|
|
|
Adding icons to menus in VB.NET
|
| Total Hit (2243) |
This project add icons in menus in VB.NET. You can use the module 'IconsMenuMain.vb' as base of your project for adding icons. This is most easy that vb6 or other languaje
|
| Rating
|
|
|
|
Flat VS.NET Style Menus - Even on Windows 98
|
| Total Hit (2730) |
First and foremost, this component provides a menu style that is 90% identical to the one provided by VS.NET (the 10% gap is described below in the "Work pending" section, please help me eliminate it). This means that it applies the VS.NET menu style to not only individual menu items but also to the
....Read More |
| Rating
|
|
|
|
Subclassed System Menu
|
| Total Hit (2246) |
The reason for this article is to show a method of subclassing an application's system menu, so that extra menu items can be added and click events can be easily handled. This is my first article submitted to CodeProject and all suggestions, criticisms etc. are welcome.
....Read More |
| Rating
|
|
|
|
A class to put a ProgressBar into a StatusBar
|
| Total Hit (2190) |
It is not possible to directly put a ProgressBar in a StatusBar in VB.NET. Solutions are available for C++ or VB 5 or 6.0. This is a way to do it in VB.NET.
|
| Rating
|
|
|
|
Packet Capture and Analayzer
|
| Total Hit (2464) |
The first idea of writing a packet sniffer program came from a reply to my comments on one of the projects named "NetSend ( Sending popup messenger messages between computers )" by Marc Clifton. Marc asked me "What about receiving message". To say the truth, I didn't know how I could do that. I knew
....Read More |
| Rating
|
|
|
|
Building Reusable Components in .NET
|
| Total Hit (2361) |
One of the main advantages of building components is to promote reusability. For example, if you build a object that represents an invoice, there could be many other projects in your company that can reuse the same object. This concept of re-using components in various projects promotes what is call
....Read More |
| Rating
|
|
|
|
Serialize VB.NET objects without the events
|
| Total Hit (2105) |
Because of the way VB.NET implements events, when you serialize an object, its events get serialized too (because events are actually implemented using hidden multicast delegate fields). A side effect of this is that any object which handles events raised by the object being serialized will be consi
....Read More |
| Rating
|
|
|
|
Controlling scrolling with the API
|
| Total Hit (2706) |
In certain circumstances, we need to be able to control the scroll bars from our code. This may seem like it should be easily done with standard methods when in fact they are buried in the API. I will tell you how I solved this problem in the application I am working on.
....Read More |
| Rating
|
|
|
|
Real Time syntax highlighting [wrapper class]
|
| Total Hit (2744) |
Hello again. This time I wanted to bring you something that was really challenging for me to build. I must have tried at least four totally different solutions to this problem consuming literally days of my time until I reached the best one. At the request of our beloved staff, I will attempt to exp
....Read More |
| Rating
|
|
|
|
Subclassing in .NET - The pure .NET way
|
| Total Hit (2311) |
If you are a Visual Basic 6 programmer then you are obviously aware of the sub-classing power. My article demonstrates the same thing for .NET. If you are a C# programmer, then you can easily change this code to fit into a C# Project. This project demonstrates how can you use the .NET way to subclas
....Read More |
| Rating
|
|
|
|
Stopwatch - a High-Resolution code timer class
|
| Total Hit (2311) |
Creating an application requires precisely measuring how long specific operations take to complete. You may be searching for performance bottlenecks prior to shipping, measuring to ensure that changes do not unexpectedly degrade performance, or (in my case), testing alternative architectural approac
....Read More |
| Rating
|
|
 |
HOW TO: Use Database and ASP Sessions to Implement ASP Security
|
| Total Hit (3883) |
This step-by-step procedure illustrates how to implement forms-based security for Active Server Pages (ASP) applications. You can use this mechanism when your application is secure, when you want to allow only authenticated users, and when the users are not part of your internal domain (such as Inte
....Read More |
| Rating
|
|
|
|
|
|
Cursors: An Overview
|
| Total Hit (1192) |
We'll talk about the basics of cursors. These let you move through records one at a time and perform processing on each record.
|
| Rating
|
|