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);
}
}