Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

JavaScript Character Key Codes| KeyBoard Keys Codes JavaScript

Sep 13, 2013 0 comments
Introduction:

Here I will explain JavaScript character key codes or keyboard keys codes in JavaScript or alphabet keycodes in JavaScript or alphabet character codes or number character codes or special characters key codes or the character code value of the key pressed or released.

Description:

jQuery Get Query String Values with Special Characters (&,')

3 comments
Introduction

Here I will explain how to get query string parameter value with special characters in
jQuery .

Description:
  
In previous articles I explained jQuery get query string parameter value with spaces,
jQuery get query string parameter values, asp.net pass multiple parameters in query string, jQuery Remove first/last character from string, jQuery create rounded corners for textbox and many articles relating to JQuery. Now I will explain how to get query string parameter value with special characters in jQuery.

jQuery Merge Multiple Tables into a Single Table in JavaScript

1 comments
Introduction

Here I will explain how to use
jQuery to merge multiple tables into a single table in Javascript or jQuery to merge two tables into single table.

jQuery Check if String Contains Specific Word in JavaScript

Sep 12, 2013 4 comments
Introduction

Here I will explain how to use
jQuery to check particular word in string in JavaScript or jQuery to check if string contains specific word in JavaScript.

Description:
  
In previous articles I explained jQuery add border to images in webpage, jQuery show loading image in pageload, jQuery hide div elements after 5 seconds, jQuery convert am / pm time to 24 hours time, jQuery print div content with css
and many articles relating to JQuery, JavaScript. Now I will explain how to check if string contains specific word in JavaScript.

jQuery Add Border to All Images or CSS Add Border to All Images in Webpage

Sep 11, 2013 0 comments
Introduction

Here I will explain how to use CSS to add border to all images in webpage or jQuery to add border to all images in webpage.

Description:

jQuery Show No Records Found in Autocomplete Textbox if Search Text not Found in Data

0 comments
Introduction:

Here I will explain how to show no records found mesage in
jQuery autocomplete textbox if no matching records found with search text in jQuery autocomplete textbox.
Description:
  
In previous posts I explained
jQuery show loading image while page loads, jQuery autocomplete textbox with webservice, jQuery autocomplete textbox with multiple words with commas, jQuery autocomplete textbox with images and many articles relating to JQuery, asp.net, JavaScript. Now I will explain how to show no records found in jQuery autocomplete textbox.

jQuery Show / Hide Loading Image in Autocomplete Textbox

2 comments
Introduction:

Here I will explain how to show or hide loading image in
jQuery autocomplete textbox.
Description:
  
In previous posts I explained jQuery show loading image while page loads, jQuery autocomplete textbox with webservice, jQuery autocomplete textbox with multiple words with commas, jQuery autocomplete textbox with images and many articles relating to
JQuery, asp.net, JavaScript. Now I will explain how to show or hide loading image in jQuery autocomplete textbox.

jQuery Show Loading Image While Page Loads or Show Loading Image in Webpage while Page Loads

Sep 10, 2013 13 comments
Introduction

Here I will explain how to use
jQuery to show loading image while page loading in jQuery or show loading image in webpage while page loading instead of blank page in jQuery.

SQL Server - Show Time Difference in Minute Ago, Hour Ago, Day Ago, Week Ago, Month Ago

Sep 5, 2013 10 comments
Introduction

Here I will explain SQL Server query to get date time difference in minute ago, hour ago, day ago, week ago or month ago format in SQL Server 2008 / 2005 or how to get date time format in minute ago, hour ago, day ago, week ago or month ago in SQL Server 2008 / 2005.

Description

In previous articles I explained SQL Server Get only date or time from date time field,  SQL Server get list of procedures which contains table name, SQL Server can function return multiple values, SQL Server update multiple tables with inner joins, SQL Server difference between view and stored procedure and many articles relating to SQL Server. Now I will explain how to write query to get date time in minute ago, hour ago, day ago, week ago or month ago format in SQL Server.

SQL Server - Get Date or Time From Date Time Column / Field in SQL Server 2008 / 2005

Sep 4, 2013 3 comments
Introduction

Here I will explain SQL Server query to get only date or time from date time field in SQL Server2008 or 2005 or how to get only date or time from current date time field in SQL Server 2008 / 2005.

Description

In previous articles I explained sql server get list of procedures which contains table name, SQL Server difference between view and stored procedure, SQL Server difference b/w LEN and DATALENGTH functions and many articles relating to SQL Server. Now I will explain how to get only date or time from date time field in SQL Server.

SQL Server - Get Time Part Only From DateTime Column in 2008 / 2005

Sep 3, 2013 2 comments
Introduction:

Here I will explain how to get only time from datetime in SQL Server 2008 / 2005 or SQL Query to get only time part from datetime column or field in SQL Server 2008 or 2005.

Description:

In previous posts I explained get only date from datetime in SQL Server, Add row items as string with comma separated values, Exception handling in SQL Server with try catch, Add identity property to existing column in sql server, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get only time from datetime in SQL Server.  

SQL Server Get List of Stored Procedures Where a Table Name is Used

4 comments

Introduction:

Here I will explain SQL Server query to get a list of stored procedures where table is used or SQL query to get list of procedures which contains table name in SQL Server.

Description:

In previous posts I explained can function return multiple values in SQL Server, Difference between view & stored procedure in SQL, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get list procedures which contains particular table in SQL Server.  

SQL Server - Invalid Use of a Side-Effecting Operator 'insert' within a Function

1 comments
Introduction:

Here I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

Description:

In previous posts I explained many articles relating to solve errors in asp.net, SQL Server, IIS, etc. Now I will explain how to solve the problem of “invalid use of a side-effecting operator 'insert' within a function in SQL Server”.

jQuery Autocomplete Clear Textbox After Select

Sep 1, 2013 2 comments
Introduction:

Here I will explain how to clear autocomplete textbox in jQuery after select or jQuery clear autocomplete textbox after select.    

Description:

SQL Server - Can Function Return Multiple Values in SQL Server 2008

12 comments
Introduction:

Here I will explain how SQL Server function will return multiple values in SQL Server 2008 or return multiple values from SQL user defined function in SQL Server 2008.    

Description:

jQuery Wiki Plugin to Show Wikipedia Description in Tooltips

Aug 31, 2013 2 comments
Introduction:

Here I will explain how to use jQuery wikiup plugin to show or display wikipedia description in tooltips or show Wikipedia information related to word or string using jQuery wikiup plugin.

Description:
  
In previous articles I explained
create simple tooltip with jQuery UI, show gridiview row details in tooltip on mouseover, jQuery Simple Slideshow example, jQuery image slideshow with text overlay, jQuery image slideshow with next and previous buttons and many articles relating to JavaScript, jQuery, asp.net. Now I will explain how to show Wikipedia information related to word or string using jQuery wikiup plugin.

SQL Server- Difference between View and Stored Procedure

Aug 30, 2013 13 comments
Introduction:

Here I will explain difference between SQL SERVER view and stored procedure in SQL Server 2008.  
Description:

C# - Add/Copy Rows from One Datatable to Another Datatable

Aug 29, 2013 0 comments
Introduction:

Here I will explain simple
code snippet in c# to add rows from one table to another table in vb.net, asp.net or copy rows from one datatable to another datatable in  c#, vb.net.

Description:

In Previous posts I explained using statement example in c#, Get all files from folder and subfolders in c#, Export webpage with images to pdf in asp.net and many articles relating to
c#, vb.net, Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain how to add rows from one table to another table in c#, vb.net, asp.net.  

To add rows from one table to another table we need to use ImportRow function like as shown below

C# - Using Statement Example | Uses of Using Statement in C#

9 comments
Introduction:

In this article I will explain uses of using statement in c# and how to declare and use using statement in c#, vb.net,
Asp.net.

Description:

In Previous posts I explained lot of articles regarding
Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain about using statement in c#.

Generally in our applications we will write code like create connection object to handle connectionstring after that open a connection and create command object etc. to interact with database to get data that would be like this

jQuery Get Query String Parameter Values with Spaces

Aug 28, 2013 0 comments
Introduction

Here I will explain how to use
jQuery to get query string parameter value with space.

Description:
  
In previous articles I explained jQuery get query string parameter values,
jQuery Remove first/last character from string, Best Drag and Drop Plugin examples, Scroll back to top plugin Examples, jQuery create rounded corners for textbox and many articles relating to JQuery. Now I will explain how to get query string parameter value with space using JQuery.

JavaScript setTimeout Function Example

2 comments
Introduction

Here I will explain how to use JavaScript setTimeout function with example. JavaScript setTimeout() function is used to execute functions at regular intervals of time. Suppose if we want to execute one JavaScript function for every 10 seconds or for a specific time we can use JavaScript setTimeout function to achieve this functionalit. 

Description:

In previous articles I explained Start and Stop timer in JavaScript, Show user current location on Google map, Regular expression to validate file upload extension and many articles relating to jQuery, JavaScript. Now I will explain how to use JavaScript setTimeout() function with example. 
© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.