CSTrüter HomeArticlesDownloadsAbout meContact me
Modify WebControl markup via WebControlAdapter 2010-03-11 21:47:12
a quick look at how to create a windows service using C# 2010-02-28 21:48:06
How to call server-side code from client-side code, using PageMethods in ASP.net 2010-02-21 12:31:27
How to pass a set of data to an xml type in SQL 2005/8 2010-02-12 19:04:23
Some funky behaviour regarding overload Resolution of dynamic/object types 2010-02-09 17:16:52
Object orientated programming within JavaScript 2010-01-28 07:25:45
How to sort data using ASP.net (C#) and SQL 2005/8 2010-01-18 15:23:14
Quick look at some of the new features added to C# 4.0 2010-01-12 21:52:13
SQL 2008 introduced a nifty feature called Table-Valued Parameters (TVP) into its codebase 2010-01-06 22:58:25
How to page data using ASP.net (C#) and SQL 2005/8 2009-10-19 15:01:45
Creating a WYSIWYG textbox for your website is actually quite simple. 2007-02-01 12:00:00
Move items between two listboxes in ASP.net(C#, VB.NET) and PHP 2008-06-12 17:07:43
Firefox word wrapping issues 2008-06-09 09:51:21
2007-02-22 12:00:00
Blog about passing parameters by reference to functions using func_get_arg(s) 2008-07-27 12:38:24
There are three categories joins fall into, inner, outer and cross. Outer joins consist of three types, left, right and full. Lets have a quick look at the various joins. (On the right we've got two datasets we'll be using in the examples.) Table a aID title 1 a1 2 a2 3 a3 4 a4 Table b bID title aID 1 b1 1 2 b2 2 3 b3 NULL 4 b4 NULL Inner Join Return rows that match in both tables. (Default join) SELECT * FROM a INNER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 aID bID title 1 1 b1 2 2 b2 Left Outer Join Return rows from the table on the left of the expression even if they dont match with the table on the right. SELECT * FROM a LEFT OUTER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 a3 3 a4 4 aID bID title 1 1 b1 2 2 b2 NULL NULL NULL NULL NULL NULL Right Outer Join Return rows from the table on the right of the expression even if they dont match with the table on the left. SELECT * FROM a RIGHT OUTER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 NULL NULL NULL NULL aID bID title 1 1 b1 2 2 b2 3 3 b3 4 4 b4 Full Outer Join Return rows from both the left and right tables even if they don't match in either. (left + right join) SELECT * FROM a FULL OUTER JOIN b ON a.aid = b.aid title aID a1 1 a2 2 a3 3 a4 4 NULL NULL NULL NULL aID bID title 1 1 b1 2 2 b2 NULL NULL NULL NULL NULL NULL 3 3 b3 4 4 b4 Cross Join Join each row from the left with each row from the right. Known as a "carthesian product" SELECT * FROM a CROSS JOIN b or SELECT * FROM a, b title aID a1 1 a2 2 a3 3 a4 4 a1 1 a2 2 a3 3 a4 4 a1 1 a2 2 a3 3 a4 4 a1 1 a2 2 a3 3 a4 4 aID bID title 1 1 b1 1 1 b1 1 1 b1 1 1 b1 2 2 b2 2 2 b2 2 2 b2 2 2 b2 3 3 b3 3 3 b3 3 3 b3 3 3 b3 4 4 b4 4 4 b4 4 4 b4 4 4 b4
Codebooth my semi-community site etc (work in progress)
The company I'am currently working for as software developer.
a Parallel reference of programming languages 2009-09-10 12:48:23
a tutorial explaining how to develop a simple login using PHP and MySQL 2009-09-05 18:26:47
An article looking at adding some kind of event driven model to PHP 5 2008-07-28 12:48:09
It is very simple creating your own rss reader, the following article looks at a few methods of doing this. 2008-06-23 13:18:25
A quick reference about working with dropdown boxes (select element) in javascript. 2007-02-17 16:36:41
Collection of funny programming articles 2006-10-08 14:23:43