28 May 2016

Types of Stored Procedures in SqlServer

›
Stored procedure is a precompiled set of one or more SQL statements that is stored on Sql Server. stored Procedures is that they are execute...
27 May 2016

Async call

›
$.ajax({ type: 'POST', url: "webMethods.asmx/fngetuser", data: "{'userid':'" + userid + "...
18 May 2016

Variance in Delegates

›
When you assign a method to a delegate, covariance and contravariance provide flexibility for matching with method signature. Covariance p...
26 April 2016

Allow only alphanumeric in textbox using javascript and regular expression

›
function validate(evt) { var theEvent = evt || window.event; var key = theEvent.keyCode || theEvent.which; key = String.fromC...
16 March 2016

Extending using Extension methods

›
static class MyExtensionMethods { public static int Negate(this int value) { return -value; } public static int ...
14 March 2016

Stored Procedure vs Function

›
Stored Procedure Function Return type is not must, Can return zero, single or multiple values or table(s) Return type is must, and it can re...
18 February 2016

Load events in Asp.net

›
05 February 2016

Read XML Data for datasource

›
using System.Xml.Linq; <?xml version="1.0" encoding="utf-8" ?> <StatusTypes> <StatusType Name ="All...
07 October 2015

Shadowing in C#

›
In Method override   both methods (base & child class methods) have the same name, same number and same type of parameter in the same ...
10 September 2015

ref vs out in C#

›
While writing a code, we often come across situations where we need to return multiple values from a single function/method. But a method ca...
09 September 2015

.js vs .min.js

›
They are both the same functionally but the .min has all unnecessary characters (white-spaces and comments stripped out, shorter variable na...

Extension Methods in C#.Net

›
Extension methods are a new feature in C# 3.0 You can use extension methods to extend a class/interface, but not to override them. Ext...
24 August 2015

.xlsx sheet data to datatable in C#

›
using System.Data.OleDb; string qry = "Select * from [Sheet1$]"; string excelConnectionString = @"Provider=Microsoft.ACE.OLED...
18 August 2015

Search a column in a table

›
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t...
14 August 2015

Delegates

›
It is not compulsory to create delegates. It is just the easiest way in some situations to get the thing done. If you have multiple methods ...