MS SQL
Using ASP.NET AJAX CascadingDropDown with Visual Basic and a Database
10 comments
Share our glory:
This morning, I had the chance to play around with another ASP.NET AJAX control: the CascadingDropDown control. Like the name implies, it's a nifty little AJAX-enabled control that dynamically enables and populates a DropDownList based on the value selected in a previous list. Kinda like the coding version of those old skool "Choose Your Own Adventure" books.
You've seen this kind of thing in action plenty of times, I'm sure. Remember the last time you filled out a registration form that had you pick a country, then ...
Oh, Joy! More JOINs!
JOINing Tables in INSERT, UPDATE, and DELETE Queries
Share our glory:
In our last SQL post, we talked about the three basic types of JOINs enterprising young SQL junkies might use to gather data from different tables in their databases.
"Enterprising..." Oh, how I crack myself up some times. Seriously. Don't make me explain why that's funny.
Anyway, in between Star Trek-related examples, we blabbed on and on about INNER JOINs, three kinds of OUTER JOINs, and the almost completely useless CROSS JOIN. You might remember, though, that every one of those brilliant examples involved querying existing data with SELECT statements. T...
JOIN the Dark Side
Share our glory:
When you've been playing around with SQL for awhile, you start to take your knowledge of JOINs for granted. When someone asks you about JOINing data from two or more tables together, you get this stunned look on your face... You know, the same one you get when you actually hear someone mutter the words "I've never seen 'Star Wars'." You forget that you, too, once didn't know a JOIN from a Jedi, and that everyone has to start somewhere.
So let's talk about JOINs. Like the name implies, a JOIN is simply a method for connecting two tables in a database, usually through so...
Fun With GetSchemaTable
Moving Data From MS SQL 2005 Express Edition to MySQL
Share our glory:
Couple of weeks ago, I was doing some work on a personal Nerdly project on one of my laptops. That particular machine has a copy of SQL Server 2005 Express Edition already installed, and I often use that for my development needs. Has a good number of the same features that the full-blown SQL Server 2005 editions carry, but it's free to use, distribute, etc. Hard to beat that.
Anyway, using Microsoft's SQL is all well and good for most of my work projects, but this personal project is going to live on my webhost's boxes, and my cheap webhosting account doesn't include MS SQL datab...
LIMIT, OFFSET, and TOP
Get the Range of Data You Really Want
Share our glory:
Let's say you have a table that contains the monthly figures for your army of sales people. At the end of every month, the sales manager asks you to pull a list of his top ten performers from the previous period. What do you do? Well, you could just pull the entire list, ORDER BY the month, and manually count off the top ten. That query might look something like this:
SELECT salesperson_name, sales_total FROM salesdata
WHERE sales_month =
- Definitely.
2 weeks 1 day ago - A Brief Word About Shared Hosting: No
2 weeks 5 days ago - It ignores them in an
2 weeks 6 days ago - Great Work Dude (:
2 weeks 6 days ago - I hear ya...
3 weeks 43 min ago - IE Specific CSS
3 weeks 13 hours ago - Thanks
4 weeks 15 hours ago - Blocks
5 weeks 1 day ago - I'm using VS 2008 and I'm
7 weeks 5 days ago - Case sensitive
8 weeks 11 hours ago
Be sure to check out the latest from Smashing Magzine. They have a great article on CSS Specifity. Might be a review for some but still a good read.
Authentic Jobs is a great resource for finding your ideal web dev job. Be sure to check back daily as the list of impressive job openings continually grows.