PRO ASP.NET 3.5 IN C# 2008, SECOND EDITION

Download PRO ASP.NET 3.5 IN C# 2008, SECOND EDITION - Book.




Publisher Apress
Author(s) Mario Szpuszta
ISBN 1590598938
Release Date 15 November 2007

ASP.NET 3.5 is the latest version of Microsoft’s revolutionary ASP.NET technology. It is the principal standard for creating dynamic web pages on the Windows platform. Pro ASP.NET 3.5 in C# 2008 raises the bar for high-quality, practical advice on learning and deploying Microsoft’s dynamic web solution.

Seasoned .NET professionals Matthew MacDonald and Mario Szpuszta explain how you can get the most from this groundbreaking new technology. They cover ASP.NET 3.5 as a whole, illustrating both the brand-new features and the functionality carried over from previous versions of ASP. This book will give you the knowledge you need to code real ASP.NET 3.5 applications in the best possible style.

The book will teach you ASP.NET 3.5 starting with core concepts to more advanced topics. You will learn

* Core concepts of ASP.NET 3.5. Why it’s special. What it’s fundamental principals are. The basics of Visual Studio. How ASP.NET 3.5 controls are created, and how they fit into ASP.NET 3.5 pages, ultimately creating full applications
* Data access details. The intricacies of ADO.NET and how to perform data binding to many sources from databases to file streams to XML. We include LINQ coverage so you’re on the bleeding edge
* Security. Once considered the Achilles heel of all Windows web applications, security has vastly improved and is a cornerstone of ASP.NET 3.5. This section explains the various forms of available security, and how to best apply them
* Taking things further using advanced user interface techniques. This includes user controls, customer server controls, client-side JavaScript, and GDI .
* Web services. In an increasingly connected world, working with web services grows in importance. This book will show you how to work with them.
* ASP.NET AJAX, with an emphasis on comtemporary web development techniques
* Development using Internet Information Services 7, Microsoft’s premier web hosting platform.
* And much more.

Download Your eBook Now

Click Here To Download

Download ASP.NET 2.0 Unleashed Book

Download SAM's ASP.NET 2.0 Unleashed Book

ASP.NET 2.0 Unleashed is a revision of the best-selling ASP.NET Unleashed, by Microsoft Software Legend Stephen Walther. It covers virtually all features of ASP.NET 2.0 including more than 50 new controls, personalization, master pages, and web parts. All code samples are presented in VB and C#. Throughout the more than 2,000 pages, you will be shown how to develop state-of-the-art Web applications using Microsoft's latest development tools. This resource is guaranteed to be used as a reference guide over and over!

Click Here To Download

Microsoft SQL Serever 2000 Stored Procedures and XML Programming

Download Microsoft SQL Server 2000 Stored Procedures and XML programming Book

Get thorough coverage of SQL Server 2000- Including extended XML capabilities and VS.NET updates with this expertly written resource. Learn to harness the full benefits of modular programming, and achieve faster execution and a reduction of network traffic. Included are a sample database and an end-to-end solution for a Web search engine.



Click Here To Download

Dynamic LINQ (Language Integrated Quary)

Dynamic LINQ (Language Integrated Query)

LINQ (language integrated query) is one of the new features provided with VS 2008 and .NET 3.5. LINQ makes the concept of querying data a first class programming concept in .NET, and enables you to efficiently express queries in your programming language of choice.

One of the benefits of LINQ is that it enables you to write type-safe queries in VB and C#. This means you get compile-time checking of your LINQ queries, and full intellisense and refactoring support over your code:

While writing type-safe queries is great for most scenarios, there are cases where you want the flexibility to dynamically construct queries on the fly. For example: you might want to provide business intelligence UI within your application that allows an end-user business analyst to use drop-downs to build and express their own custom queries/views on top of data.

Traditionally these types of dynamic query scenarios are often handled by concatenating strings together to construct dynamic SQL queries. Recently a few people have sent me mail asking how to handle these types of scenarios using LINQ. The below post describes how you can use a Dynamic Query Library provided by the LINQ team to dynamically construct LINQ queries.

Downloading the LINQ Dynamic Query Library

Included on the VS 2008 Samples download page are pointers to VB and C# sample packages that include a cool dynamic query LINQ helper library. Direct pointers to the dynamic query library (and documentation about it) can be found below:

• VB Dynamic Query Library (included in the \Language Samples\LINQ Samples\DynamicQuery directory)
• C# Dynamic Query Library (included in the \LinqSamples\DynamicQuery directory)

Both the VB and C# DynamicQuery samples include a source implementation of a helper library that allows you to express LINQ queries using extension methods that take string arguments instead of type-safe language operators. You can copy/paste either the C# or VB implementations of the DynamicQuery library into your own projects and then use it where appropriate to more dynamically construct LINQ queries based on end-user input.

Simple Dynamic Query Library Example

You can use the DynamicQuery library against any LINQ data provider (including LINQ to SQL, LINQ to Objects, LINQ to XML, LINQ to Entities, LINQ to SharePoint, LINQ to TerraServer, etc). Instead of using language operators or type-safe lambda extension methods to construct your LINQ queries, the dynamic query library provides you with string based extension methods that you can pass any string expression into.

For example, below is a standard type-safe LINQ to SQL VB query that retrieves data from a Northwind database and displays it in a ASP.NET GridView control:

Using the LINQ DynamicQuery library I could re-write the above query expression instead like so:

