What are the magic tables available in SQL Server 2000?

Sql Server automatically creates and manages two temporary, memory-resident tables (deleted and inserted tables) which are popularly known as magic tables.

joby peter Difference between NTFS and FAT32

NTFS Also support NTFS Security that Fat not support
on FAT we just had Read , Write , Full Control
but in NTFS it is extended.

explain about page life cycle in Asp.net

  ASP.Net webpage execution will perform several steps for processing page, this is called asp.net page life cycle. the steps are
1) Page Request
2)Start
3)Page initialization
4)Page Load
5)Post Back events execution
6)Rendering
7)Unload

What is Difference between ASP.NET 2.0 and ASP.NET 3.5

NET framework 2.0:

It brings a lot of evolution in class of the framework and refactor control including the support of

Generics
Anonymous methods
Partial class
Nullable type
The new API gives a fine grain control on the behavior of the runtime with regards to multithreading, memory allocation, assembly loading and more
Full 64-bit support for both the x64 and the IA64 hardware platforms
New personalization features for ASP.NET, such as support for themes, skins and webparts.
.NET Micro Framework


.NET framework 3.0:

Also called WinFX,includes a new set of managed code APIs that are an integral part of Windows Vista and Windows Server 2008 operating systems and provides

Windows Communication Foundation (WCF), formerly called Indigo; a service-oriented messaging system which allows programs to interoperate locally or remotely similar to web services.

Windows Presentation Foundation (WPF), formerly called Avalon; a new user interface subsystem and API based on XML and vector graphics, which uses 3D computer graphics hardware and Direct3D technologies.

Windows Workflow Foundation (WF) allows for building of task automation and integrated transactions using workflows.

Windows CardSpace, formerly called InfoCard; a software component which securely stores a person's digital identities and provides a unified interface for choosing the identity for a particular transaction, such as logging in to a website


.NET framework 3.5:

It implement Linq evolution in language. So we have the folowing evolution in class:

Linq for SQL, XML, Dataset, Object
Addin system
p2p base class
Active directory
ASP.NET Ajax
Anonymous types with static type inference
Paging support for ADO.NET
ADO.NET synchronization API to synchronize local caches and server side datastores
Asynchronous network I/O API
Support for HTTP pipelining and syndication feeds.
New System.CodeDom namespace.

nikhil kansal What’s the difference between the Debug class and Trace class?

The Debug class to provide information about the program execution You can also use the Trace class to produce messages that monitor the execution of an application. The Trace and Debug classes share most of the same methods to produce output, including the following: •WriteLine •WriteLineIf •Indent •Unindent •Assert •Flush You can use the Trace and the Debug classes separately or together in the same application. In a Debug Solution Configuration project, both Trace and Debug output are active.

What is Polymorphism? How does VB.NET/C# achieve polymorphism?

Polymorphism: It's derived from a Greek word, where poly means many morph means Faces/Behaviors.

Same function/operator will show different behaviours when passed different types of values or different number of values.

Types of polymorphism:There are 2 types:-

1. Static polymorphism/Early Binding/Compile time polymorphism.

2. Dynamic polymorphism/Late Binding/Run time polymorphism.

Static polymorphism is achieved using i) Function overloading ii) Operator overloading

Dynamic polymorphism is achieved using i) Function overloading

What is difference between UNIQUE and PRIMARY KEY constraints

Unique key- unique key accept only one null value accept.but unique key use many time in table.
Primary key-Primary key does not accept null value and primary key use only one time in table.

nikhil kansal What’s the difference between an interface and abstract class?

1. Abstract classes can have implementations for some of its members, but the interface can't have implementation for any of its members.

 2.Interfaces cannot have fields where as an abstract class can have fields.

3. An interface can inherit from another interface only and cannot inherit from an abstract class, where as an abstract class can inherit from another abstract class or another interface.

4. A class can inherit from multiple interfaces at the same time, where as a class cannot inherit from multiple classes at the same time.

5. Abstract can have access modifiers where as interface members cannot have access modifiers.
projects for computer science

What is Serialization in .NET, types of Serialization and why we need it while developing an application?

Serialization is the process of converting complex objects into stream of bytes for storage. Deserialization is its reverse process, that is unpacking stream of bytes to their original form. The namespace which is used to read and write files is System.IO. For Serialization we are going to look at the System.Runtime.Serialization namespace. The ISerializable interface allows you to make any class Serializable.
Here are the following steps that we are going to do to create a serializable class and test it.

• Create a custom class named Employee and assign properties.
• Define the serialization functions.
• Create a main class and instantiate our Employee class.
• Serialize the object to a sample file.
• Deserialize the values by reading it from the file.

Defining Employee class and properties
Our custom class Employee should be derived from the ISerializable interface and should hold the Serializable attribute. Here is the code snippet.

using System;
using System.IO;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary; namespace MyObjSerial
{
[Serializable()] //Set this attribute to all the classes that want to serialize
public class Employee : ISerializable //derive your class from ISerializable
{
public int EmpId;
public string EmpName;

//Default constructor
public Employee()
{
EmpId = 0;
EmpName = null;
}
}
}

Different types of serialization.

The different types of serialization are

·         Binary Serialization

·         XML Serialization

·         SOAP Serialization

Binary Serialization

Binary serialization is the process where you convert your .NET objects into byte stream. In binary serialization all the public, private, even those which are read only, members are serialized and converted into bytes. So when you want a complete conversion of your objects to bytes then one can make use of binary serialization.

XML Serialization

In XML serialization only the public properties and fields of the objects are converted into XML. The private members are not taken into consideration in XML serialization.

SOAP Serialization

Similar to XML serialization. When you serialize object to SOAP format it conforms to the SOAP specification.

Need of Serialization
Most uses of serialization fall into two categories: persistence and data interchange. Persistence allows us to store the information on some non-volatile mechanism for future use. This includes multiple uses of our application, archiving, and so on. Data interchange is a bit more versatile in its uses. If our application takes the form of an N-tier solution, it will need to transfer information from client to server, likely using a network protocol such as TCP. To achieve this we would serialize the data structure into a series of bytes that we can transfer over the network. Another use of serialization for data interchange is the use of XML serialization to allow our application to share data with another application altogether. As you can see, serialization is a part of many different solutions within our application.