Month: June 2014

Don’t scroll whole page while scrolling

-View- 

<html>
  <head>
     <title>Title here</title>
  </head>
  <body>
      <div id="navbar" style="position:fixed;"></div>
      <div id="content>
      <div id="leftColumn"></div>
      <div id="centerColumn"></div>
      <div id="rightColumn"></div>    
  </div>
  </body>
</html>

-Javascript-

    $(window).scroll(function () {
        var scrollTop = $(window).scrollTop();
        if (scrollTop > 0)
            $('#leftColumn, #rightColumn').css('margin-top', scrollTop);
        else
            $('#leftColumn, #rightColumn').css('margin-top', scrollTop);
    });

P.S. Use this code if you just want to scroll center of the page Not left not right content just scroll center content of the page.

A union of two list

You can also use AddRange method.


var listB = new List<int>{3, 4, 5};  
var listA = new List<int>{1, 2, 3, 4, 5};

listA.AddRange(listB); // listA now has elements of listB also.

If you need new list (and exclude the duplicate), you can use union


  var listB = new List<int>{3, 4, 5};  
  var listA = new List<int>{1, 2, 3, 4, 5};
  var listFinal = listA.Union(listB);

If you need new list (and include the duplicate), you can use concat


  var listB = new List<int>{3, 4, 5};  
  var listA = new List<int>{1, 2, 3, 4, 5};
  var listFinal = listA.Concat(listB);

Textarea enter submit

 
<html lang="eng">
	<head>
		<title> Index Page </title>
		<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
		<script type"text/javascript">
		$(function(){
		$('#txtMessage').focus();
		
		$('#txtMessage').keydown(function(event){
		
		if(event.keyCode==13 && event.shiftKey) return;
		
		if(event.keyCode==13){
		var messageBody=$('#txtMessage').val();
		$('<p/>').html(messageBody).appendTo($('#content'));
		$('#txtMessage').val('').focus();
		event.preventDefault();
		}
		
		});
		
		});
		</script>
	</head>
	<body>

	<hr/>
	<hr/>
	
	<textarea id="txtMessage" col="50" rows="5" placeholder="Enter your message"></textarea>
	
	<div id="content" style="white-space:pre"></div>

	</body>
</html>

This script shows textarea enter submit , shift+enter is new line key also after submit shows place holder message again.

Shrink sql database transaction log file

 
--Database Name
USE Database_Name;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE Database_Name
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (Database_Name_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE Database_Name
SET RECOVERY FULL;
GO

When your sql database transaction log file is too big than shrink it . It will take about 30 second. You can run this script any time you want.

Sql row number usage

 
USE AdventureWorks2012;
GO
WITH OrderedOrders AS
(
    SELECT SalesOrderID, OrderDate,
    ROW_NUMBER() OVER (ORDER BY OrderDate) AS RowNumber
    FROM Sales.SalesOrderHeader 
) 
SELECT SalesOrderID, OrderDate, RowNumber  
FROM OrderedOrders 
WHERE RowNumber BETWEEN 50 AND 60;

PS: When you do not have increase identity number . You can use ms sql row number feature.