Running Total In Gridview Footer in Asp.net

When we want to display running total in gridview footer, use the following methods:

1) Using gridview row data bound:

http://csharpdotnetfreak.blogspot.com/2009/07/display-total-in-gridview-footer.html

2) Using private method in codebehind:

http://aspalliance.com/782_CodeSnip_How_to_Display_Sum_Total_in_the_Footer_of_the_GridView_Control

Useful Mozilla Firefox Add-ons/Extensions for Developers

While developing applications, there arises requirement where we need to check how the page looks runtime, what is the css applied, how many request gone, what is the markup generated, any javascript occurred if then at which place, how many javascript and stylesheets loaded, browser compatibility etc etc..

Here is a list of useful  Mozilla Firefox Add-ons :

1) Firebug

An add-on for every web developer.  You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

Download:

https://addons.mozilla.org/en-US/firefox/addon/1843

2) Web Developer

The Web Developer extension adds a menu and a toolbar with various web developer tools.

Download:

https://addons.mozilla.org/en-US/firefox/addon/60

3) Javascript Debugger

Javascript Debugger provide a powerful JavaScript debugging environment for Mozilla based browsers.

Download

https://addons.mozilla.org/en-US/firefox/addon/216

4) JSView

All browsers include a “View Source” option, but none of them offer the ability to view the source code of external files. Most websites store their javascripts and style sheets in external files and then link to them within a web page’s.

Download

https://addons.mozilla.org/en-US/firefox/addon/2076

5) IETab

View Internet Explore Tab in Firefox . This is a very nice addon to check compatibility of Internet Explorer in Firefox

Download

https://addons.mozilla.org/firefox/addon/1419

6) YSlow

YSlow analyzes web pages and why they’re slow based on Yahoo!’s rules for high performance web sites.

Download

https://addons.mozilla.org/en-US/firefox/addon/5369

7) Httpfox

HttpFox monitors and analyzes all incoming and outgoing HTTP traffic between the browser and the web servers.

Download

https://addons.mozilla.org/en-US/firefox/addon/6647

Using Jquery Autocomplete with Asp.net

Jquery Demos

http://www.ajaxdaddy.com/demo-jquery-autocomplete.html

http://www.pengoworks.com/workshop/jquery/autocomplete.htm

http://jquery.bassistance.de/autocomplete/demo/

Jquery Autocomplete with asp.net

http://trappedinhoth.blogspot.com/2008/07/jquery-autocomplete-example.html

http://www.devbridge.com/projects/autocomplete/jquery/

http://www.eggheadcafe.com/tutorials/aspnet/18b6a1fa-a7cf-4507-84f2-15056fe65bb7/autocompletion-with-jque.aspx

http://www.dotnetcurry.com/ShowArticle.aspx?ID=515

http://www.codeproject.com/KB/aspnet/Jquery_Autocomplete.aspx

Jquery Autocomplete Result Handler

http://stackoverflow.com/questions/1452726/how-to-get-the-jquery-autocomplete-result-event-handler-to-work

http://stackoverflow.com/questions/1208203/autocomplete-hidden-field-in-jquery

Jquery Autocomplete Caching Problem

http://www.highdots.com/forums/jquery/autocomplete-cache-problem-urgent-283369.html

Simple Jquery Autocomplete Server Side

http://aspnetnova.blogspot.com/2009/06/simple-jquery-ajax-server-side.html

Another Jquery UI Autocomplete

http://www.jensbits.com/2010/04/14/jquery-ui-autocomplete-widget-with-asp-net/

Using Replace() function in Sql Server

In this article, we will be talking about one of the important inbuilt functions of sql server, Replace()

Syntax:

REPLACE ( string_expression , string_pattern , string_replacement )

Some examples of using replace are as follows:

1)

select replace('Nice Article', 'Nice','Cool')

returns Cool Article

2)

UPDATE emp set designation=replace(designation, 'Sales', 'Marketing') where department='Marketing'