|
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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.
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 [...]
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.
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 : [...]
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 [...]
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 [...]
Popular Post
Tag Cloud
Code Snippets
- Get Current Windows User In C#
- Get Width And Height Of Image In C#
- Get Windows Registry Size With WMI And C#
- Reverse Array Elements Using C#
- Convert Hexadecimal To Number In C#
- Get Free Disk Space Using T-SQL
- SQL Server 2008 – Get All Indexes In A Database
- Get Name Of Current Executing Assembly In C#
- Get CD Or DVD Drive Information Using WMI And C#
- Get Last Row From Table Using LINQ To SQL

