developertipoftheday.com

developer-express.blogspot.com

developer-express: January 2011

http://developer-express.blogspot.com/2011_01_01_archive.html

Saturday, 22 January 2011. For me, Responsive Web Design is a relatively new term. Basically it refers to a web design layout that alters to it's environment. So the layout can alter depending on the screen size or resolution. This is not the same as a fluid design though, with Responsive Design the lay can actually change rather than just scale down. A List Apart has a fantastic article on Response Web Design. Read rest of entry. Free eBook for Web Designers: 5 Tips for Better Sites. Read rest of entry.

developer-express.blogspot.com

developer-express: SQL: OVER Clause

http://developer-express.blogspot.com/2011/02/sql-over-clause.html

Friday, 4 February 2011. The OVER clause allows partitioning and ordering of the rowset. The syntax for this function:. OVER CLAUSE : =. 160;   OVER ( [ PARTITION BY value expression, . [ n ] ]. 160;          ORDER BY Clause )Aggregate Window Functions. OVER CLAUSE : =. 160;   OVER ( [ PARTITION BY value expression, . [ n ] ] ). As specified above the OVER clause can be used in conjunction with aggregate functions, which can make your code a little shorter. SELECT * FROM #Bookings ORDER BY CourseID.

developer-express.blogspot.com

developer-express: September 2010

http://developer-express.blogspot.com/2010_09_01_archive.html

Wednesday, 29 September 2010. Getting Started with LINQ to Entities. Filed Under: Entity Framework. Introducing the object context, basics queries, eager loading, lazy loading and projection. In this video, Julie Lerman will show you how to query your database with LINQ to Entities queries against an Entity Data Model. This video uses Entity Framework 4.0 and Visual Studio 2010. Var context = new myModel.MyEntities. Var query = from c in context.Customers select c;. Var customers = query.ToList();. This ...

developer-express.blogspot.com

developer-express: October 2010

http://developer-express.blogspot.com/2010_10_01_archive.html

Friday, 29 October 2010. Filed Under: .NET. The type system in .NET or Common Type System (CTS) divides types into 2 categories:. These are simple data types that directly contain their data, for example:. These types store references to objects. Reference type variables have the ability to refer to the same data, so two variables can point to same object and the object be manipulated by performing operations of both variables. Examples include:. Read rest of entry. Thursday, 28 October 2010. Note: Compa...

developer-express.blogspot.com

developer-express: November 2010

http://developer-express.blogspot.com/2010_11_01_archive.html

Thursday, 4 November 2010. Partial Classes, Interfaces and Generics. Filed Under: .NET. Can be used to split definitions of classes, structs or interfaces over two or more source files. Each source file contains a section of the class definition which are combined at when the application is compiled. Partial classes can be beneficial in the following situations:. Working on large projects, allowing developers to work on different sections of a class without both having to access the same physical file.

developer-express.blogspot.com

developer-express: JSON - An Express Overview

http://developer-express.blogspot.com/2010/08/json-express-overview.html

Saturday, 7 August 2010. JSON - An Express Overview. Whilst building a new reporting engine this week I was advised by a friend to consider using JSON as a simple and effective way to store the business rules. Having not used JSON before, I decided to take a quick look and found it to be a very straightforward yet elegant way of storing data. JSON (JavaScript Object Notation) is a neat and structured text-based data format that is an accepted alternative to XML. JSON comprises of two structures:. Recentl...

developer-express.blogspot.com

developer-express: jQuery: Find the label text for a selected radio button

http://developer-express.blogspot.com/2011/03/jquery-find-label-text-for-selected.html

Friday, 4 March 2011. JQuery: Find the label text for a selected radio button. Sometimes the seemingly easiest pieces of code can end up giving you trouble.  This morning I was working on a project where I wanted to display the text (not the value) of a selected radio button. In the end it was very simple.  I added a label to my radio buttons and used the following line of code. Input[name=myname]:checked label').text();. Subscribe to: Post Comments (Atom). Capitalise first letters in SQL Server. Introdu...

developer-express.blogspot.com

developer-express: Creating an Entity Data Model from a Database

http://developer-express.blogspot.com/2010/09/creating-entity-data-model-from.html

Tuesday, 21 September 2010. Creating an Entity Data Model from a Database. Filed Under: Entity Framework. The entity framework is an object-relational mapping (ORM) framework for the .NET Framework. The entity framework separates the conceptual and logical data models, allowing developers to program against the conceptual model rather than the logical model. Subscribe to: Post Comments (Atom). A scrapbook of different techniques and practices. Getting Started with LINQ to Entities. SQL Server has no buil...

developer-express.blogspot.com

developer-express: SQL: Format Dates with DATENAME()

http://developer-express.blogspot.com/2011/01/sql-format-dates-with-datename.html

Friday, 21 January 2011. SQL: Format Dates with DATENAME(). Is an ANSI compliant. Fast date part function built into SQL Server. It accepts two arguments datepart and date. The datepart parameter specifies which part of the date to return - day, month, year with the function returning an nvarchar. DATENAME ( datepart ,date). SELECT DATENAME(m, GETDATE(). Http:/ msdn.microsoft.com/en-us/library/ms174395(v=sql.90).aspx. Subscribe to: Post Comments (Atom). A scrapbook of different techniques and practices.