How to find all SP using a particular column of a table ?


SELECT * FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Columname%'
Or
SELECT * FROM sys.objects
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Columname%'

How to delete the last character from the string?


TrimEnd removes ending characters from a string. this is a common requirement when formatting string.
Example:-
protected void Page_Load(object sender, EventArgs e)
{
string str = "rengan,";
Response.Write(str.TrimEnd(','));
}

How to show simple popup window using jQuery


In this article I have explained about how to show simple Popup window using jQuery. Each steps I have clearly explained in this article . Introduction: In this article I have explained about how to show simple Popup window using jQuery. Each steps I have clearly explained in this article . The jQuery java script file can be downloaded from jQuery Official website http://www.jquery.com/ To load JQuery in your application Just copy and past below line titile tag Just copy and paste below code after import jquery Full Code Simple Popup Window using JQuery
User Name
Password
Close
My original Post is http://www.dotnetspider.com/resources/43951-How-show-simple-popup-window-using-jQuery.aspx

How to set focus on a Textbox on page load ?


protected void Page_Load(object sender, EventArgs e)
{ if (!Page.IsPostBack)
{ Page.SetFocus(TextBox1);
}
}

What is Json?

What is Json?

JSON Stands for Javascript Object Notation. JSON is language Independent. JSON is syntax for storing and exchanging text information. JSON is smaller than XML , and faster and easier to parse. One of the most common use of JSON is to fetch JSON data from a web server convert the JSON data to a javascript object, and then it uses the data in a web page.


.Net questions with OOPS



What is Object Oriented Programming ?
What's a Class ?
What's a Object ?
What's the relation between Classes and Objects ?
What are different properties provided by Object-oriented systems ?
Can you explain different properties of Object Oriented Systems?
what is Polymorphism?
What is meant by Binding?
What is meant by static binding?
What is meant by Dynamic binding?
Define Modularity?
What is meant by Persistence?
What is friend function?
What is a virtual function?
What is a ternary operator?
What is exception handling?
What are the various types of constructors?
What is a copy constructor?
What is Access Modifier in OOPS?
What is Compile Time Polymorphism in OOPS?
can we implement multiple inheritance by using interfaces in C#.net?
How a pointer stores address?
Difference between Object Base and Object Oriented ?
Main Difference between Method and function?
What is the difference between a struct and a class in C#?
If you are required to call a non-static method in static method then how will you do this?
If you want to restrict user to make only one object in the entire application usage how will you achieve this?

What's difference between Association , Aggregation and Inheritance relationships?
How can we achieve inheritance in VB.NET ?

What are abstract classes ?
What's a Interface ?
What is difference between abstract classes and interfaces?
What is a delegate ?
What are event's ?
Do events have return type ?
Can event's have access modifiers ?
Can we have shared events ?
What is shadowing ?
What's difference between Shadowing and Overriding ?
What's difference between delegate and events?
If we inherit a class do the private variables also get inherited ?
What are different accessibility levels defined in .NET ?
Can you prevent a class from overriding ?
What's the use of "MustInherit" keyword in VB.NET ?
What is Dispose method in .NET ?
Whats the use of "OverRides" and "Overridable" keywords ?

Why can not you specify accessibility modifier in Interface ?
What are similarities between Class and structure ?
What's the difference between Class and structure's ?
What does virtual keyword mean ?
What are shared (VB.NET)/Static(C#) variables?


Where are all .NET Collection classes located ?
What is ArrayList ?
What's a HashTable ?
What's difference between HashTable and ArrayList ?
What are queues and stacks ?
What is ENUM ?
What is nested Classes ?
What's Operator Overloading in .NET?
In below sample code if we create a object of class2 which constructor will fire first ?
What's the significance of Finalize method in .NET?
Why is it preferred to not use finalize for clean up?
How can we suppress a finalize method?
What's the use of DISPOSE method?
How do I force the Dispose method to be called automatically, as clients can forget to call Dispose
method?
In what instances you will declare a constructor to be private?
Can we have different access modifiers on get/set methods of a property ?
If we write a goto or a return statement in try and catch block will the finally block execute ?

What is Indexer ?
Can we have static indexer in C# ?
In a program there are multiple catch blocks so can it happen that two catch blocks are executed ?
What is the difference between System.String and System.StringBuilder classes?
What is sealed class?