\\Developers Place\...

Best Practice for deleting large records from a table

2011-12-07T13:02:00.000+05:30

Request Timed out for Large Table records delaetion.

Even sometime it sayes Transaction Logs Full, or sometime Memory Issues...

So here i get the Best Practice for deleting large records from a table...

WHILE (SELECT COUNT(*) FROM <table name> WHERE [Filter Condition] > 0
BEGIN
DELETE TOP 10 FROM <table name> WHERE [Filter Condition]
END

Debug (F5) Global.asax.cs Application_Start() Method

2011-10-12T10:18:00.001+05:30

Many Times we need to debug the Application_Start on server where we can not debug with Visual Studio IDE, instead we use CLR Debugger. So debugging on Global.asax.cs is deifficult as you need to attach the W3WP process, but it starts only when your application get a first hit, and so Application_Start code already executed. So how we can debug ??

So I was reading few discussion over mail thread when I came across this wonderful ideas.

(Hey Guys accept my thanks and from others as well [who read this ] for your good debugging tricks.)

So here we goes -

Put delay in Application_Start Methods first Line as approx. you need to attach the debugger.
#if DEBUG

if(ApplicationSetting("DebugStartup"))

System.Diagnostics.Debugger.Break();

#end if

Info about Lokpal

2011-08-18T23:51:00.001+05:30

As Received!

See how Lokpal Bill can curb the politicians, Circulate it to create awareness

Existing System	System Proposed by civil society
No politician or senior officer ever goes to jail despite huge evidence because Anti Corruption Branch (ACB) and CBI directly come under the government. Before starting investigation or initiating prosecution in any case, they have to take permission from the same bosses, against whom the case has to be investigated.	Lokpal at centre and Lokayukta at state level will be independent bodies. ACB and CBI will be merged into these bodies. They will have power to initiate investigations and prosecution against any officer or politician without needing anyone's permission. Investigation should be completed within 1 year and trial to get over in next 1 year. Within two years, the corrupt should go to jail.
No corrupt officer is dismissed from the job because Central Vigilance Commission, which is supposed to dismiss corrupt officers, is only an advisory body. Whenever it advises government to dismiss any senior corrupt officer, its advice is never implemented.	Lokpal and Lokayukta will have complete powers to order dismissal of a corrupt officer. CVC and all departmental vigilance will be merged into Lokpal and state vigilance will be merged into Lokayukta.
No action is taken against corrupt judges because permission is required from the Chief Justice of India to even register an FIR against corrupt judges.	Lokpal & Lokayukta shall have powers to investigate and prosecute any judge without needing anyone's permission.
Nowhere to go - People expose corruption but no action is taken on their complaints.	Lokpal & Lokayukta will have to enquire into and hear every complaint.
There is so much corruption within CBI and vigilance departments. Their functioning is so secret that it encourages corruption within these agencies.	All investigations in Lokpal & Lokayukta shall be transparent. After completion of investigation, all case records shall be open to public. Complaint against any staff of Lokpal & Lokayukta shall be enquired and punishment announced within two months.
Weak and corrupt people are appointed as heads of anti-corruption agencies.	Politicians will have absolutely no say in selection of Chairperson and members of Lokpal & Lokayukta. Selections will take place through a transparent and public participatory process.
Citizens face harassment in government offices. Sometimes they are forced to pay bribes. One can only complaint to senior officers. No action is taken on complaints because senior officers also get their cut.	Lokpal & Lokayukta will get public grievances resolved in time bound manner, impose a penalty of Rs 250 per day of delay to be deducted from the salary of guilty officer and award that amount as compensation to the aggrieved citizen.
Nothing in law to recover ill gotten wealth. A corrupt person can come out of jail and enjoy that money.	Loss caused to the government due to corruption will be recovered from all accused.
Small punishment for corruption- Punishment for corruption is minimum 6 months and maximum 7 years.	Enhanced punishment - The punishment would be minimum 5 years and maximum of life imprisonment.

Iftaar Timing Noida Delhi 2011

2011-08-05T15:03:00.000+05:30

Noida & Delhi


	Date	Day	Sehar	Iftar	Date	Day	Sehar	Iftar
2-Aug	Tue	4:16	7:12	17-Aug	Wed	4:28	7:00
3-Aug	Wed	4:17	7:12	18-Aug	Thu	4:29	6:59
4-Aug	Thu	4:18	7:11	19-Aug	Fri	4:30	6:58
5-Aug	Fri	4:19	7:10	20-Aug	Sat	4:30	6:57
6-Aug	Sat	4:19	7:09	21-Aug	Sun	4:31	6:56
7-Aug	Sun	4:20	7:09	22-Aug	Mon	4:32	6:55
8-Aug	Mon	4:21	7:08	23-Aug	Tue	4:32	6:54
9-Aug	Tue	4:22	7:07	24-Aug	Wed	4:33	6:53
10-Aug	Wed	4:23	7:06	25-Aug	Thu	4:34	6:52
11-Aug	Thu	4:23	7:05	26-Aug	Fri	4:35	6:50
12-Aug	Fri	4:24	7:04	27-Aug	Sat	4:35	6:49
13-Aug	Sat	4:25	7:03	28-Aug	Sun	4:36	6:48
14-Aug	Sun	4:26	7:03	29-Aug	Mon	4:37	6:47
15-Aug	Mon	4:26	7:02	30-Aug	Tue	4:37	6:46
16-Aug	Tue	4:27	7:01	31-Aug	Wed	4:38	6:45

MOTHERS & CHILDRENS

2011-06-26T13:48:00.000+05:30

Pencil: I'm sorry
Eraser: For what? You didn't do anything wrong.
Pencil: I'm sorry cause you get hurt because of me. Whenever I made a mistake, you're always there to erase it. But as you make my mistakes vanish, you lose a part of yourself. You get smaller and smaller each time.
Eraser: That's true. But I don't really mind. You see, I was made to do this. I was made to help you whenever you do something wrong. Even though one day, I know I'll be gone and you'll replace me with a new one, I'm actually happy with my job. So please, stop worrying. I hate seeing you sad. :)

I found this conversation between the pencil and the eraser very inspirational.

Mother is like the eraser whereas their children are the pencil.
She is always there for their children, cleaning up their mistakes.
Sometimes along the way... She get hurt, and become smaller (older, and eventually pass on).
Though her children will eventually find someone new (spouse), but she is still happy with what she do for their children, and will always hate seeing her precious ones worrying, or sad.
This is to all the MOTHERS & CHILDRENS..............!!!!!!!!!!!!!!!!!
Ref: Dont know the origin but I get it from Ahsan
P.S. Thanks a lot (whomsoever compose it) for writing such a wonderful inspirational message..

How to pass variable to sql script from batch file?

2011-02-20T09:07:00.002+05:30

How to pass variable to sql script from batch file?

1. Create a Table called Employees

id int

fname varchar(50)

lname varchar(50)

dept varchar(10)

2. Insert few records into it as

Id fname lname dept

01 Mohd Irfan IT

02 Gaurav Thakur IT

03 Animesh Mishra Security
04 Ashok Roy Admin

3. Create the sql script as getEmployees.sql

use $(dbname)

select * from $(tablename)

4. Create the runsqlscript.bat file for running the sql script as below.

sqlcmd -S %1 -i getEmployees.sql -v dbname = %2 tablename = %3 -o %4

5. Run this command from cmd.

>runsqlscript.bat SQLServerName DBName Employees D:\EmployeesList.txt

Ref - http://blogs.msdn.com/b/ssehgal/archive/2009/04/03/passing-parameters-to-sql-script-using-batch-files.aspx

HCL Care Noida

2010-09-02T11:17:00.000+05:30

Hcltouch Number for Noida - 18601800425

For Desktop - Monday to Saturday 9:00 AM to 5:00 PM

For Labtop - 24x7

Equivalent SQLWB Command in SLQ 2008

2010-03-18T11:17:00.002+05:30

Run command for opening SQL2005 management studio is SQLWB, however the same is not availabl ein sql 2008.

So what is the run command for SQL 2008

Its SMSS

Go to Start -> RUN

Type SSMS

Click Enter

And here you are with SQL2008 Management Studio.

It is possible to have dynamic query in LINQ?

2010-01-22T21:07:00.000+05:30

It is possible to have dynamic query in LINQ?

var data = items in ItemsList
where items='some condition'
select items;

The above query is static query as its already written and it will be executed good.

I wanna know if we can make the same query into some string and exec the same??

Can SQL Mirroring be implemented on .NET 1.1

2010-01-18T15:45:00.001+05:30

The straight answer is NO, let me find some tweeks and update this topic.

And yes its true, for mirroring , failover implementation it need to provide the failover partner into the connection string which is not supported for .NET Framework 1.1 and 1.0.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx

Key: Failover Partner
Default Value : N/A
Description: The name of the failover partner server where database mirroring is configured.
The Failover Partner keyword is not supported by .NET Framework version 1.0 or 1.1.

Database Mirroring Vs Database Replication [SQL 2005 and Above]

2010-01-15T15:56:00.001+05:30

Database Mirroring	Database Replication
Making the same database with transaction logs [ synchronous or asynchronous]	Making the same database replicated on other server.
Only snapshot can be used to fetch the data from mirroring server.	Can be fetched data directly from the replicated server.
Mirroring is preferred when we want database online most of the time.	Replication used when we need to run the reports without affecting the primary database performance.
In case of failover the mirroring database in as primary database.	In case of failover you have to specify the secondary database name, it's not failover automatically.

Microsoft BING is Releasing on 3 June 09

2009-05-31T12:20:00.001+05:30

Microsoft BING is coming its way on 3rd June, so keep watching the new search engine wars among google & bing.

So what Microsoft say about Bing " Its will be great tool for strategic search, its search intelligently. Every seconds there are 4 new sites are being listing, current search engines are not taking these sites, but BING do."

Currently the search engines percentage worldwide is Live 3% , Yahoo 16% and Google 81% ......

So lets watch going to happen..

You can get more information about bing here

Previously also there were search engines launched but not get popular.

Some of the search engine you can see

scour.com

guruji.com

getit.in [targeted for india market for searching products/services]

.Net Interview Questions | Assembly - Part -3

2009-03-08T12:30:00.000+05:30

11. Do you know BCL?
The BCL (Base Class Library) is a combination of classes or we can say that it’s a library of functionalities and types available to all languages that used in .NET Framework. To make the programmer job more easier dot net gave a advantage to includes the BCL in order to collect a large number of common functions, just like to read a file and write to file, graphic rendering, database interaction, and XML document manipulation at one place . The scope of this is large and standard libraries for most other languages, including C++, and would be comparable in scope to the standard libraries is just like Java. The BCL is sometimes incorrectly referred to as the Framework Class Library (FCL), which is a superset including the Microsoft namespaces.

12. In Assembly which work as GacBrowser ?
The GACPicker class allows the user to select an assembly from the Global Assembly Cache. It does this by looking at the filesystem representation of the GAC, since there appears to be no actual API in the current .NET environment.

.Net Interview Questions | [Assembly]

.Net Interview Questions | Assembly - Part -2

2009-03-08T12:27:00.002+05:30

6. How strong name being defined? OR What is strong name?
A strong name consists of the assembly's identity—its simple text name, version number, and culture information (if provided)—plus a public key and a digital signature. It is generated from an assembly file (the file that contains the assembly manifest, which in turn contains the names and hashes of all the files that make up the assembly), using the corresponding private key. There are SDK tools to sign an assembly with strong name. Assemblies with the same strong name are expected to be identical.

7. How to Sign an Assembly with strong Name?
The Windows Software Development Kit (SDK) provides several ways to sign an assembly with a strong name:
• Using the Assembly Linker(Al.exe) provided by the Windows SDK.
• Using assembly attributes to insert the strong name information in your code. You can use either the AssemblyKeyFileAttribute or the AssemblyKeyNameAttribute, depending on where the key file to be used is ocated.
Note: In the .NET Framework version 2.0, some compilers issue warning messages when attributes are used.
To create and sign an assembly with a strong name using the Assembly Linker
At the command prompt, type the following command:
al /out: /keyfile:
In this command, assembly name is the name of the assembly to sign with a strong name, module name is the name of the code module used to create the assembly, and file name is the name of the container or file that contains the key pair.
The following example signs the assembly MyAssembly.dll with a strong name using the key file sgKey.snk.
al /out:MyAssembly.dll MyModule.netmodule /keyfile:sgKey.snk

To sign an assembly with a strong name using attributes
In a code module, add the AssemblyKeyFileAttribute or the AssemblyKeyNameAttribute, specifying the name of the file or container that contains the key pair to use when signing the assembly with a strong name.
The following code example uses the AssemblyKeyFileAttribute with a key file called sgKey.snk, located in the directory where the assembly is compiled. This assumes that the assembly is compiled using the command-line compilers vbc.exe and csc.exe.
Visual Basic

C#
[assembly:AssemblyKeyFileAttribute(@"sgKey.snk")]

8. What is delay signing?
When signing an assembly, you might not always have access to a private key. For example, an organization might have a closely guarded key pair that developers do not have access to on a daily basis. While the public key might be available, access to the private key is restricted to a few individuals. In such a case, you can use delayed or partial signing to provide the public key, deferring the addition of the private key until the assembly is handed off.
Delay signing can be enabled in the Signing pane of the Project Designer as follows.
To delay sign an assembly
• With the project node selected in Solution Explorer, from the Project menu, click Properties (or right-click the project node in Solution Explorer, and click Properties).
• In the Project Designer, click the Signing tab.
• Select the Sign the assembly check box.
• Specify a key file. (ie key.snk)
• Select the Delay sign only check box. Note that a delay signed project will not run and cannot be debugged. You can, however, use the Strong Name Tool (Sn.exe) with the -Vr option to skip verification during development.

9. What is version number and Culture into Manifest?
Version number:- A major and minor version number, and a revision and build number. The common language runtime uses these numbers to enforce version policy.For example ... - 1.02.0012.0113
Culture:- This relates to Satellite assembly. This information should be used only to Pick an assembly as a satellite assembly containing culture- or language-specific information.

10. What do you mean by satellite assemblies?
The assemblies which contains only culture information are known as satellite assemblies.This assembly is used to get language specific resources for an application.
To know how to create satellite assmblies refer to http://msdn.microsoft.com/en-us/library/21a15yht(VS.71).aspx

.Net Interview Questions | [Assembly]

.Net Interview Questions | Assembly - Part -1

2009-03-08T11:32:00.002+05:30

1. What you mean by Assembly?
Assemblies are the building blocks of .NET Framework applications; they form the fundamental unit of deployment, version control, reuse, activation scoping, and security permissions. An assembly is a collection of types and resources that are built to work together and form a logical unit of functionality. All the .NET assemblies contain the definition of types, versioning information for the type, meta-data, and manifest.

2. What is menifest?
Detailed description of the assembly contents. A manifest contains metadata describing the name, resources, types, and version of the assembly as well as dependencies upon other assemblies. The manifest makes an assembly self-describing, easier to deploy, and not bound to a particular system because of storing data in the Windows registry.

3. How many type of assembly are there?
There are two types of Assembly in .NET
• Private Assembly
• Shared Assembly
Private Assembly: These are simple assemblies and being copied with each applications running folder.Dont nned to have strong name.
Shared Assembly: Also named as Strong Named Assemblies are copied to a single location (usually the Global assembly cache). For all calling assemblies within the same application, the same copy of the shared assembly is used from its original location. Hence, shared assemblies are not copied in the private folders of each calling assembly. Each shared assembly has a four part name including its face name, version, public key token and culture information. The public key token and version information makes it almost impossible for two different assemblies with the same name or for two similar assemblies with different version to mix with each other.
An assembly can be a single file or it may consist of the multiple files. In case of multi-file, there is one master module containing the manifest while other assemblies exist as non-manifest modules. A module in .NET is a sub part of a multi-file .NET assembly. Assembly is one of the most interesting and extremely useful areas of .NET architecture along with reflections and attributes.

4. What is GAC? WhereGAC located on machine?
GAC is known as Global Assembly Cache where the shared assembiles are being kept. GAC can be found on a system at \\Assembly ie. C:\Windows\Assembly

5. Can we have two DLL with same name into GAC?
GAC is a Folder that contains DLL that have strong name.We can say that GAC is a very special folder, and it is not possible to place two files with the same name into a Windows folder,But GAC differentiates DLL by strong names and since strong name can not be same hence wwe can put two DLL with same name into GAC. For example SameNameApp.dll and SameNameApp.dll to co-exist in GAC if the first one have version 1.0.0.0 and the second have 1.1.0.0.

.Net Interview Questions | [Assembly]

.Net Interview Questions | Assembly

2009-03-08T11:17:00.003+05:30

In this section I included only questions related to Assembly.

1. What is assembly?
2. What is manifest?
3. How many type of assembly are there?
4. What is GAC? Where you found GAC on a machine?
5. Can we have two DLL with same name into GAC?
6. What is strong name?
7. How to Sign an Assembly with strong Name?
8. What is delay signing?
9. What is version number and Culture into Manifest?
10. What do you mean by satellite assemblies?
11. Do you know BCL?
12. In Assembly which work as GacBrowser ?

Answers [1-5] [6-10] [11-12]

Global Variable in C# | Application Cache Vs Static Variable

2009-02-28T16:59:00.000+05:30

Some times we need to use some variable globaly so that it may be available to application wide. For having a global variable we can use static variables as well application cache.

Example :

Application["gVar1"]="Global variable One stored here";
and this can be get anywhere in application by using string var1 = (string)Application["Var1"];

The same thing can be by using static variable also.

public static string GVar1;

These variables need to be initialized first time into Global.asax.cs application_start() method and keep alive until a IIS reset or worker process recycle not occurs.

Application_Start()
{
Application["gVar1"]="Global variable One stored here";
Gvar2= "Global Variable Two is here";
}
For using the Gvar2 we need to simply write the className.Gvar2 // Here Global.Gvar2 will do the work for us.

So the question arise as both are doing the same work which we prefer to use.
I must say It depends!!

Why I said so? Because there are reasons behind this.
In the above scenario I must say I MUST use static variable. (Please make static property rather than directly using static variable)
So what factors you must count for choosing static -
1. Application holds variable as Object.
2. While getting the value we need to caste into the objects which it stores. Of course casting need some value.

So when we need to use some primitive variables and they are not going to changes very frequent (locking issue in case of frequent changes) we should use static variable.
Application need to be used when we need to Hold some objects application wide.
(Note Its my own experience please do not take it as hard and fast rule).

Thanks

UP CPMT2009

2009-02-22T18:19:00.001+05:30

Uttar Pradesh Combined Pre Medical Test is an examination conducted by University of Lucknow on behalf of the Government of Uttar Pradesh. The examination is conducted for admission to various medical courses in Government and recognized, approved Medical, Dental, Homeopathic, Ayurvedic and Unani Colleges of Uttar Pradesh.

Important dates of UPCPMT

1. Feb to first week of March 2009 – availability of application forms.
2. 2nd week of March 2009 – deadline for submission of completed application forms.
3. Mid of May 2009 – date of examination.

Eligibility criteria for UPCPMT

The candidate must be a citizen of India and must have domicile of Uttar Pradesh.
The candidate must have cleared class 12th examination with PCB and English as one of the main subjects.

Courses offered for UPCPMT

1. MBBS
2. BDS
3. BHMS
4. BAMS
5. BUMS

Examination pattern and syllabus:

1. The examination will be conducted in two parts.
2. The first paper will contain questions from Zoology and Botany and the timings will be from 10:00 AM-12:00 Noon
3. The second paper will have questions from Chemistry and Physics and the timings will be from 2:0O PM-4:00 PM.

For more information keep watching this page....

AMU Admission Notice 2009 - 2010

2009-02-08T09:53:00.005+05:30

Aligarh Muslim University (AMU) announces the admissions Notice for Academic session 2009-2010. First time AMU Entrance Test will be held on five centres across India (Only for BTech and MBBS/BDS), Rest of the Test courses will be held on Aligarh except Class XI/Diploma Engineering which will be held in Lucknow also along with Aligarh. For more information visit :http//amu.ac.in

Admissions related more information/Application Form can be downloaded at http://amucontrollerexams.com

Examination Notice:

Physics - Cyclotron

2008-10-28T11:49:00.007+05:30

Purpose: Cyclotron is a device used to accelerate heavy charge particles e.g.protons,deuerons etc.

Principle: It is based on the principle that a changed particle can be accelerated to very hagh energies by making it pass through a moderate electric field a number of times and applying a strong magnetic field at same time.

Construction: -

1-Strong electromagnet(N&S).

2-Two dees D1&D2 (D shaped hollow semi circular copper chambers called dees).

3-Source of high voltage coupled with adjustable high frequency oscillator.

4-Source of charged ions at the centre of the dees.g. deuterium for protons,helium for a-particles,bombarded with high energy electrons.
The hole assembly is housed in a vaccum chamber which is evacuated to a pressure of about 10-6 mm Hg,to avoid collision of charged particlels with medium gas particles which would result in loss of energy.

Physics-Moving coil galvanometer

2008-10-26T23:07:00.005+05:30

It is an instrument to detect and measure the strength of small electric current.

Principle:--When a current carrying coil is placed in magnetic field,it is experience a torque.

Construction:-It is consists of a coil bound on a non-magnetic field.The coil is suspended between two poles of a permanent magnet which are concave in shape.the coil is suspended by a phosphur bronze strip and this strip is connected to the terminal T1 of the galvanometer and other end of the coil is connected to hair spring which is connected to terminal T2 .A peace of the soft iron is the placed within the frame of the coil.A concave mirror is attached to the suspension to note the deflection of the coil using length and scale arrangement.

Physics - Fleming Left Hand Rule

2008-10-26T20:38:00.004+05:30

Fleming Left Hand Rule describes that if took the first three fingers of your hand so that Center Finger point to Current, First Finger point to the direction of Field then Thumb will point the Force.

A simple rule to remember this

Center Finger --> Current Direction
First Finger --> Magnetic Field Direction
Thumb(Most Powerful in hand) --> Force

Haj Flight Schedule 2008 from Lucknow

2008-10-17T20:21:00.004+05:30

Haj flight Schedule for 2008 from Lucknow is from 30Oct to 16 Nov.(From Lucknow to Medinah) and from 14Dec to 30Dec(From Jeddah to Lucknow).

For details for your Flight Information visit to http://hajcommittee.com/index.php?value=flt_inquiry

iPhone 3G Launch in India with High Price Difference

2008-08-22T21:30:00.002+05:30

iPhone is now available in 8GB & 16GB models, priced at Rs 31,000 and Rs 36,100 respectively.

Where can you make this advance payment?

The iPhone 3G will be available at select Vodafone Stores. All you need to do is drop in at any select Vodafone Store between August 20 and 21 and make the advance payment by cash or credit card. Don´t forget to show the iPhone booking SMS, which you would have received from us, when you visit the Vodafone Store to pay the advance. To find a Vodafone Store near you, click here

Get an appointment now. No queues for you.

Once you pay the advance, we will immediately give you an appointment date and time, starting August 22 when you can come and experience a full demonstration and collect your iPhone, all ready to use with your contacts and settings, by paying the balance amount.

You can get the iPhone with Airtel service on same Price.

After seeing this High Price I turn my mind from having one. I am shocked first to see the price. In US it is around 9000 Rs (199USD) with two years service agreement with AT&T. I am wondering why Vodafone and Airtel not mainitaing the same with their TWO years of Service agreements.
I am seeing it totally flop show of iPhone in India. Hope the price will get down soon and Gadget lovers get this cool phone in their budget.

3g iPhone set to launch on 22 Aug in India

2008-08-08T21:05:00.002+05:30

All set to lanuch ipod in india, a news from midday news

"Apple's iPhone, the touch screen handset that acquired a cult status in the US and other western countries, will be available to Indian mobile users through Bharti Airtel at the stroke of midnight on August 21, giving competitors like Nokia, Samsung and others a run for their money.
Millions of Airtel subscribers will be able to purchase the iPhone at Airtel's Relationship Centres from August 22.
"iPhone has been an iconic technological revelation of this year and Airtel has been at the forefront of innovation and customer delight in the Indian telecom sector," Sanjay Kapoor, President, Bharti Airtel mobile services, said.
iPhone is embedded with all 3G features and is twice as fast as the existing mobile phones. The phone also has in-built GPS system, that facilitates as a navigation and positioning tool.
US-based Apple has tied up with Airtel and Vodafone to bring iPhone in the country.
Asked at what price it will be available, Bharti Airtel officials declined to give details."
To read the whole article....
http://www.mid-day.com/news/2008/aug/06082008-iPhone-in-India-from-Aug-22.htm

Storing and Retirving Data in XML format from sql server

2008-07-14T10:50:00.002+05:30

Retrieving and storing data in XML format in Sql Server 2000.

Suppose you have 20 X 20 controls on your page. And want to send all the data to sql server then create xml for it.

Example :

Let there are A,B,C,D,E,F ……….. controls .

Then create xml for it as

Through String builder as

StringBuilder xmlData = new StringBuilder();

xmlData.Append("<Column>");

xmlData.Append("<ColumnVal ");

xmlData.Append(" A=");

xmlData.Append("'0'");

xmlData.Append(" B=");

xmlData.Append("’1’");

xmlData.Append(" C=");

xmlData.Append(" 2=");

xmlData.Append(" D=");

xmlData.Append(" 3=");

xmlData.Append(" E=");

……………………………………………………………………………………

……………………………………………………………………………………..

……………………………………………………………………………………

xmlData.Append("</Column>");

xmlData.Append("</ColumnVal ");

And at last it will created as :

………………………….

send this string into DataBase in as xml datatype.

And write query for inserting into datatable.

insert into YourTableName(A,B,C,D,E,F,G,H,…………………………… ColumnVal)

SELECT A,B,C,D,E,F,G,H, ColumnVal FROM OPENXML (@idoc, '/XML/ Column',1)

Retriving data from database.

It will return data in xml format.

CONVERT(xml,(select * from YourTableName where ‘yourcondition’ for xml raw,Elements,ROOT(' Column '))) as ColumnValue

Clustered Index vs Non Clustered Index

2008-07-07T22:36:00.002+05:30

Clustered Index | Non Clustered Index

Indexing is used to get fast retrival of data. The indexing which is done on physical storage is known as Clustered Indexing. And an indexing which is performed logically is know as Non Clustered Indexing.

Clustered Indexing can be only one per table as we phyisically can arrange in one way only, while a table can have 249 Non Clustered Index.

Indexing should be used on table which not very frequently having update operations on it. There are many ways which can be used to get more performance while retrieving data.

Covering Index is --> when you create an index on fields which you are also using in select query, is know as covering index.

For ex suppose
Employee Table
---------------
EmpID int
EmpName
EmpDept
EmpDesing

----------------
If you have a query which only select EmpID and EmpName, then we can create a non clustered index with these two fields only, and it gains our performance while retrieving data.

Get all the triggers for a Database

2008-07-01T11:08:00.001+05:30

To get all the triggers list and their scripts run the script below. View the result in file view mode.

SELECT [text]
FROM sysobjects o
JOIN syscomments c ON o.id = c.id
WHERE xtype = 'TR'

Getting all stored procedures scripts from a Database

2008-07-01T10:54:00.002+05:30

By using Cursor
declare @proc_name varchar(100)
declare @str_query nvarchar(MAX)

declare loop_proc cursor
for select [name] from sys.procedures where type='P'
and is_ms_shipped = 0
open loop_proc

FETCH NEXT FROM loop_proc INTO @proc_name
IF @@FETCH_STATUS <> 0
PRINT ' <>'
WHILE @@FETCH_STATUS = 0

BEGIN
SELECT @str_query = 'sp_helptext ' + @proc_name
PRINT @str_query
exec sp_executesql @str_query
FETCH NEXT FROM loop_proc INTO @proc_name
END
CLOSE loop_proc
DEALLOCATE loop_proc

Run these sql statements and view the result in Text mode. You will get all scripts for stored procedures.

From sysobjects
This is better option to get all stroed procedures from a database.

SELECT [text]
FROM
sysobjects o
JOIN syscomments c ON o.id = c.id
WHERE xtype = 'P'

Abstract Classs vs Virtual Methods

2008-06-27T14:37:00.004+05:30

Abstract Class:
Abstract class is a class that has no direct instances, but whose descendants may have direct instances. There are case in which it is useful to define classes for which the programmer never intends to instantiate any objects; because such classes normally are used as bae-classes in inheritance hierarchies, we call such classes abstract classes These classes cannot be used to instantiate objects; because abstract classes are incomplete. Derived classes called concrete classesmust define the missing pieces.

Abstract classes normally contain one or more abstract methods or abstract properties, such methods or properties do not provide implementations, but our derived classes must override inherited abstract methods or properties to enable obejcts ot those derived classes to be instantiated, not to override those methods or properties in derived classes is syntax error, unless the derived class also is an abstract class.

In some cases, abstract classes constitute the top few levels of the hierarchy, for Example abstract class Shape with abstract method Draw() has tow derived abstract classe Shape2D & Shape3D inherites the method Draw() & also do not provide any implementation for it. Now we have normal classes Rectangle, Square & Circle inherites from Shape2D, and another group of classes Sphere, Cylinder & Cube inherites from Shape3D. All classes at the bottom of the hierarchy must override the abstract method Draw().

A class is made abstract by declaring it with Keyword abstract.

Example:
public abstract class Shape
{
//...Class implementation

public abstract void Draw(int x, int y)
{
//this method mustn't be implemented here.
//If we do implement it, the result is a Syntax Error.
}
}
public abstract class Shape2D : Shape
{
//...Class implementation
//...you do not have to implement the the method Draw(int x, int y)
}

public class Cricle : Shape2D
{
//here we should provide an implemetation for Draw(int x, int y)
public override void Draw(int x, int y)
{
//draw the shape
}
}

Difference between an abstract method & virtual method:
Virtual method has an implementation & provide the derived class with the option of overriding it. Abstract method does not provide an implementation & forces the derived class to override the method.

Important Notes:

(a)Any Class with abstract method or property in it must be declared abstract
(b)Attempting to instantiate an object of an abstract class retults in a compilation error

Example:
Shape m_MyShape = new Shape(); //it is Wrong to that.

But we can do that.
Shape m_MyShape = new Circle(); // True

Or
Shape m_MyShape;
/*

declare refrences only, and the refrences can refer to intances of
any concrete classes derived from abstract class
*/

Circle m_MyCircle = new Circle();
m_MyShape = m_MyCircle; // Also True
(d)An abstract class can have instance data and non-abstract methods -including constructors-.

Polymorphism, Method Hiding and Overriding in C#

2008-06-27T13:05:00.000+05:30

Polymorphism

One of the fundamental concepts of object oriented software development is polymorphism. The term polymorphism (from the Greek meaning "having multiple forms") in OO is the characteristic of being able to assign a different meaning or usage to something in different contexts - specifically, to allow a variable to refer to more than one type of object.

C# Example

Let's assume the following simple classes A and B for the discussions in this text. A is the base class, B is derived from A.

Inherited Methods

A method Foo() which is declared in the base class A and not redeclared in classes B or C is inherited in the two subclasses

using System;
namespace Polymorphism
{
class A
{
public void Foo() { Console.WriteLine("A::Foo()"); }
}

class B : A {}

class Test
{
static void Main(string[] args)
{
A a = new A();
a.Foo(); // output --> "A::Foo()"

B b = new B();
b.Foo(); // output --> "A::Foo()"
}
}
}

The method Foo() can be overridden in classes B and C:

using System;
namespace Polymorphism
{
class A
{
public void Foo() { Console.WriteLine("A::Foo()"); }
}

class B : A
{
public void Foo() { Console.WriteLine("B::Foo()"); }
}

class Test
{
static void Main(string[] args)
{
A a;
B b;

a = new A();
b = new B();
a.Foo(); // output --> "A::Foo()"
b.Foo(); // output --> "B::Foo()"

a = new B();
a.Foo(); // output --> "A::Foo()"
}
}
}

There are two problems with this code.

The output is not really what we, expected. The method Foo() is a non-virtual method. C# requires the use of the keyword virtual in order for a method to actually be virtual.

Although the code compiles and runs, the compiler produces a warning:
...\polymorphism.cs(11,15): warning CS0108: The keyword new is required on 'Polymorphism.B.Foo()' because it hides inherited member 'Polymorphism.A.Foo()'

Virtual and Overridden Methods

Only if a method is declared virtual, derived classes can override this method if they are explicitly declared to override the virtual base class method with the override keyword.

using System;
namespace Polymorphism
{
class A
{
public virtual void Foo() { Console.WriteLine("A::Foo()"); }
}

class B : A
{
public override void Foo() { Console.WriteLine("B::Foo()"); }
}

class Test
{
static void Main(string[] args)
{
A a;
B b;

a = new A();
b = new B();
a.Foo(); // output --> "A::Foo()"
b.Foo(); // output --> "B::Foo()"

a = new B();
a.Foo(); // output --> "B::Foo()"
}
}
}

Method Hiding

Why did the compiler in the second listing generate a warning? Because C# not only supports method overriding, but also method hiding. Simply put, if a method is not overriding the derived method, it is hiding it. A hiding method has to be declared using the new keyword. The correct class definition in the second listing is thus:

using System;
namespace Polymorphism
{
class A
{
public void Foo() { Console.WriteLine("A::Foo()"); }
}

class B : A
{
public new void Foo() { Console.WriteLine("B::Foo()"); }
}

class Test
{
static void Main(string[] args)
{
A a;
B b;

a = new A();
b = new B();
a.Foo(); // output --> "A::Foo()"
b.Foo(); // output --> "B::Foo()"

a = new B();
a.Foo(); // output --> "A::Foo()"
}
}
}

Combining Method Overriding and Hiding

Methods of a derived class can both be virtual and at the same time hide the derived method. In order to declare such a method, both keywords virtual and new have to be used in the method declaration:

class A
{
public void Foo() {}
}

class B : A
{
public virtual new void Foo() {}
}

A class C can now declare a method Foo() that either overrides or hides Foo() from class B:

class C : B
{
public override void Foo() {}
// or
public new void Foo() {}
}

Important things to remember -->

1. If you are using same name in derived class it hides the base class method, and generate a compiler warning. Use new keyword to supress this warning and tells the compiler that ok i am hiding it intentional.
2. Else define the base as virtual and write override in derived class method.
3. If you dont sure whether you want to hide or override use both virtual and new in base class method definition.

Creating a DataTable | DataTable in C#

2008-06-26T12:22:00.000+05:30

Creating a DataTable | DataTable in C#

DataTable aTable = new DataTable();
aTable.Columns.Add("ProductID", typeof(int));
aTable.Columns.Add("ProductName", typeof(string));
DataRow dr;
dr = aTable.NewRow();
dr[0] = 12;
dr[1] = "Lap Top";
aTable.Rows.Add(dr);
dr = aTable.NewRow();
dr[0] = 13;
dr[1] = "DeskTop";
aTable.Rows.Add(dr);
dr = aTable.NewRow();
dr[0] = 14;
dr[1] = "Server";
aTable.Rows.Add(dr);
dr = aTable.NewRow();
dr[0] = 15;
dr[1] = "Mac PC";
aTable.Rows.Add(dr);

You can create these rows by getting data from database also

command=new SqlCommand("select * from Product",connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while(reader.Read())
{
Dr=aTable.NewRow();
Dr[0] = reader.GetValue(1);
Dr[1] = reader.GetValue(2);
aTable.Rows.Add(Dr);
}

Haj committee India | Haj 2008 Lucknow

2008-06-22T12:59:00.003+05:30

All about Haj, please visit http://www.hajcommittee.com

This year UP haj pilgrims will be decided on lottery draw due to more responces of limited quota assigned to UP. The lucky draw was decided to held on 21st June 08, and the final list of pilgrims will be posted on haj committee site.

Lets wait and see Whom Allah give a chance to perform Haj this year.
Finally wait is over you can get the results here

Top 20 2008 Antivirus Software

2008-06-12T23:22:00.001+05:30

To Download click the link below:

BitDefender
Kaspersky
ESET Nod32
AVG Anti-Virus
F-Secure
Anti-Virus
Trend
Micro Antivirus
McAfee
VirusScan
Norton
AntiVirus
CA
Antivirus
Norman Antivirus and Antispyware
G DATA Antivirus
Panda Antivirus
AVAST!

F-Prot
PC
Tools AntiVirus
Webroot
Antivirus
ViRobot

CyberScrub
AntiVirus
The
Shield Antivirus
WinAntiVirus

Windows Live OneCare

AMU 2008 Test courses results

2008-06-10T15:32:00.001+05:30

AMU 2008 Test Results

B. Arch.
B.A.L.L.B.
B.C.A./B.I.T./B.C.M.
B.Ed.
B.E. Evening
B.Lib.
B. Sc. (Hons.) Indus. Chemistry
B.Tech.
C.E.T.
D.C.P.
Dip. in Gen. Nursing
L.L.M .
M.B.A./M.B.A.(IB)
M.B.B.S. / B.D.S.
M.C.A.
MD/MS/PG Dip.
M.Ed.
M.Lib.
M.A Mass Comm.
M.S.W. (Final)
XI/Dip. Engg.

All the above courses results can be found at this link.

Learn ASP.NET

2008-05-31T08:38:00.005+05:30

Here are the links which helps you to get started learning ASP.NET

1. Learn ASP.NET
2. Free videos to understand you better Free ASP.NET Videos
3. ASP.NET FAQs Get It
4. ASP.NET
5. For any technical queries join to this forum

Note: If you know some more resources for learning ASP.NET please add a comment.

UP Board Xth Results declared

2008-05-30T13:00:00.002+05:30

UP Board Xth Results declared on 30th May 08.
Click to Get it

Best of Luck guys !!!

CBSE 2008 Xth Results

2008-05-29T07:55:00.002+05:30

CBSE Xth Results declares. you can get your results at following links.
www.cbse.nic.in
www.mtnldelhi.in
or www.results.nic.in

Bust of luck guys !!!

Double click on Drive goes to search

2008-05-28T22:37:00.003+05:30

Today I stuck with "when I clcik any drive it goes to search insted of opening it".
After a little search I get the solutions.
Problem occurs when you do some thing like that
Folder Options -> File Types --> Advanced (for Drive) --> Change Icon.

The problem occurs when you save this setting and the default value reset to some thing else.

To fix this problem
Go to
Regedit
HKEY_CLASSES_ROOT
Drive\Shell (in case of Drive)
Directory\Shell(in case of folders)
Edit shell value to none.
Close
Quit from registry

You did it.

CPMT 2008 Results

2008-05-28T14:46:00.002+05:30

CPMT 2008 results have been declared.

Link -> http://www.luresults.org/index.cpmt.php

Best of Luck guys!!!

Free Downloads

2008-05-27T12:38:00.006+05:30

Here are the list of free downloads:-
Standard C & C++ Editor:
To direct
download you could click in the below image
too.

Java editor v1.12

What do you can with Java editor.
edit java code ( move or copy marked text by dragging, search for
text, cut, copy, paste, undo, autoindent and "smart tabs" modes ...)
compile,jump in to error row/column
run application,
create HTML template for applet,
run applet
Note: you must have installed Java 2 SDK. Java
editor uses Java SDK's compiler, interpreter and applet viewer.

Download
here Free HTML Editor

JavaScript Editor

Click here to Download

Free FLV Player

Moyea FLV Player
is an easy-to-use desktop FLV playe for the desktop playback of FLV files in a controllable
mode, Files both from the local and the online video url can be accessed. Moreover,
the FLV videos playlist and favorites management make it convenient for you to organize
the FLV files, Support full screen mode, Quick thumbnail picture capturing, and
current screen saving can help you to get your favorite pictures from the video
in no time. Ultimately, it is totally for free!

Click here to Free Download

Photoscape: Free Photo Editing Software

Click here to Download
Vedio Composing Software

Down Load Here

Download the latest version of Adobe Reader

Adobe
Shockwave Player v11.0.0.0 More than 400 million Web
users have installed Adobe Shockwave Player in mature markets around the world.
These people now have access to some of the best the Web has to offer - including
dazzling 3D games and entertainment, interactive product demonstrations, and online
learning applications. Shockwave Player displays Web content that has been
created by Adobe Director. You could install from below too.

Adobe Shockwave Player

: Microsoft Windows Live OneCare is a >comprehensive and
integrated PC health service that helps protect and maintain your computer with
antivirus, firewall, PC maintenance, and file backup and restore functionality.
This new service is in beta testing.
Download Here

:CyberLink PowerDVD 8.0 Final :PowerDVD
is a software DVD player that offers the solution to enjoy personalized DVD entertainment
on the PC. Its high quality video and audio playback has made it one of the most
reliable. Download

:Mozilla Firefox 3.0 Beta 5 for Windows
:Firefox is a free, open-source web browser for Windows,
Linux and Mac OS X and is based on the Mozilla codebase. It is small, fast and easy
to use, and offers many advantages over Internet Explorer, such as the ability to
block pop-up windows

:Winamp
5.531 Build 1938 Full

>Nullsoft Winamp is a fast, flexible, high-fidelity music player for Windows. Winamp
supports MP3, CD, Audiosoft, Audio Explosion, MOD, WAV and other audio formats,
custom appearances called skins, plus audio visualization and audio effect plug-ins.

Nokia PC Suite 6.86 Release 8

Nokia PC Suite is a package of Windows-based PC applications developed especially
for use with Nokia phones. Depending on your phone model, Nokia PC Suite lets you
edit, synchronize and back up many of your phone's files on a compatible PC through
a cable or wireless connection.

RealPlayer 11.0.0.442 Gold >Easy, Fun
& Intuitive: Browse the web, organize audio & video files, create playlists,
& more

Virtual CloneDrive 5.3.0.0 BETA Virtual
CloneDrive works and behaves just like a physical CD/DVD drive, however it exists
only virtually. Image files generated with CloneDVD or CloneCD can be mounted onto
a virtual drive from your hard-disk or from a network drive and used in the same
manner as inserting them into a normal CD/DVD drive.

Probably the best virtual drive software, Virtual CloneDrive allows you to enjoy
the freedom of a virtual drive

K-Lite Codec Pack 3.8.5 Full
: K-Lite Codec Pack is a collection of codecs and related tools. Codecs are required
to encode and/or decode (play) audio and video. The K-Lite Codec Pack is designed
as a user-friendly solution for playing all your movie files. With the K-Lite Codec
Pack you should be able to play 99% of all the movies that you download from the
internet. The K-Lite Codec Pack works on Windows 2000/XP/2003/XP64/Vista.

Norton
AntiVirus 2008 v15.5.0.23 Norton AntiVirus from Symantec
is one of the best anti-virus software titles in the world. Enjoy the security of
automatic protection against viruses, malicious ActiveX controls and Java applets,
and other dangerous code. It protects you while you're surfing the Internet or getting
information from floppy disks, CDs, or a network. It also automatically scans incoming
attachments in the most popular email programs.

Corel WinDVD Plus v9.0 >Enjoy state-of-the-art
HD-quality upscaling. Watch your movies on the go with advanced laptop enhancements.
Play home movies from AVCHD camcorders. For those who want the best, WinDVD 9 offers
the ultimate DVD and video playback experience.

Opera 9.27 Build 8841 Final >The most
full-featured Internet power tool on the market, Opera includes pop-up blocking,
tabbed browsing, integrated searches, and advanced functions like Opera's groundbreaking
E-mail program, RSS Newsfeeds and IRC chat. And because we know that our users have
different needs, you can customize the look and content of your Opera browser with
a few clicks of the mouse

Apple Safari 3.1 Final for Windows Experience
the web, Apple Style, with Safari - the fastest, easiest to use web browser in the
world. With its simple, elegant interface, Safari gets out of your way and lets
you enjoy the web - up to 2 times faster than Internet Explorer. Now on Windows,
too.

Google
Picasa 2.7 Build 37.49 Picasa is software that makes it
easy and fun to view, organise, edit and share the digital photos on your PC.Picasa
lets you pick the size and then automatically attaches your pictures. Browse through
all your pictures and view slideshows of your albums with the click of a button.
Enhance, fix red-eye, and even crop without losing data or permanently changing
your original picture

ACDSee Photo Editor 2008 5.0.244 Beta Make
the most of your photos! Photo Editor has all the tools and clear instruction you
need to turn your digital photos into truly captivating keepsakes. Frame-worthy
memories and creative projects such as scrapbook pages, greeting cards, and invitations
are all easy to achieve. You'll be amazed at what you can do with your photos.

Internet Explorer 8 Beta 1 for Windows Vista
64-Bit

Internet Explorer 8 Beta 1 for Window XP SP2

Internet Explorer 8 Beta 1 for Windows Server 2003
64-Bit

Internet Explorer 8 takes the Web experience beyond the page and introduces a
new way to seamlessly experience the power of the Web whether you are a Web developer
writing

to standards, or an end user discovering a new online service.

Windows XP Service Pack 3 Build 3311 RC2

Microsoft Windows XP Service Pack 3 (SP3) provides new proactive security technologies
for Windows XP to better defend against viruses, worms, and hackers along with increased
manageability and an improved experience for users.
Microsoft
Windows XP Service Pack 3 fixes a range of bugs in Windows XP. It doesn't matter
what XP updates you have previously applied to your system, SP3 will update any
unpatched, partially patched or completely updated system (it includes all previously
released patches and updates). XP SP3 fixes the security holes so you won't get
attacked.

F-Secure
Anti-Virus Client Security v7.11 Build 107

F-Secure Anti-Virus Client Security offers protection against new breeds of threats.
It is a centrally-managed solution consisting of tightly-integrated virus protection,
spyware protection, desktop firewall, and intrusion prevention and application control
software for desktop and laptop computers.

WinRAR 3.71 Final Regged >WinRAR is a 32-bit
Windows version of RAR Archiver, an archiver and archive manager. RAR files can
usually compress content by 8 percent to 15 percent more than ZIP files can. WinRAR's
main features include strong general and multimedia compression, the ability to
process non-RAR archive formats, ZIP compression and decompression, support for
long filenames, programmable self-extracting archives (SFX), repair of damaged archives,
authenticity verification, embedded file comments, and encryption. Unicode is supported
in archive filenames, allowing non-English filenames to be handled painlessly. You
can manipulate the parameters of many archives at once and view a volume sequence
as a single archive. WinRAR can convert other archive formats to RAR and search
for specified text and files in archives.
FREEWARES

Mycpu113.zip
MyCPU is a small and simple utility that displays the type of CPU installed on your
system. It shows vendor, type, model, stepping and speed information and in addition,
it scans for features like MMX, 3dnow and SIMD (ISSE). and is able to read cache
information such as the size of the L1-data and more. (Size: 46 KB)

IP_Netinfo.zip

IPNetInfo is a small utility that allows you to easily find all available information
about an IP address: The owner of the IP address, the country/state name, IP addresses
range, contact information (address, phone, fax, and email). This utility can be
very useful for finding the origin of unsolicited mail. (Size: 47 KB)

Clean My Registry 3:The
Windows Registry is a crucial part of your PC's operation system. Regular use of
computer makes the registry fragmented and cluttered with obsolete and invalid data.
Clean My Registry software keeps this critical part of your PC in perfect condition.
Just clean registry in a blink of an eye for free. (Size: 620 KB)

Scrubxp.zip

ScrubXP cleans temporary files and registry keys resulting from opening files and
or using the Internet. It removes IE History, IE Temporary Files, IE Cookies, Documents
List from Start Menu, Empties Recycle Bin, Clears Autocomplete Entries, Clears Recent
File Lists for Run, Common Dialogs, Recent Documents, Search Assistant, Typed URLs,
Paint, Find Computer, Printer Ports, Find Files, Media Player, Previous Tasks, and
Real Player... (Size: 344 KB)

PdfEdit.zip >Create PDF files from any application
by simply selecting the print command. Preview documents, combine files, change
page orientation, add "Confidential" stamps, create PDF stationery, adjust
image resolution, summarize documents, convert PDFs to several image file formats,
create batch print jobs from Microsoft Office applications, and choose from several
file-naming methods. Encrypt or digitally sign your PDF documents. This download
contains all the features of PDF995, with additional support for PDF-to-HTML and
PDF-to-DOC conversions. (Size: 595 KB)

InternetSweeper.zip:Erase
information stored in Windows about Internet sites visited. This program is free
(although donations are appreciated) and fully functional. It automatically runs
when the computer boots, the user logs in, or browsers are closed. It works with
all 32-bit Windows programs and with all major browsers (Internet Explorer, Navigator,
Opera, and now AOL). It erases the cache, history, cookies, addresses, passwords,
and temporary files, and closes pop-up windows in browsers, including AOL. (Size:
96 KB)

CdKeyGrabber.zip

This tool can be used by System Administrators for identifying the Installed Windows
XP's CD Key on a machine. Just run this tool and it will just get you the installed
versions CD Key. This tool will a great addition to the system admins tool chest.
(Size: 12 KB)

Cdrecover.zip

This is a lossy disc copying program. Designed for recovering as much information
as possible from a corrupted file. The program is optimized for recovering corrupt
video data from CDs. Supports multiple file retrieval methods. Say goodbye to CRC
errors at the end of a file copy. (Size: 19 KB)

Himalaya
USB Modem Driver (12.4 KB)

Nyxem.E Virus
Removal Tool (1.05 MB)(for
any version of Windows XP)

VMware Workstation 6.5 Build 84113 Beta

DivX Codec 6.8.2 Beta 1

2008 Results Links

2008-05-19T14:54:00.009+05:30

CBSE 12th Results have been declared on 23rd May
CBSE 2008 Results
UP Board results will be declared today ie 24th May.
UP Board 2008 Results
Results across all over india

BHU announces results for PMT and PAT.
PMT
PAT

AMU Results
Test Courses
Non Test Courses

How to log Events from ASP

2008-05-05T18:40:00.001+05:30

How to write Events to eventlog by ASP

Open run command à Type notepad

Open notepad à Type/Copy/Paste the code below into the notepad and save as Test.asp.

<%@ Language=VBScript %>

<HTML>

<BODY>

<% 'Use these Constants to designate the type of Event Log.

const SUCCESS = 0

const ERROR = 1

const WARNING = 2

const INFORMATION = 4

const AUDIT_SUCCESS = 8

const AUDIT_FAILURE = 16

dim WshShell set WshShell = Server.CreateObject("WScript.Shell")

wshshell.Logevent WARNING, " Event Logged Successfully by Windows Script Host!"

set wshshell=nothing

Response.write "Event Logged Successfully by Windows Script Host!" %>

</BODY>

</HTML>

Now copy the test.asp and place into C:\Inetpub\wwwroot à hit the browser as http://localhost/test.asp

create a folder name Test and put this test.asp into this folder. Right click on Test folder à Click Web Sharing Tab à Share This Folder àKeep Name as Test à Apply OK. à Now hit http://localhost/test/test.asp

Now open run command à Type eventvwr à See application events à You will get logged your events to EventLog

Enjoy J

Ref: For more information visit http://support.microsoft.com/kb/301309

How to write Text / Trace / Log file using ASP?

2008-04-24T16:08:00.000+05:30

How to write Trace file using ASP?

Previously I wrote for how to write text file with ASP , Now one step forward how to write trace file with ASP?

So here we goes.

Create a text file .

1. Create an File system object that is used for File Access

2. Get the File Path

3. Create the file if not exist.

4. Open the File

5. Log the Server Variables

6. Close the File object release all memory

set FSO = Server.CreateObject("scripting.FileSystemObject")

Dim filePath

filePath = Server.MapPath("Trace.txt");

set myFile = fso.CreateTextFile(filePath ,8, true) 'Here 8 means we using for appending

myFile.WriteLine(Request.servervariables("SERVER_NAME"))

myFile.WriteLine(Request.servervariables("SCRIPT_NAME"))

myFile.WriteLine("Write more looging tuff")

myFile.Close

How to write text file using ASP?

2008-04-24T10:44:00.000+05:30

How to write text file using ASP?

Previously I wrote for how to write text file with C#, Now one step back how to write text file with ASP?

So here we goes.

set FSO = Server.CreateObject("scripting.FileSystemObject")

This line creates an object that is used for File Access

set myFile = fso.CreateTextFile("C:\Trace.txt", true)

This creates a blank text file object for us to use.The CreateTextFile object creates a text file, based on what we specified. The first option specifies the location of the text file, while the second one states whether or not to create the file if one doesn't exist. Very simple methods.

Next, we do something simple

myFile.WriteLine("Write whatever you want to put")

myFile.WriteLine("Write some more stuff")

WriteLine writes the text to the text file.

myFile.Close

This closes the file and free the memory.

Now for Reading:

First, we create an object, but not after defining some constants

Const ForReading = 1, ForWriting = 2, ForAppending = 8

This just allows us the different methods of working with text, when we have an open text file.

set fso = server.CreateObject("Scripting.FileSystemObject")

Here we create our object again.

set f = fso.GetFile("C:\Trace.txt")

Here we state that we will be manipulating the file C:\Trace.txt . Moderately simple. Now we need to open it as a stream. Get ready, here comes the hard stuff ;-)

set ts = f.OpenAsTextStream(ForReading, -2)

This creates a text stream with our file. It is like a continous flow of information. Now we jsut read a line

TextStreamTest = ts.ReadLine

This code reads a line of information, and puts it into TextStreamTest. Pretty simple, isnt it?! I hope so. Anyway, I've discussed the code, and I shall let you go.

One last note. Let's say you wanted to read all the contents out a text file. Then you would do this

Do While not ts.AtEndOfStream

myText = myText & ts.ReadLine & vbCrLf

Loop

Hope you learn something !! Write your comments !! Thanks !!

Writing Log to Text File with C#

2008-04-23T13:09:00.001+05:30

Writing Text File with C#

Problem definition : I need to write this for logging for testing purpose. I am logging the information when a aspx file is being called,

I want to put all information like browser, os, resolution, referer page etc.

So here we goes

I like to add a method let it call LogToFile()

Don't forget to include #using System.IO; as we are going to use stream writer

protected void LogToFile()

{

string logFilePath = Server.MapPath("Trace.txt");

StreamWriter sw = new StreamWriter(logFilePath, true);

//true means if file not there then create it otherwise append to it.

try

{

sw.WriteLine("Logging Time: " + DateTime.Now.ToLongDateString());

sw.WriteLine("OS/Browser/Version : "+Request.Browser.Platform.ToString()+"/" +Request.Browser.Browser.ToString()+ “/"+Request.Browser.Version.ToString());

if (Request.UrlReferrer != null)

{

sw.WriteLine("Referrer: "+ Request.UrlReferrer.ToString());

}

sw.WriteLine("User Agent: " + Request.UserAgent.ToString());

sw.WriteLine("--------------------------------------------------------");

}

catch(Exception )

{

}

finally

{

if (sw != null)

{

sw.Close();

}

Now call this function into pageload method of your page... you will get the trace.

You can add more properties/ information according to your needs.

Enable pinging - Ping worker process every ( 30 seconds)

2008-04-22T12:31:00.001+05:30

Application Pools setting

Enable pinging – Ping worker process every (frequency in seconds)

This setting specifies that each worker process will be pinged every n seconds, where n is the number specified in the selection box. This process is used to determine if a worker process is running correctly, or if it has been deadlocked.

What it mean ?

Central to Health monitoring is process pinging. With process pinging, IIS periodically checks to see if worker processes are responsive. This means that the WWW Service (svchost.exe) sends a ping request at a specified interval to each worker process (w3wp.exe). If a worker process fails to respond to the ping request, either because it doesn’t have additional threads available for processing incoming requests or because it’s hung up, the WWW Service flags the worker process as unhealthy. If the worker process is in an idle but unresponsive state, the WWW Service terminates it immediately and a replacement worker process is created. Otherwise, the worker process is marked for recycling.

Free Tax Calculator 2008 2009 India

2008-04-17T12:50:00.001+05:30

In my previous post I could not upload the Tax Calculator, Here I did it and posted it again.

Please get if from HERE

Note this is for salaried personal only.

Tips on Filling your Vehicles

2008-04-17T10:04:00.001+05:30

This is a Message received from a friend:

I don't know what you guys are paying for petrol... but here in Durban, we are also paying higher, up to 47.35 per litre. But my line of work is in petroleum for about 31 years now, so here are some tricks to get more of your money's worth for every litre.

Here at the Marian Hill Pipeline, where I work in Durban, we deliver about 4 million litres in a 24-hour period thru the pipeline.

One day is diesel; the next day is jet fuel, and petrol, LRP and Unleaded. We have 34-storage tanks here with a total capacity of 16,800,000 litres.

ONLY BUY OR FILL UP YOUR CAR OR BIKKIE IN THE EARLY MORNING WHEN THE GROUND TEMPERATURE IS STILL COLD. Remember that all service stations have their storage tanks buried below ground. The colder the ground, the denser the fuel, when it gets warmer petrol expands, so buying in the afternoon or in the evening.... your litre is not exactly a litre.

In the petroleum business, the specific gravity and the temperature of the petrol, diesel and jet fuel, ethanol and other petroleum products play an important role. A 1degree rise in temperature is a big deal for this business. But the service stations do not have temperature compensation at the pumps.

WHEN YOU'RE FILLING UP, DO NOT SQUEEZE THE TRIGGER OF THE NOZZLE TO A FAST MODE. If you look, you will see that the trigger has three (3) stages: low, middle, and high. In slow mode, you should be pumping on low speed, thereby minimizing the vapours that are created, while you are pumping. All hoses at the pump have a vapour return. If you are pumping on the fast rate, some of the liquid that goes to your tank becomes vapour. Those vapours are being sucked up and back into the underground storage tank so you're getting less worth for your money.

ONE OF THE MOST IMPORTANT TIPS IS TO FILL UP WHEN YOUR TANK IS HALF FULL. The reason for this is, the more fuel you have in your tank, the less air occupying its empty space. Petrol evaporates faster than you can imagine. Petroleum storage tanks have an internal floating roof. This roof serves as zero clearance between the petrol and the atmosphere, so it minimizes the evaporation.

Unlike service stations, here where I work, every truck that we load is temperature compensated, so that every litre is actually the exact amount.

ANOTHER REMINDER, IF THERE IS A FUEL TRUCK PUMPING INTO THE STORAGE TANKS, WHEN YOU STOP TO BUY, DO NOT FILL UP - most likely the petrol/diesel is being stirred up as the fuel is being delivered, and you might pick up some of the dirt that normally settles on the bottom.

Hope, this will help you get the maximum value for your money.

DO SHARE THESE TIPS WITH OTHERS! LET’S SHARE INFORMATION AND BENEFIT ALL, FOR THE BETTER OF MANKIND.

A wonderful message for all who misuse their work phone : Joke

2008-04-11T14:39:00.000+05:30

Phone Bill

The phone bill was exceptionally high and the man of the house called a family meeting...

Dad: People this is unacceptable. You have to limit the use of the phone. I do not use this phone, I use the one at the office.

Mum: Same here, I hardly use this home telephone as I use my work telephone

Son: Me too, I never use the home phone. I always use my company mobile

Maid: I know I am the one to be blamed but what is the problem? We all use our work telephones.

TAX Calculator for Financial Year 2008 - 2009

2008-04-03T13:34:00.001+05:30

A quick tax calculator by Economics Times for year 2008 - 2009.

Please get it from here

Note: Only for employed person only

Linked bloggers

2008-04-01T17:46:00.000+05:30

Blogger List

At this page I wish to see a lot of information about blogs and their links.

Please write comment to add you blog here.

Computers & Internet

http://matespoint.blogspot.com Technical hurdles while development.

http://uiautomation.blogspot.com All about UI Automation information.

Education

http://up-results.blogspot.com Search Results, CPMT 2008, UP Board 2008 etc.

Fun and Entertainment

www.techieshangout.blogspot.com
http://worldofinfotainment.blogspot.com
http://rahul-games-movies.blogspot.com
http://teentweens.blogspot.com/

Personal

http://mohanitguy.blogspot.com
http://varunkrishna.blogspot.com
http://freakers-digest.blogspot.com/
www.sarv007.blogspot.com
http://mhkharish.blogspot.com
http://www.supershiva.blogspot.com
http://www.versatilecollection.blogspot.com
http://www.supershiva.blogspot.com

http://www.versatilecollection.blogspot.com

IT Technologies

http://itbuddy.blogspot.com
http://www.tech4logic.blogspot.com
www.goldnvk.blogspot.com
www.techieshangout.blogspot.com
http://theblogresource.blogspot.com
http://javabugger.blogspot.com
www.techieshangout.blogspot.com

Others

http://trusted-money-making-sites-for-asians.blogspot.com/

Note: These links remain there until you have this page into your blog. This applies for all, no discrepancy. If anybody wants to include his/her blog @ this page. He / She needs to include this page link into his/her page and leave a comment with his/her blog along the Category in which blog should be placed.

Proxy class generation from WSDL in .NET 2.0 and .NET3.0

2008-03-20T15:21:00.001+05:30

Proxy class generation from WSDL in .NET 2.0

The following command creates a .wsdl file for the XML Web service located at the specified URL and creates a client proxy class in the C# language for the XML Web service.

wsdl http://hostServer/WebserviceRoot/WebServiceName.asmx?WSDL

The following command creates a client proxy class in the C# language for an XML Web service located at the specified URL. The tool saves the client proxy class in the file myProxyClass.cs

wsdl /out:myProxyClass.cs http://hostServer/WebserviceRoot/WebServiceName.asmx?WSDL

For more visit to:

http://msdn2.microsoft.com/en-us/library/7h3ystb6(VS.71).aspx

Proxy class generation from WSDL in .NET 3.0

Use this command to generate proxy class from a web service.

WseWsdl3 http://hostServer/WebServiceRoot/WebServiceName.asmx?WSDL /out:MyProxyClass.cs

This will generate the class MyProxyClass.cs which we can include in our solution to create an object of this and then call the appropriate method.

For more visit to :

http://msdn2.microsoft.com/en-us/library/aa529578.aspx

Passing Data from one sp to other sp using Temp Table.

2008-03-04T18:04:00.001+05:30

Passing Data from one sp to other sp using Temp Table.

Hi,

Here I tried a trick, there may be others trick also to do the same.

CREATE PROCEDURE Proc_Record_Insertion

-- This #Temp1 table is defined in the other sp which I am using here.

INSERT INTO #Temp1(id,info) VALUES(1,'Mohammad')

INSERT INTO #Temp1(id,info) VALUES(2,'Irfan');

INSERT INTO #Temp1(id,info) VALUES(3,'matespoint@gmail.com');

INSERT INTO #Temp1(id,info) VALUES(4,'matespoint.blogspot.com');

-- This will create a sp Proc_TempTableCreate which create a Temp table and insert four recors into it.

CREATE PROCEDURE Proc_UseTempData

BEGIN

CREATE TABLE #Temp1

(id int,

info varchar(40) )

-- Executing the sp

EXEC Proc_Record_Insertion

SELECT * FROM #Temp1

END

Reading URL thru HttpRequest in C#

2008-03-04T18:02:00.001+05:30

Here is the sample code for reading Http request.

HttpWebRequest request = null;

string url = “http://matespoint.blogspot.com”

// Create web request

request = (HttpWebRequest)WebRequest.Create(url);

// Set value for request headers

request.Method = "GET";

request.ProtocolVersion = HttpVersion.Version11;

request.AllowAutoRedirect = false;

request.Accept = "*/*";

request.UserAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727)";

request.Headers.Add("Accept-Language", "en-us");

request.KeepAlive = true;

StreamReader responseStream = null;

HttpWebResponse webResponse = null;

string webResponseStream = string.Empty;

// Get response for http web request

webResponse = (HttpWebResponse)request.GetResponse();

responseStream = new StreamReader(webResponse.GetResponseStream());

// Read web response into string

webResponseStream = responseStream.ReadToEnd();

IF EXIST Vs COUNT(*) - SQL Server

2008-03-03T16:30:00.000+05:30

IF EXIST Vs COUNT(*)

Many times we see that people use count(*) to get the condition that if we have any record like

IF (SELECT COUNT(*) FROM Employee where Salaried =0 ) >0

BEGIN

PRINT 'Yes Got It'

-- Do your calculation here.

END

We are doing some calculation if we get Salaried=0 for at least once. And I know many times we use the same trick.

"The cost for getting the count(*) is that it counts all the data we get by where clause."

Use if exist to reduce this overhead.

IF EXISTS(SELECT * FROM Employee where Salaried =0)

BEGIN

PRINT 'Yes Get it'

-- Do your calculation here.

END

In this as soon as we get the first record further execution stops and it comes out of the if condition with true. If this not get any result then will cost same as above query.

Uses of GO in SQL

2008-02-25T19:10:00.000+05:30

Very interesting question, can anybody what will be the answer if we execute this query by selecting all at once.

DECLARE @Test1 int, @Test2 VARCHAR(20)

SET @Test1 = 1;

SET @Test2 = 'Character';

SELECT @Test1,@Test2

- Either it through an error

- Or Give 1 Character twice.

Yes – It will through error as @Test1 is undefined, because after GO it ends the scope of declaration of the variable.

Here we seen the scope of Variable declaring into SQL.

Getting all columns for a Table

2008-02-22T12:19:00.001+05:30

Using INFORMATION_SCHEMA View

Getting all columns for a Table

SELECT * FROM INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = '<TABLE NAME>'

Getting all constraints for a Table

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_NAME = '<TABLE NAME>'

Getting all check constraints for a Table

SELECT * FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS where CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_NAME = '<TABLE NAME>')

For more about INFORMATION_SCHEMA please visit (However this link is a kb for a bug still has enough pointers to go ahead)

http://support.microsoft.com/kb/294350

Happy learning

SilverLight 1.1 MediaElement Example

2008-02-20T15:49:00.001+05:30

Here are the links for SilverLight 1.1 MediaElement example.

Nice links to get hands on SilverLight 1.1

http://blogs.msdn.com/coding4fun/archive/2008/01/22/7163484.aspx

http://www.codeproject.com/KB/silverlight/SLFun.aspx

Do it and Have fun!

Mediaelement not showing the media.

2008-02-20T11:12:00.000+05:30

SilverLight 1.1 Media element not showing the media.

Mediaelement not working with my case, but may be these links will help in your case.

http://silverlight.net/forums/p/1532/8690.aspx#8690

http://silverlight.net/forums/t/2914.aspx

I am using like

It don’t showing any error but not showing the video also.

When I tried using http://sever/viz.wmv its giving download error ErrorType: 1001

Trying to get what may be the reason.

After a lot of hard work I get the problem.

The video file I was using having some problem, however this was working with media file. Funny na ?? So let check with other media file also, if you are facing the same problem.

mediaelement not showing the media.

2008-02-20T11:04:00.000+05:30

SilverLight 1.1 Media element not showing the media.

Mediaelement not working with my case, but may be this link will help in your case.

http://silverlight.net/forums/p/1532/8690.aspx#8690

I am using like

It don’t showing any error but not showing the video also.

When I tried using http://sever/viz.wmv its giving download error ErrorType: 1001

Trying to get what may be the reason.

Getting all the constraints for a Table

2008-02-15T11:13:00.001+05:30

How to get all the constraints for a table?

Sysconstraints table –

This is the table which contains the constraints which are defined on various tables.

If you query by – SELECT * FROM sysconstraints

You will get OUTPUT –

constid id colid spare1 status actions error

----------- ----------- ------ ------ ----------- ----------- ------

2099048 2133582639 6 0 2069 4096 0

11147085 1269579561 2 0 2067 4096 0

14623095 2130106629 6 0 2069 4096 0

27147142 1301579675 2 0 2067 4096 0

For details go to http://msdn2.microsoft.com/en-us/library/aa260399(sql.80).aspx

Now come to the actual point – getting all constraints for a table

SELECT OBJECT_NAME(constid) 'Constraint Name',

constid 'Constraint ID',

CASE (status & 0xF)

WHEN 0x1 THEN 'Primary Key'

WHEN 0x2 THEN 'Unique'

WHEN 0x3 THEN 'Foreign Key'

WHEN 0x4 THEN 'Check'

WHEN 0x5 THEN 'Default'

ELSE 'Undefined'

END 'Constraint Type',

CASE (status & 0x30)

WHEN 0x10 THEN 'Column Level'

WHEN 0x20 THEN 'Table Level'

ELSE 'Unknown'

END 'Constraint Level'

FROM sysconstraints

WHERE id=OBJECT_ID(‘TABLE_NAME’)

This will result to all the constraints applied to this table.

Error code 1001 silverlight

2008-02-12T15:25:00.000+05:30

While I run a silver light application, I get the

Silverlight error message

Error Code: 1001

Error Type: DownloadError

Message: AG_E_UNKNOWN_ERROR

Solution: Visit the following link

http://silverlight.net/forums/t/586.aspx

How to close secure connection

2007-12-19T12:08:00.000+05:30

I have two web service suppose A and B which should be call from an application, for this I am using Proxy class and meking the call. To get access these services one need to have client certificate. Now the problem is that when I calling the services one by one A and B one in one go , A is working but B is failing. But if i call both in one go [ofcourse one by one] both A and B work.

What may be the problem??

I think it is due to once connection is opened by A used by the B so both passes while in case of individual A and B fail. If we change the order of calling now the B fails , A passes.

Application Instance is already running in C#

2007-09-27T12:09:00.000+05:30

How to make sure that only one instance of application is running in C#

public static void Main(string[] args)

{

// ----------------------------------------------------

bool running;

Mutex mutex = new Mutex(true, “Your application name”, out running);

if (!running)

{

Console.WriteLine("Another instance is already running.");

Console.WriteLine (Messages.ExitMessage);

Console.ReadKey(false);

return;

}

// -----------------------------------------------------

Your all working code will go here

// -------- Don’t forget to include this

GC.KeepAlive(mutex); //1

mutex.ReleaseMutex(); //2

}

Note: Use only one either 1 or 2 both will works, but make sure one is present.

Now only one application will run at a time.

How to get the first not null column from a table?

2007-05-02T11:08:00.000+05:30

Hey , really a tricky question , select all the values into a single column from a table which is first not null in that table.
For Exapmle
There is table test

id	col1	col2	col3	col4
1	NULL	NULL	W	M
2	Q	NULL	R	NULL
3	NULL	W	P	T
4	NULL	NULL	NULL	S

Now I want to get the result like that in a single column
First Not NULL Values
W
Q
W
S

So what you think how can we get that,
First thing is that you can use cursor and loop each row and get them.
The second one is the use of COALESCE to get that

this query will get the result

SELECT COALESCE(col1,col2,colo3,col4) FROM TEST

If you have any query you can ask me at matespoint@gmail.com

Sending Email thru C#

2007-03-29T14:51:00.000+05:30

Sending email thru C#, .NET 2.0 , with attachment,

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Net.Mail;

namespace MailConnect
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Sendbutton_Click(object sender, EventArgs e)
{
MailMessage aMessage = new MailMessage("matespoint@gmail.com", "xyz@yahoo.com");
aMessage.Subject = "This is test message";
aMessage.Body = "Body text message";

Attachment aT = new Attachment("C:\files.doc");
aMessage.Attachments.Add(aT);
aT = new Attachment("C:\files.pdf");
aMessage.Attachments.Add(aT);

SmtpClient aClient = new SmtpClient(servername, 25);
aClient.DeliveryMethod = SmtpDeliveryMethod.PickupDirectoryFromIis;
aClient.Send(aMessage);
MessageLabel.Text = "Mail has been sent successfully";
}
}
}