Notice how the conditional-where clause and sort-orderby clause now take string expressions instead of code expressions. Because they are late-bound strings I can dynamically construct them. For example: I could provide UI to an end-user business analyst using my application that enables them to construct queries on their own (including arbitrary conditional clauses).

Dynamic Query Library Documentation

Included with the above VB and C# Dynamic Query samples is some HTML documentation that describes how to use the Dynamic Query Library extension methods in more detail. It is definitely worth looking at if you want to use the helper library in more depth:

Download and Run a Dynamic Query Library Sample

You can download and run basic VB and C# samples I've put together that demonstrate using the Dynamic LINQ library in an ASP.NET web-site that queries the Northwind sample database using LINQ to SQL:

• Basic Dynamic LINQ VB Sample
• Basic Dynamic LINQ C# Sample

You can use either Visual Web Developer 2008 Express (which is free) or VS 2008 to open and run them.

Beginning ASP.NET 3.5 in C# 2008: From Novice to Professional,Second Edition

Publisher Apress
Author(s) Matthew MacDonald
ISBN 1590598911
Release Date 15 November 2007

The most up-to-date and comprehensive introductory ASP.NET book you’ll find on any shelf, Beginning ASP.NET 3.5 in C# 2008 guides you through Microsoft’s latest technology for building dynamic web sites. This book will enable you to build dynamic web pages on the fly, and it assumes only the most basic knowledge of C#.

The book provides exhaustive coverage of ASP.NET, guiding you from your first steps right up to the most advanced techniques, such as querying databases from within a web page and tuning your site for optimal performance. Within these pages, you’ll find tips for “best practicesâ€� and comprehensive discussions of key database and XML principles you need to know in order to be effective with ASP.NET. The book also emphasizes the invaluable coding techniques of object orientation and code behind, which will start you off on the track to building real-world web sites right from the beginning–rather than just faking it with simplified coding practices.

By the time you’ve finished the book, you will have mastered the core techniques and have all the knowledge you need to begin work as a professional ASP.NET developer.

Download Your eBook Now




Click Here To Download

Microsoft SQL Server FAQ's Part - IV

Microsoft SQL Server FAQ's Part - IV


Q1. Topic - CASTing
First question of day: what is the len of @c?


declare @c varchar(8000)
set @c = N'hello' + replicate('-',8000)
print len(@c)
print @c

A. 8000
B. 4000
C. 2000


Ans: B


Explanation: The CAST to NVARCHAR(4000) means that the maximum len is 4000, then the cast to varchar(8000) allows more characters, but the string is already truncated.


Ref: CAST and CONVERT - http://msdn2.microsoft.com/en-us/library/ms187928.aspx




Q2. Topic - Database Background
What type of database is used on this site?

A. Oracle
B. MS SQL Server 2000
C. MySQL
D. MS SQL Server 2005
E. MS Access


Ans: D


Explanation: Of course the background of this site is MS SQL Server 2005! After running SQL Server 2000 for 6 years, the database was upgraded to SQL Server 2005 in September 2007.


Q3. Topic - Datetime conversion
You have a default SQL2005 SP2 install. What is the output from the following


set language us_english
set dateformat dmy
go
declare @date datetime
set @date = '11 apr 2008 17:10'
select left(@date,1)


A. 1
B. 4
C. A
D. An error 'The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.'


Ans: C


Explanation: The default conversion of a date type to character data is style 0, 'mon dd yyyy hh:miAM (or PM)', which gives us 'Apr 11 2008 5:10PM' and the left function returns the leftmost n characters, in this case 1 character, namely 'A'. Setting the DATEFORMAT to DMY has no impact on the outcome, as this setting is used only in the interpretation of character strings as they are converted to date values.


Ref:SET DATEFORMAT - http://msdn2.microsoft.com/en-us/library/ms189491(SQL.100).aspx




Q4. Topic - SQL Server 2008 FILESTREAM
What is the purpose of FILESTREAM storage in SQL Server 2008?

A. To enable user direct access to database files
B. To store BLOB data on file system
C. To allow network storage of data and log files

Ans: B


Explanation: FILESTREAM storage allows user to create a table with a varbinary(max) column (BLOB) which is actually stored on the filesystem, rather than as a field in the row.


Ref: Designing and Implementing FILESTREAM - http://msdn2.microsoft.com/en-us/library/bb895234(SQL.100).aspx

Q5. Topic - Installed Instances
Which registry key houses the values for the name of SQL Server 2005's installed instances?

A. HKLM\SOFTWARE\Microsoft\Microsoft SQL Native Client
B. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server
C. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist


Ans: B


Explanation: The "InstalledInstance" Value is located in HKLM\SOFTWARE\Microsoft\Microsoft SQL Server.




Q6. Topic - Function execution
With the user defined function in SQL Server 2005:


CREATE FUNCTION [dbo].[fn_DoSomething](@Bin VARCHAR(10))
RETURNS VARCHAR(12)
AS
BEGIN
DECLARE @L AS INT
SET @L = LEN(LTRIM(RTRIM(@Bin)))
RETURN (@Bin)
END
GO

What value would you expect to be returned when executing this code in SQL Server 2005?
SELECT dbo.fn_DoSomething('1234567890ABC')


A. An error message
B. 1234567890AB
C. 1234567890
D. 1234567890ABC


Ans: C


Explanation: Try it to see for yourself. It will return "1234567890" and this appears to be a glitch in SQL 2005 at compatibility level 90 and in SQL 2000.




Q7. Topic - Returning Data from Stored Proc
In SQL Server 2005, a strored procedure can return the data using: (select all that apply)

