My Web Development Blog

LINQ: left join

2011-11-08T10:49:00.000-08:00


ffrom p in products
join c in categories on p.CategoryId equals c.Id into g
from c in g.DefaultIfEmpty()
select new
{
 CategoryTitle = c == null ? string.Empty : c.Title,
 ProductTitle = p.Title
};

Oracle: disable a trigger in an stored procedure

2011-10-26T04:49:00.000-07:00


execute immediate 'ALTER TRIGGER tr_name DISABLE';

...

execute immediate 'ALTER TRIGGER tr_name ENABLE';

Принципы проектирования классов (S.O.L.I.D.)

2011-10-20T02:27:00.000-07:00

Хорошая серия постов о (S.O.L.I.D.)

ExtJS: delay/buffer event

2011-10-17T03:27:00.000-07:00


listeners: {
    keyup: {
        fn: function () {
            //...
        },
        delay: 500 //buffer: 500
    }
}

EF 4.1 Code-First: generate model

2011-10-13T03:11:00.000-07:00


private void WriteEdm()
{
    var settings = new XmlWriterSettings();
    settings.Indent = true;

    using (var ctx = new WebEntities())
    {
        using (var writer = XmlWriter.Create(Server.MapPath(@"Model.edmx"), settings))
        {
            EdmxWriter.WriteEdmx(ctx, writer);
        }
    }
}

EF 4.1 Code-First: remove all conventions

2011-10-12T22:57:00.000-07:00


        protected override void OnModelCreating(DbModelBuilder db)
        {
            var types = typeof(IConvention).Assembly.GetTypes()
                .Where(x => x.IsClass && !x.IsAbstract && typeof(IConvention).IsAssignableFrom(x))
                .ToList();

            var remove = typeof(ConventionsConfiguration).GetMethod("Remove");

            types.ForEach(x => remove.MakeGenericMethod(x).Invoke(db.Conventions, null));
        }

Полный список аннотаций, поддерживаемый в EF 4.1

2011-10-12T07:16:00.000-07:00


    KeyAttribute

    StringLengthAttribute

    MaxLengthAttribute

    ConcurrencyCheckAttribute

    RequiredAttribute

    TimestampAttribute

    ComplexTypeAttribute

    ColumnAttribute
    Атрибут свойства для указания имени столбца, ординарного типа и типа данных

    TableAttribute
    Атрибут класса для указания имени таблицы и схемы

    InversePropertyAttribute
    Атрибут свойства навигации для указания свойства, которое представляет другой конец связи

    ForeignKeyAttribute
    Placed on a navigation property to specify the property that represents the foreign key of the relationship

    DatabaseGeneratedAttribute
    Атрибут свойства для указания того, как база данных будет вычислять  значение поля (Identity, Computed or None)

    NotMappedAttribute
    Атрибут свойства или класса для его исключения из базы данных

source

MVC: Cascading Dropdown

2011-10-09T09:40:00.000-07:00

Action Methods:


[HttpPost]
public JsonResult GetCategories()
{
    Thread.Sleep(1000);

    return Json(categoriesList);
}

[HttpPost]
public JsonResult GetProducts(int? category)
{
    Thread.Sleep(1000);

    var list = category.HasValue ? productsList.Where(x => x.CategoryId == category).ToList() : productsList;

    return Json(list);
}

HTML:


<lable for="category">Category</lable>
<select id="category" name="category">
<option value="-1">Select...</option>
@foreach (var item in Model)
{
    <option value="@item.Id">@item.Title</option>
}
</select>
<lable for="product">Product</lable>
<select id="product" name="product">
    <option value="-1">Select cetegory...</option>
</select>

Script:


$(function () {
        var categories = $('#category');
        var products = $('#product');

        products.change(function () {
            console.log(products.val());
        });

        categories.change(function () {
            var id = categories.val();

            if (id != -1) {
                products.empty();
                products.append($('<option/>', {
                    value: -1,
                    text: "Loading..."
                }));

                $.ajax({
                    type: 'POST',
                    url: "/Products/GetProducts",
                    data: { category: id },
                    success: function (resp) {
                        var items = eval(resp);

                        products.empty();
                        products.append($('<option/>', {
                            value: -1,
                            text: "Select product..."
                        }));

                        $.each(items, function (index, item) {
                            products.append($('<option/>', {
                                value: item.Id,
                                text: item.Title
                            }))
                        });
                    },
                    error: function () {
                        console.log('Error');
                        console.log(arguments);
                    }
                });
            } else {
                products.empty();
                products.append($('<option/>', {
                    value: -1,
                    text: "Select cetegory..."
                }));
            }
        });
    });

C#: Draw string with custom font

2011-09-15T01:14:00.000-07:00


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

2011-08-30T03:55:00.000-07:00


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

2011-08-04T04:54:00.000-07:00


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

2011-08-04T02:15:00.000-07:00


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

Visual Studio: find invalid commas in *.js

2011-07-22T00:01:00.000-07:00

Use find with regexp:


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

Oracle grant execute

2011-07-13T04:51:00.000-07:00


grant execute on aspnetuser.goods_all_get_gtitle_by_gid to pds_sales;

Anonymous PL/SQL block

2011-07-13T00:09:00.000-07:00


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;

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

