Get start and end date of current week in C#

DayOfWeek day = DateTime.Now.DayOfWeek;
int days = day - DayOfWeek.Monday;
DateTime start = DateTime.Now.AddDays(-days);
DateTime end = start.AddDays(6);

Code from
http://www.codekeep.net/snippets/0d955fdd-ff9e-4403-90cb-15dac8391034.aspx

SQL SERVER: Function To Search Coma or Delimiter separated value in a column

We sometimes stores Coma or other delimiter separated values in a column, to search a particular value in that column, the following function will be helpful.

--30-jan-2009 Priyan R
CREATE FUNCTION [dbo].[IsExistInString]
(
 @Data VARCHAR(MAX),
 @Delim VARCHAR(100),
 @ValueToFind VARCHAR(MAX)
)
RETURNS BIT
AS
BEGIN
DECLARE @pos1 INT
DECLARE @pos2 INT
DECLARE @tbl_Split_Data TABLE
(
 Data VARCHAR(MAX)
)
 SET @pos1=1
 IF(CHARINDEX(@Delim,@Data,1)=0)
 BEGIN
  INSERT INTO @tbl_Split_Data VALUES(@Data) 
 END
 ELSE
 BEGIN 
  WHILE (@pos1<>0)  
  BEGIN  
   SET @pos2=CHARINDEX(@Delim,@Data,@pos1)
   IF(@pos2=0)
   BEGIN   
    INSERT INTO @tbl_Split_Data VALUES(SUBSTRING (@Data,@pos1,LEN(@Data)))
   END
   ELSE
   BEGIN
    INSERT INTO @tbl_Split_Data VALUES(SUBSTRING (@Data,@Pos1,@Pos2-@Pos1))   
   END
   IF(@pos2<>0) SET @pos2=@pos2+LEN(@Delim)
   SET @pos1=@pos2
  END  
 END
 SELECT @POS1=COUNT(*) FROM @tbl_Split_Data WHERE Data=@ValueToFind
 IF(@POS1<>0)
 BEGIN
  RETURN 1
 END
 RETURN 0
END

go
--eg
SELECT dbo.IsExistInString('one|$|two|$|three','|$|','one')

C# :Seconds TO String

This functions return a string like 1 hours ago, a day ago etc.

//Returns seconds to 1 hour ago, 10 sec ago etc.
        public static string SecondsToString(double seconds)
        {   

                   string time = "";        
                   if (seconds >= 3600)
                    {
                        time =Convert.ToInt32((seconds / 3600)).ToString();
                        if (seconds > 24)
                        {
                            time = Convert.ToInt32((seconds / 24)).ToString();
                            time += " days ago";
                        }
                        else
                            time += " hrs ago";
                    }
                    else if (seconds >= 60)
                    {
                        time = Convert.ToInt32((seconds / 60)).ToString();
                        time += " minutes ago";
                    }
                    else
                    {
                        time = Convert.ToInt32(seconds).ToString();
                        time += " sec ago";
                    }
                   return time;
        }

Programmers And Mathematics

I have been coding in various languages for more than 6 years. Till now i havent used much mathematics for programming. From my experience i feel that one can be a very good programmer without a deep knowledge in maths. But i think proficieny in mathematics will be an added advantage for Programmer. With maths we can write many interesting & funny programs easily without any difficulty.

There is good blog post about it by Steve Yegge.

http://steve-yegge.blogspot.com/2006/03/math-for-programmers.html