Programming360

.Net Framework Version

noreply@blogger.com (Syed Tayyab Ali) — Wed, 22 Jun 2016 14:29:00 +0000

Run this command in command prompt.

dir %windir%\Microsoft.NET\Framework/AD

Find Text in Stored Procedures

noreply@blogger.com (Syed Tayyab Ali) — Thu, 02 May 2013 15:16:00 +0000

Method to retrieve every text inside the stored procedures of a database

SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'

Reference: http://geekswithblogs.net/whiletrue/archive/2009/02/02/find-text-in-sql-stored-procedures.aspx

Static Constructor in C#

noreply@blogger.com (Syed Tayyab Ali) — Tue, 16 Apr 2013 17:30:00 +0000

In C#, static constructor is always private and it does not need explicit access modifier, it does not take parameters and only good for initialization of static members of class. Static constructor calls before first instance of class's object and user does not really have any control on it.

Singleton pattern also take the advantage of static constructor of C#.

Interface Implementations

noreply@blogger.com (Syed Tayyab Ali) — Wed, 10 Apr 2013 16:48:00 +0000

Interesting post on the different implementations of Interface in C#.

AutoEventWireup

noreply@blogger.com (Syed Tayyab Ali) — Thu, 21 Mar 2013 17:53:00 +0000

If autoeventwireup=true, ASP.NET page events will automatically subscribe to respective life cycle event. An special hash table behind the scene maintains the match. :)

ABC of WCF

noreply@blogger.com (Syed Tayyab Ali) — Thu, 12 Apr 2012 16:28:00 +0000

WCF service exposes endpoints and each endpoint contain address, binding and contract.

Address: Where the service communicate and points to actual network address.
Binding: How service communicate and includes protocol.
Contract: What the message contain.

Language Integrated Query

noreply@blogger.com (Syed Tayyab Ali) — Thu, 10 Nov 2011 02:26:00 +0000

LINQ api provide a way to access Object Data, Relational Data, and XML Data. System.LINQ defines more than 50 operators(also called standard query operator and can also be extendable) which are similar to SQL operators. Static type checking allows the assignment of selected result in correct IEnumerable object.

It was also misunderstood in early days of LINQ concept that only database is accessible from API. LINQ can used with any data object which are in main memory. It is really easy to use LINQ and filter item in list instead of writing foreach code and then apply if else conditions.

LINQ to SQL translates query expression into T-SQL It is simple ORM.

Some cool facts about LINQ.

LINQ query does not execute until it is actually use/access by code. This concept is called Deferred Execution. So most operators are lazy.

New Series

noreply@blogger.com (Syed Tayyab Ali) — Tue, 01 Nov 2011 17:54:00 +0000

In recent month I was not much active on my blog. Now I am seriously thinking to write more on WCF, and LINQ.

Let me know your favorite topics or suggestions.

iSad

noreply@blogger.com (Syed Tayyab Ali) — Fri, 07 Oct 2011 00:55:00 +0000

Steve Jobs changed the computing experience from large computers to personal computers.
He further revolutionized the computing by changing keyboard hits to clicks and then clicks to touches.

"Remembering that I'll be dead soon is the most important tool I've ever encountered to help me make the big choices in life. Because almost everything — all external expectations, all pride, all fear of embarrassment or failure - these things just fall away in the face of death, leaving only what is truly important. Remembering that you are going to die is the best way I know to avoid the trap of thinking you have something to lose. You are already naked. There is no reason not to follow your heart."

"No one wants to die. Even people who want to go to heaven don't want to die to get there. And yet death is the destination we all share. No one has ever escaped it. And that is as it should be, because Death is very likely the single best invention of Life. It is Life's change agent. It clears out the old to make way for the new."

Serialization/Deserialization

noreply@blogger.com (Syed Tayyab Ali) — Sun, 05 Jun 2011 23:56:00 +0000

Serialization is the process of converting object into linear sequence of byte, while deserialization is constructing object from that serialized linear sequence of byte. Serialization allows to store the content of object on file, transmit across network or send to another process. Serialization is used in distributed application.

.Net provide clean way to achieve serialization and deserialization in just few lines of code.

SoapFormatter/BinaryFormatter.Serialize/Deserialize methods are used.

Asynchronous ASP.NET Programming

noreply@blogger.com (Syed Tayyab Ali) — Mon, 30 May 2011 03:27:00 +0000

SharePoint Saturday Houston 2011

noreply@blogger.com (Syed Tayyab Ali) — Fri, 29 Apr 2011 03:04:00 +0000

SharePoint Saturday Houston 2011 event is going to happen on May 7.

"SharePoint Saturday is an educational, informative & lively day filled with sessions from respected SharePoint professionals & MVPs, covering a wide variety of SharePoint-orientated topics. SharePoint Saturday is FREE, open to the public and is your local chance to immerse yourself in SharePoint!"

For more information please visit SharePoint Saturday Houston website.

Please register for SharePoint Saturday Houston Event.

NULL

noreply@blogger.com (Syed Tayyab Ali) — Mon, 21 Mar 2011 16:00:00 +0000