2011-07-04T22:48:00.000-07:00


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))
{
  using(var cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", conn))
  {
    using(var adapter = new OleDbDataAdapter(cmd))
    {
      var table = new DataTable();

      adapter.Fill(table);

      grid.DataSource = table;
      grid.DataBind();
    }
  }
}

Ext: confirm dialog localization

2011-07-01T04:01:00.000-07:00


if (Ext.window.MessageBox) {
    Ext.window.MessageBox.prototype.buttonText = {
        ok: "OK",
        cancel: "Отмена",
        yes: "Да",
        no: "Нет"
    };
    Ext.MessageBox = Ext.Msg = new Ext.window.MessageBox();
}

Oracle RETURNING Clause - get identity of inserted row

2011-06-30T07:35:00.000-07:00


PROCEDURE Ins
(pContactID     OUT Contacts.ContactID%TYPE,
 pFirstname     IN Contacts.Firstname%TYPE,
 pSurname       IN Contacts.Surname%TYPE)
IS
BEGIN
 INSERT INTO Contacts
 (fname, sname)
 VALUES
 (pFirstname, pSurname)
 RETURNING ContactID INTO pContactID;
END;

ExtJS 4.0 GridPanel double-click event

2011-06-30T03:12:00.000-07:00

In ExtJS 4.0 you need to listen for events on the GridPanel’s view, via the “viewConfig”:


    viewConfig: {
        listeners: {
           itemdblclick: function(dataview, index, item, e) {
                    console.log('itemdblclick');
                }
            }
      }

Wow slider

2011-06-22T23:01:00.000-07:00

demo

ExtJS State

2011-06-21T07:40:00.000-07:00

Set provider:


Ext.state.Manager.setProvider(new Ext.state.CookieProvider({
  expires: new Date(new Date().getTime() + (1000 * 60 * 60 * 24 * 30))//30 days
}));

Field Example:


{
    xtype: 'textfield',
    fieldLabel: 'Логин',
    name: 'UserName',
    allowBlank: false,
    validateOnBlur: false,
    blankText: 'Введите логин',
    stateful: true,
    stateId: 'UserName',
    stateEvents: ['blur'],
    getState: function () {
        return { value: this.getValue() };
    },
    applyState: function (state) {
        this.setValue(state.value);
    }
}

ExtJS получить параметры URL

2011-06-21T06:10:00.000-07:00

Add ext-methods:


Ext.apply(Ext, {
    urlParams: function () {
        return Ext.Object.fromQueryString(location.search);
    },
    urlParam: function (name) {
        return this.urlParams()[name];
    }
});

Use:


var query = Ext.urlParams();
var p1 = query.p1;
//or
var p2 = Ext.urlParam('p2');

ORA-01008: not all variables bound

2011-06-17T07:34:00.000-07:00

Если код 100 раз проверен, а ошибка есть - лечит ошибку:


command.BindByName = true;

ExtJS: 3 Value Checkbox

2011-06-15T06:36:00.000-07:00

js:


{
    xtype: 'checkbox',
    fieldLabel: 'Active',
    name: 'Active',
    inputValue: 'true',
    cls: 'value-undefined',
    handler: function () {
        if (!this.uncheckedValue) {
            this.removeCls('value-undefined');
            this.uncheckedValue = 'false';
        }
    },
    reset: function () {
        this.setValue(undefined);
        this.addCls('value-undefined');
        if (this.uncheckedValue) this.uncheckedValue = undefined;
    }
}

css:


.x-field.value-undefined input
{
    opacity:0.4;
}

Ext JS 4: localize grid loading message

2011-06-09T07:49:00.000-07:00


Ext.view.AbstractView.prototype.loadingText = "Загрузка...";

MVC 3 Content with no cache

2011-06-09T04:18:00.000-07:00

Simple helper:


public static class UrlHelperExtensions
{
 public static string ContentNoCache(this UrlHelper url, string path)
 {
  return url.Content("{0}?_dc={1}".FormatWith(path, DateTime.Now.ToFileTime()));
 }
}

where FormatWith:


public static string FormatWith(this string input, params object[] args)
{
 return string.Format(input, args);
}

Use:
<script src="@Url.ContentNoCache("~/Scripts/app.js")" type="text/javascript"></script>
Result:
<script src="/Scripts/app.js?_dc=129520920501677826" type="text/javascript"></script>

Sql paging in Oracle

2011-06-03T01:12:00.000-07:00


select t.*
from (select t.*, row_number() over (order by t.aps_id desc) rn
      from pds_sales.tbl_all_pds_sales t) t
where t.rn > :first and t.rn <= :last

ExtJs 4 dateFormat M$

2011-06-02T05:28:00.000-07:00

ExtJS 3:
{ name: 'SaleDate', type: 'date', dateFormat: "M$" }

ExtJS 4:
{ name: 'SaleDate', type: 'date', dateFormat: "MS" }

Some w3s css rules

2011-05-30T01:29:00.000-07:00

background: #f00 url(background.gif) no-repeat fixed 0 0;
// по W3C: цвет картинка повторение аттачмент координаты

font: italic small-caps bold 1em/140% "Lucida Grande",sans-serif;
// по W3C: style variant weight size/line-height family

Сравнение браузеров (HTML5)

2011-05-26T23:11:00.000-07:00

Сравнение браузеров (HTML5)

Compatibility tables for support of HTML5, CSS3, SVG and more in desktop and mobile browsers

Поддержка твоим браузером HTML5/CSS3

Modernizr — HTML5 и CSS3 уже сегодня

Default ASP.NET Membership Provider Settings

2011-05-25T12:10:00.000-07:00

Code to view settings:


protected void Page_Load(object sender, EventArgs e)
{
    var type = typeof(Membership);

    var infos = type.GetProperties(BindingFlags.Public | BindingFlags.Static);

    foreach (var p in infos)
    {
        PrintProp(p);
    }
}

private void PrintProp(PropertyInfo p)
{
    var value = p.GetValue(null, null);

    Response.Write(string.Format("<b>{0}</b>: {1}<br />", p.Name, value));
}

Result:

EnablePasswordRetrieval: False
EnablePasswordReset: True
RequiresQuestionAndAnswer: True
UserIsOnlineTimeWindow: 15
Providers: System.Web.Security.MembershipProviderCollection
Provider: System.Web.Security.SqlMembershipProvider
HashAlgorithmType: HMACSHA256
MaxInvalidPasswordAttempts: 5
PasswordAttemptWindow: 10
MinRequiredPasswordLength: 7
MinRequiredNonAlphanumericCharacters: 1
PasswordStrengthRegularExpression:
ApplicationName: /

and from machine.config

requiresUniqueEmail: false

Use the ref config option in ExtJS

2011-05-21T01:22:00.001-07:00


var win = new Ext.Window({
    layout: 'fit',
    width: 300,
    height: 200,
    title: 'my window',
    items: [{
            ref: 'panel',
            xtype: 'panel', layout: 'form',
            frame: true, defaults: {xtype: 'textfield'},
            items: [
                {ref: '../nameField', fieldLabel: 'Name'},
                {ref: 'age', fieldLabel: 'Age'}
            ]
    }]
});

win.show();
//so now, with the above ref options, you can do:
win.nameField.setValue('name here');
win.panel.age.setValue(20);

source

Неплохой css reset

2011-05-21T00:09:00.000-07:00


html, body, div, span, applet, object, iframe, h1, h2, h3, h4, h5, h6, p, blockquote,
pre, a, abbr, acronym, address, big, cite, code, del, dfn, em, font, img, ins, kbd,
q, s, samp, small, strike, strong, sub, sup, tt, var, dl, dt, dd, ol, ul, li,
fieldset, form, label, legend, table, caption, tbody, tfoot, thead, tr, th, td {
    border: 0 none;
    font-family: inherit;
    font-size: 100%;
    font-style: inherit;
    font-weight: inherit;
    margin: 0;
    outline: 0 none;
    padding: 0;
    text-decoration: none;
    vertical-align: baseline;
}

Base64 Helpers

2011-05-20T02:29:00.000-07:00


public static string ToBase64(this string input)
{
 if(string.IsNullOrEmpty(input)) return input;

 return Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(input));
}

