Programming

To make this article, I have taken Table A and Table B as reference tables for explaining.

SELECT * FROM A
id          name                       RowState
----------- ------------------------------ --------
1           A1                             1
2           A2                             1
3           A3                             0
4           A4                             0
5           A5                             1
 
(5 row(s) affected)
 
SELECT * FROM B
 
id          name                           RowState aid

System.IO.Path.Combine is one of the scarcely used method provided by .Net Framework. It is used to combine two strings in to a complete path. Path.Combine is also essential for cross-platform coding as it uses whatever path separator the current OS uses.

I got "Unable to connect to the remote server error" when I tried to call a webservice that is hosted on some remote machine outside my firewall. I am using a proxy server, and figured it that my application is not aware of the proxy server. So I did some googling and add the following defaultproxy settings under System.net tag in applications web.config file.

Gone are the days when client side Form Validation was used to be a hectic task for most of us. Lately I stumbled upon a Jquery Validation Plugin, which can validate a form in much more cleaner and simple way. Here I try to give you a gist of the functionality provided by the plugin.

Let us take an example.

Removing records from a table is a crucial operation. So I would like to pen down my knowledge about removing records from a table. There are two ways to do the same, Truncate and Delete.

I would like to explain the basic difference between two.

1. Delete is a DML whereas truncate is a DDL. Truncate deallocates the data pages for the table and does'nt delete them row by row. So if there is an Identity column in the table it would be reset to initial seed after truncate.

I used to create temporary tables and subqueries to add a row number to every row in the result set. But somedays ago, I came across to the Row_Number() function provided in Sql Server, which simply constructs the row number column on the fly as part of the query. But a question might have arosed in your mind, What is the use of adding a Row_Number, when we have serial number associated with every row. There are several situation, where we need to query against the row number.(we can't query against a serial number)

When I was developing this site, I knew I would be publishing a lot of Source Code. After some googling I foung GeSHi Filter for Source Code Syntax Highlighting. This module integrates the third party PHP library GeSHi (Generic Syntax Highlighter) into Drupal. GeSHi Filter, syntax highlight your source code between <blockcode>tag.

Understanding Indexes

Indexes speed up the querying process by providing filtered access to rows in the data tables (just like book’s index) if they are used efficiently.

Indexes are created on columns in tables or views.

1. Define an ASP.NET web site.
2. Create two pages within the site. The first page will contain an ASP.NET Web Form that will post back to itself and then redirect to the second page.

   Note: The reason this example uses two pages is to prove that a session variable is available to a second, third, fourth, etc. page in the web site. Request variables, which are an alternative to session variables, cannot be carried over from an ASP.NET Web Form on one page to a second page