Multi Database Management Tool

Multi Database Management Tool supports Microsoft Access, Excel, SQLite, Firebird, dBase, FoxPro, OData, Generic OLEDB, Generic ODBC, SQL Server, LocalDB, SQL Server Compact, SQL Azure, MySQL, Oracle, IBM DB2, IBM Informix, PostgreSQL, Sybase ASE. It can be used to SharePoint 2013 OData queries. Check this link: http://fishcodelib.com/Database.htm

ASP.NET Inline Tags

inline asp.net tags... sorting them all out (<%$, <%=, <%, <%#, etc.) by naspinski 3/24/2008 8:56:00 AM

There are all sorts of different inline tags, and I haven't found a place that explains them all in one place, so here is the quick and dirty...

<% ... %>

The most basic inline tag, basically runs normal code:

<% if (User.IsInRole("admin")) { %>
You can see this
<% } else { %>
You are no admin fool!
<%} %>

http://msdn2.microsoft.com/en-us/library/ms178135(vs.80).aspx

<%= ... %>

Used for small chunks of information, usually from objects and single pieces of information like a single string or int variable:

The Date is now <%= DateTime.Now.ToShortDateString() %>
The value of string1 is <%= string1 %>

http://msdn2.microsoft.com/en-us/library/6dwsdcf5(VS.71).aspx

*note: <%= is the equivalent of Response.Write() - Courtesy of Adam from the US,thanks!

<%# .. %>

Used for Binding Expressions; such as Eval and Bind, most often found in data controls like GridView, Repeater, etc.:

<%# Eval("MeetingName") %>

http://msdn2.microsoft.com/en-us/library/ms178366.aspx

<%$ ... %>

Used for expressions, not code; often seen with DataSources:

" SelectCommand="SELECT * FROM [table]" />

http://msdn2.microsoft.com/en-us/library/d5bd1tad.aspx

<%@ ... %>

This is for directive syntax; basically the stuff you see at the top your your aspx pages like control registration and page declaration:

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" Title="Untitled Page" %>
<%@ Register TagPrefix="wp" Namespace="CustomWebParts" %>

http://msdn2.microsoft.com/en-us/library/xz702w3e(VS.80).aspx

<%-- ... --%>

This is a server side comment, stuff you don't want anyone without code access to see:

<%-- sometimes end users make me angry --%>

http://msdn2.microsoft.com/en-us/library/4acf8afk.aspx

Source : Click Here

Create MySite Programmatically

Here is the code, which will create MySite for the user programatically

public static void CreateMySite(string userId)
{
using (SPSite site = new SPSite("http://sharepointurl"))
{
ServerContext context = ServerContext.GetContext(site);
UserProfileManager profileManager = new UserProfileManager(context);
UserProfile userProfile = profileManager.GetUserProfile(userId);
userProfile.CreatePersonalSite();

}
}

Best Practices

For More Info http://mindsharpblogs.com/ben/archive/2008/11/06/11316.aspx

Fetch SharePoint Data Programmatically

There are different ways to fetch data in Share Point. SharePoint uses CAML to query the data. Following are the possible ways to retrieve the content
FullTextSqlQuery - search
SPListItems and for each loop - object model
List Web Service - Search from remote client
SPQuery Object - Search the list
SPSiteDataQuery - Search across the site
PortalSiteMapProvider

Step by Step - Install & Configure

http://mindsharpblogs.com/bill/archive/2006/06/27/1153.aspx

SharePoint Javascript Validation

http://edinkapic.blogspot.com/2007/10/add-javascript-date-validation-into.html