My Articles on DotNetSpider

I have been an active member of this site for a long time and in the course I wrote many articles based on common problems faced by developers. Below is a compiled list for your reference

How to Read Excel into Access Database Using ADO.Net and C#
In this article you can learn:-
1. Creating Access database from C# code
2. Reading Excel file into database
3. Drop table in Access database using code
4. Create table in Access database using code
5. Copy values from dataset to access table
You can access this article here

Implementing Session in WebService
This question is asked many times in interview..This is possible with System.Net.CookieContainer class
This article can be accessed here

Polymorphism
As per BOOCH " Poly means Many and Morphs means Forms" So Polymorphism is One thing and many forms. Polymorphism is of two types:-

a.) Compile Time Polymorphism
Compiler resolves the method calls at compile time. It can be achieved using Function overloading and Operator Overloading.
For Function Overloading refer
For Operator Overloading refer

b.) Runtime Polymorphism
Compiler resolves method calls at runtime. It can be achieved using Method Overriding and Casting.
To understand runtime polymorphism you need to have solid OOPS concepts. Below are my articles on OOPS. This is a four part series that will certainly shake your OOPS fundamentals

Part 1
Part 2
Part 3
Part 4

Multiple Active Result Set
MARS is a new feature in ado.net 2.0 and Sql Server 2005 that allows for multiple forward only read only result sets. With this feature in ADO.NET 2.0 you can have multiple active commands on one connection. By using MARS, you can open a connection to the database, open a new command and process some results, open a second command and process those results, then go back to the first command and process more results.

You can access complete article here

Events and Delegate Sample to Pass information from User Control to Main Page
This article talks about how to create custom events in user control to allow interaction with parent page.

This article can be accessed here