A. Output parameter
B. Return Code
C. Cursor data type in an output parameter

Ans: A, B, C


Explanation: The stored procedure can return the data using output parameters, a return code and as well as a cursor data type.


Ref: Designing Stored Procedures - http://msdn2.microsoft.com/en-us/library/ms191132.aspx


Q8. Topic - Blocking
You have a default SQL2000 SP4 install.

select * from sysprocesses


reports SPID 55 as blocking SPID 55. You also notice that the waitime value is low and the waittype is a latch waittype


What is the most likely reason?


A. The code has entered into an infinite loop, blocking itself
B. As of SP4, sysprocesses reports latch waits and the behaviour is expected
C. Parallelism is enabled and the SPID is waiting for other threads of the SPID to finish
D. SPID 55 is reserved for CHECKPOINTS and is waiting for the next CHECKPOINT interval


Ans: B


Explanation: After you install Microsoft SQL Server 2000 Service Pack 4 (SP4), you may notice that the blocked column in the sysprocesses system table is populated for latch waits in addition to lock waits. Sometimes, you may notice brief periods of time when a single server process ID (SPID) is reported as blocking itself. This behavior is expected.

Ref: KB 906344 http://support.microsoft.com/default.aspx/kb/906344


Q9. Topic - Impersonation in an Execute As statement
The database user or SQL Server login is impersonated when the EXECUTE AS statement is executed or specified in a module. Which of the following statements are true about the impersonation? (Select all that apply)

A. Another EXECUTE AS statement or the REVERT statement must be used before the impersonation will end.
B. The database user or SQL Server login impersonation ends when the session is dropped or when the module finishes its execution.
C. If the statement is called by a member of sysadmin, server-level impersonation is used. If the statement is called by an account that is dbo, database-level impersonation is used.
D. The scope of the impersonation is explicitly defined

Ans: B, D

Explanation: Although using another Execute As statement or the revert statement will modify the impersonation it is not necessary to execute either statement to end the impersonation. The impersonation will end automatically when the session is dropped or the module completes its execution.

Ref: Understanding Context Switching - http://msdn2.microsoft.com/en-us/library/ms191296.aspx The scope of the impersonation is explicitly defined in the Execute AS statement.
The SETUSER statement is implicit. http://msdn2.microsoft.com/en-us/library/ms188315.aspx

Q10. Topic - Query
What will happen if following query get executed:
select CategoryID, Quantity, Pricefrom Customer c, SalesOrderDetail sodwhere sod.clientid in (select customerid where pricingplan='X')

A. Query will return error because the From clause is missing in query used in where clause
B. Query will succeed if the customerid column is available in any table used in the first From Clause
C. Query is wrong

Ans: B

Explanation: If any attribute is available in the outer From Clause then it will validate column in that before returning any error. You can view this with the following code:

create table customer (ClientID int, customername varchar(10), pricingplan char(1))
--create table customer (ClientID int, customername varchar(10), pricingplan char(1), CustomerID int) gocreate table SalesOrderDetail (ClientID int, CustomerName varchar(10), categoryid int, quantity int, price money, customerid int)
go
insert customer select 1, 'Steve', 'X'
insert customer select 2, 'Andy', 'Y'
-- insert customer select 1, 'Steve', 'X', 1
-- insert customer select 2, 'Andy', 'Y', 2
insert SalesOrderDetail select 1, 'Steve', 1, 2, 10, 1
insert SalesOrderDetail select 2, 'Andy', 1, 5, 10, 2
select CategoryID, Quantity, Price
from Customer c, SalesOrderDetail sod
where sod.clientid in (select customerid where pricingplan='X')
drop table Customer
drop table SalesOrderDetail

You can also remove CustomerID from both tables and see that it causes an error.

Q11. Topic - Delete Duplicates
Which of the three lines will correctly remove duplicated items in the following table:

Create table #new(ID int null, Keyvalue varchar(2))
insert into #new(id,keyvalue) values (1,'aa')
insert into #new(id,keyvalue) values (2,'bb')
insert into #new(id,keyvalue) values (1,'aa')
insert into #new(id,keyvalue) values (1,'aa')

