Aspdotnetinterviewquestions

Difference Between Dispose() and Close()
The basic difference between Close() and Dispose() is, when a Close() method is called, any managed resource can be temporarily closed and can be opened once again. It means that, with the same object the resource can be reopened or used. Where as Dispose() method permanently removes any resource ((un)managed) from memory for cleanup and the resource no longer exists for any further processing.
 
 1) Delegeates a)Why delegates we use.
 2) what are collection (HashTable, Array ,ArrayList etc)
 3) Sp and Function a.) Why a sp cannot be called inside function? if no
 4) Indexing.
5) select name starting with 's' without like (A:  select substring(EmpName,1,1),* from Employeemst where substring(EmpName,1,1)='s')
6) select highest salary without using top
7) Bind two dropdown without using dataset? if possible
8) Page life cycle.
9)
10)
11)