Wednesday 23 April 2014

Trigyn Asp.net Interview

New features in Asp.Net 3.5
http://www.dotnetcurry.com/ShowArticle.aspx?ID=96&AspxAutoDetectCookieSupport=1
http://www.tipsntracks.com/11/new-features-in-the-dotnet-framework-version-35.html
AutoEventWireup="true"
AutoEventWireup attribute in ASP.NET

The ASP.NET page framework supports an automatic way to associate page events and methods. If the AutoEventWireup attribute of the Page directive is set to true, the page framework calls page events automatically, specifically the Page_Init and Page_Load methods. In that case, no explicit Handles clause or delegate is needed.
• AutoEventWireup is an attribute in Page directive.
• AutoEventWireup is a Boolean attribute that indicates whether the ASP.NET pages events are auto-wired.
• AutoEventWireup will have a value true or false. By default it is true.
There is no event or method associated with Page_Load. Those events whose inline event is not there but that should be executed, for that purposed AutoEventWireup="true".
Httppostedfile
event handlers in sharepoint
ASP.NET HTTP Modules and HTTP Handlers Overview
typed dataset in .net
restart IIS.

http://www.beansoftware.com/ASP.NET-Tutorials/Restart-Stop-Application.aspx
Temp tables in SQL, # local temporary table, ## global temporary table
http://www.sqlteam.com/article/temporary-tables
http://www.codeproject.com/KB/database/TempTable.aspx
Ans) You'll notice I prefixed the table with a pound sign (#). This tells SQL Server that this table is a local temporary table. This table is only visible to this session of SQL Server. When I close this session, the table will be automatically dropped. You can treat this table just like any other table with a few exceptions. The only real major one is that you can't have foreign key constraints on a temporary table.
You can also create global temporary tables. These are named with two pound signs. For example, ##YakHerders is a global temporary table. Global temporary tables are visible to all SQL Server connections. When you create one of these, all the users can see it. These are rarely used in SQL Server.
Can I call a SP in Function?
Can I call a SP in SP?
Can I call a function in SP?
Can I Call a function in function?
What is 2nd normalization rule?
What is catching?
Can I use session in Web services?
What is error and exception?
Can I write try without Catch?
If get an exception in DAL, what I ‘v to do, whether I ‘v kill or through it.

Can I run one application in 2 modes (windows, and forms?)