Blogger Cochin

SQLServer Date examples

2012-02-07T02:45:00.001-08:00

select year(getdate())-1 as lastyear
select year(getdate()) as currentYear
select day(getdate()) as currentDay
select month(getdate()) as currentMonth

http://msdn.microsoft.com/en-us/library/ms186313.aspx

the magic in 1=1 SQL server

2011-08-20T23:28:00.002-07:00

WHERE 1 =
(
CASE
WHEN @Status = 'ALL'
AND 0=0 THEN 1
WHEN @Status = 'updated'
AND KareoId >= 0 THEN 1
WHEN @Status = 'not updated'
AND KareoId is null THEN 1
ELSE 0
END
)

SQL Server 2008 where clause and case ,CASE IN where Clause,1=1,

2011-08-20T23:28:00.000-07:00

WHERE 1 =
(
CASE
WHEN @Status = 'ALL'
AND 0=0 THEN 1
WHEN @Status = 'updated'
AND KareoId >= 0 THEN 1
WHEN @Status = 'not updated'
AND KareoId is null THEN 1
ELSE 0
END
)

Rename column name in SQL server 2008

2011-08-11T02:49:00.000-07:00

Rename Column
Syntax
sp_RENAME 'table.Column','New ColumnName','column'
EG.
sp_RENAME 'PatientDetail.MRN' ,'KareoMRN', 'column'

to Change Data Type.

alter table PatientDetail alter column MRN varchar(200)

SQL SERVER – Find Current Location of Data and Log File of All the Database

2011-08-01T06:32:00.001-07:00

SQL SERVER – Find Current Location of Data and Log File of All the Database

SELECT name, physical_name AS current_file_location
FROM sys.master_files

SELECT name, physical_name AS current_file_location
FROM sys.master_files

SELECT DB_NAME(mf.database_id) AS databaseName
,mf.physical_name
,num_of_reads
,num_of_bytes_read
,io_stall_read_ms
,num_of_writes
,num_of_bytes_written
,io_stall_write_ms
,io_stall
,size_on_disk_bytes
FROM sys.dm_io_virtual_file_stats(NULL, NULL) AS divfs
JOIN sys.master_files AS mf ON mf.database_id = divfs.database_id
AND mf.file_id = divfs.file_id
ORDER BY 3 DESC

Shrink Whole Database

2011-08-01T05:37:00.001-07:00

USE dbName
EXEC sp_helpfile

Let us understand this using database AdventureWorks.
/* Shrink Whole AdventureWorks Database */
DBCC SHRINKDATABASE (AdventureWorks)
GO

USE AdventureWorks
EXEC sp_helpfile
GO
/* Shrink MDF File of AdventureWorks Database */
DBCC SHRINKFILE (AdventureWorks_Data)
GO

Truncate and reseed Table DBCC

2011-08-01T05:36:00.000-07:00

delete from VendorMemoHead
DBCC CHECKIDENT (VendorMemoHead, RESEED, 0)

how to find No of Tables& Rows in database

2011-08-01T05:35:00.000-07:00

USE InstaKare1
EXEC sp_helpfile

SELECT OBJECT_NAME(OBJECT_ID) TableName, st.row_count
FROM sys.dm_db_partition_stats st
WHERE index_id < 2 and st.row_count>0
ORDER BY st.row_count DESC
--ORDER BY TableName DESC

Aging SQL server

2011-08-01T01:35:00.000-07:00

