Differences Between Procedures and Functions

http://www.c-sharpcorner.com/uploadfile/skumaar_mca/differences-between-procedures-and-functions/

Understanding .NET Framework at a glance

http://www.c-sharpcorner.com/UploadFile/chandrakantpp/UnderstandingFrameworkatglance11292005013851AM/UnderstandingFrameworkatglance.aspx

Views in SqlServer

SQL Server excludes an ORDER BY clause from a view to comply with the
ANSI SQL-92 standard. The only time that SQL Server supports an ORDER BY clause in a view is when it is used in conjunction with the TOP keyword. Note that the TOP keyword
is a SQL Server extension to the ANSI SQL-92 standard.
Source: http://dotnetguts.blogspot.in/2007/08/faq-on-view-in-sql-server.html

Difference between ArrayList and List<>

basic-difference-between-arraylist-and-list

Learning RegularExpressions in c#

learning-regex-regular-expression-the-easy-way

Empty Footer Template in Datalist

<FooterTemplate>
<asp:Label runat="server" ID="dlVideosFooter" Text="No Vidoes available at this moment for the selected category.Please try later or select another category"
Visible='<%#bool.Parse((dlBuzzVideos.Items.Count==0).ToString()) %>'></asp:Label>
</FooterTemplate>

Note:dlBuzzVideos is the datalist id.

Trim a DataBound Linkbutton inside a DataList

<ItemTemplate>

<asp:LinkButton ID="LinkButton1" runat="server" Text='<%
getShortString(Eval("Location1")) %>'></asp:LinkButton>
</ItemTemplate>
</asp:DataList>

protected string getShortString(object value)
{
string shrtString = value.ToString();
if (shrtString.Length > 4) // Change this value to set your character limit
{
shrtString = shrtString.Substring(0, 4) + "..."; // Change this value to set your character limit

}
return (shrtString);
}

source : http://forums.asp.net/t/1521615.aspx/1