eRevolution

.net interview questions and answers  Here is link to interview question & answers forum . Very helpful link....

Updatepanel with fileupload control   If we use fileupload control to submit any file on our aspx page which having UpdatePanel control on it then if we click on submit button it will give you error & hasfile false & get null exception. To resolve this problem just add below code on aspx page : <Triggers> <asp:PostBackTrigger ControlID="btnSubmit" /> </Triggers> Hope this will help you... Regards, Gajanan

SQL query to get cumulative sum of column select Idcolumn, numericalcolumn, (select max(numericalcolumn)+numericalcolumn                                                     from  tblAnnexure                                                     where    tblAnnexure.Idcolumn< Ann.Idcolumn) as CumulativeSum         from    tblAnnexure Ann

ASP.Net Threading Inside the ASP.Net Worker Process there are two thread pools. The worker thread pool handles all incoming requests and the I/O Thread pool handles the I/O (accessing the file system, web services and databases, etc.). Each App Domain has its own thread pool and the number of operations that can be

ASP.NET Optimistic Concurrency Control   Nice article on concurrency. here is link of the article same I posted here : Have you ever got a call from a user telling you that he/she edited a record and that the changes made are lost? If so, maybe your application is implementing "Last in Wins" concurrency control.

How to format datetime & date in Sql Server 2005   Execute the following Microsoft SQL Server T-SQL datetime and date formatting scripts in Management Studio Query Editor to demonstrate the multitude of temporal data formats available in SQL Server. First we start with the conversion options available for sql datetime formats with century (YYYY or CCYY format). Subtracting 100 from the Style (format) number will transform dates without century (YY). For example Style 103 is with century, Style 3 is without century. The default Style values – Style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121 – always return the century (yyyy) format.

How to format datetime & date in Sql Server 2005   Execute the following Microsoft SQL Server T-SQL datetime and date formatting scripts in Management Studio Query Editor to demonstrate the multitude of temporal data formats available in SQL Server.