If you dont have dreams, you have nothing
Archive for July, 2007
I love this poem what u think about that
Posted in postive thinking on July 25, 2007 | Leave a Comment »
how to upload larger files in asp.net 2
Posted in .net framework 2, asp.net 2 on July 23, 2007 | 4 Comments »
by default asp.net application did not upload file more than 4.5 mb or 4 mb. For this purpose You have to add following http runtime tag in web.cofig of web site.
<httpRuntime executionTimeout=“90“ maxRequestLength=“20096“useFullyQualifiedRedirectUrl=“false“ minFreeThreads=“8“ minLocalRequestFreeThreads=“4“appRequestQueueLimit=“10000“;/>
you have to change two setting in above code.MaxRequestLength (Here you mention the size limit of file , bydefault it is 4 mb) [...]
A beatiful song from Sain Zahoor.
Posted in Favorites on July 19, 2007 | Leave a Comment »
I hear a sweet song on youtube. I feel it in my soul when i hear it. all the night i continuosly hearing while learning php alone in my room at very hot day of july. This song is aslo theme song from movie Khuda Ke Liye (In the Name of God) .
[...]
database level paging in Tsql 2005 with common table expression
Posted in Sql Server 2005 on July 11, 2007 | 1 Comment »
In MSSQL 2000 we used to do paging either by dynamic sql or by some
advanced techniques like the example with rowcount.
In MSSQL 2005 with the introduction of ROW_NUMBER
function life is a lot easier.
DECLARE @PageNum AS INT;
DECLARE @PageSize AS INT;
SET @PageNum = 2;
SET @PageSize = 10;
WITH OrdersRN AS ( [...]
Common Table Expression
Posted in Favorites on July 11, 2007 | Leave a Comment »
There’s a good article here by Frank Kerrigan on a way to implement paging in SQL Server 2005 by using Common Table Expressions (CTE’s).
What are CTE’s? This is a new feature of SQL Server 2005 that helps you eliminate temp tables and cursors in your queries. You can generate some pretty amazing queries using recursive [...]
how to remove Html tags from string in c#
Posted in .net framework 2, asp.net 2 on July 5, 2007 | 27 Comments »
use this function
public string Strip(string text)
{
return Regex.Replace(text, @”<(.|\n)*?>”, string.Empty);
}