< Browse > Home / Archive: September 2008

| RSS

How I Fixed Error 0×80070052 On SD Card

My SD Card which I use between my PC and PDA was giving me Error 0×80070052. The error would occur when I created a new folder on the card. Initially I suspected this to be a virus but I also wanted to explore other options. And I discovered the solution pretty much by accident.
Solution
I [...]

[ More ] September 28th, 2008 | No Comments | Posted in Tips |

Windows Web Site Gets a New Look

I could be the last one to spot this. I just saw that the official Windows site on microsoft.com has a new look with Deepak Chopra’s (no relation) image looking into your eyes and telling you that he is a PC. The new look is refreshing. Much better than the old Microsoft.com look with too [...]

[ More ] September 25th, 2008 | No Comments | Posted in News |

Windows 7 On Horizon

Back at PDC 2004 Microsoft announced Longhorn which eventually became Vista. Those who attended PDC in 2004 got an early build of Vista to play with. Microsoft will continue the tradition and will give an early build of Windows 7 at PDC 2008. As of today you can find screenshots of Windows 7 build [...]

[ More ] September 25th, 2008 | 2 Comments | Posted in News |

I Saw Future At SBTUG

After many months I attended SBTUG today. I have always found the presentations at SBTUG to be informative and more importantly entertaining. There are times when I feel like consuming content which is bit light on programming but still related to IT. And SBTUG provides that perfect mix. Today’s presentations were Predicting the Past: Emotional [...]

[ More ] September 24th, 2008 | No Comments | Posted in News |

View T-SQL Query Generated By LINQ To SQL Using Linqpad

In my previous post I showed you three different ways to capture the T-SQL query generated by LINQ To SQL. A comment on the post reminded me that I forgot to mention a fourth way i.e. using Linqpad. In Linqpad when you have executed the query you can click on the SQL tab next to [...]

[ More ] September 23rd, 2008 | 1 Comment | Posted in Programming |

View T-SQL Query Generated By LINQ To SQL

While working with LINQ To SQL there are times when you are interested in looking at the query which will be executed on the database.  This post will cover different ways you can capture the query generated by LINQ To SQL.
SQL Server Profiler
SQL Profile has long been a preferred tool to capture activity on a [...]

[ More ] September 22nd, 2008 | 3 Comments | Posted in Programming |

SQL Server 2008 Beta Exam Now Available

As per Beta Exams blog Exam 71-433 TS: Microsoft SQL Server 2008, Database Development is now open to all. you can find more details about it here.

[ More ] September 19th, 2008 | No Comments | Posted in News |

Code Sample: Programmatically Download File Using C#

While browsing forums today I came across a question which asked for a solution to download a file from a web server programmatically. The solution is very simple and below is the code which achieves the goal. Here I am downloading a file asynchronously on Button Click.

1: private void buttonDownloadFile_Click(object sender, EventArgs [...]

[ More ] September 17th, 2008 | 5 Comments | Posted in Programming |

Microsoft Virtual TechDays

Microsoft India is running an online event called Virtual TechDays. They are covering some good content on the latest goodies from Microsoft .Net 3.5 SP1, LINQ etc. I am particularly interested in sessions on LINQ and Parallel Extensions.

[ More ] September 17th, 2008 | 2 Comments | Posted in News |

Code Sample: Find Difference Between Two DateTime Values

This code shows you how to find the difference between two DateTime values. The easiest way to do this is to use the TimeSpan class and subtract one DateTime from another.

DateTime firstDate = new DateTime(2008, 8, 1);
DateTime secondDate = DateTime.Now;

TimeSpan timeSpan = secondDate.Subtract(firstDate);

// Get Difference
Console.WriteLine(”Days : ” + timeSpan.Days.ToString());
Console.WriteLine(”Hours : ” + timeSpan.Hours.ToString());
Console.WriteLine(”Minutes : [...]

[ More ] September 17th, 2008 | No Comments | Posted in Programming |

Use SqlConnection With LINQ To SQL

LINQ To SQL allows us to use a SqlConnection object to connect to a database. The way to use a SqlConnection is to pass it as a parameter to DataContext object. DataContext object has constructor which takes in a IDbConnection and SqlConnection implements this Interface. Here I create a SqlConnection object and use it to [...]

[ More ] September 16th, 2008 | 4 Comments | Posted in Programming |

LINQ To SQL Join On Multiple Conditions

LINQ To SQL or just plain LINQ allows us to do a join on multiple conditions using an elegant technique. In this post I will show you how to perform a Join on multiple conditions. As an example I will take two tables called House and ShoppingMall.

Both these tables have PostCode and CouncilCode as common [...]

[ More ] September 16th, 2008 | 6 Comments | Posted in Programming |
  • Page 1 of 2
  • 1
  • 2
  • >