C#: Draw string with custom font

var fonts = new PrivateFontCollection();
fonts.AddFontFile(Server.MapPath("~/Alix2.ttf"));

using(var bm = new Bitmap(300, 100))
{
	using(var font = new Font(fonts.Families.First(), 22))
	{
		using(var g = Graphics.FromImage(bm))
		{
			g.DrawString("Hello fonts", font, Brushes.White, 50, 20);
		}
	}

	bm.Save(Server.MapPath("img.jpg"), ImageFormat.Jpeg);
}

C#, read sheets names from Excel (*.xls) file

var file = Server.MapPath("file.xls");

var cs = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;", file);

using(var conn = new OleDbConnection(cs))

{

	conn.Open();

	var table = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

	var sheets = table.Rows.Cast().Select(x => x["TABLE_NAME"]).ToList();

	grid.DataSource = sheets;

	grid.DataBind();

}

MVC 3: disable browser cache

public class NoCache : ActionFilterAttribute
{
 public override void OnResultExecuting(ResultExecutingContext filterContext)
 {
  filterContext.HttpContext.Response.Cache.SetExpires(DateTime.UtcNow.AddDays(-1));
  filterContext.HttpContext.Response.Cache.SetValidUntilExpires(false);
  filterContext.HttpContext.Response.Cache.SetRevalidation(HttpCacheRevalidation.AllCaches);
  filterContext.HttpContext.Response.Cache.SetCacheability(HttpCacheability.NoCache);
  filterContext.HttpContext.Response.Cache.SetNoStore();

  base.OnResultExecuting(filterContext);
 }
}

ExtJS 4: Wrap Renderer

wrapRenderer: function (value, metadata) {
    metadata.style = 'white-space: normal';
    return value;
}

Visual Studio: find invalid commas in *.js

Use find with regexp:

,[:b\n]*[\]\)\}]

Oracle grant execute

grant execute on aspnetuser.goods_all_get_gtitle_by_gid to pds_sales;

Anonymous PL/SQL block

DECLARE
   gid NUMBER(10):=5850802;
   title varchar2(80);
BEGIN
   IF gid is null THEN
      DBMS_OUTPUT.PUT_LINE('GID is null');
   ELSE
      select t.g_name
      into title
      from typhoon.tbl_goods_all t
      where t.g_id = gid;
      DBMS_OUTPUT.PUT_LINE(title);
   END IF;
END;