SELECT sysobjects.Name , sysindexes.Rows FROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.id WHERE type = ‘U’ AND sysindexes.IndId < 2 ORDER BY sysobjects.Namecode Read more →
Month: March 2013
MethodImplOptions.AggressiveInlining
MethodImplOptions.AggressiveInlining Read more →
css switcher
css switcher Read more →
How to run code from sql server in c#
How to run code from sql server in c# SqlCommand cmd = new SqlCommand(“select Developer from Stackoverflow where UserID=’786′ and Developer=’Sufiyan'”, con); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { string codeSnippet = reader[“CodeSnippet”].ToString(); dynamic script = CSScript.LoadCode(@” using System; using System.Windows.Forms; using System.Collections.Generic; using System.Data; using System.Windows.Forms; using System.Data.SqlClient; public class RunFromSqlServer {… Read more →
OData Paging
Usage: using System; using System.Collections.Generic; using System.Diagnostics; using System.Linq; using System.Net.Http; using System.Web.Http; using System.Web.Http.OData.Query; namespace WebApiTest.Controllers { public class ValuesController : ApiController { private const int PAGESIZE = 25; // GET api/values [ActionName(“Default”)] public PageOfResults Get(ODataQueryOptions queryOptions) { var data = new Poco[] { new Poco() { id = 1, name = “one”, type = “a” }, new Poco()… Read more →
a debuggable/installable windows service template: Part 1 Part 2 Minor amendment: Program.cs catch (Exception ex) { ConsoleHarness.WriteToConsole(ConsoleColor.Red, “An exception occurred in Main(): {0}”, ex); if (Environment.UserInteractive) { Console.ReadKey(); } } Read more →
3 column layout
3 column layout <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Strict//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd”> <html xmlns=”http://www.w3.org/1999/xhtml” xml:lang=”en-GB”> <head> <title>The Perfect 3 Column Liquid Layout</title> <link rel=”stylesheet” type=”text/css” href=”screen.css” media=”screen” /> </head> <body> <div id=”header”> </div> <div class=”colmask threecol”> <div class=”colmid”> <div class=”colleft”> <div class=”col1″> <!– Column 1 start –> <p>centre stuff</p> <!– Column 1 end –> </div> <div class=”col2″> <!– Column 2 start… Read more →
type safe enum extensions for MVC
extension method public static class EnumSelectList { public static IEnumerable GetList(this T thing) where T : IEnumerable { var result = from i in thing select new SelectListItem { Text = i.Value }; return result; } } new method on the type public static IEnumerable GetAll() { var list = ( from i in _instances select i.Value) .Cast(); return list;… Read more →