Programând C#

TakeFive - what an extension

2011-12-23T03:38:00.000-08:00

public static class LinqExtensions{ public public static IQueryable TakeFive(this IQueryable query) { return query.Take(5); }}

Extract currency values from text with T-SQL

2011-11-25T01:56:00.000-08:00

CREATE FUNCTION dbo.fnGetAmounts(@str nvarchar(max)) RETURNS TABLE AS RETURN ( -- generate all possible starting positions ( 1 to len(@str)) WITH StartingPositions AS ( SELECT 1 AS Position UNION ALL SELECT Position+1 FROM StartingPositions WHERE Position <= LEN(@str) ) -- generate all possible lengths , Lengths AS (

The saga on ASP .Net

2011-11-02T14:01:00.000-07:00

Indeed, there is a saga. Since from the very beginning of my ASP .Net experiences I had to deal with the "CSS problem". This problem occurs when the referenced CSS is not loaded, because the relative path is not given right.We place in the Master Page all the common html used in the website, including the links to the CSS files. Pages might be placed in different nested folders and because of

Generate class from a LINQ projection

2011-10-28T05:36:00.000-07:00

using System;using System.Linq;using Microsoft.CSharp;using System.CodeDom;public static class QueryExtensions{ public static string GetClassDefinition(this IQueryable query, string className) { var type = typeof(T); var sb = new StringBuilder(); sb.AppendLine(string.Format("public class {0}", className)); sb.AppendLine("{"); using (var provider = new CSharpCodeProvider()) {

MS-SQL script to generate update statements for rtrim and ltrim

2011-10-12T08:47:00.000-07:00

Recently I did a bulk insert into a table from a CSV file and this data had trailing spaces. I didn't notice until some email addresses look like weren't valid.I read this article which explains when the data is trimed or notSince I had many columns to update I needed to find another solution to write/generate the update statements for "update table set column = rtrim(ltrim(column))"declare @

Update between two tables when there is no relation between them

2011-10-10T23:35:00.000-07:00

I needed a SQL statement which fills the null values from the second column of #T1 table with values from #T2(C1).There is no foreign key or match between the columns of those two tables. I found two approaches:1. Using CTE create table #T1 (C1 varchar(10), T2C1 varchar(10)) create table #T2 (C1 varchar(10)) insert into #T1 values ('A1', '1') insert into #T1 values ('A2', null) insert into #T1

CKEditor m.lang.contextmenu is undefined

2011-08-23T01:18:00.001-07:00

I got the error "m.lang.contextmenu is undefined" while I was installing CKEditor on an ASP .Net website and trying to use a minimum setup. I supposed the "ckeditor/lang/en.js" is enough, but, as pointed here, the editor doesn't download en.js by default, so it needs to be set on config.js CKEDITOR.editorConfig = function (config) { config.language = "en.js"; }; If this is not set, the

Encapsulating Sets of Properties in Complex Types, convenient or not?

2011-07-28T04:52:00.000-07:00

With EF we can group properties into Complex Properties. For example I'm using audit information on all my entities, like CreatedOn, UpdatedOn, Deleted and Enabled and I grouped them into a ComplexType named Audit. A customer can have an InvoiceAddress and a DeliveryAddress of type Address(Street1, Street2, County, Town Postcode).This is nice, but I encountered some problems with the updates.As

Remotely Install EntityFramework 4.1 with psexec and gacutil

2011-07-27T01:13:00.000-07:00

I updated an website to use EntityFramework 4.1 Update 1. While I had no problems installing it on my dev machine, on the production machine the installer wasn't able to install the EntityFramework.dll on GAC. The reason is simple, there is no SDK installed.I can't RDC on the production server, but I have a hidden shared folder, named "adrian$".To install EntityFramework on the production machine

IIS 7.5, HTTPS Bindings and ERR_CONNECTION_RESET

2011-07-21T05:23:00.000-07:00

Having an website with HTTP and HTTPS bindings, running on my local IIS 7.5 server, I encountered this error with Chrome, Error 101 (net::ERR_CONNECTION_RESET) while trying to access it with HTTPS protocol. I checked the IIS and the bindings were fine, both protocols were set and self-signed certificate didn't expire yet.Since the website it wasn't accessible on the HTTPS protocol and everything

Practical Example for Abstract Classes

2011-06-28T14:09:00.000-07:00

using System;namespace AbstractClasses{ public abstract class Messager { protected string _recipient; protected string _message; public Messager(string recipient, string message) { _recipient = recipient; _message = message; } public void ProcessMessage() { LogMessageLength(); // the code from here

Table Per Hierarchy Inheritance with Column Discriminator and Associations used in Derived Entity Types

2011-06-25T07:04:00.000-07:00

In this article I will show how to model a table per hierarchy, a bit more complex than I found in books or other articles. I'm sure this model is present in real lif,e but I really didn't have the luck to find an example on the web when I needed it most. The complexity of this model is given by the Foreign Keys ( the Associations) which need to be placed in the derived entities types and the

Working with TIME type in SQL and ASP .Net

2011-06-03T00:23:00.000-07:00

Scenario: a teacher schedules his courses on a random different dates in the near future, but he always know the start time. For sample in the current week he can schedule a course for Tuesday and Friday, at 08:00 AM.In a database there would be the following tables:1. course (title, summary, ..)2. course_schedule(course_id, location, start_time) where data about that schedule is preserved( ie.

About the "The Controls collection cannot be modified because the control contains code blocks" symptom

2011-05-31T23:52:00.000-07:00

As the error message says, if a control contains code blocks (but not databinding expressions, ie <%# ..), its Controls collection can't be altered, by adding another control at runtime using Controls.Add. However, this rule doesn't apply for child controls, for example if a control uses other control with code blocks, then the first control's Controls collection (the parent's one) has no

Of, Doame!

2011-05-26T03:28:00.000-07:00

My Birthday

2011-04-06T08:25:00.000-07:00

Today is my birthday and because today my thoughts are only about myself, I had a curiosity about in which years I did celebrate my birthday on Wednesdays ( I like this day of week).With the following LINQ query I found the answerfrom i in Enumerable.Range(0,29)where (new DateTime(i + 1983,4,6).DayOfWeek) == DayOfWeek.Wednesdayselect new { year = i + 1983, age = i }which is..Year Age1983 01988

Virusii, messengerul si clinicile particulare

2011-04-06T00:14:00.000-07:00

Printre pietenii de pe YM, am si un contact de la o clinica particulara din Iasi. Cand aveam nevoie de o programare, mi-era muuult mai simplu sa o fac pe messenger, decat la telefon.Dar, cum "virusurile" informatici au pus stapanire pe calculatorul din "front office", clinica s-a pricopsit cu o problema de PR, de care nu prea vrea sa scape prea curand.

Tinute business

2011-04-05T01:33:00.001-07:00

Dau peste ditamai banner-ul pe hotnews.ro care te duce la e-shopul www.otto.roArunc un ochi pe pagina tinute business si ce gasescPropun ca prezentatorii proiectului "e-romania" sa adopte tinuta.

Ce mai canta un programator?

2011-04-04T03:09:00.001-07:00

Ce mai canta un programator? La primul release: "Like a virgin, touched for the very first time" La primul set de buguri: "We will we will rock you, We will we will rock you" La al 10-lea set de buguri: "Guess who's back Back again Shady's back Tell a friend

TVR si sondaje - sau cum poti manipula

2011-04-01T02:44:00.000-07:00

Zilele astea a fost un sondaj pe situl TVR, care continea urmatoarea intrebare: "Care credeţi că este soluţia pentru a rezolva problema câinilor comunitari?" si avea cinci variante de raspuns:AdopţiaSterilizareaEutanasiereaAltă opţiune/comentaţiNu ştiu/nu mă intereseazăFiind cat de cat interesat de subiect si inscris intr-un grup de discutii, am vazut ca oamenii au inceput sa se alarmeze ca se

Elmah: to find more, query AllXml as Xml!

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

select convert(xml,AllXml) .value('(//queryString/item[@name="id"]/value/@string)[1]','nvarchar(255)') as product_id , erroridfrom elmah_errorwhere convert(xml,AllXml) .exist('//item[@name="PATH_INFO"]/value[@string="/products/product.aspx"]') = 1Since Elmah stores in the AllXml column many informations for the logged errors, those can be queried in the XPath/XQuery fashion. The AllXml values

Totals on Reports using LinqDataSource

2011-03-01T07:48:00.000-08:00

One common request for reporting is to show aggregations as well, like sums, averages, counts, etc among with the report itself. So for example if an expenses/charges/profits report shows the list of all products sold in some date/time range, then the person who analyzes the report would like to see and some totals (sum of the costs, sum of the charges, sum of profits and the total number of

Round Decimals Up and Down

2011-02-02T01:43:00.000-08:00

table.rounding td{text-align:center}table.rounding th.small{width:50px}table.rounding th{text-align:center;width:270px}table.rounding th span{color:Red;font-weight:bold} Nr. Round Up Math.Ceiling(number * 100) / 100M Round Down Math.Floor(number * 100) /

A cazut serveru'

2011-01-13T04:58:00.000-08:00

Am o baza de date, sa zicem cea mai mare din Romania. Sa spunem despre baza asta de date asa mare ca are si cel mai mare grup de utilizatori. Totul e asa de mare incat poate concura cu succes cu facebook. Baza asta de date a mea sta la baza unei aplicatii care ar trebui sa faca doua lucruri:1. sa colectecteze date: unii utilizatori introduc date in baza mea de date. Volumul asta de date poate fi

ListView Alternating Group Template

2010-06-05T08:09:00.000-07:00

The ListView have no such thing as alternating the group templates and still is so much needed. public class aiListView : ListView { int groupDisplayIndex = 1; /*update on June 16, 2010*/ private ITemplate _alternatingGroupTemplate; public virtual ITemplate AlternatingGroupTemplate { get { return _alternatingGroupTemplate; } set { _

How a FileZilla bug made me sweat

2009-07-03T15:19:00.000-07:00

Happy that I finished some minor task, I was starting to deploy on PR.Then when I test, surprise, I get the error "Could not load file or assembly 'XXXX' or one of its dependencies. An attempt was made to load a program with an incorrect format.". Pfu. Never got this before, so I started googling. A lot of messages and the conclusion it was that the server is a 64 bit version and I have a 32 bit

ASP .Net server control for youtube embeded videos

2009-05-27T04:48:00.001-07:00

Here is ASP .Net server control for youtube embeded videos.The param definitions can be found hereOnly Src param is required, other parameters are generated only if have another value than the default one.Usage

Think LINQ deffered execution like an non-clustered SQL View

2009-05-14T15:02:00.000-07:00

LINQ deferred execution is when you create the query, but this is not executed until you need it. So first you tell what you need and you'll get it when is needed by calling methods like ToList, First, Single, etc.var ctx = ...var query = from p in ctx.products where p.enabled == true && c.deleted == false select p;After calling query.ToList(), the LINQ creates the SQL,

CLR custom aggregates for SQL Server

2009-04-24T14:27:00.000-07:00

Having the tables "product" and "product_stock" I want to display for each product the comma-separated list of sizes and this list is ordered by a specific order.CREATE TABLE product( product_id int, code varchar(50) )CREATE TABLE product_stock( product_stock_id int, size_order int , size varchar(20) , product_id int )-- desired outputProduct_id Sizes In Stock35 UK7, UK8, UK9,

Tracking codes in DEBUG-RELEASE mode

2009-04-13T08:38:00.000-07:00

While you work on a website which includes some JavaScript for counters and statistics is better not to allow or to "hide" them during the development time.One solution is to comment the source code and every time before the page is published, to uncomment the relevant lines. This leads to errors sooner or later, we use to forget things (uncomment things).A better option is to use preprocessor

Levenshtein distance - use on web site search

2009-04-01T14:08:00.000-07:00

Levenshtein distance is the minimum number of character deletion (D), insertion (I) or substitution(S) operations to transform a string to another.I used this algorithm to give alternatives to an user when he gets no results after he submitted search by a specific keyword. Often happens when the keyword is misspelled or even there are no matches.If an e-shop sells very expensive bracelets and has

Eval: Sometimes I like spagheti code

2009-03-30T15:57:00.000-07:00

code{color:red}I just discovered some interesting features of the construct <%# Eval() %>. Eval function uses reflection to evaluate a property of a bound object.I have two classes Product and Category and I want to display the available products in a page, by using a data bound control.public class Product { public int ID; public string Name; public int Stock; public DateTime Date;

Using UrlRewritingNet and Elmah together

2009-03-21T11:17:00.000-07:00

@page { size: 21.59cm 27.94cm; margin-top: 2.54cm; margin-bottom: 2.54cm; margin-left: 3.175cm; margin-right: 3.175cm } table { border-collapse:collapse; border-spacing:0; empty-cells:show } td, th { vertical-align:top; } h1, h2, h3, h4, h5, h6 { clear:both } ol, ul { padding:0; } * { margin:0; } *.Frame { font-size:12pt; vertical-align:top; text-align:center; } *.Graphics { font-size:12pt;

Un required validator pentru DropDownList cu RangeValidator

2009-02-24T07:52:00.000-08:00

Validatorul RangeValidator va aparea in UI ca un RequiredValidator. Utilizatorul nu va putea trece mai departe daca nu alege o optiune de la 1 la 5. :) Select Title Mr Mrs Miss

JQuery si WebMethod

2008-10-28T12:28:00.000-07:00

Prin noiembrie 2006 descoperisem la HALO interactive posibilitatea de a apela dintr-o pagina HTML o metoda dintr-o pagina aspx folosind un ScriptManager. Trebuia sa fac o autentificare in doi pasi. ScriptManger-ul genereaza ceva JavaScript folosit pentru a construi apelul AJAX, dar si pentru a folosi o sintaxa de genul PageMethods.MethodName, valabila atata timp cat e setata true optiunea

Conversie data pentru cultura romana (ro-RO)

2008-10-08T07:28:00.000-07:00

Vreau sa convertesc date calendaristice din cultura romana (ro-RO) din string in DateTime. Datele sunt de genul 8 Oct 2008, 9 Oct 2008, 12 Dec 2008. DateTime.TryParseExact accepta formatul "d MMM yyyy", numai ca pentru cultura romana datele trebuie sa fie de forma 8 Oct. 2008, 9 Oct. 2008, 12 Dec. 2008 (cu punct dupa luna). Obtin expresia regulata pentru gasirea lunii din data, iar dupa luna

null == null ?

2008-09-25T19:03:00.000-07:00

Test:T - SQL:if ( null = null ) print 'null == null'else print 'null != null'C#:Console.WriteLine(null == null);Ce afiseaza fiecare? Si de ce?

O fi fost vreun bug in Google Chrome?

2008-09-03T10:05:00.000-07:00

Ca si istoric, am vrut sa inspectez un element img cu imaginea inexistenta ( adica lipsea de pe server)Spre deosebire de FireFox, nu imi da optiunea de a restaura sesiunea dinaintea erorii.

Despre CompositeDataBoundControl

2008-08-08T06:36:00.000-07:00

p{text-indent:20;text-align:justify;}CompositeDataBoundControl este clasa de baza pentru DetailsView, FormView si GridView si are o metoda abstracta ce trebuie implementata de orice clasa mostenitoare.protected abstract int CreateChildControls(IEnumerable dataSource, bool dataBinding); dataBinding reprezinta:-true: controlul va fi construit pe baza unui dataSource-false: controlul se va

Operatorul APPLY in SQL 2005

2008-06-03T03:57:00.000-07:00

CREATE TABLE dbo.Items( ID int IDENTITY(1,1) NOT NULL, Name varchar(50) NOT NULL, CONSTRAINT PK_Items PRIMARY KEY (ID ASC))-- Ceva valoriGOINSERT INTO Items VALUES ('X')INSERT INTO Items VALUES ('Y')INSERT INTO Items VALUES ('Z')-- O functie care returneaza itemurile care au id-ul mai mic decat @ItemID (cele anterioare unui anumit item)GOCREATE FUNCTION [dbo].[getPreviousItems]( @ItemID int)

IsPostBack

2008-04-19T12:54:00.000-07:00

p { text-indent:20;text-align:justify; } MSDN spune ca proprietatea IsPostBack e o valoare care indica daca pagina este creata pentru a fi raspunsul postbackului unui client sau pagina este creata si accesata pentru prima data. Cuvantul cheie e postback, de fapt ce inseamna acest postback. Perceptia generala e ca IsPostBack e true atunci cand utilizatorul da click pe un buton sau pe un control

Un bug in LINQ

2008-04-14T04:13:00.000-07:00

p { text-indent:20;text-align:justify; } Am dat de un mic bug in LINQ to SQL, ce m-a facut sa-mi regandesc o abordare dintr-un anumit proiect. Eroarea apare in interiorul DataContext si anume la nivelul asocierii dintre clasele mapate pe tabele in scopul de a evidentia relatia 1:n.Sa explic insa cu un exemplu. Se da o baza de date cu trei tabele, o tabela cu categorii, o tabela cu produse si o

Reindexare in SQL 2000

2008-03-30T06:40:00.000-07:00

p { text-indent:20;text-align:justify; } Multe aplicatii ASP .Net au in spate si un server de baze de date. Ce tre’ sa faci atunci cand pagini cu diverse rapoarte se incarca tot mai greu de la o saptamana la alta, primesti erori de timeout tot mai des pe mail, iar clientii incep sa devina din ce in ce frustrati? Incepi sa gugalesti:). Presupun ca pe tabelele alea mari sunt deja construiti niste

HTML Parser sau Expresii Regulate

2008-03-21T15:26:00.000-07:00

.panel2{overflow: hidden;width: 99%;height: 350px;color:Blue}.panelHeader{width: 100%;}p{text-indent:20;text-align:justify;}Extrag informatie dintr-o pagina si ma intreb cum anume sa procedez. Sa folosesc expresii regulate sau un parser html. Norocul meu e ca am gasit unul deja implementat de un anume tip Alex Chudnovsky, iar .Net imi ofera suport si pentru expresii regulate.Am luat ca test prima

LINQ to XML in ASP .Net

2008-01-12T16:27:00.000-08:00

.panel{overflow: scroll;width: 99%;height: 500px;color:Blue/*border-left-style: inset;border-left-width: 1;border-top-style: inset;border-top-width: 1;*/}.panelHeader{width: 100%;/*border-left-style: inset;border-left-width: 1;border-top-style: inset;border-top-width: 1;*/} Un alt mod de a stoca si manipula date este familia XML. Datele din fisiere sunt constranse sa respecte un anumit model,

Path.Combine - C# 3.0 Extension Method

2007-12-21T09:23:00.000-08:00

p { text-indent:20;text-align:justify; } O data cu C# 3.0 au venit si metodele extensie. Sunt foarte utile cand se vrea a se extinde o clasa care nu poate fi mostenita cum e clasa string.Un alt avantaj e ca schimba notatia prefix a metodelor statice cu una infix, ceea ce face codul mult mai clar si mai usor de scris. De exemplu metoda statica Combine din clasa Path concateneaza doua stringuri

Injectare cod javascript

2007-10-25T09:10:00.000-07:00

p { text-indent:20;text-align:justify; } Sunt unele situri care pur si simplu te lasa sa iti formatezi textul scris de tine . De exemplu un blog iti ofera tool-uri cu care sa inserezi diverse elemente html sau il formatezi de mana. In felul acesta iti customizezi ceea ce pui pe net. Mai sunt si situri pe care poti edita html-ul, dar nu poti insera taguri