From the monthly archives: September 2008
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.
[...]
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 [...]
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 [...]
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: [...]
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 [...]
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 [...]
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.
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 e) 2: [...]
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.
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 [...]
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 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 [...]
Connect with me
-
Top Posts
- LINQ To SQL Tutorial
- LINQ To SQL Join On Multiple Conditions
- Code Sample: Programmatically Download File Using C#
- Windows 7 Control Panel In Classic Mode
- More Details Emerge On Microsoft Master Certification
- Use SqlConnection With LINQ To SQL
- Free Icons And Images With Visual Studio 2008
- Capture XML In WCF Service
- Dynamic Sort With LINQ
- StyleCop Tutorial
Tags
.Net 2010 ADO.NET ASP.NET Azure Blogging Books Browsers C# Certification Cloud Computing Code Snippets Community Data Services Eclipse Entity Framework Google IDE Java LINQ Mac Microsoft Museum NetBeans Office Oracle REST SharePoint Silverlight SQL Server T-SQL Tips Tools Training Visual Studio Visual Studio 2010 WCF Web Windows Windows 7 Windows Forms Windows Live WMI WPF XAML