public static string FromBase64(this string input)
{
 if(string.IsNullOrEmpty(input)) return input;

 return System.Text.Encoding.UTF8.GetString(Convert.FromBase64String(input));
}

Use:


var a = "input";
var b = a.ToBase64();
var c = b.FromBase64();

Webmoney merchant form

2011-05-04T02:54:00.000-07:00

On page:
<asp:Content ID="content" ContentPlaceHolderID="afterform" runat="server">
<uc:WebMoneyForm id="wmpay" runat="server" />
</asp:Content>
In code:
wmpay.Amount = 1.5;
wmpay.Description = "некий товар";
wmpay.OrderID = 1001;
wmpay.Purse = "Uxxxxxxxxxxxx";
wmpay.TestMode = true;


public class WebMoneyForm : System.Web.UI.Control
{
 public string Action { get; set; }
 public string Method { get; set; }
 public double Amount { get; set; }
 public string Description { get; set; }
 public bool TestMode { get; set; }
 public int OrderID { get; set; }
 public string Purse { get; set; }

 public Dictionary Params { get; private set; }

 public WebMoneyForm()
 {
  Method = "post";
  Action = "https://merchant.webmoney.ru/lmi/payment.asp";

  Params = new Dictionary<string, string>();
 }

 public void AppParam(string name, string value)
 {
  if(Params.ContainsKey(name))
  {
   Params[name] = value;
  }
  else
  {
   Params.Add(name, value);
  }
 }

 protected override void Render(System.Web.UI.HtmlTextWriter writer)
 {
  writer.AddAttribute("id", ID);
  writer.AddAttribute("name", ID);
  writer.AddAttribute("action", Action);
  writer.AddAttribute("method", Method);
  writer.RenderBeginTag(HtmlTextWriterTag.Form);

  AppParam("LMI_PAYMENT_AMOUNT", Math.Round(Amount, 2).ToString());
  AppParam("LMI_PAYMENT_DESC_BASE64", Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(Description)));

  AppParam("LMI_PAYMENT_NO", OrderID.ToString());
  AppParam("LMI_PAYEE_PURSE", Purse);

  if(TestMode) AppParam("LMI_SIM_MODE", "0");

  foreach(var item in Params)
  {
   AddHidden(writer, item.Key, item.Value);
  }

  writer.RenderEndTag();
 }

 private void AddHidden(System.Web.UI.HtmlTextWriter writer, string name, string value)
 {
  writer.Write(string.Format("<input type='hidden' name='{0}' value='{1}' />\n", name, value));
 }
}

CSS opacity

2011-04-19T01:03:00.000-07:00

/* This works in IE */
filter: alpha(opacity=50);

/* Older than Firefox 0.9 */
-moz-opacity:0.5;

/* Safari 1.x (pre WebKit!) */
-khtml-opacity: 0.5;

/* Modern!
/* Firefox 0.9+, Safari 2?, Chrome any?
/* Opera 9+, IE 9+ */
opacity: 0.5;

Copy:

filter: alpha(opacity=50);
-moz-opacity:0.5;
-khtml-opacity: 0.5;
opacity: 0.5;

How to set Visual Studio default "company name"?

2011-04-18T12:37:00.001-07:00

Set value in RegisteredOrganization under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion

View LINQ Generated SQL

2011-04-05T05:15:00.000-07:00

Write class:


public class LinqDebugger : System.IO.TextWriter
{
  static readonly LinqDebugger _instance = new LinqDebugger();
  static readonly string _separator = new String('_', 150);

  public static LinqDebugger Instance { get { return _instance; } }

  private LinqDebugger()
  {
  }

  public override void WriteLine(string value)
  {
    System.Diagnostics.Debug.WriteLine(value);
    if (!string.IsNullOrEmpty(value) && value.StartsWith("-- Context:"))
    System.Diagnostics.Debug.WriteLine(_separator);
  }

