.NET Answers

ASP.NET, HTML, CSS, Visual Studio, CSharp, VB.NET and other programming items of interest.
Subscribe

Archive for November, 2008

SQL - Filtering WHERE condition on two rows

November 26, 2008 By: Dave Category: SQL For Programmers

iStock_000005792139Medium I received the following question a couple of days ago from a programmer using the “Ask  a Question” form which you can access from the menu of this blog:

Given the following table:

Name Language
Nikhil Hindi
Nikhil English
Kisu Hindi
Kisu English
Rakesh Hindi
Kousik Bangali

How do I select names of persons who know both Hindi and English?

In this table, that query should return Nikhil and Kisu.

(more…)

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

Tags: , , ,

Renaming Properties, Methods and Variables

November 25, 2008 By: Dave Category: Did you know

B03B0065 Have you ever written some code and named something one thing only to realize that it should be named something else?

If you haven’t you haven’t been programming for very long.  Maybe you started a new job and you spent two weeks writing code using your previous employer’s naming conventions only to find out that this employer expects things to be named slightly differently.

So now you not only have the item named incorrectly, but you’ve referenced it from other files, so it isn’t a simple matter of just giving it a new name.  No, the code that is referencing it has to be changed as well.  So what are you going to do?

(more…)

The Dangers of Testing as Part of an Interview

November 24, 2008 By: Dave Category: none

It has always struck me as an odd practice to give a written test to an interviewee during the hiring process.  I’ve been on both sides of the hiring process.  I’ve had to take a few of these tests.  My general perception is that all a test shows is that the person taking it knows how to take a test.

I’m going to approach this topic from the hiring manager’s perspective since that is the only perspective that really matters.  I could go on about how it is unfair to me as a potential employee, but that wouldn’t convince those who need to be convinced.  So here are some points to consider when considering testing as part of the process:

(more…)

Friday Books - ASP.NET 3.5 Unleashed

November 21, 2008 By: Dave Category: none

ASP_NET_3_5_Unleashed Product Description

ASP.NET 3.5 Unleashed is the most comprehensive book available on the Microsoft ASP.NET 3.5 Framework, covering all aspects of the ASP.NET 3.5 Framework–no matter how advanced.

This edition covers all the new features of ASP.NET 3.5. It explains Microsoft LINQ to SQL in detail. It includes a chapter on the two new data access controls introduced with the ASP.NET 3.5 Framework: ListView and DataPager. With its coverage of ASP.NET AJAX, this book shows you how to take advantage of Microsoft’s server-side AJAX framework to retrofit existing ASP.NET applications with AJAX functionality. It also demonstrates how to use Microsoft’s client-side AJAX framework to build the web applications of the future: pure client-side AJAX applications. All code samples are written in the C# programming language. (Visual Basic versions of all code samples are included on the CD-ROM that accompanies this book.)

(more…)

Tags: ,

Advantages of Using Class Diagram

November 20, 2008 By: Dave Category: Did you know

misc_vol4_063 One of the new tools that showed up in Visual Studio 2005 that I don’t see many people taking much advantage of is the Class Diagram.

The class diagram displays the classes you drag onto it in a visual representation much like a UML class diagram does.  It also lets you see relationships between your classes.  But the greatest power in the Class Diagram is that it will write a lot of your code for you.

(more…)