-
Outer joins and search predicates – II
In my last post, we saw that if we place a search predicate in WHERE clause instead of placing it along with the ON clause, we may get the expected output. Now let’s understand what happens behind the scene. Note: we’ll use the pubs database for the example. Suppose we want to list all the […]
-
Outer joins and search predicates
We often use outer joins to construct queries and get the expected output, but what if you get an unexpected output and the query seems OK. A few days ago, I experienced the same thing and discovered the problem with the placement of the predicate (search condition). Let’s take an example : We’ll use the […]
-
Microsoft Community Contributor Award 2011
I am very happy to announce that I am one of many to receive this award. I consider this an honor to be recognized by Microsoft for my contribution to Asp.net Forums and look forward to continuing the same. Thanks Microsoft!
-
VS 2010 and ASPX Edit Helper
Some of my friend reported that they can’t use ASPX Edit Helper with VS 2010 and from the original post it is evident that it works great with VS 2005 and VS 2008. But one of the guy added support for VS 2010 using original souce code. You can download the latest source and binaries […]
-
Useful Visual Studio Add-Ins
Recently one of the guy asked on Asp.net forum that is there any shortcut key to insert comments above method or function. There’s no exact shortcut but yes, you can insert comment above your method and function by typing 3 slash (///) in c# and 3 single quote in VB and still you’ve to type […]
-
Mouse Extender : A cozy utility
If you don’t like your desktop covered with so many icons and still want to open your favourite program with ease then Mouse Extender (ME) is the best option for you. I’ve been using it for quite a long time at my home as well as office. You can download it from CodePlex. ME is […]
-
Update with join and unexpected output
Recently one of my colleagues was writing a trigger, and in that, he’s having Update Query with join, syntax, and everything was right, but he’s not getting the expected output. To understand the situation, let’s take an example. Create two temporary tables: And Inset the following values in both tables. Now both the table contains […]
-
SQL Server 2008 : Table Valued Parameter and Merge
Recently I was working on one project, and I was supposed to Insert/Update many records in the database. I wanted to do it in a single round trip. I Googled it and found two excellent features of SQL Server 2008: the Table Valued Parameter and Merge Statement. Table Valued Parameter allows you to send many […]
-
Show Modal Dialog with Asp.net webpage
For last few days one question is arising on asp.net forums and that is how to display Modal Dialog with Asp.net webpage. It can be done using JavaScript ShowModalDialog method. Syntax: Where This method is introduced by Microsoft Interent Explorer4 and support added to Firefox 3. Firefox 3 doesn’t support dialogHide, edge, status, or unadorned […]
-
Generate Nested Gridview Dynamically
As i said in my last post, I’ll write about how to generate Nested Gridview dynamically. As there are many articles available on the net, let me provide you the link to the article that i referred. Gridview Control to show master-child or master-slave data It provides detail explanation with snapshot. There is one disadvantage […]