Concatenate strings from a column into a single row?

2007-03-22T16:55:00.000+05:30

CREATE DATABASE Test1
Go
Use Test1
set nocount on
CREATE TABLE dbo.Test2
(
Col1 int identity,
Col2 varchar (5) default('aaaaa')
)
declare @loop
int set @loop = 1
while @loop <= 100
begin
insert into Test2 default values
set @loop = @loop + 1
end

Now you had create a Database Test1 and a Table Test2 with 100 records

Now concatenate this to a single string

DECLARE @ConcatString varchar(8000)
SELECT @ConcatString = COALESCE(@ConcatString + ',','' ) + CAST(Col1 as varchar(12))
FROM Test2
SELECT @ConcatString

You can find the same result by using ISNULL

DECLARE @ConcatString varchar(8000)
SELECT @ConcatString = ISNULL(@ConcatString + ',','' ) + CAST(Col1 as varchar(12))FROM Test2
SELECT @ConcatString

Enjoy .. .. better performance using this instead of using CURSOR.

Few Definitions

2007-03-16T13:58:00.000+05:30

School: A place where Papa pays and Son plays.
Life Insurance: A contract that keeps you poor all your life so that you can die Rich.
Nurse: A person who wakes u up to give you sleeping pills.
Marriage: It's an agreement in which a man loses his bachelor degree and a woman gains her masters.
Divorce: Future tense of Marriage.
Tears : The hydraulic force by which masculine willpower is defeated byfeminine waterpower.
Lecture: An art of transferring information from the notes of the Lecturer to the notes of the students without passing through "the minds of either"
Conference: The confusion of one man multiplied by the number present.
Compromise : The art of dividing a cake in such a way that everybody believes he got the biggest piece.
Dictionary : A place where success comes before work.
Conference Room : A place where everybody talks, nobody listens and everybody disagrees later on.
Father : A banker provided by nature.
Criminal: A guy no different from the rest....except that he got caught.
Boss : Someone who is early when you are late and late when you are early.
Politician : One who shakes your hand before elections and your Confidence after.
Doctor : A person who kills your ills by pills, and kills you by bills.
Classic : Books, which people praise, but do not read.
Smile : A curve that can set a lot of things straight.
Office : A place where you can relax after your strenuous home life.
Yawn: The only time some married men ever get to open their mouth.
Etc .: A sign to make others believe that you know more than you actually do.
Committee : Individuals who can do nothing individually and sit to decide that nothing can be done together.
Experience: The name men give to their mistakes.
Atom Bomb : An invention to end all inventions.
Philosopher : A fool who torments himself during life, to be spoken of whendead