A. with numbered;(SELECT rowno=row_number() over (partition by ID order by ID),ID,keyvalue from #new)delete from numbered where rowno>1
B. ;with numbered as(SELECT rowno=row_number() over (partition by ID order by ID),ID,keyvalue from #new)delete from numbered where rowno>1
C. ;with numbered as(SELECT rowno=row_number() over (partition by ID order by ID),ID,keyvalue from #new)delete from numbered where rowno=1

Ans: B

Explanation: Of these statements, the first one produces a syntax error. The last one produces a table with 2 duplicates. The second one is correct. A semi-colon at the beginning of the statement is valid and we want to delete all the matching row numbers greater than 1.


Q12. Topic - SQL Server 2008 FILESTREAM
How do you know whether FILESTREAM storage is available and enabled in SQL Server 2008?

A. Query Sys,Configurations view for 'FileStreamAccessLevel'
B. Query the Sys.assembly_files for 'FileStream'
C. Query the server property 'FilestreamEffectiveLevel'

Ans: C

Explanation: For knowing the current effective level of FileStream access you need to run the following query –

SELECT SERVERPROPERTY ('FilestreamShareName') ,SERVERPROPERTY ('FilestreamEffectiveLevel');

which will give you the instance name and the filestream access level. If the level is set to 3 the filestream storage is enabled and available.

Ref: sp_filestream_configure - http://msdn2.microsoft.com/en-us/library/bb934198(SQL.100).aspx



Q13. Topic - Statistics
What would you use to update a single table's statistics in the shortest time?

A. sp_updatestats
B. UPDATE STATISTICS
C. All of the above

Ans: B

Explanation: Sp_updatestats does not have an option to update a single table's statistic. It will update all tables in the database. This answer is incorrect. UPDATE STATISTICS can be used with single table and therefore it will run in most cases faster.

Ref: UPDATE STATISTICS - http://msdn2.microsoft.com/en-us/library/aa260645(SQL.80).aspx



Q14. Topic - SQL Server 2005
Which of the following are system databases in SQL Server 2005? (select all that apply)

A. Master
B. Model
C. Msdb
D. Tempdb
E. Resource

Ans: A, B, C, D, E

Explanation: All of these are system databases in SQL Server 2005.

Ref: System Databases - http://msdn2.microsoft.com/en-us/library/ms178028.aspx

Q15. Topic - Bit data
The AdventureWorks database has the HumanResources.Employee table with a column SalariedFlag defined as follows:

[SalariedFlag] [dbo].[Flag] NOT NULL

The Flag user-defined data type is defined by:

CREATE TYPE [dbo].[Flag] FROM [bit] NOT NULL

What will be the result when the following query is executed on SQL Server 2005?

USE AdventureWorks
SELECT COUNT(*) as [Number of Salaried Employees]
FROM HumanResources.Employee
WHERE SalariedFlag = 'true'

A. A numeric result will be returned
B. An error message will appear: Syntax error converting the varchar value 'true' to a column of data type bit.
C. A result set with no value (a blank result) will be returned.

Ans: A

Explanation: In SQL Server 2005, the string values TRUE and FALSE can be converted to bit values.
See the SQL Server Books Online topic "bit (Transact-SQL)" at http://msdn2.microsoft.com/en-us/library/ms177603.aspx.
In SQL Server 2000, a query such as: USE Northwind; SELECT * FROM Products WHERE discontinued = 'true'; would give the error message.

Q16. Topic - ANSI_NULLS
Assume the following table
CREATE TABLE testnull(ggg INT NULL)
INSERT testnull(ggg)SELECT NULL UNION ALLSELECT 1 UNION ALLSELECT 0
What counts do you get from the followingSELECT Count(*)
FROM testnull GOSET ANSI_NULLS OFFGOSELECT Count(*)
FROM testnull WHERE ggg=1
OR ggg!=1;

SELECT Count(*)
FROM testnull WHERE ggg=1
OR ggg!=1
OR ggg=NULL;GOSET ANSI_NULLS ONGOSELECT Count(*)
FROM testnull WHERE ggg=1
OR ggg!=1;

SELECT Count(*)
FROM testnull WHERE ggg=1
OR ggg!=1
OR ggg=NULLGODROP TABLE testnull

A. 3,3,3,2,2
B. 3,3,2,2,2
C. 3,2,3,2,2
D. 3,2,3,2,3

Ans: C

Explanation: Although Setting the ANSI_NULLS setting to OFF allows for using the =NULL notation, it does NOT affect how NULL operates with regards to comparisons with non-null values. the SET ANSI_NULLS OFF has been marked as deprecated in SQL 2005 and will be removed in the future. For more info on ANSI_NULLS, read the following Books Online document:

Ref: SET ANSI_NULLS- http://msdn2.microsoft.com/en-us/library/ms188048.aspx

Q17. Topic - Implicit Conversions
What happens with this code?select 'B'union select 4

A. The int is converted to varchar
B. The varchar is converted in int (error results)
C. The query does not compile.

Ans: B

Explanation: This is an example of an implicit conversion. In this case, an error is returned as the varchar is converted to an int, or an attempt is made, which returns an error. The int is of higher precedence than a varchar, so that is the order of conversions.

Ref: Connect and Implicit Casts - http://blogs.msdn.com/isaac/archive/2008/04/10/connect-and-implicit-casts.aspxData Type Precedence - http://msdn2.microsoft.com/en-us/library/ms190309(SQL.100).aspx



Q18. Topic - T-SQL query

Is there a condition for the WHERE clause to display the details about the students born in the month numbers of 1[Jan], 3,4,5,7,8? The condition should not use both IN and OR operators

A. No
B. Yes
C. Not Supported in SQL Server

Ans: B

Explanation: We can give the condition as follows:where datename(m,dob) not like '%e%'
because these month(s) specified do not have the letter 'e', but all the other months have at least one 'e' in month name.


Q19. Topic - Rebuild Master
If you rebuild the master database in SQL Server 2005, what happens to your version level?

A. It reverts to the RTM version, losing service packs and additonal patches
B. It reverts to the latest Service Pack version, losing any additional patches.
C. It remains the same.

Ans: A

Explanation: When you rebuild the master database, all system databases, including the systemresource database, are rebuilt from original media, so all Service Pack, Hotfix, QFE/GDR information is lost and you revert to the original RTM version.

Ref: How to: Install SQL Server 2005 from the Command Prompt (scroll down to rebuild database section) - http://msdn2.microsoft.com/en-us/library/ms144259.aspx

Q20. Topic - DAC Port
On which port can you make a Dedicated Administrator Connection (DAC)?

A. 1435
B. 3389
C. 1433
D. Dynamically assigned

Ans: D

Explanation: The DAC port is dynamically assigned when the instance starts and listed in the SQL Server error log. By default it tries for 1434, but it is possible that this port is already in use. The message will be something like:Dedicated admin connection support was established for listening locally on port 1977.

Ref: Using a Dedicated Administrator Connection - http://msdn2.microsoft.com/en-us/library/ms189595.aspx

Q21. Topic - Set trigger firing order
I have 3 UPDATE triggers on a individual table, TRA, TRB and TRC. Can I fire them in the sequence TRA, TRB and TRC?

A. No
B. Yes

Ans: B

Explanation: http://msdn2.microsoft.com:80/en-us/library/ms186762.aspx Using sp_settriggerorder Set TRA as first, TRC as LAST and TRB will fire between TRA and TRC firing which is what is desired.

Q22. Topic - Identity Columns
In SQL Server 2005, how can you easily determine which columns have the identity property set? (select all that apply).

A. Query sys.identity_columns for the rows.
B. Query sys.tables.identity_column for the name of the column in each table
C. Query sys.columns.is_identity for a value of 1
D. There is no way to do this in T-SQL.

Ans: A, C

Explanation: There is a table, sys.identity_columns that contains a row for each column in your database that has the identity property set. There is also a column called is_identity in the sys.columns view that contains a 1 if the column has the identity property set. The other answer was made up.

Ref: sys.identity_columns - http://msdn2.microsoft.com/en-us/library/ms187334.aspx

Q23. Topic - Floor Function
What is the output of this query?select floor(13.890)

A. 14
B. 13.9
C. 13

Ans: C

Explanation: Floor returns the largest integer less than or equal to the specified numeric expression. In this case, that is 13.



Q24.Topic - SQL Server Express DAC
Does SQL Server 2005 Express allow Dedicated Administrator Connections (DAC)?

A. Yes, always
B. Yes, if remote connections are allowed.
C. Yes, if started with trace flag 7806
D. No

Ans: C

Explanation: SQL Server 2005 Express Edition does not listen on the DAC port by default. If it is started with trace flag 7806, then DAC connections can be made.

Ref: Using a Dedicated Administrator Connection - http://msdn2.microsoft.com/en-us/library/ms189595.aspx


Q25. Topic - Named Pipes
In SQL Server 2005, how do you perform a backup using Named Pipes?

A. Normal backups to local disks all use named pipes
B. In the TO part of the backup command, specify the pipe as "TO PIPE = '\sql\pipe'"
C. SQL Server 2005 does not support backup to named pipes.

Ans: C

Explanation: In SQL Server 2005, the ability to backup to a named pipe (disk or tape) was removed.

Ref: Discontinued Database Engine Functionality in SQL Server 2005 - http://msdn2.microsoft.com/en-us/library/ms144262.aspx

Windows Key Board Shortcuts

Windows Key Board Shortcuts

Getting used to using your keyboard exclusively and leaving your mouse behind will make you much more efficient at performing any task on any Windows system. I use the following keyboard shortcuts every day.You also try it, believe me its fun operating without mouse:

Type the following commands in your Run Box (Press Windows Key + R) or Click-->Start--> Run.

This is usually followed by:

devmgmt.msc = Device Manager

msinfo32 = System Information

cleanmgr = Disk Cleanup

ntbackup = Backup or Restore Wizard (Windows Backup Utility)

mmc = Microsoft Management Console

excel = Microsoft Excel (If Installed)

msaccess = Microsoft Access (If Installed)

powerpnt = Microsoft PowerPoint (If Installed)

winword = Microsoft Word (If Installed)

frontpg = Microsoft FrontPage (If Installed)

notepad = Notepad

wordpad = WordPad

calc = Calculator

msmsgs = Windows Messenger

mspaint = Microsoft Paint

wmplayer = Windows Media Player

rstrui = System Restore

netscp6 = Netscape 6.x

netscp = Netscape 7.x

netscape = Netscape 4.x

waol = America Online

control = Opens the Control Panel

control printers = Opens the Printers Dialog

cmd = Command Prompt

iexplore + "web address" = Internet Explorer

compmgmt.msc = Computer Management

dhcpmgmt.msc = DHCP Management

dnsmgmt.msc = DNS Management

services.msc = Services

eventvwr = Event Viewer

dsa.msc = Active Directory Users and Computers

dssite.msc = Active Directory Sites and Services

Shortcuts by Pressing some key combinations

Windows key + E = Explorer

ALT + Tab = Switch between windows

ALT, Space, X = Maximize window

CTRL + Shift + Esc = Task Manager

Windows key + Break = System properties

Windows key + F = Search

Windows key + D = Hide/Display all windows

CTRL + C = copy

CTRL + X = cut

CTRL + V = paste

Alt + Esc = Switch between running applications

Alt + letter Select menu item by underlined letter

Ctrl + Esc = Open Program Menu

Ctrl + F4 = Close active document or group windows (does not work with some applications)

Alt + F4 = Quit active application or close current window

[Alt] + [-] = Open Control menu for active document

Ctrl] Lft., Rt. = arrow Move cursor forward or back one word

Ctrl] Up, Down arrow Move cursor forward or back one paragraph

[F1] Open Help for active application

Windows + M = Minimize all open windows

Shift + Windows+M = Undo minimize all open windows

Windows + F1 = Open Windows Help

Windows + = Tab Cycle through the Taskbar buttons

Windows + Break = Open the System Properties dialog box

Acessability shortcuts:

Right SHIFT for eight seconds - Switch FilterKeys on and off.

Left ALT + left SHIFT + PRINT SCREEN - Switch High Contrast on and off.

Left ALT + left SHIFT + NUM LOCK - Switch MouseKeys on and off.

Press SHIFT Key for five times - Switch StickyKeys on and off.

Press NUM LOCK for five seconds - Switch ToggleKeys on and off.

Explorer Shortcuts:

END - Display the bottom of the active window.

HOME - Display the top of the active window.

Num Lock + Aterisk on numeric keypad(*) - Display all subfolders under the selected folder.

NUM LOCK + PLUS SIGN on numeric keypad (+) - Display the contents of the selected folder.

NUM LOCK+MINUS SIGN on numeric keypad (-) - Collapse the selected folder.

LEFT ARROW - Collapse current selection if it's expanded, or select parent folder.

RIGHT ARROW - Display current selection if it's collapsed, or select first subfolder.

BACKSPACE[<-] - To page up and traverse through different directory.

Microsoft SQL Server 2008 FAQ's

Click Here To Download

Download-Beginning Datsbase Design by Wiley

Click Here To Download

Download-Beginning SQL Server 2005 for Developers

Click Here To Download

Download .Net Interviews Questions Book

Those who want prepair for the Interviews on .Net platform. I think this book will helpful to you for preparation.

Click Here to Download

Custom Alert box using JavaScript

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

>
<html>
<head>
       <title>Custom Alert Box</title>
           <meta equiv="Content-Type" content="text/html;

charset=utf-8">

 <script type="text/javascript" language="javascript">
document.onclick=disableEvents
document.oncontextmenu=disableEvents
var ef=0
function custAlert()
{
ef=1
var ids
ids=document.getElementById('alert')
ids.style.left=300;
ids.style.top=150;
ids.style.visibility="visible"
}

function disableEvents()

{if(ef)
return false;

} </script>

</head>
<body bgcolor="#ffffff" onload="custAlert();">       <form id="Form1" method="post" runat="server">
         <div align="center" id="alert" style="border: 2px solid gray; background: #cdeb8b
url('images/img3.gif') repeat-x; left: 240; visibility: hidden; width: 349; color: red; position: absolute;
       top: 104; height: 108">
        <br>      <h3 style="left: 0; width: 152; position: absolute; top: 0; height: 40; ali

gn: Left">
 <span style="color:#356AA0;">Custom Alert Box</span></h3>
        <img style="left: 336px; width: 6px; position: absolute; top: 8px; height: 6px" height="6"
          alt="Close" src="images/Cross.png" onclick="ef=0;document.getElementById('alert').style.visibili

ty='hidden';"          >
 <br>        <hr width="99.03%" size="1" style="left: 0px; width: 99.03%; position: absolute;
         top: 32px; height: 1px">
            <div id="msg" style="width: 349; color: #356aa0; height: 85; text-decoration: none">
         NJoy Programming<p>
      Success be Yours</div>
         <p>
          </div>
            </form>
             </body>
    </html>

VirtualBox 2.0 Released - Awesome Features

Sun has released a major update to VirtualBox, a free virtualization application that lets you run one operating system inside another. VirtualBox 2.0 runs on Mac, Linux, and Windows machines and lets you run guest operating systems inside your computer's native environment.

For example, if you're a Linux user but you occasionally want to run a Windows application that doesn't perform well under WINE, you can load up VirtualBox and run Windows (assuming you have a valid license key).

The latest update brings improved performance for machines with AMD processors and support for 64 bit guest operating systems as long as your host OS is also 64 bit, and support for VHD disk images created using Microsoft Virtual PC. VirtualDisk 2.0 also adds support for the Ubuntu 8.10 and Fedora 9 Linux distributions. You can find a complete list of bug fixes and updates in the release notes.

How to Access Linux partitions From Windows

The solution is pretty simple and straightforward, and NO you don't need to reboot Linux again! You can use any of these free softwares to do the trick for you:

• Ext2 IFS
• Ext2fsd

Linux Partition on Windows

Both the softwares install file system drivers so that you can access the Ext2 file system just like and other native Windows file system. You get both read write access to the Linux partition and it shows up as a normal drive with a drive letter assigned to it within Windows Explorer.

Copy Files in a Fastest Way in Windows XP

In Windows XP how to Copy the Files in a Fastest Way?

Fast Copy is a file copier for Windows that has been around for some time. It was recently updated making it an ideal time to review it at Ghacks. Fast Copy comes as a portable application that can be used to copy files in an efficient speedy way. It falls in the same category as programs like TeraCopy which offer the same functionality.

A major difference between the two applications is the fact that Fast Copy does not hijack the original Windows copy, delete and move operations but comes only into play when the user selects the application to handle the transfers. This can be done by loading Fast Copy or adding Fast Copy entries to the right-click context menu. The option for the latter is provided in the program's options.

Since the usage is not automatic using Fast Copy makes only sense in situations where the user has to copy many files and folders at once, for example when moving the contents of one hard drive to another. It simply takes about five to ten seconds to start the file transfer because the source and destination locations have to be added to the program manually.

The context menu entry is only adding the source location to the program but the destination would still have to be selected manually. Fast Copy uses parallel processing if the source and destination location are on different hard drives and a huge buffer if they are on the same. It comes with a lot of options that can be changed like the buffer size or actions to take if a file exists in the destination.

The command line options might make it usable for batch files that use file operations. It lacks a few of the features that TeraCopy comes with like a queue that offers options to skip files or pause the process.

Fast Copy in its current version can be used in batch files because of its command line parameters and to copy large amount of files. It does not work as a real transfer replacement for Windows and have to leave that field to Teracopy.

Manual Steps To Back Up & Restore The Registry in Windows Vista or Windows XP

How to Manually BackUp & Restore The Registry in Windows Vista or Windows XP?





BackUp the Registry

Windows Vista

1.	Click Start, type systempropertiesprotection in the Start Search box, and then press ENTER. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.
2.	Wait for Windows to search for available disks and most recent restore points. In the System Properties dialog box, on the System Protection tab, click Create,
3.	Type a name for the restore point and then click Create.
4.	After the restore point has been created successfully, click OK two times.

Note: If System Restore is turned off, click to select the local disk, click Apply and then click Create.

Windows XP

1.	Click Start, click Run, type %SystemRoot%\system32\restore\rstrui.exe, and then click OK.
2.	On the Welcome to System Restore page, click Create a restore point, and then click Next .
3.	On the Create a Restore Point page, type a name for the restore point and then click Create
4.	After the restore point has been created, click Close.

Note: If System Restore is turned off, you receive a message that asks whether you want to turn on System Restore now. Click Yes. Then, in the System Properties dialog box, click to clear the Turn off System Restore check box, click OK, and then repeat this step.

Restore the registry

Use System Restore to undo registry changes in Windows Vista or in Windows XP

Windows Vista

1.	Click Start, type systempropertiesprotection in the Start Search box, and then press ENTER. If you are prompted for an administrator password or for a confirmation, type the password, or click Allow.
2.	In the System Properties dialog box, on the System Protection tab, click System Restore,
3.	In the System Restore dialog box select Choose a different restore point, and then click Next
4.	Select the restore point that you want to use, and then click Next.
5.	Confirm your restore point, and then click Finish System restore restores the selected Windows Vista configuration and then restarts the computer.
6.	Log on to the computer. When the System Restore confirmation page appears, click OK..

Windows XP

1.	Click Start, click Run, type %SystemRoot%\System32\Restore\Rstrui.exe, and then click OK.
2.	On the Welcome to System Restore page, click Restore my computer to an earlier time (if it is not already selected), and then click Next .
3.	On the Select a Restore Point page, click the system checkpoint. In the On this list select the restore point area, click an entry that is named "Guided Help (Registry Backup)," and then click Next. If a System Restore message appears that lists configuration changes that System Restore will make, click OK.
4.	On the Confirm Restore Point Selection page, click Next. System Restore restores the previous Windows XP configuration and then restarts the computer.
5.	Log on to the computer. When the System Restore confirmation page appears, click OK..

Lock your Desktop By Mouse Click!

How to Lock your Desktop by a single Mouse Click?


As we all are getting lazier day by day, this post promotes laziness to the core! Generally we have problems in pressing Alt+Ctrl+Del or Windows+L to Lock our PCs, hence it would be better if we could do that by the click of a mouse. Here's how to do it :



1. Right click an empty spot on the desktop, point to New and click Shortcut.

2. In the Create Shortcut dialog box, copy the following into the 'Type the location' of the item text box:
"rundll32 user32.dll,LockWorkStation" remove quotes while typing.

3. Click Next.

4. In "Type a name for this shortcut", type LOCK and Click Finish

5. Now just double click on the icon, your desktop will be locked.

I tested in XP and working fine.. Just try out

Disable Windows XP Boot Screen

How to Disable Windows XP Boot Screen?

Disable your Windows XP Boot Screen by following steps

• Start->Run or (Win key + R)
• Enter msconfig and select BOOT.INI tab
• In Boot options select /NOGUIBOOT
• Restart the System you cannot see the Windows XP Boot Screen.

msconfig Utility

How to remove the unwanted programs running at the system startup and how to improve the performance of your system .Here are the procedures to remove the unwanted programmes that loads during startup and loads in System tray.

Most useful for systems that are running with low memory.

Here are the steps to follow.

Step1: Go to the Run command and type msconfig. To open Run Command Utility Press win's key + R.

Make sure that you have administrator priviledge to do .



Step2: A window utility opens and go to Startup Tab

Uncheck the unwanted programs , so that the programs do not load at system startup.

Caution : uncheck only the programs that you are sure of that event and select ok.

Windows Operating System Run Commands

These are very useful & important Windows Run Utility Commands. By these Run Commands
we can see lot of hidden utilities in Windows Operating System. Improve your skills in the usage of windows operating system by these commands.

Before using these commands Press the keys windows symbol key + R on your key board to activate the Run command utility and type the commands these and hit the enter key.

To Access….	Run Command
Accessibility Controls	access.cpl
Accessibility Wizard	accwiz
Add Hardware Wizard	hdwwiz.cpl
Add/Remove Programs	appwiz.cpl
Administrative Tools	control admintools
Adobe Acrobat (if installed)	acrobat
Adobe Designer (if installed)	acrodist
Adobe Distiller (if installed)	acrodist
Adobe ImageReady (if installed)	imageready
Adobe Photoshop (if installed)	photoshop
Automatic Updates	wuaucpl.cpl
Bluetooth Transfer Wizard	fsquirt
Calculator	calc
Certificate Manager	certmgr.msc
Character Map	charmap
Check Disk Utility	chkdsk
Clipboard Viewer	clipbrd
Command Prompt	cmd
Component Services	dcomcnfg
Computer Management	compmgmt.msc
Control Panel	control
Date and Time Properties	timedate.cpl
DDE Shares	ddeshare
Device Manager	devmgmt.msc
Direct X Control Panel (If Installed)*	directx.cpl
Direct X Troubleshooter	dxdiag
Disk Cleanup Utility	cleanmgr
Disk Defragment	dfrg.msc
Disk Management	diskmgmt.msc
Disk Partition Manager	diskpart
Display Properties	control desktop
Display Properties	desk.cpl
Display Properties (w/Appearance Tab Preselected)	control color
Dr. Watson System Troubleshooting Utility	drwtsn32
Driver Verifier Utility	verifier
Event Viewer	eventvwr.msc
Files and Settings Transfer Tool	migwiz
File Signature Verification Tool	sigverif
Findfast	findfast.cpl
Firefox (if installed)	firefox
Folders Properties	control folders
Fonts	control fonts
Fonts Folder	fonts
Free Cell Card Game	freecell
Game Controllers	joy.cpl
Group Policy Editor (XP Prof)	gpedit.msc
Hearts Card Game	mshearts
Help and Support	helpctr
HyperTerminal	hypertrm
Iexpress Wizard	iexpress
Indexing Service	ciadv.msc
Internet Connection Wizard	icwconn1
Internet Explorer	iexplore
Internet Properties	inetcpl.cpl
Internet Setup Wizard	inetwiz
IP Configuration(Display Connection Configuration)	ipconfig /all
IP Configuration (Display DNS Cache Contents)	ipconfig /displaydns
IP Configuration(Delete DNS Cache Contents)	ipconfig /flushdns
IP Configuration(Release All Connections)	ipconfig /release
IP Configuration(Renew All Connections)	ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS)	ipconfig /registerdns
IP Configuration (Display DHCP Class ID)	ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID)	ipconfig /setclassid
Java Control Panel (If Installed)	jpicpl32.cpl
Java Control Panel (If Installed)	javaws
Keyboard Properties	control keyboard
Local Security Settings	secpol.msc
Local Users and Groups	lusrmgr.msc
Logs You Out Of Windows	logoff
Malicious Software Removal Tool	mrt
Microsoft Access (if installed)	access.cpl
Microsoft Chat	winchat
Microsoft Excel (if installed)	excel
Microsoft Frontpage (if installed)	frontpg
Microsoft Movie Maker	moviemk
Microsoft Paint	mspaint
Microsoft Powerpoint (if installed)	powerpnt
Microsoft Word (if installed)	winword
Microsoft Syncronization Tool	mobsync
Minesweeper Game	winmine
Mouse Properties	control mouse
Mouse Properties	main.cpl
Nero (if installed)	nero
Netmeeting	conf
Network Connections	control netconnections
Network Connections	ncpa.cpl
Network Setup Wizard	netsetup.cpl
Notepad	notepad
Nview Desktop Manager(If Installed)	nvtuicpl.cpl
Object Packager	packager
ODBC Data Source Administrator	odbccp32.cpl
On Screen Keyboard	osk
Opens AC3 Filter(If Installed)	ac3filter.cpl
Outlook Express	msimn
Paint	pbrush
Password Properties	password.cpl
Performance Monitor	perfmon.msc
Performance Monitor	perfmon
Phone and Modem Options	telephon.cpl
Phone Dialer	dialer
Pinball Game	pinball
Power Configuration	powercfg.cpl
Printers and Faxes	control printers
Printers Folder	printers
Private Character Editor	eudcedit
Quicktime (If Installed)	QuickTime.cpl
Quicktime Player (if installed)	quicktimeplayer
Real Player (if installed)	realplay
Regional Settings	intl.cpl
Registry Editor	regedit
Registry Editor	regedit32
Remote Access Phonebook	rasphone
Remote Desktop	mstsc
Removable Storage	ntmsmgr.msc
Removable Storage Operator Requests	ntmsoprq.msc
Resultant Set of Policy (XP Prof)	rsop.msc
Scanners and Cameras	sticpl.cpl
Scheduled Tasks	control schedtasks
SecurityCenter	wscui.cpl
Services	services.msc
Shared Folders	fsmgmt.msc
Shuts Down Windows	shutdown
Sounds and Audio	mmsys.cpl
Spider Solitare Card Game	spider
SQL Client Configuration	cliconfg
System Configuration Editor	sysedit
System Configuration Utility	msconfig
System File Checker Utility (Scan Immediately)	sfc /scannow
System File Checker Utility (Scan Once At Next Boot)	sfc /scanonce
System File Checker Utility (Scan On Every Boot)	sfc /scanboot
System File Checker Utility (Return to Default Setting)	sfc /revert
System File Checker Utility (Purge File Cache)	sfc /purgecache
System File Checker Utility (Set Cache Size to size x)	sfc /cachesize=x
System Information	msinfo32
System Properties	sysdm.cpl
Task Manager	taskmgr
TCP Tester	tcptest
Telnet Client	telnet
Tweak UI (if installed)	tweakui
User Account Management	nusrmgr.cpl
Utility Manager	utilman
Windows Address Book	wab
Windows Address Book Import Utility	wabmig
Windows Backup Utility (if installed)	ntbackup
Windows Explorer	explorer
Windows Firewall	firewall.cpl
Windows Magnifier	magnify
Windows Management Infrastructure	wmimgmt.msc
Windows Media Player	wmplayer
Windows Messenger	msmsgs
Windows Picture Import Wizard (need camera connected)	wiaacmgr
Windows System Security Tool	syskey
Windows Update Launches	wupdmgr
Windows Version (to show which version of windows)	winver
Windows XP Tour Wizard	tourstart
Wordpad	write