Articles by Ramanujam Shankar (Tip/Tricks: 17)

Tip/Tricks: 17

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.29

Database Development
SQL Server	Find Missing Date Ranges in SQL Server [Tip/Trick] 10 Feb 2012 Updated: 10 Feb 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 18,401 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Find missing date periods from a table.
	Concatenate many rows into a single text string using SQL Server 2008 [Tip/Trick] 8 Mar 2012 Updated: 8 Mar 2012 Rating: 4.96/5 Votes: 22 Popularity: 6.66 Licence: CPOL Views: 262,470 Bookmarked: 18 Downloaded: 0 Please Sign up or sign in to vote. Using COALESCE function - concatenate many rows into a single text string output in SQL Server.
Mobile Apps
Windows Mobile	Accessing Data through Web Service in Windows 8 Stores App - VS2012 [Tip/Trick] 24 Oct 2012 Updated: 24 Oct 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 25,670 Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. Show data in grid view control of Windows Stores App using web service or WCF
Programming Languages
C# 3.5	Compare two datatable using LINQ Query [Tip/Trick] 12 Mar 2012 Updated: 12 Mar 2012 Rating: 4.33/5 Votes: 2 Popularity: 1.30 Licence: CPOL Views: 67,322 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote.
SQL	EXCEPT & INTERSECT command in SQL Server [Tip/Trick] 23 Dec 2011 Updated: 23 Dec 2011 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 32,260 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. New Commands in SQL Server Ex: EXCEPT & INTERSECT
Visual Basic	RowHeader Style in DataGridView - Remove Shape [Tip/Trick] 21 Jul 2011 Updated: 21 Jul 2011 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 34,883 Bookmarked: 13 Downloaded: 0 Please Sign up or sign in to vote. Remove the triangle and star symbol from the row header in a DataGridView.
	Remove Notifyicon from system tray [Tip/Trick] 28 Jul 2011 Updated: 28 Jul 2011 Rating: 3.42/5 Votes: 11 Popularity: 3.56 Licence: CPOL Views: 37,442 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Remove Notifyicon from system tray while closing the application from external application (killing proccess from another application)
	Setting focus on another application using Process name [Tip/Trick] 29 Jul 2011 Updated: 29 Jul 2011 Rating: 3.00/5 Votes: 2 Popularity: 0.90 Licence: CPOL Views: 57,652 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. How to set focus on another application using the process name
Web Development
ASP.NET	Download all types of files from server using ASP.NET [Tip/Trick] 7 Mar 2012 Updated: 8 Mar 2012 Rating: 4.70/5 Votes: 3 Popularity: 2.24 Licence: CPOL Views: 50,111 Bookmarked: 7 Downloaded: 0 Please Sign up or sign in to vote. Download any type of file from server using asp.net with javascript
	Export to EXCEL from Datatable in C#.Net [Tip/Trick] 12 Mar 2012 Updated: 12 Mar 2012 Rating: 2.91/5 Votes: 12 Popularity: 3.14 Licence: CPOL Views: 275,707 Bookmarked: 20 Downloaded: 0 Please Sign up or sign in to vote.
	How to disable validation group using javascript [Tip/Trick] 22 Nov 2011 Updated: 22 Nov 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 21,932 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Enable/Disable validation group using javascript
	Find the key code using javascript [Tip/Trick] 23 Nov 2011 Updated: 23 Nov 2011 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 21,850 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. In Text box key press event, find the pressed key code value using javascript
	Validate multiple email id's using javascript [Tip/Trick] 23 Nov 2011 Updated: 23 Nov 2011 Rating: 4.67/5 Votes: 2 Popularity: 1.40 Licence: CPOL Views: 51,151 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. Entered multiple email id's with comma/semicolon separator in text box to validate using javascript
	Trim, Mouse Hover Pointer Functions using JAVASCRIPT [Tip/Trick] 11 Feb 2012 Updated: 11 Feb 2012 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: CPOL Views: 12,440 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Trim, Change button mouse hover pointer Functions using JavaScript
	Allow only Numeric values in ASP Text box control using JavaScript [Tip/Trick] 11 Feb 2012 Updated: 11 Feb 2012 Rating: 4.82/5 Votes: 6 Popularity: 3.75 Licence: CPOL Views: 67,603 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. Allow only Numeric (either whole or decimal) values in ASP Text box control using JavaScript
	Validate From and To Date using JavaScript [Tip/Trick] 11 Feb 2012 Updated: 14 Feb 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 47,482 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. Validate entered From Date and To Date in web application using JavaScript
	Request.Form method while redirect another page using javascript [Tip/Trick] 2 Mar 2012 Updated: 2 Mar 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 15,511 Bookmarked: 6 Downloaded: 0 Please Sign up or sign in to vote. While click on hyperlink - redirect to another page and pass the Request.Form object values using javascript function