Earlier, I posted blog on T-SQL ISNULL() function. I realized that it is not good idea to post something before sharing knowledge on NULL.

NULL is considered as unknown and result of any expression that include null is also unknown. It is good idea to test null to avoid unknown result. SQL provide IS operator to test null value.

WHERE Expression IS NULL

Linked Server

noreply@blogger.com (Syed Tayyab Ali) — Thu, 24 Feb 2011 17:48:00 +0000

I was looking for a linked server in SQL management studio. I can see bunch of linked server but not sure which one I needed.

I found out that following query not only list the linked server name, but also server name, database name information.

Here is the query.

SELECT * from sys.servers
WHERE is_linked = 1

Happy SQLing!!

ISNULL

noreply@blogger.com (Syed Tayyab Ali) — Thu, 17 Feb 2011 05:12:00 +0000

ISNULL ( check_expression , replacement_value )

Today, I am writing my thoughts on T-SQL specific function isnull(). Current database system allows null values. Null itself does not show any meaning but when end users need data reports/application require data then it becomes problem.

ISNULL function convert null values into meaningful data value. Isnull function checks expression and if it founds null then replace it with second argument (replacement value expression) otherwise return first argument.

We still have coalesce() and nullif() functions to control null values in more flexible way.

Debugging ASP.NET Page

noreply@blogger.com (Syed Tayyab Ali) — Tue, 12 Oct 2010 05:21:00 +0000

You can debug asp.net application either on page level or application level.

Enable debugging for a page by adding a Debug= "true" attribute to the <%@ Page %> directive.
Enable debugging for entire application by adding <compilation debug = "true"> in configuration/system.web/ withing web.config file.

Page.IsPostBack

noreply@blogger.com (Syed Tayyab Ali) — Tue, 12 Oct 2010 05:04:00 +0000

The Page class includes a property called the IsPostBack property, which you can use to detect weather the page has already been posted back to server.

[Blog Review] If broken it is, fix it you should

noreply@blogger.com (Syed Tayyab Ali) — Mon, 03 May 2010 20:16:00 +0000

Tess Ferrandez is an ASP.NET Escalation Engineer at Microsoft. She has been writing blog on http://blogs.msdn.com/tess/ for five years. Her areas of interest are debugging and related tools.

I find her blog interesting and learned most of the advanced debugging skills.

Tess gave very funny name to her blog, If broken it is, fix it you should. She describe it in following words.

Using the powers of the debugger to solve the problems of the world - and a bag of chips

ALT.NET Houston Open Spaces 2010

noreply@blogger.com (Syed Tayyab Ali) — Fri, 23 Apr 2010 18:09:00 +0000

Three day event from April 30th to May 2nd is going to happen in Houston, TX. This conference is being held to allow developers to come and share their experiences, learn from each other. ALT.NET is about challenging the status-quo, continually looking for ways to better our craft, and to collaborate to create a community of mindful .NET software developers.

You can get registration information from http://altnethouston.com/

Master Pages in ASP.Net

noreply@blogger.com (Syed Tayyab Ali) — Tue, 23 Mar 2010 17:49:00 +0000

Quick overview of master pages mechanism in ASP.Net.

Please read ASP.NET Master Pages Overview.

Detect Control through Events in ASP.Net

noreply@blogger.com (Syed Tayyab Ali) — Mon, 22 Feb 2010 21:47:00 +0000

It is cool to use Object sender and cast it to back into original control and perform desired operations.

Let me know, if you get it. Otherwise, I will post code example here.

SharePoint in Plain English

noreply@blogger.com (Syed Tayyab Ali) — Sat, 30 Jan 2010 21:16:00 +0000

Debug CSS

noreply@blogger.com (Syed Tayyab Ali) — Mon, 07 Dec 2009 17:43:00 +0000

It is good idea to see the styles and HTML element's dimension in complex document by using Universal Selector.

Here is the code snippet.
*
{
border : 1px solid black;
}

Application Pool in IIS

noreply@blogger.com (Syed Tayyab Ali) — Mon, 30 Nov 2009 17:21:00 +0000

It is good idea to create a new pool in IIS for each web application. Instead of putting all web application in one pool, creating of new pool will isolate each application. It will provide separate worker process. Let me know, if it is good for you.

How To Enable jQuery Intellisense in VS 2008

noreply@blogger.com (Syed Tayyab Ali) — Fri, 30 Oct 2009 17:09:00 +0000

Here I want to share some valuable information on jQuery intellisense support in Visual Studio 2008.
Here are few steps which you need to follow.

Make sure you already have SP1 for VS 2008. Otherwise you need to install it.
Install patch KB958502 - JScript Editor support for “-vsdoc.js” IntelliSense files.
Download the visual studio documentation from jQuery website.

Now drag downloaded documentation in your project and place it at same location where you have jQuery library. You will also notice that your downloaded documentation contain file name vsdoc2.js. In my case, I have jQuery library name jquery-1.3.2.js, when I downloaded jQuery documentation, that has jquery-1.3.2-vsdoc2.js, what I did, I removed 2 before dot. It became like jquery-1.3.2-vsdoc.js.

For more detail on jQuery subject, please visit Setting up Visual Studio Intellisense for jQuery.