Hope you enjoy ... Have fun ...

Write your definitions if you want to share one

Application Domain

2007-03-16T11:56:00.000+05:30

An Application Domain is a light weight process and provides a logical and physical isolation from another .NET application.

This ensures that the Applications can work independent and isolated of each other. An Application Domain is created by the Common Language Runtime (CLR) and it ensures that if one Application Domain crashes or goes down, it does not in any way effect the functioning of another Application Domain.
Multiple .NET applications can be executed in one single process by loading these applications in separate Application Domains.
Several threads can be executing in a single application domain at any given time and a particular thread is not confined to a single application domain. In other words, threads are free to cross application domain boundaries and a new thread is not created for each application domain.
The following are the benefits of Application Domains.
Isolation of code, data and configuration information of one application from another
A failure in one application will not affect the other

Abstract Class Vs Interface

2007-03-16T11:47:00.000+05:30

Abstract Class Vs Interface

There are a lot of discussion on the internet about the Interface vs Abstract class. and also , as BASE class whether we should use interface, abstract class or normal class.
Abstract Class vs Interface

We can not make instance of Abstract Class as well as Interface.
Here are few differences in Abstract class and Interface as per the definition.
Abstract class can contain abstract methods, abstract property as well as other members (just like normal class).
Interface can only contain abstract methods, properties but we don’t need to put abstract and public keyword. All the methods and properties defined in Interface are
by default public and abstract.

