 |
Adobe Dreamweaver Links
Adobe.com Dreamweaver Info |
Blogs
Blogger, Blogosphere, Web 2.0... |
Design Agencies
Professional, Design, Job... |
Education And Training
Communicate, Help, Advertise... |
Flash Tutorials
Artists, Designers, Experts... |
Forums
Search, Learn, Communicate... |
Javascript Tutorials
Books, Help, Learning... |
News
Technology, Business, Web... |
|
|
|
[2003-05-23] Talking to the outside world in Excel 2003
Being able to code C# with Excel 2003 is great fun but now its time for something a bit more useful.
This next code sample shows how to connect to the internet inside of Excel. The idea is when the workbook opens the code behind the workbook searches for quotes on NASDAQ and then populates the spreadsheet with the data. You can imagine you could have a spreadsheet full of data which is retrieved from data sources on company servers and internet sources etc. As you can see coding for excel in C# allows you to leverage your C# skills and re-use them in the world of Excel spreadsheets.
[2003-05-20] Transact-SQL Programming - Sample Chapter 1
Transact-SQL, an extension to the SQL database programming language, is a powerful language offering many features--a wide variety of datatypes, temporary objects, system and extended stored procedures, scrollable cursors, conditional processing, transaction control, exception and error handling, and much more. We'll introduce those features later in this chapter in the section "What is Transact-SQL?" Before getting to Transact-SQL specifics, however, we'll provide some background information that will help you get a feel for the overall database environment in which Transact-SQL operates. After we explain the basic differences between ANSI SQL and Transact-SQL, we'll jump back to more generalized topics. We'll cover the genesis of the relational database model and its impact on SQL programming languages. We'll talk a bit about normalizing data and introduce you to the idea of row-processing and set-processing information technology. We'll spend a little time talking about the history of SQL Server in general. Finally, we'll introduce many of the features of the Transact-SQL programming language itself.
[2003-05-19] My NAnt and NUncle
I was looking for a nice and easy way to automatically build my projects and I didn't have to look far to find NAnt, a variant of Ant, a build tool for Java projects. If you want to cheat and read ahead, check out http://nant.sourceforge.net but don't get too comfy, jack, there's not much out there to guide you along. I'm going to save you some precious time and help provide you with a starter script... because believe me, you'll be hard pressed to find some good examples on the web. Don't really expect much out of the examples provided by the good folks down at NAnt, but do dig into their NAnt.build - it contains secrets that you won't find anywhere.
[2003-05-19] SQL Errors 101
Many programmers hit a brick wall in their SQL queries, slowing development to a crawl and causing an over abundance of hair loss and coffee consumption. If you have been staring at the screen with a blank look and a pounding heart, wondering what you did to deserve this mess, you have come to the right place. In this article I will unveil the six most common SQL query errors and give you tips on stress prevention.
[2003-05-19] Five Tips for .NET Programming in Perl
One of the most common categories of questions on the SOAP::Lite mailing list is how to get Perl SOAP applications to work with .NET services. It's not that Perl and SOAP::Lite are not suited to the job, but rather that there are easy traps to fall into. Add to that the fact that .NET has its own distinct philosophy toward applications, and the confusion is understandable. This article will cover some of the most common traps and considerations that trip up Perl developers.
[2003-05-19] XML for UI Description in Flash MX
Unless you've been living under a rock for the last several years, you've no doubt been bombarded with the hype surrounding a simple, plain text technology named XML - eXtensible Markup Language. But even with the books, magazines, and web sites dedicated to XML, many developers still have no idea what XML really is, or even how they can use XML in their applications.
[2003-05-15] Arrays in PHP: Part 1
What exactly is an array?
An array is a variable type in PHP that allows the programmer to associate one value directly to another value or simply take a set of data and organize it into a list format (much like a table). It can be used in many ways to store and organize data quickly and efficiently. It is one of the more useful data types available to any programming language.
[2003-05-15] Arrays in PHP: Part 2
Today we'll continue our discussion of arrays in PHP including the use of associative and multidimensional arrays.
In my last article, we introduced a new array data type in PHP and covered its fundamentals. Today we'll dive deeper into arrays and introduce a type of array called an associative array and a more complex type of array -- the multidimensional array.
[2003-05-14] Optimizing JavaScript for Execution Speed
JavaScript can benefit from many of the same speed-optimization techniques that are used in other languages, like C1,2 and Java. Algorithms and data structures, caching frequently used values, loop unrolling and hoisting, removing tail recursion, and strength-reduction techniques all have a place in your JavaScript optimization toolbox. However, how you interact with the Document Object Model (DOM) in large part determines how efficiently your code executes.
[2003-05-13] Building Web Sites with Macromedia Studio MX - Book Excerpt
Macromedia's release of the MX Studio essentially turned their entire web product line inside out and rearranged the molecules. Instead of separate products performing specialized tasks, the tight integration of the tools-Freehand, Flash MX, Fireworks MX, Dreamweaver MX, and ColdFusion MX-means an entirely new, more efficient workflow can develop. A major workflow change is how objects created in each of the applications move easily between the applications. Dragging and dropping, importing, copying, and pasting between the applications can accomplish this, but one of the more significant aspects of the new workflow is the use of symbols.
[2003-05-08] Using C#.NET in Excel 2003
Aren't you sick and tired of having to use different programming languages for different projects? A few years back I spent nearly 3 years working on Microsoft's Excel VBA support desk. Each day I would take calls from customers asking how to solve different problems using Microsoft Excel and VBA or Visual Basic for Applications.
[2003-05-06] Liquid Markup
Liquid was created because there was no markup language available to create sophisticated interactive animations that could be displayed in a web browser. * If you don't know anything about scripting, but have a basic understanding of HTML, you will still be able to use Liquid to create both sophisticated presentations and all kinds of 2D games.
[2003-05-05] Create Your Own Guestbook In ASP.NET
Recently I was working on my Website, and decided I wanted to implement a guestbook.
[2003-05-02] Ten Ways to Make the Most of IIS
As an IIS administrator it sometimes gets downright annoying having to fend off all the insults from Apache admins I meet claming innate server superiority. Generally the discussion about Web administration starts first with all the various security holes plaguing IIS and the negative press the platform garnered over the last year.
[2003-05-01] Creating PDF Files in PHP
The PDF (or portable document format) file is an amazingly versatile format for transferring what usually starts as a hard copy version of a document over the Internet.
[2003-05-01] Apache Shared Modules in Delphi
Back in Issue 69 (May, 2001) of The Delphi Magazine in Apache Shared Modules, I looked at the Apache Web server running on Linux and how Kylix could be used to write CGI applications and also Apache shared modules or DSOs (the main thrust of the article). That was shortly after Kylix had been released, and discussed how to overcome a variety of problems, including the fact that the standard Apache binary distribution is not suitable for using shared modules.
[2003-05-01] Streamlining Project Management for the Web Designer
The project management of a web design job can make or break the project. If you are a web designer who has to perform your own project management, the following guidelines can help you to stay on budget and hit your deadline.
|
