Wednesday, March 6, 2013

Animated Sliding Recent Post Widget For Blogger

One of my friend ask me sliding "Recent Post Widget For Blogger". I have searched for this in Google and I found some interesting codes for sliding recent post widget. Here I am sharing one of them, which I have also used in my blog.

In previous posts, I explained Calculate age using java scriptjQuery .toggleClass() example, jQuery Draggable Div Example in ASP.Net, jQuery Resizable Div Example in ASP.Net, Drag and drop HTML list item with in list using jQuery, jQuery Magnifier Example an other article related to jQuery and Java Script.

Tuesday, March 5, 2013

Change Input to Upper Case using Java Script

In many web sites, you will have to see that when user types into text box then input text converts into Upper case automatically even if you type in lower case. Here I am going to show you a simple example how can we do this using java script.

In previous posts, I explained Calculate age using java scriptjQuery .toggleClass() example, jQuery Draggable Div Example in ASP.Net, jQuery Resizable Div Example in ASP.Net, Drag and drop HTML list item with in list using jQuery, jQuery Magnifier Example an other article related to jQuery and Java Script.

Here, I will show you a simple example of  converting the input value in to uppercase using jQuery in ASP.Net.

SQL Server UPPER Function

In this post , I will explain the UPPER function of SQL Server of string functions category.
In my previous posts, I explained STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server.

Here, I am going to explain UPPER function of SQL Server.

Exporting Query Results to CSV using SQLCMD

In this post , I will explain how to export the query result set to CSV file using SQLCMD.
In my previous posts, I explained STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server.

Here, I am going to explain exporting the query result to CSV using SQLCMD in SQL Server.

Monday, March 4, 2013

SQL Server STUFF Function

In this post , I will explain the STUFF function of SQL Server of string function category.
In my previous posts, I explained UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server.

Here, I am going to explain STUFF function of SQL Server.

Friday, March 1, 2013

SQL Server LEN Function

In this post , I will explain the LEN function of SQL Server of string function category.
In my previous posts, I explained UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server.

Here, I am going to explain LEN function of SQL Server.

SQL Server UNICODE Function

In this post , I will explain the UNICODE function of SQL Server of string function category.
In my previous posts, I explained LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server.

Here, I am going to explain UNICODE function of SQL Server.

Wednesday, February 27, 2013

Tuesday, February 26, 2013

SQL Server's CHAR Function

In my previous posts, I explained ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server. 

Here, I am going to explain the CHAR function of SQL Server.

ASCII Function of SQL Server

In my previous posts, I explained Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server. Here, I am going to explained ASCII function of SQL Server.

Ascii() Function

This function returns the ASCII code value of leftmost character of character expression.

Monday, February 25, 2013

jQuey .toggleClass() Example in ASp.Net

In previous posts, I explained jQuery Draggable Div Example in ASP.Net, jQuery Resizable Div Example in ASP.Net, Drag and drop HTML list item with in list using jQuery, jQuery Magnifier Example. Here, I will show you a simple example of  .toggleClass() using jQuery in ASP.Net.

jQuery .toggleClass()

.toggleClass() uses for add or remove one or more classes from each element in the set of matched element.

Saturday, February 23, 2013

jQuery Draggable Div Example in ASP.Net

In previous posts, I explained jQuery Resizable Div Example in ASP.Net, Drag and drop HTML list item with in list using jQuery, jQuery Magnifier Example. Now , I will show you a simple example of  resizable div using jQuery in ASP.Net.

We can create a resizable div just by simple call the draggable() property of jQuery UI library that would be like as shown below.

Friday, February 22, 2013

jQuery Resizable Div Example in ASP.Net

In previous posts, I explained Drag and drop HTML list item with in list using jQuery, jQuery Magnifier Example. Now , I will show you a simple example of  resizable div using jQuery in ASP.Net.

We can create a resizable div just by simple call the resizable() property of jQuery UI library that would be like as shown below.

Thursday, February 21, 2013

Drag and drop html list item with in list using jQuery

Here, I will show you a simple example of rearranging the HTML list item through drag and drop functionality using jQuery. Here in this example, I have used the jQuery List DragSort plugin . You can download this plugin from here.

To implement this we need to write the code like as shown below

Wednesday, February 20, 2013

jQuery Magnifier Example | Showing the magnify view of image

Here, I will show you a simple example of jQuery magnifier for image. Here in this example, I have used the dio5 jQuery magnifier plugin . You can download this plugin from here.

To implement this we need to write the code like as shown below

Friday, February 15, 2013

Method Overloading in WebServices

As we know that Web Service is also a class just like other classes. In web service we can overload the web methods but it is not as straightforward as in class. Method overloading in the web service is little bit different. Here in this example, I will show you how to overload the web methods in We Service.

Wednesday, February 13, 2013