  public override System.Text.Encoding Encoding
  {
   get { throw new NotImplementedException(); }
  }
}

Use:


  var db = new DBDataContext();
  db.Log = LinqDebugger.Instance;

VS output:

ListView + DataPager + QueryStringField

2011-04-04T05:38:00.000-07:00


protected void Page_Load(object sender, EventArgs e)
{
  //page EnableViewState="true"
  if(!IsPostBack) BindData();

  //page EnableViewState="false"
  //BindData();
}

private void BindData()
{
  int page;
  if(!int.TryParse(Request.QueryString[pager.QueryStringField], out page)) page = 1;
  
  pager.SetPageProperties((page - 1) * pager.PageSize, pager.PageSize, false);

  items.DataSource = _items;
  items.DataBind();
}

Default Documents in IIS 7

2011-03-27T06:32:00.000-07:00


<system.webServer>
    <defaultDocument>
      <files>
        <clear/>
        <add value="~/Default.htm"/>
      </files>
    </defaultDocument>
<system.webServer>

Маленький helper-метод

2011-03-24T04:47:00.000-07:00


public static bool eq(this string s, string s2)
{
  return string.Compare(s, s2, true) == 0;
}

Use:


if(url.eq("/Default.aspx"))
{
  ...
}

CultureInfo

2011-03-22T08:16:00.000-07:00

en-GB - специфическая
ro - нейтральная


var c = "ro";

//создаем специфическую с нейтральной
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(c);
//можно использовать нейтральную, например, Strings.ro.resx
Thread.CurrentThread.CurrentUICulture = new CultureInfo(c);

.NET парсер HTML

2011-03-18T00:18:00.000-07:00

Стояла задача: вытянуть данные из таблицы в .mht документе.
Сначала подумал решить на C#+Regex, но потом нарыл парсер Html Agility Pack. Спасибо автору:).

Вот как я это сделал:


