Tuesday, April 1, 2014

Removing double/ multiple comma from a string in c#

Use namespace:
using System.Text.RegularExpressions;

then do the following code:

string inputString = "'\"1\":\"C\",\"2\":\"A\",\"3\":\"C\",,\"5\":\"C\",\"6\":\"B\",,\"8\":\"C\",,\"10\":\"C\",'";
string outputString = Regex.Replace(inputString, ",{2,}", ",").Trim(',');

Thursday, March 6, 2014

Count Stored Procedures, System Tables, User Defined Tables in any database

USE DATABASENAME
SELECT 
    CASE TYPE 
        WHEN 'U' 
            THEN 'User Defined Tables' 
        WHEN 'S'
            THEN 'System Tables'
        WHEN 'IT'
            THEN 'Internal Tables'
        WHEN 'P'
            THEN 'Stored Procedures'
        WHEN 'PC'
            THEN 'CLR Stored Procedures'
        WHEN 'X'
            THEN 'Extended Stored Procedures'
    END, 
    COUNT(*)     
FROM SYS.OBJECTS
WHERE TYPE IN ('U', 'P', 'PC', 'S', 'IT', 'X')
GROUP BY TYPE

Thursday, October 24, 2013

ASP.net Developer

Urgently Require ASP.net Developer:


Required Skills: C#, ASP NET 4.0, AJAX, HTML, CSS, java Script, ASP.NET MVC4 design pattern, SQL Server, WCF Webservices

Desired Skills: Mongo db, JQuery, HTML5, CSS, CRM

Work Location: Noida Sec-29

Job Type: Full Time

Experience: 0-3 years

Interested candidate forward their CV @ nnath.zensoftware@gmail.com with following details:


# Full Name (Expanded) (First : Middle : Last) : 
#Passport size photograph
# Present Company , Location & Date of Joining :
 
# Your Designation :
 
# Your current Salary :
 
# Your Expected Salary :
 
# Total Experience as in IT:
# Total Experience in relevant technology,:
# Your DOB ( DD / MM / YY ) :
 
# Passport Status ( Y /N ) :
 
# Notice Period & Minimum Joining Time Required :
 
# Contact Details With Phone Nos. ( Res., Cell  ) :
 
# Your two alternate personal e-mail id's :
 
#Willing to work in night shifts:

Tuesday, September 17, 2013

Message for Readers

This blog is specially for the lovers of technology. I will keep posting the updates and different technical solutions for problems related to Microsoft related technologies.