using System;
namespace ConsoleApplication2
{
///

/// Summary description for Class2. ///

public abstract class A
{
int someInt;
string someString;
public A()
{ // // TODO: Add constructor logic here // }
public abstract void F();
}

public class B : A
{
public override void F()
{ Console.WriteLine("F in B"); }
}

interface IA
{

//int someInt; give error we cant have fields in interface
//string someString;
string P{get;set;}
void F();
}
public class C : IA
{
public C() { }
public string P
{
get {return _p;}
set {_p = value;}
}
public void F()
{
Console.WriteLine("Abstract F()");
}
private string _p; }
}

we can make the call like this..
B b = new B();
b.F();
A a = b;
a.F();
//A a = new A(); will give error as we cant instantiate
C c = new C();
c.F();
c.P="Test String";
Console.WriteLine(c.P.ToString());
IA d = c;
d.F();
Console.WriteLine(c.P.ToString());
Console.Read();

Output :
F in B
F in B
Abstract F()
Test String
Abstract F()
Test String

We can see abstract class contains private members also we can put some methods with implementation also. But in case of interface only methods and properties
allowed.
We use abstract class and Interface for the base class in our application.Now most important question: What should use : Interface force everybody to implement all things in that. So use it when u wanna force all the methods, properties, etc to implement.Abstract Class - limited you to create an instance of this class, and if you derived from this class you have to implement all abstract members to create an instance of this derived class. Also Abstract class should used when you have some functions which you must override and some which you can leave in this scenerio use abstract classes,

Difference between out and ref - out vs ref

2007-03-01T18:22:00.000+05:30

In the case of Ref - assignment is needed before passing to the function
In the case of Out - no assignment is required, but you must assign a value in which function this is passed,
For Ex:
using System;
namespace ConsoleApplication2
{
///

/// Summary description for Class1.
///

class Class1 {
public static void Foo_Ref(ref int i)
{
//i = 2; //Dont gives a error
}
public static void Foo_Out(out int i)
{
//i=3; //it gives an error i must be assigned before leaving this function.
}
public static void Test()
{
int a ; Foo_Ref(ref a); //it gives an error coz a is not assigned a value
Console.WriteLine("Ref Case {0}",a);
Foo_Out(out a);
Console.WriteLine("Out Case {0}",a);
}
[STAThread] static void Main(string[] args)
{ //return MessageBoxA(0,"Hello Irfan","Caption",0);
Test();
Console.Read();
}
}
}

This is my first Post on my Blog

2007-02-28T17:23:00.000+05:30

Hi,

I, Mohammad Irfan, welcomes you at my blog, and also thanks you for your time. This is my first post and hence I just want to introduce my self.

Well, I am Mohammad Irfan, holding a Master Degree in Computer Science and a Bachelor Degree in Physics (Hons.) from AMU in 2004 and 2001 respectively. I did my schooling from various parts of UP, like Azamgarh, Kushi Nagar, Deoria, Basti and Siddhartha Nagar, basically all these Districts are in East UP.

My interests include playing cricket, watching movies, surfing net and explore to new technologies{actually trying to do it}.

This is my first step towards being connected to the word.

In my blog, I just want to put everything which I find interesting irrespective of which categories it shoud be.

Thanking you.
Irfan
{matespoint@gmail.com}