If you are looking for free online tutorials to learn ASP.NET MVC 3 basics then you should check out ASP.NET MVC site. Microsoft has made arrangements with Pluralsight to provide many on-demand videos free of charge.
Link: ASP.NET MVC
8. Leveraging the ASP.NET Runtime
10. Deployment & Configuration
Walking on water and developing software from a specification are easy if both are frozen.
– Edward V Berard
If you hate that slight flicker in IE browser between page transitions then you will find this snippet useful.
When user navigate from one page to another in IE, there is slight “white out” before this transition. Whereas in Firefox and other browsers this page transition is very smooth. IE browser will show blank page for very short duration before showing content of next page. User experience this effect more like flicker on the browser. If your web application has more post backs then it become more annoying to users.
To reduce this flicker in IE, simple add below META tags in HEAD section of your page.
<META http-equiv="Page-Enter" content="blendTrans(Duration=0.05)" /> <META http-equiv="Page-Exit" content="blendTrans(Duration=0.05)" />
By reducing the duration between fading previous content and revealing new content, user experience relatively smooth transition between pages.
This snippet has only impact on IE and not on other browsers.
Here is small javascript snippet you will find useful for your web application. It will automatically logout user after specific time of inactivity.
<script type="text/javascript"> var timer; var wait=10; document.onkeypress=resetTimer; document.onmousemove=resetTimer; function resetTimer() { clearTimeout(timer); timer=setTimeout("logout()", 60000*wait); } function logout() { window.location.href='Logout.aspx'; } </script>
Code is self explanatory. We are using setTimeout method which will call a function (logout function in above case) after specified delay in milliseconds. With that, we also resetting that again and again for every user movement on page.
You just need to drop this code in all pages (except login and unsecured pages) of your application. Master page is good place instead for easy maintenance.
Before login off user from application, you may also like to alert user first. So let’s extend above code further. This gonna be bit tricky as we cannot use simple javascript alert to show this message. Instead we will create a DIV layer in the page and use it for showing alert message. Any user interaction will hide this alert message. After specific time of inactivity, user will navigate to Logout.aspx page where you can provide actual implementation to logout user and clear all session objects.
Here is modified code:
<html> <head runat="server"> <title>Default Page</title> <script type="text/javascript"> var timer1, timer2; document.onkeypress=resetTimer; document.onmousemove=resetTimer; function resetTimer() { document.getElementById('timeoutPopup').style.display='none'; clearTimeout(timer1); clearTimeout(timer2); // waiting time in minutes var wait=10; // alert user one minute before timer1=setTimeout("alertUser()", (60000*wait)-1); // logout user timer2=setTimeout("logout()", 60000*wait); } function alertUser() { document.getElementById('timeoutPopup').style.display='block'; } function logout() { window.location.href='Logout.aspx'; } </script> <style type="text/css"> #timeoutPopup { display:none; position:absolute; top:0; right:0; bottom:0; left:0; width:30%; height:30%; margin:auto; padding:4px; border:solid 1px #999999; background-color:#dddddd; text-align:center; } </style> </head> <body> <form id="form1" runat="server"> <div id="timeoutPopup"> Your session is about to expire if there is no additional activity. </div> </form> </body> </html>
I was looking for TSQL implementation which can build JSON payload directly from database. After couple of failed search, I decided to create my own stored procedure which can render JSON based for any query passed as parameter. After few keystrokes in SQL Server Management Studio, I have this semi-finish stored procedure which I thought you will find useful.
CREATE PROCEDURE [dbo].[GetJSON] ( @ParameterSQL AS VARCHAR(MAX) ) AS BEGIN DECLARE @SQL NVARCHAR(MAX) DECLARE @XMLString VARCHAR(MAX) DECLARE @XML XML DECLARE @Paramlist NVARCHAR(1000) SET @Paramlist = N'@XML XML OUTPUT' SET @SQL = 'WITH PrepareTable (XMLString) ' SET @SQL = @SQL + 'AS ( ' SET @SQL = @SQL + @ParameterSQL+ ' FOR XML RAW, TYPE, ELEMENTS ' SET @SQL = @SQL + ') ' SET @SQL = @SQL + 'SELECT @XML = XMLString FROM PrepareTable ' EXEC sp_executesql @SQL, @Paramlist, @XML=@XML OUTPUT SET @XMLString = CAST(@XML AS VARCHAR(MAX)) DECLARE @JSON VARCHAR(MAX) DECLARE @Row VARCHAR(MAX) DECLARE @RowStart INT DECLARE @RowEnd INT DECLARE @FieldStart INT DECLARE @FieldEnd INT DECLARE @KEY VARCHAR(MAX) DECLARE @Value VARCHAR(MAX) DECLARE @StartRoot VARCHAR(100); SET @StartRoot = '<row>' DECLARE @EndRoot VARCHAR(100); SET @EndRoot = '</row>' DECLARE @StartField VARCHAR(100); SET @StartField = '<' DECLARE @EndField VARCHAR(100); SET @EndField = '>' SET @RowStart = CharIndex(@StartRoot, @XMLString, 0) SET @JSON = '' WHILE @RowStart > 0 BEGIN SET @RowStart = @RowStart+Len(@StartRoot) SET @RowEnd = CharIndex(@EndRoot, @XMLString, @RowStart) SET @Row = SubString(@XMLString, @RowStart, @RowEnd-@RowStart) SET @JSON = @JSON+'{' -- for each row SET @FieldStart = CharIndex(@StartField, @Row, 0) WHILE @FieldStart > 0 BEGIN -- parse node key SET @FieldStart = @FieldStart+Len(@StartField) SET @FieldEnd = CharIndex(@EndField, @Row, @FieldStart) SET @KEY = SubString(@Row, @FieldStart, @FieldEnd-@FieldStart) SET @JSON = @JSON+'"'+@KEY+'":' -- parse node value SET @FieldStart = @FieldEnd+1 SET @FieldEnd = CharIndex('</', @Row, @FieldStart) SET @Value = SubString(@Row, @FieldStart, @FieldEnd-@FieldStart) SET @JSON = @JSON+'"'+@Value+'",' SET @FieldStart = @FieldStart+Len(@StartField) SET @FieldEnd = CharIndex(@EndField, @Row, @FieldStart) SET @FieldStart = CharIndex(@StartField, @Row, @FieldEnd) END IF LEN(@JSON)>0 SET @JSON = SubString(@JSON, 0, LEN(@JSON)) SET @JSON = @JSON+'},' --/ for each row SET @RowStart = CharIndex(@StartRoot, @XMLString, @RowEnd) END IF LEN(@JSON)>0 SET @JSON = SubString(@JSON, 0, LEN(@JSON)) SET @JSON = '[' + @JSON + ']' SELECT @JSON END
To use this stored procedure, just pass TSQL query as parameter. Something like this:
EXEC GetJSON 'SELECT * FROM dbo.Employee_TBL'And this stored procedure will return JSON payload:
[{"UserId":"7C92EB27-DD81-498E-82CE-18192C940328","FirstName":"Bill","LastName":"Gates","Age":"45","LastLogin":"2008-11-02T00:00:00"},{"UserId":"58E75687-8D0F-423A-8A76-4B1D750F62FD","FirstName":"Steve","LastName":"Job","Age":"52","LastLogin":"2008-10-17T00:00:00"}]
Recent Comments