Suppose there is two versions of a assembly, how your application will decide which version to use?

In web.config under binding give old version and new versi...

Read More

Why object of abstract class can’t be instantiate

We all knows that object of abstract class can be created but cannot be instantiated, but important question is why its not allowed to instantiate the object of abstract class? Lets understand it with an example: public abstract class cal { public cal() { } public cal(int a) { } public abstract int add(int a, int b); } public class c2 { cal...

Read More

Can we create clustered index on non primary key column

Yes we can create clustered index on non-primary key column but that column must be unique and the primary key column of that table must have non-clustered index. By default primary key column contains clustered index so its recommended to create such non-primary key clustered index column first and then should create primary key column so in such case the primary key on that column will be with non-clustered. But its highly...

Read More

What is use of parameterized constructor in abstract class? As Abstract classes cannot be instantiated

public abstract class ABC { int _a; public ABC(int a) { _a = a; } public abstract void computeA(); }; The above question is little bit tricky, it wants to make you confuse by emphasizing on keyword “Abstract”, where as it has got nothing to do with abstract class. First of all its essential to understand the constructor call chain. Whenever an object of a class created, its constructor gets called and that constructor...

Read More

What is difference between Private and Sealed Classes

Sealed Class:"Sealed" keyword provide us facility to prevent a class to be inherited by other classes, so "Sealed" classes cannot be inherited by any other class. You can also use the sealed modifier on a method or property that overrides a virtual method or property in a base class. This enables you to allow classes to derive from your class and prevent them from overriding specific virtual methods or properties. "Sealed"...

Read More

Override style of css class for some elements in page

I had to change the image of handle of jquery's slider control for some specific page, i have done that by below style, which i created in the page in which i had to change the image of slider's handel. < style type="text/css" > .ui-slider-horizontal .ui-state-default { background: white url(../images/sliderhandle.png) no-repeat scroll 50% 50%; } .ui-slider-horizontal .ui-slider-handle { ...

Read More

Cast Int to Enum and vice-versa

Many of times we face a situation where we are to cast integer/string value to Enum or vice-versa Cast Int To Enum From a string: YourEnum foo = (YourEnum) Enum.Parse(typeof(YourEnum), yourString); From an int: YourEnum foo = (YourEnum)yourInt; From number you can also: YourEnum foo = Enum.ToObject(typeof(YourEnum) , yourInt); Cast Enum To Int int something = (int)Question.Role; Get Enum type as a string: YourEnumName.ItsOption.ToString() Compiled...

Read More

Magic Tables in SQL Server

Magic TablesThere are two Magic tables available in SQL Server named "Inserted" and "Deleted". These are mantained by SQL server for Internal processing whenever an update, insert of delete occur on a table. so These are not physical tables, only Internal tables When ever insert statement is fired the "Inserted" table is populated with newly inserted Row and when ever delete statement is fired the "Deleted" table is populated...

Read More

Get Ranking using ROW_Number() without specific ordering in SQL Server

As we all knows that, to get ranking with query we use ROW_Number() in sql server but this issue with Row_Number() is that it only works with "order by" and sometimes we face a situation where we wants the ranking without doing any change in its ordering. To do so, you can do a trick to provide order by to Row_Number as well as it will not affect ordering of your result. With ordering, this will provide result with row_number...

Read More

Multi record Insert into column with unique key constraint and ignore duplicate

Lets say i have got a table named tblcity and it contains two columns cityid and cityname. this table contains lets say 1000 records. now wants to insert some cities from a another table into this table and i wants that if city already exists in tblcity then it should not be reinserted. to do so, mysql provides very good facility to ignore duplicate like: INSERT IGNORE INTO Table2(Id, Name) SELECT Id, Name FROM Table1 Source:...

Read More