private void MainForm_Load(object sender, EventArgs e)
{
 try
 {
  var file = @"C:\демпинг.mht";

  var contentHex = File.ReadAllText(file, Encoding.GetEncoding(1251));

  var content = Regex.Replace(contentHex, @"=[0-9A-F]{2}", m => HexStringToUtf8(m.ToString().Substring(1)));

  var doc = new HtmlAgilityPack.HtmlDocument();

  doc.LoadHtml(content);

  var table = doc.DocumentNode.SelectSingleNode("/html[1]/body[1]/div[1]/table[1]");

  if(table == null) throw new Exception("data not found");

  var rows = table.SelectNodes("tbody/tr").Skip(1).ToList();

  var data = (from r in rows
     let tds = r.SelectNodes("td")
     select new
     {
      N = tds[0].InnerText,
      Group = tds[1].InnerText,
      Product = tds[2].InnerText,
      OurPrice = tds[3].InnerText,
      AveragePrice = tds[4].InnerText,
      Difference = tds[5].InnerText,
      DifferencePercent = tds[6].InnerText,
      Offers = tds[7].InnerText,
      Shops = tds[7].Attributes["title"].Value,
      MinPrice = tds[8].InnerText,
      MaxPrice = tds[9].InnerText
     }).ToList();

  grid.DataSource = data;
 }
 catch(Exception exc)
 {
  MessageBox.Show(exc.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
 }
}

private string HexStringToUtf8(string hexString)
{
 var bytes = new List();
 
 for(int i = 0; i <= hexString.Length - 2; i += 2)
 {
  bytes.Add(byte.Parse(hexString.Substring(i, 2), System.Globalization.NumberStyles.HexNumber));
 }

 var str = Encoding.GetEncoding(1251).GetString(bytes.ToArray());

 return str;
}

Результат:

Портативные версии основных браузеров

2011-03-10T01:24:00.001-08:00

Портативные версии основных браузеров

Float blocks

2011-03-10T00:45:00.000-08:00


/* Firefox 2 */
display: -moz-inline-stack;

/* IE 8, Firefox 3, Opera, Safari, Chrome */
display: inline-block;
vertical-align: top;

/* IE 6 и 7 */
zoom: 1;
*display: inline;

Source

Несколько полезных примеров регулярок

2011-03-04T00:04:00.000-08:00

foo – Слово foo
^foo – Наичнается с foo
foo$ - Кончается с foo
^foo$ - Точное совпадение с foo
[abc] – a, b или c
[a-z] – Любая строчная буква
[^A-Z] - Любой символ не в верхнем регистре
(gif|jpg) - Совпадает либо gif либо jpeg
[a-z]+ - Одна или более строчных букв
[0-9.-] - Любое число, точка или минус
^[a-zA-Z0-9_]{1,}$ – Любое слово, в котором как минимум одна буква, число или _
([wx])([yz]) - wy, wz или xy, xz
[^A-Za-z0-9] – Любой символ (не буква и не цифра)
([A-Z]{3}|[0-9]{4}) - Совпадает три буквы или четыре цифры

Взято тут

Using ExtJs XTemplate

2011-02-26T02:03:00.000-08:00


Ext.Ajax.ws({
 url: "WebService.asmx/GetAllClients",
 success: function(data) {
  var tpl = new Ext.XTemplate(
   '<table class="styled"><tr><th>№</th><th>ID</th><th>Name</th></tr>',
   '<tpl for=".">',
   '<tr><td>{#}</td><td>{ID}</td><td>{Name}</td></tr>',
   '</tpl>',
   '</table>'
  );
  tpl.overwrite(Ext.get('container'), data);
 }
});

My result:

FBML not working in IE

2011-02-25T06:02:00.000-08:00

Нужно добавить xmlns:fb="http://www.facebook.com/2008/fbml" в тег htlm:


<html xmlns="http://www.w3.org/1999/xhtml" mlns:fb="http://www.facebook.com/2008/fbml" >

Loading JavaScript Asynchronously

2011-02-23T07:20:00.001-08:00

JQuery plugin:


(function($) {
    jQuery.asyncJs = function(js) {
        var s = document.createElement('script');
        s.type = 'text/javascript';
        s.async = true;
        s.src = js;
        document.getElementsByTagName('head')[0].appendChild(s);
    }
})(jQuery);

Use:


$.asyncJs('http://connect.facebook.net/ru_RU/all.js');

Linq Paging Extensions

2011-02-21T05:03:00.000-08:00


public static class PagingExtensions
{
 //linq to sql
 public static IQueryable Page(this IQueryable source, int page, int size)
 {
  return source.Skip((page - 1) * size).Take(size);
 }

 //linq to objects
 public static IEnumerable Page(this IEnumerable source, int page, int size)
 {
  return source.Skip((page - 1) * size).Take(size);
 }
}

Статистика поиска

2011-02-09T03:16:00.000-08:00

http://wordstat.yandex.ru/
http://www.google.com/insights/search/

Пример курсора

2011-01-13T23:43:00.000-08:00


declare @Login nvarchar(255)
declare @Password nvarchar(255)
declare @i int

DECLARE curs CURSOR FOR
SELECT [Login], [Password]
FROM [UsersToCreate]

OPEN curs

FETCH NEXT FROM curs INTO @Login, @Password

set @i=1

WHILE @@FETCH_STATUS = 0
BEGIN
 BEGIN TRY
  exec('CREATE LOGIN ['+@Login+'] WITH PASSWORD = '''+@Password+'''')
  exec('CREATE USER ['+@Login+'] FOR LOGIN ['+@Login+'] WITH DEFAULT_SCHEMA = my_sc')
  exec('EXEC sp_addrolemember ''my_role'', ['+@Login+']')
 END TRY
 BEGIN CATCH
  print cast(@i as char(3))+ ') login: ' + @Login + ' - error:' + ERROR_MESSAGE()
  set @i= @i+1
 END CATCH;
 FETCH NEXT FROM curs INTO @Login, @Password
END

CLOSE curs
DEALLOCATE curs

C#, Get Current Path

2011-01-11T05:30:00.000-08:00


public static class PathHelper
{
 public static string GetCurrentPath()
 {
  string codeBase = System.Reflection.Assembly.GetExecutingAssembly().CodeBase;
  UriBuilder uri = new UriBuilder(codeBase);
  return System.IO.Path.GetDirectoryName(Uri.UnescapeDataString(uri.Path));
 }

 public static string CombineWithCurrent(string path)
 {
  return System.IO.Path.Combine(GetCurrentPath(), path);
 }
}

Ext-method: Capitalize

2010-12-30T01:09:00.000-08:00


public static string Capitalize(this string value)
{
  if(string.IsNullOrEmpty(value)) return value;
  if(value.Length == 1) return value.ToUpper();
  return value.Substring(0, 1).ToUpper() + value.Substring(1).ToLower();
}

CSS хаки

2010-12-08T09:04:00.000-08:00

div {
background: red; /* для нормальных браузеров */
//background: green; /* для всех ie */
-background: blue; /* “_”, или дефис “-“ для ie6 и ниже */
*background: blue; /* для ie7 и ниже */
}

favi-icon

2010-12-01T04:30:00.000-08:00

Оптимизация клиентской части

2010-12-01T02:11:00.000-08:00

Непогана стяття
Оптимизация клиентской части

Render user control to a string

2010-11-30T06:00:00.000-08:00

Simple render:


var c = LoadControl("uc.ascx");
using(var sw = new System.IO.StringWriter())
using(var tw = new HtmlTextWriter(sw))
{
 c.RenderControl(tw);
 Controls.Add(new LiteralControl(sw.ToString()));
}

Execute and render:


var c = LoadControl("uc.ascx");
var page = new Page();
page.Controls.Add(c);

using(var sw = new System.IO.StringWriter())
using(var tw = new HtmlTextWriter(sw))
{
 Server.Execute(page, tw, false);
 Controls.Add(new LiteralControl(sw.ToString()));
}

Add mime types with IIS7

2010-11-20T00:21:00.000-08:00


<configuration>
    <system.webServer>
        <staticContent>
            <mimeMap fileExtension=".mp4" mimeType="video/mp4" />
        </staticContent>
    </system.webServer>
</configuration>

.NET Round

2010-11-17T12:04:00.000-08:00


Math.Round(3.5);//=4
Math.Round(4.5);//=4

Math.Round(3.5, MidpointRounding.AwayFromZero);//=4
Math.Round(4.5, MidpointRounding.AwayFromZero);//=5

Call webservice with basic auth

2010-11-10T03:11:00.000-08:00


var srv = new SalersService();
srv.Credentials = new NetworkCredential("[user]", "[pass]");
...

Call webservice via proxy

2010-11-10T03:06:00.000-08:00


var srv = new SalersService();
var proxy = new WebProxy("[url]", [port]);
proxy.Credentials = new NetworkCredential("[user]", "[pass]", "[domain]");
srv.Proxy = proxy;
...

Кириллица в куках

2010-11-01T03:00:00.000-07:00

Можно использовать UrlEncode, UrlDecode:


var cookie = new HttpCookie("user", Server.UrlEncode(name));
...
var name = Server.UrlDecode(cookie.Value);

Cool Player

2010-10-26T01:13:00.001-07:00

Нашел крутой плеер

WPF Color Table

2010-10-15T02:46:00.001-07:00

Write to appSettings

2010-10-14T08:48:00.000-07:00


System.Configuration.Configuration config =   
 ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
config.AppSettings.Settings["LastMsgID"].Value = value.ToString();
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");

WPF & Thread.CurrentPrincipal

2010-10-14T01:25:00.000-07:00

так неправильно:

System.Threading.Thread.CurrentPrincipal = [YourPrincipal];

так правильно:

AppDomain.CurrentDomain.SetThreadPrincipal([YourPrincipal]);

Select Top n Random Items

2010-09-28T04:25:00.000-07:00


class Item
{
 public string Name { get; set; }
}
...
var list = new List { 
 new Item() { Name="Item1" },
 new Item() { Name="Item2" },
 new Item() { Name="Item3" },
 new Item() { Name="Item4" },
 new Item() { Name="Item5" },
};

Random rnd = new Random();

var items = from i in list
 orderby rnd.Next()
 select i;

var top = items.Take(3);

.NET 3.5 RSS Feed Handler

2010-09-27T06:26:00.000-07:00


public void ProcessRequest(HttpContext context)
{
 SyndicationFeed feed = GetNoveltiesFeed();

 var output = new StringWriter();
 var writer = new XmlTextWriter(output);

 new Rss20FeedFormatter(feed).WriteTo(writer);

 context.Response.ContentType = "application/rss+xml";
 context.Response.Write(output.ToString());
}

Получить top, left static-элемента

2010-09-23T07:01:00.000-07:00



var div = $('#div1');
var top = Math.round(div.offset().top);
var left = Math.round(div.offset().left);

Remove html-tags from string

2010-09-09T02:27:00.000-07:00


var value = Regex.Replace(value, "<[^>]*?>", string.Empty, RegexOptions.IgnoreCase);

Метод для провірки телефона

2010-08-27T04:13:00.000-07:00


public static bool IsPhone(this string phone)
{
 return Regex.IsMatch(phone, @"^\+?[0-9\-() ]{5,19}$");
}

Custom css for IE 6

2010-08-21T05:47:00.001-07:00


<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="ie6.css" />
<![endif]-->

ExtJS grid wrap column

2010-07-27T23:25:00.000-07:00

Добавляєм в наше апп метод:


App.Globals.wrapRenderer = function(val) {
    return '<div style="white-space:normal !important;">' + val + '</div>';
}

потім використовуємо:


...
{ 
 header: "Описание", 
 dataIndex: "DESCRIPTION",
 renderer: App.Globals.wrapRenderer, 
 width: 200 
},
...

ExtJS app errors handling

2010-07-21T08:26:00.000-07:00

Для того щоб будь-які помилки від сервера виводились в спеціальному вікні
можна зробити override метода request:


Ext.override(Ext.data.Connection, {
    request: Ext.data.Connection.prototype.request.createSequence(function(o) {
        if (!o.failure) {
            o.failure = function(response) {
                var msg = "Unknown server error";
                var resp = Ext.decode(response.responseText);

                if (resp && resp.Message) {
                    msg = resp.Message;
                }

                Ext.Msg.show({
                    title: "Server Error",
                    msg: msg,
                    minWidth: 300,
                    buttons: Ext.Msg.OK,
                    icon: Ext.Msg.ERROR
                });
            }
        }
    })
});

MSSQL paging + sorting + filtering

2010-07-16T05:23:00.000-07:00


CREATE PROCEDURE [TestTable_GetPagedAndSortedAndFiltered]
(
 @startRowIndex int,
 @maximumRows int,
 @order nvarchar(50),
 @ID int = null,
 @Name nvarchar(50) = null,
 @Size int = null,
 @From datetime = null,
 @To datetime = null
) 
AS
BEGIN

declare @lastKey int
declare @lastAsc sql_variant
declare @lastDesc sql_variant

set rowcount @startRowIndex

select
@lastAsc = OrderAsc,
@lastDesc = OrderDesc,
@lastKey = OrderKey
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
where 
((@ID is null) or (@ID = ID))
and
((@Name is null) or (Name like @Name))
and
((@Size is null) or (@Size = Size))
and
((@From is null) or (@From < Created))
and
((@To is null) or (dateadd(day,1,@To) > Created))
) as T
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount @maximumRows

select *
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
where
((@ID is null) or (@ID = ID))
and
((@Name is null) or (Name like @Name))
and
((@Size is null) or (@Size = Size))
and
((@From is null) or (@From < Created))
and
((@To is null) or (dateadd(day,1,@To) > Created))

)as T
where
(
 @lastAsc is null
 and
 @lastDesc is null
 and
 @lastKey is null
)
or
(
 @lastAsc is not null
 and
 (
  OrderAsc > @lastAsc
   or
  OrderAsc = @lastAsc
   and
  OrderKey >= @lastKey
 )
)
or
(
 @lastDesc is not null
 and
 (
  OrderDesc < @lastDesc
   or
  OrderDesc = @lastDesc
   and
  OrderKey >= @lastKey
 )
)
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount 0

END

MSSQL sort and filter procedure

2010-07-16T04:37:00.000-07:00

Припустимо в нас є табличка:


CREATE TABLE [TestTable](
 [ID] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](50) NULL,
 [Size] [int] NULL,
 [Created] [datetime] NULL
)

Для сортування і фільтрації по всіх полях можна використати процедуру:


CREATE PROCEDURE [TestTable_GetPagedAndSorted]
(
 @startRowIndex int,
 @maximumRows int,
 @order nvarchar(50)
)
AS
BEGIN

declare @lastKey int
declare @lastAsc sql_variant
declare @lastDesc sql_variant

set rowcount @startRowIndex

select
@lastAsc = OrderAsc,
@lastDesc = OrderDesc,
@lastKey = OrderKey
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
) as T
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount @maximumRows

select *
from 
(
select *, 
ID as OrderKey,
case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
 else ID
END as OrderAsc,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END as OrderDesc
from TestTable
)as T
where
(
 @lastAsc is null
 and
 @lastDesc is null
 and
 @lastKey is null
)
or
(
 @lastAsc is not null
 and
 (
  OrderAsc > @lastAsc
   or
  OrderAsc = @lastAsc
   and
  OrderKey > @lastKey
 )
)
or
(
 @lastDesc is not null
 and
 (
  OrderDesc < @lastDesc
   or
  OrderDesc = @lastDesc
   and
  OrderKey > @lastKey
 )
)
order by OrderAsc,OrderDesc desc,OrderKey

set rowcount 0

END

MSSQL ORDER BY CASE

2010-07-16T02:45:00.000-07:00

Припустимо в нас є табличка:


CREATE TABLE [TestTable](
 [ID] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](50) NULL,
 [Size] [int] NULL,
 [Created] [datetime] NULL
)

Сортувати її за значення певного параметра можна так:


declare @order nvarchar(50)
set @order = 'Created DESC'

select *
from TestTable
order by

case @order
 when 'ID' then cast(ID as sql_variant)
 when 'Name' then cast(Name as sql_variant)
 when 'Size' then cast(Size as sql_variant)
 when 'Created' then cast(Created as sql_variant)
END,
case @order
 when 'ID DESC' then cast(ID as sql_variant)
 when 'Name DESC' then cast(Name as sql_variant)
 when 'Size DESC' then cast(Size as sql_variant)
 when 'Created DESC' then cast(Created as sql_variant)
END desc

ExtJs VS2008 Project Template

2010-07-10T00:51:00.000-07:00

Створив непоганий темплейт для студії:

кому цікаво - можу вислати:)

ExtJs store для json web-сервиса

2010-07-08T11:19:00.000-07:00

Используя proxy из предыдущего поста, напишем и сохраним в файл
Ext.data.WsJsonStore.js следуючий код:


Ext.data.WsJsonStore = Ext.extend(Ext.data.JsonStore, {
    constructor: function(c) {
        var d = {
            root: 'd',
            proxy: new Ext.data.WsProxy({
                url: c.url
            })
        }
        Ext.data.WsJsonStore.superclass.constructor
         .call(this, Ext.apply(d, c));
    }
});

Потом, подключив оба файла, используем:


var store = new Ext.data.WsJsonStore({
   url:'url',
   fields: [fields],
   ...
});

ExtJs proxy для web-сервиса

2010-07-08T11:08:00.000-07:00

В файл Ext.data.WsProxy.js сохраним такой код:


Ext.data.WsProxy = Ext.extend(Ext.data.HttpProxy, {
    constructor: function(c) {
        var d = {
            method: 'POST',
            headers: { 
              'Content-Type': 'application/json;charset=utf-8' 
            }
        }
        Ext.data.WsProxy.superclass.constructor
         .call(this, Ext.apply(d, c));
    }
});

Потом, подключив его, используем:


var proxy = new Ext.data.WsProxy({
    url:'url'
});

JSON запрос к web-сервису на ExtJs

2010-06-26T10:28:00.000-07:00

Для удобства создадим метод:


Ext.Ajax.ws = function(o){
   Ext.Ajax.request({
       method      : "POST",
       url         : o.url,
       jsonData    : o.data || "{}",
       headers     : {
           "Content-Type": "application/json;charset=utf-8"
       },
       success     : function(resp){
           o.success(Ext.decode(resp.responseText));
       }
   });
}

Потом используем:


Ext.Ajax.ws({
   url:"url",
   data:"json data",
   success:function(data){
   }   
});

Уроки дизайну йдуть на користь

2010-06-24T15:34:00.000-07:00

Застосував останні навики дизайну на сайті http://yoursofthouse.com/

Знайшов цікаві уроки по Photoshop

2010-05-30T06:01:00.000-07:00

http://www.photoshop-master.ru

Виконав один урок:
http://www.photoshop-master.ru/lessons.php?rub=4&id=731

MS SQL sysobjects table

2010-05-04T09:47:00.000-07:00

SELECT * FROM sysobjects WHERE xtype = <type>

<type>:
C: Check constraint
D: Default constraint
F: Foreign Key constraint
L: Log
P: Stored procedure
PK: Primary Key constraint
RF: Replication Filter stored procedure
S: System table
TR: Trigger
U: User table
UQ: Unique constraint
V: View
X: Extended stored procedure

1. Get all tables:

SELECT [name]
FROM sysobjects
WHERE xtype = 'U'
order by [name]

2. Get all columns by table:

SELECT syscolumns.name as [name],
systypes.name as [datatype],
syscolumns.length as [length]
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
JOIN systypes ON syscolumns.xtype=systypes.xtype
WHERE sysobjects.xtype='U' and sysobjects.name = <table name>
ORDER BY syscolumns.colid

Raise error from SQL code

2010-05-01T04:30:00.000-07:00

RAISERROR('error message', 16, 1)

AJAX Control Toolkit CalenderExtender localization

2010-04-15T09:56:00.000-07:00

The Calendar Extendar supports localization ,and you can localize it by setting the EnableScriptGlobalization Script Manager property to true , this way the calendar extendar will display its contents based on the current page culture.

Новые возможности C# 3.0

2010-04-10T09:53:00.000-07:00

Вывод типа (Type Inference)
// Можно объявить переменную так:
var localVar = new MyLongFooClassWithTemplate<MyLongTypeParameter>();

Анонимные типы (Anonymous Type)
// Вот так выглядит объявление нового типа:
var anon = new { a = 3, b = 4.81, c = "string data" };

Расширяющие методы (Extension Methods)
// добавить this перед первым параметром метода
public static int ElementCount(this IEnumerable enumerable)
...
// и вызывать этот утилитный метод можно так
int count = array.ElementCount();

Лямбда-выражения (Lambda Expression
//old
var filtered = items.Filter(delegate(int i) { return i % 2 == 0; });
//new
var filtered = items.Filter(n => n % 2 == 0);

Auto Properties
public string Name { get; set; }

Ленивые вычисления (Lazy Evaluation)

Частичные методы (Partial Methods)

Cистемные требования windows XP, Vista, 7

2010-03-20T05:39:00.000-07:00

Win XP Professional:
- PC: 300 MHz; min: 233 MHz
- RAM: 128 MB; min: 64 MB
- HDD: 1.5 Gb

Win Vista:
- PC: 1 GHz; min: 800 MHz
- RAM: 1 GB; min: 512 MB
- HDD: 15 Gb
- Graphics: DirectX 9.0
- Video: 32Mb (Home Basic), 128Mb(other)

Win 7:
- PC: 1 GHz;
- RAM: 1 GB(x86); 2 GB(x64);
- HDD: 16 Gb(x86); 20 Gb(x64);
- Graphics: DirectX 9.0
- Video: 128Mb

Непогана стяття по Twitter API

2010-03-19T09:27:00.000-07:00

Непогана стяття по Twitter API

Специфікація Twitter API

Закладки

2010-03-16T13:07:00.000-07:00

Знайшов кілька закладок
http://www.searchlast.co.uk/blog/search-engine-optimisation/how-to-create-a-twitter-bookmark/

del.icio.us
<a href="http://del.icio.us/post?url=http://www.searchlast.
co.uk/blog/&title=Product+Price+Comparison+and+E-commerce
+News+Blog" >Del.icio.us</a>

Digg
<a href="http://digg.com/submit?url=http://www.searchlast.
co.uk/blog/&title=Product+Price+Comparison+and+E-commerce
+News+Blog" >Digg.com</a>

Reddit
<a href="http://reddit.com/submit?url=http://www.searchlast.
co.uk/blog/&title=Product+Price+Comparison+and+E-commerce+
News+Blog" >Reddit.com</a>

Facebook
<a href="http://www.facebook.com/sharer.php?u=http://www.
searchlast.co.uk/blog/">Facebook.com</a>

StumbleUpon
<a href="http://www.stumbleupon.com/submit?url=http://www.
searchlast.co.uk/blog/&title=Product+Price+Comparison+and
+E-commerce+News+Blog" >StumbleUpon.com</a>

Twitter
<a href="http://www.twitter.com/home?status=Currently+reading
+http://www.searchlast.co.uk/blog/" >Twitter.com</a>

Мій твіттер

2010-03-16T13:04:00.000-07:00

Тепер і я в твіттері)))

http://twitter.com/khmurach

JavaScript: replace XML special characters

2010-02-20T01:28:00.000-08:00


    XmlHelper = {};
  
    XmlHelper.getExp = function(str)
    {
        return new RegExp(str, 'g');
    }

    XmlHelper.encodeInvalidChars = function(str) {
        return str
                .replace(this.getExp('&'),'&amp;')
                .replace(this.getExp('<'),'&lt;')
                .replace(this.getExp('>'),'&gt;')
                .replace(this.getExp('\''),'&apos;')
                .replace(this.getExp('"'),'&quot;')
    }
    XmlHelper.decodeInvalidChars = function(str) {
        return str
                .replace(this.getExp('&amp;'),'&')
                .replace(this.getExp('&lt;'),'<')
                .replace(this.getExp('&gt;'),'>')
                .replace(this.getExp('&apos;'),'\'')
                .replace(this.getExp('&quot;'),'"')
    }

C#: replace XML special characters

2010-02-18T02:20:00.000-08:00

System.Security.SecurityElement.Escape(string str);

& - &
< - <
> - >
" - "
' - '

not null -> true and null -> false

2009-12-23T01:49:00.000-08:00


select 
CASE
 when ImageFile is NULL then 0
 else 1
end as HasImage
from News

Bind to ItemIndex

2009-12-23T01:44:00.000-08:00

Repeater:
<% #DataBinder.Eval(Container, "ItemIndex") %>
Gridview:
<% #DataBinder.Eval(Container, "RowIndex") %>

Footer always bottom

2009-10-29T16:41:00.000-07:00

HTML:


    <div id="container">
        <div id="main">
            <div id="header">
                <h2>
                    header
                </h2>
            </div>
            <div id="content">
                <h2>
                    content content content content<br />
                    content content content content<br />
                    content content content content<br />
                    content content content content<br />
                </h2>
            </div>
        </div>
    </div>
    <div id="footer">
        <h2>
            footer
        </h2>
    </div>

CSS:


*{padding:0; margin:0;}
html {height: 100%;}
body {height: 100%;}
#container {min-height: 100%;}
* html #container {height: 100%;}
#header {height: 110px;}
#footer {height: 90px;position: relative;margin-top:-90px;}
#main {min-height: 100%;}
* html #main{height: 100%;}
#content {padding-bottom: 90px;}

#header{background:red;}
#container {background:#aaa;}
#content{background:green;}
#footer{background:blue;}

Body min-height 100%

2009-10-29T15:25:00.000-07:00


  html
  {
    height:100%;
  }
  body
  {
    margin:0px;
    min-height:100%;
    height:100%;
    height:auto !important;
  }

Div min-height

2009-10-29T15:14:00.000-07:00


  #content
  {
    min-height:400px;
    height:auto !important;
    height:400px;
  }

GridView + autopostback CheckBox

2009-07-29T09:58:00.000-07:00


в темплейтах колонок прописуємо:

    asp:CheckBox ID="chb1" AutoPostBack="true" 
    key='<%# Eval("ID") %>'
    runat="server" 
    OnCheckedChanged="chb1_CheckedChanged"

а в коді:
    protected void chb1_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chb = (CheckBox)sender;
        string id = chb.Attributes["key"];
        ...
    }