select Debtor,
sum(case when DSO <= 30 then Invoice_Amount else 0 end) as [0 - 30 Days], sum(case when DSO > 30 and DSO <= 60 then Invoice_Amount else 0 end) as [31 - 60 Days]from Invoicesgroup by Debtor----------------------------------------------------------------------------------------------------------------------datediff(dd,convert(varchar,invoice.inv_due_dt,102),convert(varchar,getdate(),102)) as DSO. Not sure if that makes a difference with regard to the above code. Can I just substitute: datediff(dd,convert(varchar,invoice.inv_due_dt,102),convert(varchar,getdate(),102))---------------------------------------------------------------------------------------------------SELECT invoice.inv_co, invoice.inv_no, CONVERT(VARCHAR,invoice.inv_dt,101), CONVERT(VARCHAR,invoice.inv_paid_dt,101), invoice.inv_paid_amt, invoice.inv_status, CONVERT(VARCHAR,invoice.inv_due_dt,101), invoice.inv_type, invoice.inv_category, invoice.inv_base_amt, customer.cus_cd, customer.cus_name, cuscat.cusc_code, CONVERT(VARCHAR,GETDATE(),102), DATEDIFF(dd,CONVERT(VARCHAR,invoice.inv_due_dt,102),CONVERT(VARCHAR,GETDATE(),102)) as DSOSUM (CASE WHEN (DATEDIFF(dd,CONVERT(VARCHAR,invoice.inv_due_dt,102),CONVERT(VARCHAR,GETDATE(),102))<= 30 THEN invoice.inv_base_amt ELSE 0 END) AS [0 - 30 Days],SUM (CASE WHEN (datediff(dd,CONVERT(VARCHAR,invoice.inv_due_dt,102),CONVERT(VARCHAR,GETDATE(),102)) )> 30
and (DATEDIFF(dd,CONVERT(VARCHAR,invoice.inv_due_dt,102),
CONVERT(varchar,GETDATE(),102))) <= 60 THEN invoice.inv_base_amt ELSE 0 END) AS [31 - 60 Days]FROM sxacctnotes.dbo.cuscat cuscat, sxacctnotes.dbo.customer customer, sxacctnotes.dbo.invoice invoiceWHERE invoice.inv_cus_cd = customer.cus_cd AND invoice.inv_cus_grp = customer.cus_grp_cd AND customer.cus_category = cuscat.cusc_code AND ((invoice.inv_status='O') AND (invoice.inv_co='10')--------------------------------------------------------------------SELECT invoice.inv_co ,invoice.inv_no ,cONVERT(VARCHAR,invoice.inv_dt,101) inv_dt ,CONVERT(VARCHAR,invoice.inv_paid_dt,101) inv_paid ,invoice.inv_paid_amt ,invoice.inv_status ,CONVERT(VARCHAR,invoice.inv_due_dt,101) inv_due_dt ,invoice.inv_type ,invoice.inv_category ,invoice.inv_base_amt ,customer.cus_cd ,customer.cus_name ,cuscat.cusc_code ,CONVERT(VARCHAR,GETDATE(),102) curr_date --? ,DATEDIFF(dd, invoice.inv_due_dt, GETDATE()) as DSO ,CASE WHEN DATEDIFF(dd,invoice.inv_due_dt, GETDATE()) <= 30 THEN invoice.inv_base_amt ELSE 0 END AS [0 - 30 Days] ,CASE WHEN datediff(dd,invoice.inv_due_dt, GETDATE()) > 30
and DATEDIFF(dd,invoice.inv_due_dt, GETDATE()) <= 60 THEN invoice.inv_base_amt ELSE 0 END AS [31 - 60 Days]FROM dbo.cuscat cuscatinner join dbo.customer customer on customer.cus_category = cuscat.cusc_codeinner join dbo.invoice invoice on invoice.inv_cus_grp = customer.cus_grp_cd and invoice.inv_cus_cd = customer.cus_cdWHERE invoice.inv_status = 'O' AND invoice.inv_co = '10'-----------------------------------------------------------------SELECT--DateOfservice,BillCharges --,CONVERT(VARCHAR,GETDATE(),102) curr_date --? --,DATEDIFF(dd, PBD.DateOfservice, GETDATE()) as DSO --, SUM(CASE WHEN DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 30 THEN (ISNULL(PBD.BillCharges,0) -(ISNULL(RD.amtpaid,0)+ISNULL(RD.ContractAdj,0)+ISNULL(RD.SecondAdj,0))) ELSE 0 END )AS [0 - 30 Days] ,SUM(CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 30
and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 60 --THEN (ISNULL(PBD.BillCharges,0)) THEN (ISNULL(PBD.BillCharges,0) -(ISNULL(RD.amtpaid,0)+ISNULL(RD.ContractAdj,0)+ISNULL(RD.SecondAdj,0))) ELSE 0 END) AS [31 - 60 Days] ,SUM(CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 60
and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 90 THEN (ISNULL(PBD.BillCharges,0) -(ISNULL(RD.amtpaid,0)+ISNULL(RD.ContractAdj,0)+ISNULL(RD.SecondAdj,0))) ELSE 0 END) AS [61 - 90 Days] ,SUM(CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 90
and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 120 THEN (ISNULL(PBD.BillCharges,0) -(ISNULL(RD.amtpaid,0)+ISNULL(RD.ContractAdj,0)+ISNULL(RD.SecondAdj,0))) ELSE 0 END) AS [90 - 120 Days] ,SUM(CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 120
--and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 120 THEN (ISNULL(PBD.BillCharges,0) -(ISNULL(RD.amtpaid,0)+ISNULL(RD.ContractAdj,0)+ISNULL(RD.SecondAdj,0))) ELSE 0 END )AS [120+ Days]FROM PatientBillDetailed PBDLEFT JOIN ReceiptDetails RD ON PBD.ID=RD.BillDetailIdWHERE PatientID=178 GROUP BY PatientID------------------------------------------------------------------------SELECTDateOfservice,BillCharges ,CONVERT(VARCHAR,GETDATE(),102) curr_date --? ,DATEDIFF(dd, PBD.DateOfservice, GETDATE()) as DSO ,CASE WHEN DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 30 THEN PBD.BillCharges ELSE 0 END AS [0 - 30 Days] ,CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 30
and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 60 THEN PBD.BillCharges ELSE 0 END AS [31 - 60 Days] ,CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 60
and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 90 THEN PBD.BillCharges ELSE 0 END AS [61 - 90 Days] ,CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 90
and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 120 THEN PBD.BillCharges ELSE 0 END AS [90 - 120 Days] ,CASE WHEN datediff(dd,PBD.DateOfservice, GETDATE()) > 120
--and DATEDIFF(dd,PBD.DateOfservice, GETDATE()) <= 120
THEN PBD.BillCharges
ELSE 0
END AS [120+ Days]
FROM PatientBillDetailed PBD
WHERE PatientID=178
----------------------------------------------------------
declare @counter int
set @counter = 0
while @counter < 10
begin
set @counter = @counter + 1
print 'The counter is ' + cast(@counter as char)
end
---------------------------------------------------------------------------------
declare @Part_Id int
declare @Category_Id int
declare @Desc varchar(50)
create table PART (Part_Id int, Category_Id int, Description varchar(50))
set @Part_Id = 0
set @Category_Id = 0
while @Part_Id < 2
begin
set @Part_Id = @Part_Id + 1
while @Category_Id < 3
begin
set @Category_Id = @Category_Id + 1
set @Desc = 'Part_Id is ' + cast(@Part_Id as char(1)) +
' Category_Id ' + cast(@Category_Id as char(1))
insert into PART values(@Part_Id,
@Category_Id,
@Desc )
end
set @Category_Id = 0
end
select * from PART
drop table PART

2011-01-26T23:05:00.000-08:00

DECLARE @temp TABLE(empid INT,empname varchar(20),empsal float)
insert into @temp values(1,'sooraj',2000)
insert into @temp values(2,'raj',1000)
insert into @temp values(3,'nahas',8000)
insert into @temp values(4,'binoj',4000)
select * from @temp

CREATE table #temp ( empid INT,empname varchar(20),empsal float)
insert into #temp values(1,'sooraj',2000)
insert into #temp values(2,'raj',1000)
insert into #temp values(3,'nahas',8000)
insert into #temp values(4,'binoj',4000)

select * from #temp

SELECT TOP 1 empsal
FROM (
SELECT DISTINCT TOP 3 empsal
FROM #temp
ORDER BY empsal DESC) a
ORDER BY empsal

Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value

2011-01-26T22:52:00.000-08:00

DECLARE @temp TABLE(empid INT,empname varchar(20),empsal float)
insert into @temp values(1,'sooraj',2000)
insert into @temp values(2,'raj',1000)
insert into @temp values(3,'nahas',8000)
insert into @temp values(4,'binoj',4000)
select * from @temp

CREATE table #temp ( empid INT,empname varchar(20),empsal float)
insert into #temp values(1,'sooraj',2000)
insert into #temp values(2,'raj',1000)
insert into #temp values(3,'nahas',8000)
insert into #temp values(4,'binoj',4000)

select * from #temp

SELECT TOP 1 empsal
FROM (
SELECT DISTINCT TOP 4 empsal
FROM #temp
ORDER BY empsal DESC) a
ORDER BY empsal

How To: Reset Identity column in SQL Server

2010-06-23T22:20:00.001-07:00

This is one of those simple tip posts that may seem obvious and taken for granted by those of us who have been working with SQL Server for a while now but maybe a newbie or two out there will find this helpful.

Every so often (just this morning!) I find myself resetting an identity column value back to 0 after I've deleted all the existing records so the table gets a fresh start at primary key 1. Yes, I know all about primary keys not changing and how the value in the primary key doesn't matter and so on. Sometimes I just like the primary keys starting at 1.

The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

DBCC CHECKIDENT('Customer', RESEED, 0)

Keyboard shortcuts for Windows

2010-05-26T22:44:00.000-07:00

Short Cut Keys

How to solve SQL SERVER 2008 Allow remote access problem

2010-05-26T22:43:00.000-07:00

Read

Using SourceSafe in Visual Studio 2005 & 2008

2010-04-20T00:25:00.000-07:00

1. Choosing SourceSafe as the SCC Provider in Visual Studio
2. Adding Solution into Source Control of SourceSafe
3. Performing SourceSafe Operations in Visual Studio
4. Changing Source Control Binding
5. Pending Checkins Window
6. Viewing Source Control Message

http://www.kevingao.net/sourcesafe/using-sourcesafe-in-visual-studio-2005-2008.html

primary key vs unique key

2010-03-09T21:53:00.000-08:00

what is a unique key ?
how difer from primary key
answer
Like a primary key, a unique key is created on a field containing only unique values throughout an entire
table.
So, why create unique keys that are not primary keys? If surrogate keys are used and the author name is
required to be unique, it is common to see unique keys created on name fields such as the AUTHOR table
NAME and the PUBLICATION table TITLE fields.
A unique key ensures uniqueness across a table. A
primary key is always unique, or at least a unique key; however, a primary key is also used to define
relationships between tables. Unique keys are not used to define relationships between tables.

Common Table Expressions

2010-03-09T02:50:00.000-08:00

A common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Unlike a derived table, a CTE can be self-referencing and can be referenced multiple times in the same query.

A CTE can be used to:

Create a recursive query. For more information, see Recursive Queries Using Common Table Expressions.

Substitute for a view when the general use of a view is not required; that is, you do not have to store the definition in metadata.

Enable grouping by a column that is derived from a scalar subselect, or a function that is either not deterministic or has external access.

Reference the resulting table multiple times in the same statement.

Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries. The query can be divided into separate, simple, logical building blocks. These simple blocks can then be used to build more complex, interim CTEs until the final result set is generated.
Structure of a CTE
A CTE is made up of an expression name representing the CTE, an optional column list, and a query defining the CTE. After a CTE is defined, it can be referenced like a table or view can in a SELECT, INSERT, UPDATE, or DELETE statement. A CTE can also be used in a CREATE VIEW statement as part of its defining SELECT statement.

The basic syntax structure for a CTE is:

WITH expression_name [ ( column_name [,...n] ) ]

AS

( CTE_query_definition )

The list of column names is optional only if distinct names for all resulting columns are supplied in the query definition.

The statement to run the CTE is:

SELECT

FROM expression_name;

Read

Temporary Tables vs. Table Variables

2010-03-05T02:37:00.000-08:00

The first difference is that transaction logs are not recorded for the table variables. Hence, they are out of scope of the transaction mechanism

The second major difference is that any procedure with a temporary table cannot be pre-compiled, while an execution plan of procedures with table variables can be statically compiled in advance. Pre-compiling a script gives a major advantage to its speed of execution. This advantage can be dramatic for long procedures, where recompilation can be too pricy.

Finally, table variables exist only in the same scope as variables. Contrary to the temporary tables, they are not visible in inner stored procedures and in exec(string) statements. Also, they cannot be used in an insert/exec statement

Read

MSDN

Should I use a #temp table or a @table variable?

Normalization An Easy Way 2 Learn

2010-03-04T05:32:00.000-08:00

1st Normal Form (1NF)—Removes repeating fields by creating a new table where the original and new table are linked together with a master-detail, one-to-many relationship.
For example,
a master table could contain parent records representing all the ships owned by a cruise line. A
detail table would contain detail records, such as all the passengers on a cruise to the Caribbean.
Create primary keys on both tables where the detail table will have a composite primary key containing the master table primary key field as the prefix field of its primary key. That prefix field is also a foreign key back to the master table.

2nd Normal Form (2NF)—Performs a seemingly similar function to that of 1NF, but creates a table where repeating values (rather than repeating fields as for 1NF) are removed to a new table. The result is a many-to-one relationship rather than a one-to-many relationship, created between the original and the new tables.
The new table gets a primary key consisting of a single field. The master table contains a foreign key pointing back to the primary key of the new table.
That foreign key is not part of the primary key in the original table.

3rd Normal Form (3NF)—It is difficult to explain 3NF without using a mind bogglingly confusing technical definition. Elimination of a transitive dependency implies creation of a new table for something indirectly dependent on the primary key in an existing table

What is the difference between a ‘soliloquy’ and a ‘monologue’?

2010-02-19T00:51:00.001-08:00

First, let’s deal with the pronunciation of ‘soliloquy’. The ‘o’ in the first and third syllable is pronounced like the ‘a’ in ‘china’. The second syllable ‘lil’ rhymes with ‘fill’, ‘bill’, and ‘chill’. The ‘qui’ in the final syllable is like the ‘qui’ in ‘quit’ and ‘quiz’. The word is pronounced ‘se-LIL-e-kwi’ with the stress on the second syllable. It comes from the Latin ‘soliloquium’ meaning ‘talking to oneself’. A soliloquy is a device used by a dramatist to let the audience know what a character is thinking. In a soliloquy, a character is speaking to himself; he is thinking aloud, and what he says is meant only for the audience, and not for the other characters in the play. The plays of Shakespeare are well known for their soliloquies. A monologue is one person talking; not necessarily to himself. A play in which there is only one character is called a ‘monologue’. The term can also be used to refer to a conversation between two individuals in which one person does most of the talking. The other individual merely listens.

******

“Efficiency is intelligent laziness.” — Anonymous

What is the meaning of ‘kitchen cabinet’?

2010-02-19T00:48:00.004-08:00

Every head of state is believed to have his/her own ‘kitchen cabinet’. It usually consists of a small group of people whom the Prime Minister or President turns to for advice. These unofficial advisers are not politicians, and the head of state implicitly trusts them. It is believed that sometimes the kitchen cabinet has a greater influence on the head of state than the official cabinet. This is understandable, I guess, because the official cabinet consists of politicians, and as everyone knows, politicians are not meant to be trusted — even if they happen to be from your own party!

The expression ‘kitchen cabinet’ was coined in the United States in the 1830s during the presidency of Andrew Jackson. He had three friends whom he depended on for advice. Since he wanted to keep their visits a secret, he usually had them ushered in through the kitchen door. It is believed that most of their meetings actually took place in the kitchen: hence the term ‘kitchen cabinet’. Other expressions which have more or less the same meaning are ‘brain(s) trust’ and ‘think tank’.

******

“A graduation ceremony is an event where the commencement speaker tells thousands of students dressed in identical caps and gowns that ‘individuality’ is the key to success.” — Robert Orben

What it the meaning of ‘cut loose’?

2010-02-19T00:48:00.003-08:00

The expression has several different meanings. While watching cricket, we often hear Gavaskar and Bhogle say, ‘Sehwag has cut loose’. In this context, the expression means ‘free and relaxed’. In other words, the batsman is not holding back; he is going for his shots, and is thoroughly enjoying himself. He is batting without restraint. He is like an animal that is no longer tied up.

*When Prahlad, Bala, and Rakesh get together, they really cut loose.

How is ‘amour-propre’ pronounced?

2010-02-19T00:48:00.001-08:00

There seem to be different ways of pronouncing this expression of French origin. One way is to pronounce the ‘a’ in ‘amour’ like the ‘a’ in ‘ask’, ‘bath’, and ‘path’, and the ‘ou’ like the ‘u’ in ‘put’, ‘full’, and ‘pull’. The second word ‘propre’ is pronounced like the word ‘pro’. The expression is pronounced ‘aamur PRO’ with the main stress on ‘pro’. ‘Amour’ means ‘love’ and ‘propre’ means ‘own’; the expression is mostly used to refer to one’s self-esteem or self-respect.

*Whatever you do, don’t offend Kavitha’s amour-propre.

What is the difference between ‘eminent’ and ‘famous’?

2010-02-19T00:47:00.004-08:00

When it means, ‘widely known’, the word ‘famous’ can be used with both people and things. ‘Eminent’, on the other hand, is mostly restricted to people. ‘Famous’ suggests that the individual is widely known for a particular reason: it can be for good or bad. For example, Aamir Khan is a famous actor. Someone like Monica Lewinsky is also famous; perhaps, not for the right reasons.

‘Eminent’ is a stronger word than ‘famous’. It comes from the Latin ‘eminentem’ meaning ‘to stand out’. An eminent person, therefore, is someone who stands apart from others; in other words, he is an outstanding and distinguished member of his profession. He is respected by both the public and the members from his own profession. India has produced many eminent artists.

What is the difference between `revue' and `review'?

2010-02-19T00:47:00.003-08:00

Don't let the spelling fool you. `Revue' is pronounced the same way as `review'; both words have the stress on the second syllable. Their meanings, however, are very different.

A `revue' is a form of theatrical entertainment. It is not a full length play; it is a multi-act form of entertainment, which usually includes songs, dances, and short sketches. People enjoy going to revues because they are satirical in nature; they make fun of politicians, actors, writers and other public figures. This form of entertainment was very popular in the early decades of the 20th century.

Ashok wants me to write a political revue for his theatre group.

The word `review' has several different meanings, but I'll be dealing with only one here. When someone writes a review of a book or a film, for example, he gives his opinion of it. He tells us what he liked and didn't like about the film/book.

The reviews that the film got weren't particularly good. My friend has been asked to write a review of my favourite author's latest book. * * *

"Rogues are preferable to imbeciles because they sometimes take a rest."

- Alexandre Dumas

What is the meaning and origin of `set the ball rolling'?

2010-02-19T00:47:00.001-08:00

According to some scholars, the idiom comes from the world of football: the game starts when the ball is set rolling.

When you set the ball rolling, you do something which starts an activity. You make a beginning. It is also possible to say, `get the ball rolling' and `start the ball rolling'.

Ajit set the ball rolling by putting up posters in the nearby supermarkets.

You can get the ball rolling by talking to your classmates.

How is the word `sycophancy' pronounced?

2010-02-19T00:46:00.001-08:00

There are several ways of pronouncing the word. One simple way is to pronounce the `syc' like the word `sick'. The following `o' and `a' sound like the `a' in `china', and the final `y' is like the `i' in `bit', `sit', and `kit'.

The word is pronounced SICK-e-fen-si with the stress on the first syllable. A `sycophant' is someone who flatters others in order to get something from them. He is a like a parasite: he hangs on to people in power for personal gain.

At the party, the wellknown cricket player was surrounded by sycophants.

Please, we do not want any of your sycophancy here.

What is the meaning of `scuttlebutt'?

2010-02-19T00:43:00.000-08:00

This is a word which comes from the world of sailing. `Butt' means `barrel' or `cask', and `scuttle' refers to the hatch on the deck of a ship.

A`scuttlebutt' was actually a barrel containing the day's supply of drinking water for the ship's crew. Since this barrel (butt) of water was placed near the hatch (scuttle), the container began to be called `scuttlebutt'. What do you think happened when the members of the crew got together to drink water? The same thing that happens today when colleagues in an office gather around the water cooler or the coffee machine. They gossiped! The sailors drank water, and gossiped about what was happening on the ship. In informal contexts, the expression `scuttlebutt' is used to mean `rumour' or `gossip'.

Have you heard the latest scuttlebutt about my new neighbour?

I don't pay too much attention to the scuttlebutt around here.

Which Collections Are Thread Safe?

2010-02-17T22:04:00.002-08:00

ArrayList, Queue,
Hashtable, SortedList, HybridDictionary, ListDictionary, and StringDictionary are
thread safe.

Which Collection Should I Use?

2010-02-17T22:04:00.001-08:00

How do you decide which collection to use for a given programming task? The following
points may help you decide:
§ If you want a fixed-size array, use System.Array.
§ If you want a dynamically sizable array, use ArrayList.
§ If you want to store a list of elements and always retrieve the last one you added first,
use a Stack.
§ If you want to store elements and retrieve them using a key, use a Hashtable. If you
also want to be able to access them by index, use a SortedList.
§ If you want to store a list of elements and always retrieve them in the order in which
you added them, use a Queue.
§ If you want to store a series of true/false (or on/off) flags, use a BitArray.
§ If you want to store a list of strings and refer to them by index, use a StringCollection.
§ If you want to store a list of strings and refer to them by key or index, use a
NameValueCollection.

csharp3.0specification

2010-02-17T21:59:00.000-08:00

Overview of C# 3.0
1 Implicitly typed local variables
2 Extension methods
2.1 Declaring extension methods
2.2 Importing extension methods
2.3 Extension method invocations
3 Lambda expressions
3.1 Lambda expression conversions
3.2 Type inference
3.3 Overload resolution
4 Object and collection initializers
4.1 Object initializers
4.2 Collection initializers
5 Anonymous types
6 Implicitly typed arrays
7 Query expressions
7.1 Query expression translation
7.1.1 where clauses
7.1.2 select clauses
7.1.3 group clauses
7.1.4 orderby clauses
7.1.5 Multiple generators
7.1.6 into clauses
7.2 The query expression pattern
7.3 Formal translation rules
8 Expression trees

Download

thread safety.

2010-02-17T21:55:00.000-08:00

Brief explanation of thread safety. Nowadays, many programs are
written using multiple threads of execution. A thread (looking at it very simply) is a function
within a program that is executing at the same time as the rest of the code, and the
operating system schedules them against one other in the same way that it schedules whole
programs against one another. This is done by giving each thread (each function) a short
time slice, and then suspending it in order to give another thread a chance to run. If it is done
quickly and smoothly, it gives the illusion that functions are executing simultaneously.
Intelligent use of scheduling by the operating system can result in much smoother program
operation.
The problem, however, is that the scheduler can decide to suspend one thread while it is in
the middle of an operation, which can cause real problems with shared data structures.
Imagine that one thread has just started to retrieve item 5 from a collection when the
scheduler decides to swap to another thread, and that this new thread promptly removes
item 5. When control switches back to the original thread, the scheduler is not going to get
the data item it was expecting. Errors due to shared data being accessed by multiple threads
can be very hard to track down because of the unpredictability of the scheduler and when it
decides to swap between threads.
A thread-safe class is one in which critical methods, such as insertion, removal, and retrieval
of elements, are protected against being interrupted by another thread.

download

Csharp System Collection

2010-02-17T21:50:00.000-08:00

The System.Collections Namespace
The System.Collections Interfaces
Interfaces are very important in the System.Collections namespace because very few of
the collection classes are related by inheritance, but many of them need to provide the same
functionality. A good example of this is the ability to iterate over the members of a collection;
moving from one element to another is the same no matter how the data is actually stored.
Moving from one element of an array to the next is the same logical idea as moving from one
element of a linked list to the next, but the way in which the collection navigates through its
data is completely different.
The System.Collections namespace includes a number of interfaces that between them
define all the common behavior required of collection classes; I’ll explain each of these
interfaces and what they do. When discussing the classes, I’ll illustrate which interfaces they
implement so that you can see the extra methods they are going to provide.
IEnumerable
If a collection implements the IEnumerable interface, it signals that it can provide an
enumerator object that supports forward-only iteration over the collection. Because this
behavior is very common, this interface is implemented by approximately 100 classes.
IEnumerable only has one member, the GetEnumerator() method, which takes no
arguments and returns an enumerator object:
Function GetEnumerator() As IEnumerator
Note how the IEnumerable and IEnumerator interfaces work together. If a class implements
IEnumerable, then this method will return a reference to an object that implements
IEnumerator. You don’t have to know exactly what type the returned object is, only that you
can use it as an enumerator.
IEnumerator
IEnumerator is implemented by classes that support simple iteration over a collection. By
simple, I mean that you can only move forward from element to element, although you can
go back to the start at any time.
Enumerators are read-only because the object takes a snapshot of the collection when it is
created. This means that it is perfectly possible to have more than one enumerator with
access to the same collection. The underlying collection must not be changed while an
enumerator is active because its snapshot would then be out of date. If this happens, the
iterator will throw exceptions whenever you try to use it.
The IEnumerator interface has three members. The MoveNext() method advances the
iterator to the next element in the collection. Note that the initial position of the iterator is
before the first element in the collection, so you need to call MoveNext() once in order to
advance to the first element.
The function returns a Boolean value, which will be true if the iterator successfully advanced
to the next element, and false once it has passed the end. The Reset() method can be used
to set the iterator back to its initial position, that is, before the first element in the collection.
The Current property returns a reference to the current object in the collection. This property
will throw an invalid operation exception under two circumstances:
§ If the enumerator is positioned before the start or after the end of the collection
§ If the collection has been modified since the enumerator object was created
See the Immediate Solutions section for examples of enumerator usage.
ICollection
ICollection is a descendant of IEnumerable and defines size, enumerators, and
synchronization methods for collections. Like IEnumerable, it is implemented by a very large
number of classes, and because ICollection is based on IEnumerable, any class that
implements ICollection has to implement IEnumerable as well.
ICollection adds the following functionality to the GetEnumerator() method defined by
IEnumerable:
§ SyncRoot and IsSynchronized—These properties allow classes to implement thread
safe collections.
§ Count—This property returns the number of items in the collection.
§ CopyTo()—This method can be implemented to copy elements from a collection into a
one-dimensional array.
IList
The IList interface, a descendent of ICollection, is implemented by classes that represent
collections of objects that can be individually indexed, and it specifies all the properties and
methods that must be supported by such classes. This means that it is implemented by array
classes (such as System.Array and System.Collections.ArrayList) as well as other more
specialized classes. Implementations of IList fall into three types: read-only, fixed-size, and
variable-size.
The methods supported by IList are fairly self-explanatory:
§ Add() and Insert() can be used to add items to the list. Insert() takes a zero-based
index specifying where the item is to be inserted, whereas Add() appends the new item
to the end.
§ Remove() and RemoveAt() are used to remove items from the list. RemoveAt() takes
an index specifying which item is to be removed, whereas Remove() takes an Object
reference and removes that object. Clear() can be used to remove all entries.
§ IndexOf() and Contains() are used to search the list. Both take an Object reference.
Contains() returns a Boolean value, whereas IndexOf() returns a zero-based index.
§ The Item property is used to get or set the value at the specified index.
§ The IsFixedSize and IsReadOnly properties tell you whether the underlying collection
is fixed size, and whether it can be modified.
IComparer
The IComparer interface implements a single method that compares two objects and returns
a value indicating which one is greater:
Function Compare(ByVal x as Object, ByVal y As Object) As Integer
The function returns a negative value if x is less than y, zero if they are the same, and a
positive value if x is greater than y.
Objects passed to compare must implement the System.IComparable interface; if they
don’t, the function will throw an ArgumentException. You’ll find a discussion of the
System.IComparable interface in Chapter 3.
The default implementation of this interface is provided by the
System.Collections.Comparer class. This default implementation lets you easily create an
object with which to perform comparisons.
This interface is often used with the System.Array class when using its Sort() and
BinarySearch() methods. When using these methods, you can either use the default
ICompare implementations of the objects themselves or provide your own comparison
objects by implementing this interface.
IDictionary
A dictionary is a data structure consisting of a set of keyword/value pairs, where each value
is identified by an associated key. Keys and values can be any type of object; keys have to
be unique and non-null. IDictionary is implemented by over half a dozen classes including
two members of System.Collections—Hashtable and SortedList—which are discussed
under their own headers in the In Depth section.
The following list shows the properties and methods specified by IDictionary:
§ Add() adds an entry with a specified key and value to the dictionary.
§ The Item property retrieves the value corresponding to the specified key.
§ The Keys and Values properties return collections containing all the keys and values
respectively.
§ Contains() determines whether a value with a specified key exists in the dictionary.
§ Clear() removes all entries from dictionary, whereas Remove() removes the entry with
a specified key.
§ GetEnumerator() returns an IDictionaryEnumerator that you can use to walk through
the dictionary.
§ The IsFixedSize and IsReadOnly properties tell you whether the underlying collection
is fixed size, and whether it can be modified.
IDictionaryEnumerator
The IDictionaryEnumerator interface is based on IEnumerator and provides extra methods to
let you retrieve the key and/or value associated with an item.
You can use the standard enumerator methods, MoveNext() and Reset(). In addition, you
can use the Entry property to retrieve the key and value of the current item or the Key and
Value properties to retrieve them separately. Note that although the enumerator selects
items in the dictionary one after another, this does not imply any ordering of the data.
The Entry property returns a DictionaryEntry object. DictionaryEntry is a value type that
contains Key and Value public fields, each of which is an Object reference.
Download
Read The .NET Framework Black Book

Visual Studio to Full Screen mode

2010-02-09T01:25:00.000-08:00

SHIFT + ALT + ENTER: This one will switch you Visual Studio to Full Screen mode, which is very useful in those boring presentation when you have to show your code through a projector on a screen. Another click will get you back to normal mode.

Test your JavaScript Code with QUnit

2010-02-04T01:35:00.001-08:00

What is QUnit
QUnit is a powerful JavaScript unit testing framework that helps you to debug code. It's written by members of the jQuery team, and is the official test suite for jQuery. But QUnit is general enough to test any regular JavaScript code, and it's even able to test server-side JavaScript via some JavaScript engine.

"

In computer programming, unit testing is a software verification and validation method in which a programmer tests if individual units of source code are fit for use. A unit is the smallest testable part of an application. In procedural programming a unit may be an individual function or procedure.
This is quoted from Wikipedia. Simply put, you write tests for each functionality of your code, and if all of these tests are passed, you can be sure that the code will be bug-free.

Read article from nettut

Maruti Cervo The Storm-An addition to the Cold war on small car segment

2010-02-03T21:26:00.000-08:00

Maruti Cervo to be priced between Rs 1.5-2 lakh-Rediff-Bussiness

The original small car makers of the country who gave us the first economy car Maruti 800 are back with Maruti Cervo to compete with Tata Nano.

With Cervo the car makers are expecting to gain their lost position in the small car segment that they had during the days of Maruti 800. Maruti Cervo is priced between Rs 150,000 - Rs 200,000 (ex-showroom Delhi), which is higher than the price of Tata Nano.

It is still expected to give the one-lakh-rupee car a run for its money. Cervo is seen to be rolled out sometime in the month of May or June 2010.

All about Cervo

With Maruti Cervo the car maker wishes to repeat the success of Maruti 800 and Maruti Alto. Maruti is working very hard to tap the entry level segment and it might reduce some features from the original model available in Japan.

Cervo which is a five-door hatchback model has a spacious passenger cabin. It comes equipped with a 0.7L, 660cc petrol engine capable of producing maximum power of 60bhp. The phenomenal fuel efficiency is one of the USPs of this car.

Styling

Cervo is build to attract the young generation and so the styling has been done keeping in mind just that. Arching roofline, sporty headlamps and fog lamps placed right next to the large grille makes the car look appealing.

The high mounted tail lamps also lend it a peppy look. However, the disadvantage is that the rear seat of Cervo is sufficient only for two passengers and the luggage box has space to carry daily shopping bags only.

What Cervo stands for?

Cervo is all about affordability, efficient engine and an economical price tag. Its sleek looks are just an add-on to attract the right segment of the consumer.

Down Load Wallpaper

2010-01-20T05:22:00.000-08:00

download

Digital Mesh MachineTest

2010-01-20T05:05:00.000-08:00

download

source

What is the meaning and origin of `Comstockery'?

2010-01-19T21:05:00.003-08:00

Anthony Comstock was the U.S Postal Inspector in the late 19th century. He was a firm believer in the principles of Victorian morality. In 1875, he succeeded in getting the `Comstock Law' passed by Congress. This law made it illegal for people to send obscene materials through post. Anyone sending or receiving such material through mail was promptly put in prison. Comstock's definition of obscene material included pamphlets related to birth control, and medical books on human anatomy. These things were banned as well. According to some scholars, it was this ridiculous censorship which made George Bernard Shaw coin the word `Comstockery' to mean, `censorship because of perceived obscenity or immorality'. The Irish dramatist said, "Comstockery is the world's standing joke at the expense of the United States." This angered Comstock, and he called Shaw, "the Irish smut dealer".

Can the word `guys' be used to refer to a group of girls?

2010-01-19T21:05:00.001-08:00

Yes, it can. When used in the singular, the word always refers to a man. One can never say, `She is a nice guy'. It is always, `He is a nice guy'. The word `guys' can be used to refer to a group of people. The people in question could be a group of boys, a group of girls, or a group consisting of boys and girls.

*Come on you guys. Let's think of something interesting to do.

What is the meaning of `derring-do'?

2010-01-19T21:04:00.003-08:00

This is a word which is seldom heard nowadays. Some dictionaries list it as being old fashioned. It means daring, displaying courage against overwhelming odds. The term is mostly used to refer to the daring actions which heroes perform in stories. The main stress is on `do'. *The title suggested it would be a tale of derring-do. It turned out to be a soppy love story.

As children, when we misspelt a word, our teachers circled it, and made us rewrite it several times. Hoping that we would learn the correct spelling! When printers make an error in spelling, it sometimes results in the creation of a new word. Derring-do is one such example. The original expression as used by Chaucer was `dorrying don' meaning `daring to do'. Through a series of copying and printing errors, it became `derring-do'.

How is the word `dereliction' pronounced?

2010-01-19T21:04:00.001-08:00

The `e' in the first syllable is like the `e' in `set', `bet', and `get', and the `e' in the second is like the `a' in `china'. The final two syllables rhyme with the words `fiction' and `diction'. The word is pronounced 'de-re-LICK-shen' with the stress on the third syllable. In some contexts, `dereliction' can be used to mean `failure'; failure to do one's duty. When you accuse someone of `dereliction of duty', you are implying that the individual deliberately chose not to do his work. It is a case of wilful negligence.

*The students are taking the Principal to court for dereliction of duty.

*What you and your friends did was a grave dereliction of duty.

The word can also be used to mean `in bad condition'; it is normally used in reference to abandoned buildings.

*The old hotel was in a state of dereliction. The new owner wanted to renovate it.

******

"Half the lies they tell about me aren't true." - Yogi Berra

How is the word ‘subterfuge’ pronounced?

2010-01-19T21:03:00.001-08:00

The first syllable rhymes with the words ‘cub’, ‘tub’, and ‘hub’. The following ‘er’ sounds like the ‘a’ in ‘china’, and the final syllable rhymes with the word ‘huge’. The word is pronounced ‘SUB-te-fyuuj’ with the stress on the first syllable.

When you trick someone or employ dishonest means in order to achieve your goal, you are making use of subterfuge. Very often, the deception is employed to hide one’s real intentions. The word literally means ‘escape secretly’; it comes from the Latin ‘subter’ meaning ‘secretly’ and ‘fugere’ meaning ‘to flee’.

I don’t care how you get the information. Obtain it by subterfuge if you have to.

Everyone knew the minister wasn’t sick at all. It was only a subterfuge.

Is it okay to say ‘prepare the vegetables’?

2010-01-19T21:02:00.000-08:00

I understand this is an expression commonly found in recipe books. When you ask someone to prepare the vegetables, what you would like the person to do is to wash them, clean them, peel them, and cut them. In other words, the person ensures that the vegetables are ready to be used.

Maya, you’ll have to prepare the potatoes. I want you to peel them and then cut them into thin slices.

* * *

“Every generation imagines itself to be more intelligent than the one that went before it, and wiser than the one that comes after it.” — George Orwell

‘soliloquy’ and a ‘monologue’?

2010-01-19T21:01:00.000-08:00

Meaning of daymare?

2010-01-19T21:00:00.000-08:00

The word daymare has been in use for several hundred years now; the well-known author, Charles Dickens, used ‘daymare’ in his novel ‘David Copperfield’. A ‘daymare’ is like a nightmare except that it takes place during the day time. The anxiety attacks that we sometimes have when we are wide awake can be called ‘daymares’. The pressure that we feel on the chest when we have a nightmare is usually present during a daymare as well.

*She has a daymare every day around noon.

What is the meaning of ‘mollycoddle’?

2010-01-19T20:58:00.000-08:00

The expression can be used both as a noun and a verb. When you ‘coddle’ someone, you go out of your way to protect the person; you are being overly protective. ‘Molly’, I understand, was traditionally a nickname for ‘Mary’. The expression ‘mollycoddle’ is often used contemptuously to refer to a man whom you think is rather weak and ineffectual; the individual, in your opinion, is effeminate. When used as a verb, it means to overprotect or pamper someone.

*The new principal believes that students should be mollycoddled.

How is the word ‘masquerade’ pronounced?

2010-01-19T20:57:00.001-08:00

The first syllable is pronounced like the word ‘mask’, and the ‘ue’ in the second syllable is like the ‘a’ in ‘china’. The final syllable sounds like the word ‘raid’. The word is pronounced ‘mask-e-RAID’ with the stress on the final syllable. Some people drop the vowel in the second syllable, and pronounce the word ‘mask-RAID’.

The word comes from the Italian ‘mascarata’ meaning ‘a ball at which masks are worn’. People generally wear a mask when they wish to hide their identity. When you masquerade as being someone else, you are pretending to be someone that you are not.

*Terrorists masquerading as policemen managed to enter the Minister’s house.

The word can also be used to mean ‘to put on a show’ or to cover up; you act in a way which prevents others from knowing the truth about something unpleasant.

*For the sake of her parents, Gayathri kept up a masquerade of being happily married.

Puzzles To Puzzle You! - By Shakuntala Devi

2010-01-11T06:32:00.000-08:00

Free Download

Orion final round interview Def you should read this.

20 Excellent AJAX Effects You Should Know

2010-01-08T04:04:00.000-08:00

http://net.tutsplus.com/articles/web-roundups/20-more-excellent-ajax-effects-you-should-know/

10 Essential SQL Tips for Developers

2010-01-08T03:29:00.000-08:00

1. Use The Right Language
2. Secure Your Code
3. Understand Joins
4. Know Your Data Types
5. Write Compliant Code
6. Normalize Your Data
7. Fully Qualify Your Database Object Names
8. Understand Indexing
9. Properly Use Database Permissions
10. Know Your DBMS Limitations

http://net.tutsplus.com/tutorials/other/10-essential-sql-tips-for-developers/

top-15-best-practices-for-writing-super-readable-code

2010-01-08T02:42:00.001-08:00

http://net.tutsplus.com/tutorials/html-css-techniques/top-15-best-practices-for-writing-super-readable-code/

35-css-based-layouts-that-look-awesome

2010-01-08T02:37:00.000-08:00

http://net.tutsplus.com/articles/web-roundups/35-css-based-layouts-that-look-awesome/

Design_Patterns_Interview_Questions

2010-01-05T04:23:00.000-08:00

A common scenario might look like this, a user sends a request to a server. The request is
handled by a Servlet (the controller) which will initialize any JavaBeans (the model) required
to fulfill the user's request. The Servlet (the controller) will then forward the request, which
contains the JavaBeans (the model), to a JSP (the view) page which contains only HTML and
JSTL syntax. The JSTL will format the data into a human readable format before being sent
back to the user. Thus completing the full MVC process.
JSTL also has a tag library for XML processing, this could be used in an MVC environment as
you could replace the JavaBeans with an XML document to describe your data, so long as
the XML is still constructed in a controller such as a Servlet before being passed to the JSP
(the view).
JSTL also has a tag library for database access, using this in your JSP (the view) pages
would NOT comply to the MVC pattern as there will be no separation between the model and
the view.

ASP.NET interview questions

2010-01-04T22:46:00.000-08:00

ASP.NET Interview Questions
This is a list of questions I have gathered and created over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.
There are some questions in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them here for easy access.
1. Describe the role of inetinfo.exe, aspnet_isapi.dll andaspnet_wp.exe in the page loading process.
inetinfo.exe is theMicrosoft IIS server running, handling ASP.NET requests among other things.When an ASP.NET request is received (usually a file with .aspx extension), the ISAPI filter aspnet_isapi.dll takes care of it by passing the request tothe actual worker process aspnet_wp.exe.

2. What’s the difference between Response.Write() andResponse.Output.Write()?
Response.Output.Write() allows you to write formatted output.

3. What methods are fired during the page load?
Init() - when the page is instantiated
Load() - when the page is loaded into server memory
PreRender() - the brief moment before the page is displayed to the user as HTML
Unload() - when page finishes loading.

4. When during the page processing cycle is ViewState available?
After the Init() and before the Page_Load(), or OnLoad() for a control.

5. What namespace does the Web page belong in the .NET Framework class hierarchy?
System.Web.UI.Page

6. Where do you store the information about the user’s locale?
System.Web.UI.Page.Culture

7. What’s the difference between Codebehind="MyCode.aspx.cs" andSrc="MyCode.aspx.cs"?
CodeBehind is relevant to Visual Studio.NET only.

8. What’s a bubbled event?
When you have a complex control, like DataGrid, writing an event processing routine for each object (cell, button, row, etc.) is quite tedious. The controls can bubble up their eventhandlers, allowing the main DataGrid event handler to take care of its constituents.

9. Suppose you want a certain ASP.NET function executed on MouseOver for a certain button. Where do you add an event handler?
Add an OnMouseOver attribute to the button. Example: btnSubmit.Attributes.Add("onmouseover","someClientCodeHere();");

10. What data types do the RangeValidator control support?
Integer, String, and Date.

11. Explain the differences between Server-side and Client-side code?
Server-side code executes on the server. Client-side code executes in the client's browser.

12. What type of code (server or client) is found in a Code-Behind class?
The answer is server-side code since code-behind is executed on the server. However, during the code-behind's execution on the server, it can render client-side code such as JavaScript to be processed in the clients browser. But just to be clear, code-behind executes on the server, thus making it server-side code.

13. Should user input data validation occur server-side or client-side? Why?
All user input data validation should occur on the server at a minimum. Additionally, client-side validation can be performed where deemed appropriate and feasable to provide a richer, more responsive experience for the user.

14. What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
Server.Transfer transfers page processing from one page directly to the next page without making a round-trip back to the client's browser. This provides a faster response with a little less overhead on the server. Server.Transfer does not update the clients url history list or current url. Response.Redirect is used to redirect the user's browser to another page or site. This performas a trip back to the client where the client's browser is redirected to the new page. The user's browser history list is updated to reflect the new address.

15. Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
Valid answers are:
• A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.
• A DataSet is designed to work without any continuing connection to the original data source.
• Data in a DataSet is bulk-loaded, rather than being loaded on demand.
• There's no concept of cursor types in a DataSet.
• DataSets have no current record pointer You can use For Each loops to move through the data.
• You can store many edits in a DataSet, and write them to the original data source in a single operation.
• Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.

16. What is the Global.asax used for?
The Global.asax (including the Global.asax.cs file) is used to implement application and session level events.

17. What are the Application_Start and Session_Start subroutines used for?
This is where you can set the specific variables for the Application and Session objects.

18. Can you explain what inheritance is and an example of when you might use it?
When you want to inherit (use the functionality of) another class. Example: With a base class named Employee, a Manager class could be derived from the Employee base class.

19. Whats an assembly?
Assemblies are the building blocks of the .NET framework. Overview of assemblies from MSDN

20. Describe the difference between inline and code behind.
Inline code written along side the html in a page. Code-behind is code written in a separate file and referenced by the .aspx page.

21. Explain what a diffgram is, and a good use for one?
The DiffGram is one of the two XML formats that you can use to render DataSet object contents to XML. A good use is reading database data to an XML file to be sent to a Web Service.

22. Whats MSIL, and why should my developers need an appreciation of it if at all?
MSIL is the Microsoft Intermediate Language. All .NET compatible languages will get converted to MSIL. MSIL also allows the .NET Framework to JIT compile the assembly on the installed computer.

23. Which method do you invoke on the DataAdapter control to load your generated dataset with data?
The Fill() method.

24. Can you edit data in the Repeater control?
No, it just reads the information from its data source.

25. Which template must you provide, in order to display data in a Repeater control?
ItemTemplate.

26. How can you provide an alternating color scheme in a Repeater control?
Use the AlternatingItemTemplate.

27. What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?
You must set the DataSource property and call the DataBind method.

28. What base class do all Web Forms inherit from?
The Page class.

29. Name two properties common in every validation control?
ControlToValidate property and Text property.

30. Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
DataTextField property.

31. Which control would you use if you needed to make sure the values in two different controls matched?
CompareValidator control.

32. How many classes can a single .NET DLL contain?
It can contain many classes.

Web Service Questions
1. What is the transport protocol you use to call a Web service?
SOAP (Simple Object Access Protocol) is the preferred protocol.

2. True or False: A Web service can only be written in .NET?
False

3. What does WSDL stand for?
Web Services Description Language.

4. Where on the Internet would you look for Web services?
http://www.uddi.org

5. True or False: To test a Web service you must create a Windows application or Web application to consume this service?
False, the web service comes with a test page and it provides HTTP-GET method to test.

State Management Questions
1. What is ViewState?
ViewState allows the state of objects (serializable) to be stored in a hidden field on the page. ViewState is transported to the client and back to the server, and is not stored on the server or any other external source. ViewState is used the retain the state of server-side objects between postabacks.

2. What is the lifespan for items stored in ViewState?
Item stored in ViewState exist for the life of the current page. This includes postbacks (to the same page).

3. What does the "EnableViewState" property do? Why would I want it on or off?
It allows the page to save the users input on a form across postbacks. It saves the server-side values for a given control into ViewState, which is stored as a hidden value on the page before sending the page to the clients browser. When the page is posted back to the server the server control is recreated with the state stored in viewstate.

4. What are the different types of Session state management options available with ASP.NET?
ASP.NET provides In-Process and Out-of-Process state management. In-Process stores the session in memory on the web server. This requires the a "sticky-server" (or no load-balancing) so that the user is always reconnected to the same web server. Out-of-Process Session state management stores data in an external data source. The external data source may be either a SQL Server or a State Server service. Out-of-Process state management requires that all objects stored in session are serializable.

Covering letter Sample

2010-01-04T06:31:00.002-08:00

Dear HR Manager,

With reference to your advertisement in website I am applying for the position of Senior Software Engineer[Module Lead].I believe that my interests and credentials will match with your requirement. I have completed my Masters degree [MCA] from Bharathidasan University in Information Technology .

I am working with MNC from the last two years as a Senior Software Engineer [Module Lead]. Throughout my career I have acquired a very good knowledge of Web technologies (.Net,SQLServer,Ajax,C#,Javascript,IIS). My responsibility includes providing back end support for the distributed applications and guiding assosiates through their jobs.

I am enjoying my present job, but still I am looking out for new opportunities in the same field.
Enclosure Resume.

Thanks & Regards.

Sincerely,

Your Name
email|Contact Number Mobile |LandLine

75 Ways to Improve Your C# and VB.NET

2010-01-04T06:31:00.001-08:00

.NET Gotchas 75 Ways to Improve Your C# and VB.NET Programs By Venkat Subramaniam

C# Interview Questions

2010-01-04T06:29:00.000-08:00

C# Interview Questions
This is a list of questions I have gathered from other sources and created myself over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.
There are some question in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them easy access.
General Questions
1. Does C# support multiple-inheritance?
No.

2. Who is a protected class-level variable available to?
It is available to any sub-class (a class inheriting this class).

3. Are private class-level variables inherited?
Yes, but they are not accessible. Although they are not visible or accessible via the class interface, they are inherited.

4. Describe the accessibility modifier “protected internal”.
It is available to classes that are within the same assembly and derived from the specified base class.

5. What’s the top .NET class that everything is derived from?
System.Object.

6. What does the term immutable mean?
The data value may not be changed. Note: The variable value may be changed, but the original immutable data value was discarded and a new data value was created in memory.

7. What’s the difference between System.String and System.Text.StringBuilder classes?
System.String is immutable. System.StringBuilder was designed with the purpose of having a mutable string where a variety of operations can be performed.

8. What’s the advantage of using System.Text.StringBuilder over System.String?
StringBuilder is more efficient in cases where there is a large amount of string manipulation. Strings are immutable, so each time a string is changed, a new instance in memory is created.

9. Can you store multiple data types in System.Array?
No.

10. What’s the difference between the System.Array.CopyTo() and System.Array.Clone()?
The Clone() method returns a new array (a shallow copy) object containing all the elements in the original array. The CopyTo() method copies the elements into another existing array. Both perform a shallow copy. A shallow copy means the contents (each array element) contains references to the same object as the elements in the original array. A deep copy (which neither of these methods performs) would create a new instance of each element's object, resulting in a different, yet identacle object.

11. How can you sort the elements of the array in descending order?
By calling Sort() and then Reverse() methods.

12. What’s the .NET collection class that allows an element to be accessed using a unique key?
HashTable.

13. What class is underneath the SortedList class?
A sorted HashTable.

14. Will the finally block get executed if an exception has not occurred?¬
Yes.

15. What’s the C# syntax to catch any possible exception?
A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

16. Can multiple catch blocks be executed for a single try statement?
No. Once the proper catch block processed, control is transferred to the finally block (if there are any).

17. Explain the three services model commonly know as a three-tier application.
Presentation (UI), Business (logic and underlying code) and Data (from storage or other sources).

Class Questions
1. What is the syntax to inherit from a class in C#?
Place a colon and then the name of the base class.
Example: class MyNewClass : MyBaseClass

2. Can you prevent your class from being inherited by another class?
Yes. The keyword “sealed” will prevent the class from being inherited.

3. Can you allow a class to be inherited, but prevent the method from being over-ridden?
Yes. Just leave the class public and make the method sealed.

4. What’s an abstract class?
A class that cannot be instantiated. An abstract class is a class that must be inherited and have the methods overridden. An abstract class is essentially a blueprint for a class without any implementation.

5. When do you absolutely have to declare a class as abstract?
1. When the class itself is inherited from an abstract class, but not all base abstract methods have been overridden.
2. When at least one of the methods in the class is abstract.

6. What is an interface class?
Interfaces, like classes, define a set of properties, methods, and events. But unlike classes, interfaces do not provide implementation. They are implemented by classes, and defined as separate entities from classes.

7. Why can’t you specify the accessibility modifier for methods inside the interface?
They all must be public, and are therefore public by default.

8. Can you inherit multiple interfaces?
Yes. .NET does support multiple interfaces.

9. What happens if you inherit multiple interfaces and they have conflicting method names?
It’s up to you to implement the method inside your own class, so implementation is left entirely up to you. This might cause a problem on a higher-level scale if similarly named methods from different interfaces expect different data, but as far as compiler cares you’re okay.
To Do: Investigate

10. What’s the difference between an interface and abstract class?
In an interface class, all methods are abstract - there is no implementation. In an abstract class some methods can be concrete. In an interface class, no accessibility modifiers are allowed. An abstract class may have accessibility modifiers.

11. What is the difference between a Struct and a Class?
Structs are value-type variables and are thus saved on the stack, additional overhead but faster retrieval. Another difference is that structs cannot inherit.

Method and Property Questions
1. What’s the implicit name of the parameter that gets passed into the set method/property of a class?
Value. The data type of the value parameter is defined by whatever data type the property is declared as.

2. What does the keyword “virtual” declare for a method or property?
The method or property can be overridden.

3. How is method overriding different from method overloading?
When overriding a method, you change the behavior of the method for the derived class. Overloading a method simply involves having another method with the same name within the class.

4. Can you declare an override method to be static if the original method is not static?
No. The signature of the virtual method must remain the same. (Note: Only the keyword virtual is changed to keyword override)

5. What are the different ways a method can be overloaded?
Different parameter data types, different number of parameters, different order of parameters.

6. If a base class has a number of overloaded constructors, and an inheriting class has a number of overloaded constructors; can you enforce a call from an inherited constructor to a specific base constructor?
Yes, just place a colon, and then keyword base (parameter list to invoke the appropriate constructor) in the overloaded constructor definition inside the inherited class.

Events and Delegates
1. What’s a delegate?
A delegate object encapsulates a reference to a method.

2. What’s a multicast delegate?
A delegate that has multiple handlers assigned to it. Each assigned handler (method) is called.

XML Documentation Questions
1. Is XML case-sensitive?
Yes.

2. What’s the difference between // comments, /* */ comments and /// comments?
Single-line comments, multi-line comments, and XML documentation comments.

3. How do you generate documentation from the C# file commented properly with a command-line compiler?
Compile it with the /doc switch.

Debugging and Testing Questions
1. What debugging tools come with the .NET SDK?
1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch.
2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.

2. What does assert() method do?
In debug compilation, assert takes in a Boolean condition as a parameter, and shows the error dialog if the condition is false. The program proceeds without any interruption if the condition is true.

3. What’s the difference between the Debug class and Trace class?
Documentation looks the same. Use Debug class for debug builds, use Trace class for both debug and release builds.

4. Why are there five tracing levels in System.Diagnostics.TraceSwitcher?
The tracing dumps can be quite verbose. For applications that are constantly running you run the risk of overloading the machine and the hard drive. Five levels range from None to Verbose, allowing you to fine-tune the tracing activities.

5. Where is the output of TextWriterTraceListener redirected?
To the Console or a text file depending on the parameter passed to the constructor.

6. How do you debug an ASP.NET Web application?
Attach the aspnet_wp.exe process to the DbgClr debugger.

7. What are three test cases you should go through in unit testing?
1. Positive test cases (correct data, correct output).
2. Negative test cases (broken or missing data, proper handling).
3. Exception test cases (exceptions are thrown and caught properly).

8. Can you change the value of a variable while debugging a C# application?
Yes. If you are debugging via Visual Studio.NET, just go to Immediate window.

ADO.NET and Database Questions
1. What is the role of the DataReader class in ADO.NET connections?
It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed.

2. What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?
SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET.

3. What is the wildcard character in SQL?
Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’.

4. Explain ACID rule of thumb for transactions.
A transaction must be:
1. Atomic - it is one unit of work and does not dependent on previous and following transactions.
2. Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t.
3. Isolated - no transaction sees the intermediate results of the current transaction).
4. Durable - the values persist if the data had been committed even if the system crashes right after.

5. What connections does Microsoft SQL Server support?
Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

6. Between Windows Authentication and SQL Server Authentication, which one is trusted and which one is untrusted?
Windows Authentication is trusted because the username and password are checked with the Active Directory, the SQL Server authentication is untrusted, since SQL Server is the only verifier participating in the transaction.

7. What does the Initial Catalog parameter define in the connection string?
The database name to connect to.

8. What does the Dispose method do with the connection object?
Deletes it from the memory.
To Do: answer better. The current answer is not entirely correct.

9. What is a pre-requisite for connection pooling?
Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings. The connection string must be identical.

Assembly Questions
1. How is the DLL Hell problem solved in .NET?
Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.

2. What are the ways to deploy an assembly?
An MSI installer, a CAB archive, and XCOPY command.

3. What is a satellite assembly?
When you write a multilingual or multi-cultural application in .NET, and want to distribute the core application separately from the localized modules, the localized assemblies that modify the core application are called satellite assemblies.

4. What namespaces are necessary to create a localized application?
System.Globalization and System.Resources.

5. What is the smallest unit of execution in .NET?
an Assembly.

6. When should you call the garbage collector in .NET?
As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice.

7. How do you convert a value-type to a reference-type?
Use Boxing.

8. What happens in memory when you Box and Unbox a value-type?
Boxing converts a value-type to a reference-type, thus storing the object on the heap. Unboxing converts a reference-type to a value-type, thus storing the value on the stack.

Function_Point_Training PDF

2009-12-31T01:55:00.000-08:00

Function_Point_Tutorials PDF

Download

26 pager styles from around the web (css, images and html)

2009-12-29T03:09:00.000-08:00

http://blog.webdistortion.com/2008/10/27/26-pager-styles-from-around-the-web-css-images-and-html/

http://woork.blogspot.com/2008/03/perfect-pagination-style-using-css.html

table variables

2009-12-16T06:37:00.000-08:00

DECLARE @ProductTotals TABLE

(

ProductID int,

Description nvarchar(200)

)

ExtensionMethods

2009-12-16T01:10:00.001-08:00

class ExtensionMethods2
{

static void Main()
{
int[] ints = { 10, 45, 15, 39, 21, 26 };
var result = ints.OrderBy(g => g);
foreach (var i in result)
{
System.Console.Write(i + " ");
}
}
}
//Output: 10 15 21 26 39 45
namespace ExtensionMethods
{
public static class MyExtensions
{
public static int WordCount(this String str)
{
return str.Split(new char[] { ' ', '.', '?' }, StringSplitOptions.RemoveEmptyEntries).Length;
}
}
}
http://msdn.microsoft.com/en-us/library/bb383977.aspx

lambda expression csharp

2009-12-15T22:45:00.000-08:00

You can use anonymous methods to achieve the same thing in C# 2.0. C# 3.0 introduces an even simpler syntax, lambda expressions, which you write as a parameter list followed by the "=>" token, followed by an expression or a statement block.

Parameters to Lambda Expressions
The parameters of a lambda expression can be explicitly or implicitly typed. In an explicitly typed parameter list, the type of each expression is explicitly specified. In an implicitly typed parameter list, the types are inferred from the context in which the lambda expression occurs:

(int x) => x + 1 // explicitly typed parameter
(y,z) => return y * z; // implicitly typed parameter
Dictionary varClothes= new Dictionary();
varClothes.Add("Jeans", 20);
varClothes.Add("Shirts", 15);
varClothes.Add("Pajamas", 9);
varClothes.Add("Shoes", 9);
var ClothesListShortage = varClothes.FilterBy((string name,
int count) => name == "Shoes" && count < 10);
// example of multiple parameters
if(ClothesListShortage.Count > 0)

Read

Table Variables In T-SQL

2009-12-15T22:11:00.000-08:00

Microsoft introduced table variables with SQL Server 2000 as an alternative to using temporary tables. In many cases a table variable can outperform a solution using a temporary table, although we will need to review the strengths and weaknesses of each in this article.

Table variables store a set of records, so naturally the declaration syntax looks very similar to a CREATE TABLE statement, as you can see in the following example:

DECLARE @ProductTotals TABLE

(

ProductID int,

Description nvarchar(200)

)

insert into @ProductTotals select productId,Description from Products

select * from @ProductTotals

Read

DataList_Pagination_Sample

2009-12-15T01:00:00.000-08:00

Read

http://www.c-sharpcorner.com/UploadFile/rizwan328/DataListCustomPaging01112009021450AM/DataListCustomPaging.aspx

How to do add a custom paging Datalist And Repeater

2009-12-14T05:01:00.000-08:00

Repeater

DataList 1

DataList 2

jQuery-for-absolute-beginners-video-series

2009-12-09T03:44:00.000-08:00

Read

24 JavaScript Best Practices for Beginners

2009-12-09T02:43:00.000-08:00

24 JavaScript Best Practices for Beginners

Design and Code Your First Website in Easy Steps

2009-12-09T02:40:00.000-08:00

Read

Get vs Post

2009-12-09T02:15:00.000-08:00

In HTML, one can specify two different submission methods for a form. The method is specified inside a FORM element, using the METHOD attribute. The difference between METHOD="GET" (the default) and METHOD="POST" is primarily defined in terms of form data encoding. According to the technical HTML specifications GET means that form data is to be encoded (by a browser) into a URL while POST means that the form data is to appear within the message body of the HTTP request.

Differences in form submission

The fundamental difference between METHOD="GET" and METHOD="POST" is that they correspond to different HTTP requests, as defined in the HTTP specifications. The submission process for both methods begins in the same way - a form data set is constructed by the browser and then encoded in a manner specified by the enctype attribute. For METHOD="POST the enctype attribute can be multipart/form-data or application/x-www-form-urlencoded, whereas for METHOD="GET", only application/x-www-form-urlencoded is allowed. This form data set is then transmitted to the server.

For form submission with METHOD="GET", the browser constructs a URL by taking the value of the action attribute, appending a ? to it, then appending the form data set (encoded using the application/x-www-form-urlencoded content type). The browser then processes this URL as if following a link (or as if the user had typed the URL directly). The browser divides the URL into parts and recognizes a host, then sends to that host a GET request with the rest of the URL as argument. The server takes it from there. Note that this process means that the form data are restricted to ASCII codes. Special care should be taken to encode and decode other types of characters when passing them through the URL in ASCII format.

Submission of a form with METHOD="POST" causes a POST request to be sent, using the value of the action attribute and a message created according to the content type specified by the enctype attribute.
Pros and Cons

Since form data is sent as part of the URL when GET is used --

Form data are restricted to ASCII codes. Special care should be taken to encode and decode other types of characters when passing them through the URL in ASCII format. On the other hand, binary data, images and other files can all be submitted through METHOD="POST"
All form data filled in is visible in the URL. Moreover, it is also stored in the user's web browsing history/logs for the browser. These issues make GET less secure.
However, one advantage of form data being sent as part of the URL is that one can bookmark the URLs and directly use them and completely bypass the form-filling process.
There is a limitation on how much form data can be sent because URL lengths are limited.

Get_vs_Post

22 Neat Code Editors for Windows

2009-12-08T06:42:00.000-08:00

Read

10+ Reasons Why you Should Definitely Upgrade to Windows 7

2009-12-08T06:41:00.001-08:00

http://net.tutsplus.com/articles/web-roundups/10-reasons-why-you-should-upgrade-to-windows-7/

The Ultimate Guide to Creating a Design and Converting it to HTML and CSS

2009-12-08T06:40:00.000-08:00

Read

8-regular-expressions-you-should-know

2009-12-08T06:34:00.000-08:00

This is what Wikipedia has to say about them:

In computing, regular expressions provide a concise and flexible means for identifying strings of text of interest, such as particular characters, words, or patterns of characters. Regular expressions (abbreviated as regex or regexp, with plural forms regexes, regexps, or regexen) are written in a formal language that can be interpreted by a regular expression processor, a program that either serves as a parser generator or examines text and identifies parts that match the provided specification.

Matching a Username

Matching a Password

Matching a Hex Value

Matching a Slug

Matching an Email

Matching a URL

Matching an IP Address

Matching an HTML Tag

READ

Regular Expressions for Dummies: Screencast Series

2009-12-08T06:29:00.002-08:00

Screencasts

Lesson 1: Introduction
Lesson 2: Matching
Lesson 3: Validating Email Addresses
Lesson 4: Javascript and "Replace"
Lesson 5: Preg_match_all, and Scraping Data

You Don’t Know Anything About Regular Expressions: A Complete Guide

. - Matches any character, except for line breaks if dotall is false.
* - Matches 0 or more of the preceding character.
+ - Matches 1 or more of the preceding character.
? - Preceding character is optional. Matches 0 or 1 occurrence.
\d - Matches any single digit
\w - Matches any word character (alphanumeric & underscore).
[XYZ] - Matches any single character from the character class.
[XYZ]+ - Matches one or more of any of the characters in the set.
$ - Matches the end of the string.
^ - Matches the beginning of a string.
[^a-z] - When inside of a character class, the ^ means NOT; in this case, match anything that is NOT a lowercase letter.

Regular Expressions Cheat Sheets

11 Classic CSS Techniques Made Simple with CSS3

2009-12-08T06:26:00.000-08:00

11-classic-css-techniques-made-simple-with-css3

5 Super Helpful Web Development Video Quick Tips

HTML 5 and CSS 3: The Techniques You’ll Soon Be Using

2009-12-08T06:16:00.001-08:00

Live Action

Read

Page title

Page title

The Basics of Object-Oriented JavaScript,CSS

2009-12-08T06:11:00.000-08:00

READ

Object-Oriented CSS: What, How, and Why

5 Ways to Instantly Write Better CSS

2009-12-08T06:08:00.000-08:00

READ

30 CSS Best Practices for Beginners – Basix

9 Most Common IE Bugs and How to Fix Them

2009-12-08T06:06:00.001-08:00

READ

20 Email Design Best Practices and Resources for Beginners

2009-12-08T06:00:00.000-08:00

READ

1: Keep the Design Simple
2: Use Tables
3: Have Web Browsers at the Ready
4: Sign Up for all the Major Email Clients
5: Use Inline Styles
6: Give all Images Alt Tags
7: Do not Set Widths or Heights to Images

8: Wrap the Email in a 100% Width Table

9: No Wider than 600px
Many people don't actually open their email; they instead view them in the preview panel. On average the smallest preview panel is around 600px, so always design your emails accordingly, unless you don't want your full email viewable in the preview panel, of course.

10: Link Styling

11: Try not to Nest Tables
12: Avoid Background Images

13: Borders don't Work

14: Hotmail Bug Fixes

15: Encode All Characters
16: JavaScript = Junk Email

17: Give the User a Way Out

18: Users Want Options

19: Use a spacer.gif

20: Send Tests

Other Helpful Resources
General Email Marketing info:
http://www.shayhowe.com/resource/smart-email-marketing/
http://www.webdesignerdepot.com/2009/11/a-guide-to-creating-email-newsletters/
http://www.smartbiz.com/article/articleview/2073/1/53/
http://www.smartbiz.com/article/view/2076/1/53
http://www.kamikazemusic.com/quick-tips/basics-html-email-newsletters/
http://www.mailchimp.com/articles/email_marketing_subject_line_comparison/
http://lyrishq.lyris.com/index.php/Email-Marketing/Email-Subject-Lines-15-Rules-to-Write-Them-Right.html
http://net.tutsplus.com/misc/6-easy-ways-to-improve-your-html-emails/
http://www.copyblogger.com/persuasive-writing/
Email Inspiration:
Campaign Monitor Gallery
Beautiful Email Newsletters
HTML Email Gallery
Services
Mail Chimp
Campaign Monitor
Emma Email Marketing
AWeber
Interspace SendStudio
Feel Breeze
Email Design Tools
LitmusApp
Preview My Email
Premium Email Templates
ThemeForest Email Templates

20 Excellent AJAX Effects You Should Know

2009-12-08T05:55:00.000-08:00

Read

1. TextboxList meets Autocompletion
2.Ajax IM
3. LiveValidation
4. Inline Editing
5. Ajax Upload
6. Fancy Upload
7. ClickHeat Clicks Heatmap
8. Ajax Mail Form
9. Ajax Directory Manager
10. Ajax Email Client
11. Improve Form Usability with Auto Messages
12. qGallery
13. Ajax Star Rating
14. CakePHP Ajax Form
15. Amberjack Site Tours
16. Prototype UI
17. JCrop
18. jQuery Auto-tabbing Plugin
19. Sort Table Rows with Ajax
20. DrasticMap

The two most challenging aspects of learning anything .NET

2009-12-08T05:46:00.000-08:00

1. Getting familiar with with the classes in the Framework Class Library.
2. Learning and getting comfortable with object oriented programming (if you don’t have any OOP experience).

I can only speak from my experience, but the only problem I had in switching to ASP.NET with C# from PHP was finding decent online resources (I switched in 2003). That’s not much of a problem these days.

The first part of this series covered some of the advantages. It’s by no means an exhaustive list. Something I didn’t put into that list is flexibility. One thing I hate about PHP is being completely dependent on the PHP installation in a shared-hosting environment. Unless you have a very generous host, you’re out of luck if you want to use extensions or third party components that require you to recompile PHP.

With ASP.NET, using extensions or third party components is typically completely in your control. You simply add a reference to the components/extensions in your project, upload the DLLs, and you’re ready to roll. There are some exceptions to this; nothing requires a recompilation of .NET on the server, but some components do have to be installed on the web server in order to work correctly. MySQL’s Net Connector is one such component that has to be installed in order to take advantage of all the features.

ASP.NET from Scratch With Video Tutorials

2009-12-08T05:41:00.000-08:00

Lesson 1

Lesson 2

What are HTTP Headers?

2009-12-08T05:39:00.001-08:00

HTTP stands for "Hypertext Transfer Protocol". The entire World Wide Web uses this protocol. It was established in the early 1990's. Almost everything you see in your browser is transmitted to your computer over HTTP. For example, when you opened this article page, your browser probably have sent over 40 HTTP requests and received HTTP responses for each.

HTTP headers are the core part of these HTTP requests and responses, and they carry information about the client browser, the requested page, the server and more.

Read More

Using the Google AJAX Search API: JSON serialisation with .NET

2009-12-08T05:33:00.000-08:00

Read

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

2009-12-08T03:33:00.000-08:00

An ASP.NET setting has been detected that does not apply in Integrated managed pipeline mode

Reason :

This could be a problem with IIS, have you upgraded recently? Usually this error gives you more details than that with some instructions of what to do. This error is thrown by ValidateConfigurationModule when it detects that system.webServer/validation@validateIntegratedModeConfiguration is true and there is some configuration in httpHandlers or httpModules section which is not picked in integratedMode or system.web/identity@impersonate is set to true which is also not effective in integratedMode. You can follow the suggestions in the error message to migrate the configuration so that your managed modules/handlers work in integrated and classic mode both.

To resolve this issue by writing this code in web.config file. hope this will help you

the code is as:

James Camaron's AVATHAR

2009-12-07T22:49:00.000-08:00

190 million $ PRoject From James Camaron

Read More

Dynamic Paging For DataList Control with PagedDataSource

2009-12-07T05:46:00.000-08:00

Dynamic Paging For DataList Control with PagedDataSource

Abstract Class Vs Interface

2009-12-07T01:59:00.000-08:00

What is an Abstract class?

An abstract class is a special kind of class that cannot be instantiated. So the question is why we need a class that cannot be instantiated? An abstract class is only to be sub-classed (inherited from). In other words, it only allows other classes to inherit from it but cannot be instantiated. The advantage is that it enforces certain hierarchies for all the subclasses. In simple words, it is a kind of contract that forces all the subclasses to carry on the same hierarchies or standards.

An interface is not a class. It is an entity that is defined by the word Interface. An interface has no implementation; it only has the signature or in other words, just the definition of the methods without the body. As one of the similarities to Abstract class, it is a contract that is used to define hierarchies for all subclasses or it defines specific set of methods and their arguments. The main difference between them is that a class can implement more than one interface but can only inherit from one abstract class. Since C# doesn’t support multiple inheritance, interfaces are used to implement multiple inheritance.

Both together

When we create an interface, we are basically creating a set of methods without any implementation that must be overridden by the implemented classes. The advantage is that it provides a way for a class to be a part of two classes: one inheritance hierarchy and one from the interface.
When we create an abstract class, we are creating a base class that might have one or more completed methods but at least one or more methods are left uncompleted and declared abstract. If all the methods of an abstract class are uncompleted then it is the same as an interface but with the restriction that it cannot make a class inherit from it. The purpose of an abstract class is to provide a base class definition for how a set of derived classes will work and then allow the programmers to fill the implementation in the derived classes.

There are some similarities and differences between an interface and an abstract class that I have arranged in a table for easier comparison:Look at in Summary

Easy SMTP Mail Using ASP.NET 2.0

2009-12-03T22:52:00.000-08:00

http://mail.google.com/support/bin/answer.py?answer=78799

http://www.codeproject.com/KB/aspnet/EasySMTP_package.aspx

http://www.codeproject.com/Messages/1732134/System-Net-Mail-and-Web-config-Specifying-multiple-SMTP-servers.aspx

Custom Attribute

2009-12-03T05:36:00.001-08:00

Custom Attributes always inherit from System.Attribute, in fact any class that inherits from System.Attribute whether directly or indirectly is an attribute class. Attribute classes also follow the convention of having the word �Attribute� attached as a suffix to the class name.

Attributes allow you to add metadata to an object that you can read at run-time via reflection. As a result, they provide an elegant (and granular) solution to the object oriented problem of cross-cutting concerns.

Our first step will be to build a custom attribute class that will allow us to acquire meta data about the properties of our container class (which we haven�t built yet) at run-time. The beauty of this solution is that we can use our custom attribute class (in this case ConversionAttribute) to decorate any class that we decide to add to our project at a later date.

StringEnumerator

2009-12-03T05:30:00.000-08:00

http://www.codeproject.com/KB/cs/StringEmulator.aspx

C# Coding Practicies Guide

2009-12-03T05:25:00.001-08:00

http://www.codeproject.com/KB/cs/csharpstyle.aspx
Naming Conventions

.NET standards do not recommend using Hungarian prefixes, so avoid them. To refer to member field inside class member function use this word this.memberVariable. You use lower case for variables and function parameters, all the rest go with capitals:

SomeClass { ... };
SomeEnum { Item1, Item2, ... };
SomeProperty { get; set }
double someVariable;
int someFunctionParameter;
const char SomeConstantVariable;
static readonly SomeReadOnlyStaticVariable;
Exception SomeNameException;
Attribute SomeNameAttribute;
Button cancelButton;
TextBox nameTextBox;
PictureBox namePictureBox;
Class Layout

It is recommended to declare class internals in that order:

Fields
Constructors
Nested enums, structs, classes
Properties
Methods
Miscellaneous

One class per source file (SomeName class should be declared in somename.cs file)

Private members are private by default in class, avoid explicit private.

For a single statement get/set property use that construction:

public int Foo
{
get { return this.foo; }
set { this.foo = value; }
}
Use {} for if, else, for, while even if single lined.

Collapse
if (someVar == true)
{
foo++;
}
Use @ instead of escape sequencies in strings - @"c:\somepath\file.txt"

Use override instead of new

Collapse
class SomeParent
{
//...
public int DoWork();
//...
}

class SomeOverride
{
//...
public override int DoWork();
//...
}
Initialize string to String.Empty rather than assigning it "".

Use StringBuilder for composing complex strings rather than using string class operators.

Document if the method returns copy of reference type.

Do not compare to true or false use if(condition).

Provide private constructor if only static fields are in the class or declare static class.

Const objects in class are static by default.

Struct may have constructor with parameters only.

Consider documenting your code so you will not be trying to recall what the method is supposed to do after some days have gone

///

/// Save trimed text
///

/// Trimed text file name
/// zero upon success
public int SaveText(String fileName)
{
//...
}

JSON and C# using Generics and Delegates

2009-12-03T04:59:00.000-08:00

http://www.codeproject.com/Articles/34730/JSON-and-Csharp-using-Generics-and-Delegates.aspx

Three Layer Architecture in C# .NET

how to design a good user interface

2009-12-02T04:11:00.001-08:00

Follow the KISS (Keep It Simple Stupid) Principle. What this means is that you should make the
user interface as simple as possible yet still acquire the information you need. Resist the urge to
add objects to a form if they don ’ t contribute to the functionality of the program.
Use familiar interfaces. For example, in this program you are asking the user for address
information. Chances are good that the user has filled in a tear - out magazine subscription form
or filled in a driver ’ s license form that asks for address information. Try to model your interface
in a way that the user might already be familiar with, or do your best to make an unfamiliar
user interface easy to understand.
The user interface should have a natural flow to it. In a Windows program, the Tab key is used
to advance from one input field to the next. It wouldn ’ t make much sense to have the user type
in his name and, after he presses the Tab key, to jump to the Zip Code field, have him enter its
value, and then jump back to the Address field. The flow would make more sense to the user if
the program went from the Name field to the Address field to the City field to the State field,
and so forth. Likewise, English - speaking users read from top left to bottom right, while Chinese
readers progress from top right to bottom left. Therefore, even language and cultural factors can
influence the flow of the user interface. Simply stated, the flow of a user interface should be
intuitive and make sense to the user.
Don ’ t use the Gee - Whiz Factor. The Gee - Whiz Factor refers to any user interface change you
might make that doesn ’ t serve any purpose other than to get the user to say, “ Gee whiz! ”
Beginning programmers often change the background color for labels and textboxes, change the
font color from black to purple, and make other changes that add nothing useful to the interface
other than to show that they know how to make them. The fact remains, however, that Microsoft
has probably spend more money on research that tests the colors, shapes, and other default
property values for objects than you or I will make in a lifetime. As a result, there are not many
good reasons not to accept the results of that research.
Always keep in mind that goal of a user interface is to make it easy for the user to run your program. Try
to make the user interface intuitive and simple from the user ’ s point of view.

4-Tier Architecture in ASP.NET with C#

2009-12-01T23:21:00.001-08:00

4-Tier Architecture in ASP.NET with C#
I am using 3-Tier architecture in my different projects, but adding a 4th tier is a novelty for me.
After reading this article, I can see the benefits to add a Business Access Layer in some complex scenarios.
From the author:
Almost all of us must have heard about 3-Tier architecture but what is this 4-Tier architecture? What are the benefits and how it is different from other architectures?

Well, the architecture I am going to demonstrate here is just enhancement of 3-Tier archicture. In this architecture; you no need of writing long function parameters throughout the layers (as in traditionally 3-Tier archicture has to) and the actual objects of the application will be in a separate tier so that in future you can separately use these objects for enhancements. Change in the object definition can be done without touching the entire Business Access Layers ............

Let me explain you step-wise process of creatioin of 4-Tier architecture application.

In this application, I am going to take example of a Person that will have 3 properties: FirstName, LastName, Age. We will create a separate pages to insert these records (default.aspx) into database and list,update,delete records (list.aspx) from database.

In this application we will have following 4-Tiers
1. Business Object [BO]
2. Business Access Layer [BAL]
3. Data Access Layer [DAL]
4. UI (4-Tier) folder [UI]

Well, the architecture I am going to demonstrate here is just enhancement of 3-Tier archicture. In this architecture; you no need of writing long function parameters throughout the layers (as in traditionally 3-Tier archicture has to) and the actual objects of the application will be in a separate tier so that in future you can separately use these objects for enhancements. Change in the object definition can be done without touching the entire Business Access Layers ............

Let me explain you step-wise process of creatioin of 4-Tier architecture application.

In this application, I am going to take example of a Person that will have 3 properties: FirstName, LastName, Age. We will create a separate pages to insert these records (default.aspx) into database and list,update,delete records (list.aspx) from database.

In this application we will have following 4-Tiers
1. Business Object [BO]
2. Business Access Layer [BAL]
3. Data Access Layer [DAL]
4. UI (4-Tier) folder [UI]

Picture - 1 (Solution Explorer)

For simplicity reason, I have created separate folders for first 3-tiers into App_Code folder. You can create a separate projects for these tiers and add into forth tier (UI) solution.

Lets create above tiers one by one.

Business Object [BO - Person.cs]

Create a separate folder by right-clicking App_Code folder and name it as BO. Right click this folder and create a new .cs (Class) file named Person.cs. Write following code inside it.

- Hide Code

int m_PersonID = 0;

string m_FirstName = string.Empty;

string m_LastName = string.Empty;

int m_Age = 0;

#region Propertiers

public int PersonID

{

get { return m_PersonID; }

set { m_PersonID = value; }

}

public string FirstName

{

get { return m_FirstName; }

set { m_FirstName = value; }

}

public string LastName

{

get { return m_LastName; }

set { m_LastName = value; }

}

public int Age

{

get { return m_Age; }

set { m_Age = value; }

}

#endregion Properties

Here, we are first declaring 4 variables for corresponding properites and defining properties for them.This is your Business Object with all its properties/attributes to work with. Next step is to create Data Access Layer.

Data Access Layer [DAL - PersonDAL.cs]

The way you created BO folder inside App_Code folder, create another folder named DAL. Create a .cs file inside it and name it as PersonDAL.cs

Write following code inside it (You can copy-paste).

- Hide Code

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

///

/// Summary description for PersonDAL

///

public class PersonDAL

{

string connStr = ConfigurationManager.ConnectionStrings["TutTestConn"].ToString();

public PersonDAL()

{

}

///

/// Used to insert records into database

///

///

///

public int Insert(Person person)

{

SqlConnection conn = new SqlConnection(connStr);

conn.Open();

SqlCommand dCmd = new SqlCommand("InsertData", conn);

dCmd.CommandType = CommandType.StoredProcedure;

try

{

dCmd.Parameters.AddWithValue("@firstName", person.FirstName);

dCmd.Parameters.AddWithValue("@lastName", person.LastName);

dCmd.Parameters.AddWithValue("@age", person.Age);

return dCmd.ExecuteNonQuery();

}

catch

{

throw;

}

finally

{

dCmd.Dispose();

conn.Close();

conn.Dispose();

}

}

///

/// Update record into database

///

///

///

public int Update(Person person)

{

SqlConnection conn = new SqlConnection(connStr);

conn.Open();

SqlCommand dCmd = new SqlCommand("UpdateData", conn);

dCmd.CommandType = CommandType.StoredProcedure;

try

{

dCmd.Parameters.AddWithValue("@firstName", person.FirstName);

dCmd.Parameters.AddWithValue("@lastName", person.LastName);

dCmd.Parameters.AddWithValue("@age", person.Age);

dCmd.Parameters.AddWithValue("@personID", person.PersonID);

return dCmd.ExecuteNonQuery();

}

catch

{

throw;

}

finally

{

dCmd.Dispose();

conn.Close();

conn.Dispose();

}

}

///

/// Load all records from database

///

///

public DataTable Load()

{

SqlConnection conn = new SqlConnection(connStr);

SqlDataAdapter dAd = new SqlDataAdapter("LoadAll", conn);

dAd.SelectCommand.CommandType = CommandType.StoredProcedure;

DataSet dSet = new DataSet();

try

{

dAd.Fill(dSet, "PersonTable");

return dSet.Tables["PersonTable"];

}

catch

{

throw;

}

finally

{

dSet.Dispose();

dAd.Dispose();

conn.Close();

conn.Dispose();

}

}

///

/// Delete record from database

///

///

///

public int Delete(Person person)

{

SqlConnection conn = new SqlConnection(connStr);

conn.Open();

SqlCommand dCmd = new SqlCommand("DeleteData", conn);

dCmd.CommandType = CommandType.StoredProcedure;

try

{

dCmd.Parameters.AddWithValue("@personID", person.PersonID);

return dCmd.ExecuteNonQuery();

}

catch

{

throw;

}

finally

{

dCmd.Dispose();

conn.Close();

conn.Dispose();

}

}

}

In this class file, we have Insert, Update, Delete, Load methods. In this class file, first I am getting the connection string from the web.config file in a class level variable called connStr and using the same string in all my methods to open the connection.

For simplicity reason, I have not shown the code for Stored Procedure, however you can get the complete database and code by downloading the Source Code files. This was your Data Access Layer. Till now you have your Business Object and Data Access Layer ready. Now lets go to the third layer and create Business Access Layer.

Business Access Layer [BAL - PersonBAL.cs]

Again, right click App_Code folder and add a new folder named BAL. Create a new class file inside it and name it as PersonBAL.cs. Write following code inside it.

- Hide Code

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

///

/// Summary description for PersonBAL

///

public class PersonBAL

{

public PersonBAL()

{

}

///

/// insert records into database

///

///

///

public int Insert(Person person)

{

PersonDAL pDAL = new PersonDAL();

try

{

return pDAL.Insert(person);

}

catch

{

throw;

}

finally

{

pDAL = null;

}

}

///

/// Update records into database

///

///

///

public int Update(Person person)

{

PersonDAL pDAL = new PersonDAL();

try

{

return pDAL.Update(person);

}

catch

{

throw;

}

finally

{

pDAL = null;

}

}

///

/// Load records from database

///

///

public DataTable Load()

{

PersonDAL pDAL = new PersonDAL();

try

{

return pDAL.Load();

}

catch

{

throw;

}

finally

{

pDAL = null;

}

}

///

/// Delete record from database

///

///

///

public int Delete(Person person)

{

PersonDAL pDAL = new PersonDAL();

try

{

return pDAL.Delete(person);

}

catch

{

throw;

}

finally

{

pDAL = null;

}

}

}

Here, we are creating separate methods each for respective PersonDAL.cs methods here. As in our case we don't have any business logic, so we are just instantiating the Data Access Layer objects, using its methods and and returning to UI (fourth layer, described later on).

You must have noticed here that in the try catch block, I am just writing throw; statement. This is because when any error will occur it will be send to the calling layers (in our case UI) and there we will handle it.

Till now, we have BO, BAL and DAL ready. Now we are left with our application face, I mean UI. Lets first create default.aspx file that will contain one form and textboxs that will be used to enter records.

User Interface - [UI]-Default.aspx

Create a separate folder in your UI solution named 4-Tier and add one .aspx page called Default.aspx (Picture - 2). In this page, we will write ASP.NET code to render textboxes and buttons. OnClick event of the button we will calll AddRecords method that will ultimately insert the records into database. Below is the code to render the asp.net form.

- Hide Code

List Records

EnableViewState="False">

Add Records
First Name:		ControlToValidate="txtFirstName" Display="dynamic">
Last Name:		ControlToValidate="txtLastName" Display="dynamic">
Age:		Display="dynamic"> ControlToValidate="txtAge" Operator="DataTypeCheck" Type="Integer">

Picture - 2 (Default.aspx)

AddRecords method

- Hide Code

protected void AddRecords(object sender, EventArgs e)

{

//Lets validate the page first

if (!Page.IsValid)

return;

int intResult = 0;

// Page is valid, lets go ahead and insert records

// Instantiate BAL object

PersonBAL pBAL = new PersonBAL();

// Instantiate the object we have to deal with

Person person = new Person();

// set the properties of the object

person.FirstName = txtFirstName.Text;

person.LastName = txtLastName.Text;

person.Age = Int32.Parse(txtAge.Text);

try

{

intResult = pBAL.Insert(person);

if (intResult > 0)

lblMessage.Text = "New record inserted successfully.";

else

lblMessage.Text = "FirstName ["+ txtFirstName.Text +"] alredy exists, try another

name";

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

person = null;

pBAL = null;

}

}

In the above method, I am doing following things mainly:
1. Instantiating BAL object
2. Instantiating BO object
3. Settinng properties of BO object by the textbox values
4. Calling Insert method of the BAL object and passing BO object as parameter [pBAL.Insert(person)] in try block
5. Checking for number of records affected, If the number is more than zero, I am writing Success message otherwise Duplicate records found.
6. If any layer will throw any error, I am catching it and displaying to the user in throw block.
7. Whatever objects I had instantiated, I am specifying their values to null to let the GC know that I am no more going to use them.

User Interface - [UI]-List.aspx

In this page, I am going to use a GridView to List, Modify, Sort and Delete records from the database. Create an .aspx page in the same 4-Tier folder named List.aspx (Picture - 3). Following is the code for the GridView that will do data manipulation for us.

- Hide Code

Add Record

DataKeyNames="PersonID" AutoGenerateEditButton="True" AutoGenerateColumns="False"

OnRowEditing="EditRecord" OnRowUpdating="UpdateRecord" OnRowCancelingEdit="CancelRecord"

OnRowDeleting="DeleteRecord" AllowPaging="True" AllowSorting="true" PageSize="5"

OnPageIndexChanging="ChangePage" OnSorting="SortRecords">

<%# Eval("FirstName") %>

<%# Eval("LastName") %>

<%# Eval("Age") %>

Picture - 3 (List.aspx)

On the OnRowEditing, OnRowUpdating, OnRowCancelEdit, OnSorting and OnRowDeleting events we are calling respective methods to do data manipulation. Following are codes to bind the GridView and methods that will fire on GridView events.

- Hide Code

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

BindGrid();

}

///

/// Fired when Cancel button is clicked

///

///

///

protected void CancelRecord(object sender, GridViewCancelEditEventArgs e)

{

GridView1.EditIndex = -1;

BindGrid();

}

///

/// Fires when Edit button is clicked

///

///

///

protected void EditRecord(object sender, GridViewEditEventArgs e)

{

GridView1.EditIndex = e.NewEditIndex;

BindGrid();

}

///

/// Fires when Update button is clicked

///

///

///

protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)

{

int personID = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());

int intResult = 0;

GridViewRow row = GridView1.Rows[e.RowIndex];

TextBox tFN = (TextBox) row.FindControl("txtFName");

TextBox tLN = (TextBox)row.FindControl("txtLName");

TextBox tAge = (TextBox)row.FindControl("txtAge");

// instantiate BAL

PersonBAL pBAL = new PersonBAL();

Person person = new Person();

try

{

person.PersonID = personID;

person.FirstName = tFN.Text;

person.LastName = tLN.Text;

person.Age = Int32.Parse(tAge.Text);

intResult = pBAL.Update(person);

if (intResult > 0)

lblMessage.Text = "Record Updated Successfully.";

else

lblMessage.Text = "Record couldn't updated";

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

person = null;

pBAL = null;

}

GridView1.EditIndex = -1;

// Refresh the list

BindGrid();

}

///

/// fires when Delete button is clicked

///

///

///

protected void DeleteRecord(object sender, GridViewDeleteEventArgs e)

{

int personID = Int32.Parse(GridView1.DataKeys[e.RowIndex].Value.ToString());

// instantiate BAL

PersonBAL pBAL = new PersonBAL();

Person person = new Person();

try

{

person.PersonID = personID;

pBAL.Delete(person);

lblMessage.Text = "Record Deleted Successfully.";

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

person = null;

pBAL = null;

}

GridView1.EditIndex = -1;

// Refresh the list

BindGrid();

}

///

/// Fires when page links are clicked

///

///

///

protected void ChangePage(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

// Refresh the list

BindGrid();

}

///

/// Fires when Columns heading are clicked

///

///

///

protected void SortRecords(object sender, GridViewSortEventArgs e)

{

DataTable dataTable = GridDataSource();

if (dataTable != null)

{

DataView dataView = new DataView(dataTable);

dataView.Sort = GetSortExpression(e);

GridView1.DataSource = dataView;

GridView1.DataBind();

}

}

#region Private Methods

///

/// Bind the gridview

///

private void BindGrid()

{

GridView1.DataSource = GridDataSource();

GridView1.DataBind();

}

///

/// Get GridView DataSource

///

private DataTable GridDataSource()

{

PersonBAL p = new PersonBAL();

DataTable dTable = new DataTable();

try

{

dTable = p.Load();

}

catch (Exception ee)

{

lblMessage.Text = ee.Message.ToString();

}

finally

{

p = null;

}

return dTable;

}

///

/// Get sort expression for the gridview

///

///

///

private string GetSortExpression(GridViewSortEventArgs e)

{

string sortDirection = string.Empty;

// if clicked on the same column twice then let it toggle the sort order, else reset to ascending

if (ViewState["SortExpression"] != null)

{

if (!ViewState["SortExpression"].ToString().Equals(e.SortExpression.ToLower()))

{

ViewState["SortDirection"] = null;

}

}

if (ViewState["SortDirection"] != null)

{

if (ViewState["SortDirection"].ToString().Equals("ASC"))

{

sortDirection = "DESC";

ViewState["SortDirection"] = "DESC";

}

else

{

sortDirection = "ASC";

ViewState["SortDirection"] = "ASC";

}

}

else

{

ViewState["SortDirection"] = "ASC";

}

ViewState["SortExpression"] = e.SortExpression.ToLower();

return e.SortExpression + " " + sortDirection;

}

#endregion Private Methods

Thats it!!!

Now we have done all our home work, Its time to enjoy now. Just build the application by pressing Ctrl+Shift+B, once it shows Build Succeeded in the status bar at the bottom, you are ready to enjoy your 4-Tier architecture application.

Browse it as http://localhost/4-Tier (Provided you have created "4-Tier" virtual directory in your IIS or you can choose your own virtual directory name), you should see your screens as shown above (default.aspx and list.aspx pages).

Try manipulating data and see how effectively its happening. This was a simple application, based on this architecture, you can create larger application by adding separate objects and their corresponding tiers.

In order to use namespace in different tiers, you should define your namespace in respective tiers objects and use those namespace by using statement whereever you need.

dotnetricks

2009-12-01T23:16:00.000-08:00

dotnetricks
try
{
SqlConnection con = new SqlConnection(connectionstring);
try
{
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
}
catch {}
finally
{
cmd.Dispose();
}
}
catch(){}
finally
{
con.Dispose();
}
}

How to implement France google map in my Asp.net?

2009-12-01T23:04:00.000-08:00

http://code.google.com/apis/maps/documentation/v3/introduction.html

http://www.eggheadcafe.com/community/aspnet/17/10113953/how-to-implement-france-g.aspx
http://www.codeproject.com/KB/scripting/Use_of_Google_Map.aspx

Debugging failed because integrated Windows authentication is not enabled

2009-12-01T21:14:00.000-08:00

error message:

"Unable to start debugging on the web server. Debugging failed because
integrated Windows authentication is not enabled. - What could be the problem?

in case the project is on local IIS server, you need to enable Integrated
Windows Authentication on the local IIS.

1. Open IIS Manager (Internbet Information Services)
2. Right-click the web site (in case you run it locally you only have
Default web site) and pick Properties
3. Choose "Directory Security" tab and click Edit on "Anonymous access and
authentication control"
4. In the opening window, uncheck "Allow Anonymous access" and check
"Integrated Windows Authentication" (allowing anonymous can make that you
don't have enough permissions to debug)

After that you also need to make sure your NT Debugger user is on Debugger
users group (and in practise to attach to the aspnet_wp.exe process it also
needs to be admin unless you change local security policies)