Upload and Read the Excel file using C#

This example will show you how to Upload the excel file and then read the excel file data using C# and display it on Gridview.

Drag and drop the FileUpload control and Button control from toolbox. Also drag and drop the Gridview  control for display the excel file data. ASPX page will look as following.

Friday, February 8, 2013

Bind Multiple Controls to a Single Event in jQuery

In this sample, we will see how to bind Multiple Controls to a single event in jQuery. We will bind 5 button controls (Button A, B, C, D and E) to a single click event. This example also demonstrates how to create an array of controls and loop through them. Here’s the sample:

Thursday, February 7, 2013

Simple script to backup all SQL Server databases

Working as developer or DBA, we often required to take the backup of database. This is not a big deal if you have a handful of databases, but this task become very hectic if the there is number of databases (ex. 50+) on the same instance of SQL Server. You could use SQL Server Management Studio to backup the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach.

Wednesday, February 6, 2013

Disable cut, copy and paste in textbox using jquery, javascript

Sometimes we need to restrict the user to cut or copy the content from TextBox and also restrict to paste the content into TextBox. It is very easy to do this using Java Script as well as using Jquery. Here I will show you both the methods i.e. using Java Script and using jQuery.

Friday, February 1, 2013

Nested Gridview with Expand/Collapse Functionality

Here in this example, I am going to show you how to create Nested Gridview with Expand and Collapse Functionality.

I have used java script to add the expandable and collapsible functionality in nested gridview by displaying plus and minus image. I have used Subjects and SubjectUnits tables to populate the nested gridviews. 

Monday, January 28, 2013

Difference between document.ready and window.onload or pageLoad

In Asp.Net Web applications, developers use the jquery’s $document.ready() and pageLoad() or window.onload events very frequently. In the first sight these events seems very similar in functioning. But $document.ready()  and pageLoad() methods are very differ in functioning.

In this post I am trying to expose the difference between $document.ready()  and pageLoad() .

Thursday, January 24, 2013

Difference between Int32.Parse(), Convert.ToInt32() and Int32.TryParse()

Int32.Parse()


Int32.Parse (string s) method converts the string representation of a number to its 32-bit signed integer equivalent. When s is a null reference, it will throw ArgumentNullException. If s is other than integer value, it will throw FormatException. When s represents a number less than MinValue or greater than MaxValue, it will throw OverflowException.

Wednesday, January 23, 2013

Get IP address using C#

Here is I'm trying to get IP address in a web application when it's page load using C#. The following code will help u for getting IP address....

Tuesday, January 22, 2013

Watermark in textbox using JavaScript

In the web application development, developers always try to make UI more user-friendly and interactively. Showing watermark on textbox is one of the tools to increase user-interactivity of website. Most of the sites use the watermark mainly for “Search” functionality. In this post I will show you a simple implementation of watermark in textbox using JavaScript.

Monday, January 21, 2013

Prevent multiple clicks on button

More often programmers need to prevent the multiple clicks on button. We can prevent the multiple clicks just by disable or hide the button after the first click and enable or show it again when the processing in done. We can also show the message at the time of processing to user.Here in the images shown below, I have just show you the scenario before and after the postback.

Saturday, January 19, 2013

How to pass table as parameter in stored procedures in SQL Server (Table-Valued Parameters)

In this post I will explain how to pass table as parameter in stored procedure with example.
Table-Valued Parameters is a new feature of Microsoft SQL Server 2008. In earlier versions of SQL Server it is not possible to pass table variable in store procedure as parameter. You can use Table-Valued Parameter to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing so many parameters.

Thursday, January 17, 2013

Maintain div scroll position on postback

Sometimes we need to maintain the div scroll position on page postbacks. Here is how you can do it using JavaScript and Cookies.

Here I am simple using the cookie for store the current scroll position of div before postback and then set the div scroll position by reading the cookie which I nave stored in browser on page postback.

Wednesday, January 16, 2013

Get the list of all HttpModules in ASP.Net

Here I will give you a quick trick to get the list of all active HttpModules at runtime. We can get all the HttpModules from web.config or from machine.config file. But, If we want this at runtime then we can do this with the help of HttpApplication and HttpModuleCollection class. Below is the code snippet for getting the list of all active  HttpModules

Tuesday, January 15, 2013

Find the child element position inside the parent element using Jquery/Java Script

In this post I will explain how to find the child element position inside the parent element using jquery/java script.

Let's start, I have two div elements one is parent div and other is child div and a label to show the output.

Thursday, January 10, 2013

How to pass ASP.NET server side array to client side

In ASP.Net , this is a very often requirement to pass the server side array to client side and access them using java script. It this post I am describing the simplest way to pass the server side array to client side. Here I will show you two things, one is how to pass the server side array to client side and bind that array to empty "htmldropdown" list.
^ Scroll to Top