Client Insight - Advanced JsRender Templating Features
Tue, 01 May 2012 10:00:00 GMT
John Papa continues the exploration of JsRender in more scenarios such as rendering external templates, changing context with the {{for}} tag and using complex expressions. He also demonstrates how to use some of JsRender’s more powerful features including creating custom tags, converters, context helpers and allowing custom code.
Client Insight - Using JsRender with JavaScript and HTML
Mon, 02 Apr 2012 10:00:00 GMT
John Papa explores JsRender, the emergent technology poised to replace jQuery Templates.
Client Insight - Knockout's Built-in Bindings for HTML and JavaScript
Thu, 01 Mar 2012 10:00:00 GMT
John Papa continues his exploration of the Knockout JavaScript library by delving into a number of the built-in bindings it offers.
Client Insight - Getting Started with Knockout
Wed, 01 Feb 2012 10:00:00 GMT
This inaugural Client Insights column explains how to get started with the Knockout JavaScript library by learning how and where to use it.
Data Points - Data Validation with Silverlight 3 and the DataForm
Mon, 12 Oct 2009 10:00:00 GMT
In this month’s column, John Papa shows you how the DataForm control works and how it can be customized. He presents in detail a sample application that uses several features to bind, navigate, edit and validate data using the DataForm.
Data Points - Data Performance and Fault Strategies in Silverlight 3
Fri, 24 Jul 2009 10:00:00 GMT
In this month’s column, the author shows how binary encoding works, the effect it has on an application’s performance, and how it behaves by demonstrating it in action.
Data Points - Building An Out-of-Browser Client With Silverlight 3
Mon, 18 May 2009 10:00:00 GMT
Silverlight 2 applications are restricted to running inside a browser. However, Silverlight 3 applications can run inside the browser or out. Here we build a social networking app as a standalone Silverlight 3 application.
Data Points - Using Silverlight 2 With ADO.NET Data Services
Thu, 19 Mar 2009 10:00:00 GMT
ADO.NET Data Services and Silverlight make a powerful combination, but to make them work well together, there are a few things you need to understand. Here, John Papa explains.
Data Points - Syndicated Data And Isolated Storage In Silverlight
Fri, 23 Jan 2009 10:00:00 GMT
Here we build a syndicated news reader application to illustrate the use of isolated storage and data syndication in Silverlight.
Data Points - Cloud Gazing From Silverlight 2
Thu, 23 Oct 2008 10:00:00 GMT
John Papa tackles questions about calling services from Silverlight 2 applications.
Data Points - Service-Driven Apps With Silverlight 2 And WCF
Wed, 20 Aug 2008 10:00:00 GMT
Here John Papa demonstrates how to build a Silverlight 2 user interface that communicates through WCF to interact with business entities and a database.
Data Points - The Entity Framework in Layered Architectures
Fri, 20 Jun 2008 10:00:00 GMT
Here we build a solution that fits the Entity Framework into an n-tier architecture that uses WCF and WPF and the MVP pattern.
Data Points - Entity Framework Q&A
Thu, 17 Apr 2008 10:00:00 GMT
The Entity Framework is a hot topic, but how do you know when to use EntityClient, Object Services, Entity SQL, or LINQ? Find out here.
Data Points - Standard Query Operators with LINQ
Wed, 20 Feb 2008 10:00:00 GMT
LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.
Data Points - Designing an Entity Data Model
Tue, 18 Dec 2007 10:00:00 GMT
With the Entity Framework, developers are given more flexibility by being able to design around a conceptual model rather than a relational data model.To get started, you need to know how to design an Entity Data Model. John Papa walks you through that process.
Data Points - Accessing Data from a Mobile Application
Tue, 11 Dec 2007 10:00:00 GMT
This month John Papa takes a look at developing a mobile application that can access data on your application server.
Data Points - Data Binding in WPF
Wed, 24 Oct 2007 10:00:00 GMT
WPFis one of the most important new technologies in the .NET Framework 3.0. This month John Papa introduces its data binding capabilities.
Data Points - Common Table Expressions
Wed, 19 Sep 2007 10:00:00 GMT
In T-SQL, views and derived tables serve similar purposes and have their advantages. But when working with SQL Server 2005,there's a third option--using Common Table Expressions (CTEs).John Papa explains.
Data Points - ADO.NET Entity Framework Overview
Tue, 22 May 2007 10:00:00 GMT
The new Entity Framework in ADO.NET will let you manipulate data using an object model. John Papa explains.
Data Points - SQL Server Management Objects
Wed, 18 Apr 2007 10:00:00 GMT
SQL Server Management Objects offer developers a robust toolset forbacking up and restoring databases, and issuing DDL commands, as John Papa explains.
Data Points - Disabling Constraints and Triggers
Tue, 13 Mar 2007 10:00:00 GMT
What to do when you need to disable triggers and constraints to perform data synchronization and other tasks with an offline database.
Data Points - Data Bound Applications with ADO.NET and Custom Objects
Thu, 21 Dec 2006 10:00:00 GMT
In this column see how to bind a custom list of business entities using the binding tools in the .NET Framework 2.0.
Data Points - Column Expressions, DataRelations, and Computations
Wed, 22 Nov 2006 10:00:00 GMT
This month John Papa fields some of his favorite questions regarding data manipulation with ADO.NET.
Data Points - RSS Feeds on a Smartphone
Wed, 18 Oct 2006 10:00:00 GMT
John Papa builds a Windows Mobile 5.0 application that reads RSS feeds and loads them into an ADO.NET DataSet.
Data Points - Revisiting System.Transactions
Thu, 12 Oct 2006 10:00:00 GMT
The System.Transactions namespace of the Microsoft .NET Framework makes handling transactions much simpler than previous techniques.Read all about it this month.
Data Points - Report Controls in SQL Server 2005 Reporting Services
Thu, 08 Jun 2006 10:00:00 GMT
Reporting has always been one of the dark arts of development.The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
Data Points - Designing Reports with SQL Server Reporting Services 2005
Thu, 04 May 2006 10:00:00 GMT
Many applications require some degree of integration with a reporting tool.A good solution, SQL Server™ Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.
Data Points - SQL Server 2005 XML Support, Exception Handling, and More
Thu, 06 Apr 2006 10:00:00 GMT
SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language.One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.
Data Points - Using XQuery, New Large DataTypes, and More
Thu, 09 Feb 2006 10:00:00 GMT
SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language.Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.
Data Points - SqlConnectionStringBuilder, DataView, and More
Tue, 13 Dec 2005 10:00:00 GMT
Several significant enhancements have been made to ADO. NET 2. 0 in the areas of improved performance, increased flexibility, and added features.In my last column (Data Points: DataSet and DataTable in ADO.
Data Points - DataSet and DataTable in ADO.NET 2.0
Tue, 11 Oct 2005 10:00:00 GMT
ADO. NET 2. 0 sports some exciting enhancements to the core classes found in ADO. NET 1. x and introduces a variety of new classes, all of which promise to improve performance, flexibility, and efficiency.
Data Points - The Enterprise Library Data Access Application Block, Part 3
Tue, 13 Sep 2005 10:00:00 GMT
E nterprise applications can have a wide variety of data update requirements.Sometimes you need to save multiple rows of changes at once within a single transaction.Other times, the user must be allowed to enter multiple rows of data, send them to the database in a batch; and if a row or two fails, only the rows that succeeded should be committed and remain committed.
Data Points - The Enterprise Library Data Access Application Block, Part 2
Tue, 12 Jul 2005 10:00:00 GMT
Last month I explored the foundation of the Enterprise Library Data Access Application Block (DAAB) including how it all fits into an architecture (see Data Points: The Enterprise Library Data Access Application Block, Part 1).
Data Points - The Enterprise Library Data Access Application Block, Part 1
Tue, 14 Jun 2005 10:00:00 GMT
A solid data access later (DAL) can benefit an application by hiding redundant tasks, helping handle exceptions more gracefully, helping clean up resources more efficiently, and providing a layer of abstraction from the database.
Data Points - XML Features in SQL Server 2000
Tue, 10 May 2005 10:00:00 GMT
SQL Server™ 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML.For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.
Data Points - Data Access Strategies Using ADO.NET and SQL
Tue, 12 Apr 2005 10:00:00 GMT
When your goal is a scalable and efficient enterprise solution, you need to develop an efficient data-access strategy.You can't just do some testing on your production machines and rely on the results.
Data Points - ADO.NET and System.Transactions
Tue, 11 Jan 2005 10:00:00 GMT
The Microsoft® . NET Framework versions 1. 0 and 1. 1 represented major changes in software development.However, one important thing that did not change much was support for distributed transactions.
Data Points - Data Source Controls in ASP.NET 2.0
Tue, 14 Dec 2004 10:00:00 GMT
ASP. NET 2. 0 introduces a series of new tools that improve data access including several data source and data bound controls.The new assortment of data source controls can eliminate a ton of repetitive code that was required in ASP.
Data Points - Efficient Coding With Strongly Typed DataSets
Tue, 16 Nov 2004 10:00:00 GMT
Someone once said to me that the hallmark of a good developer is the desire to spend time efficiently.Developers are continually pursuing ways to make coding easier and faster, and to reduce the number of errors.
Data Points - Updating Data in Linked Servers, Information Schema Views, and More
Tue, 19 Oct 2004 10:00:00 GMT
Every day a developer somewhere needs to write code to iterate through SQL Server™ system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.
Data Points - Handling Data Concurrency Using ADO.NET, Part 2
Tue, 14 Sep 2004 10:00:00 GMT
Enterprise development has been moving towards a discon-nected model in recent years and ADO. NET development is no exception.While the disconnected model of the ADO. NET DataSet offers great flexibility, that adaptability also means looser control over data updates than you get with a connected data access model.
Data Points - Handling Data Concurrency Using ADO.NET
Tue, 17 Aug 2004 10:00:00 GMT
One of the key features of the ADO. NET DataSet is that it can be a self-contained and disconnected data store.It can contain the schema and data from several rowsets in DataTable objects as well as information about how to relate the DataTable objects—all in memory.
Data Points - Migrating from ADO to ADO.NET, Part 2
Tue, 20 Jul 2004 10:00:00 GMT
As you move forward with your use of ADO. NET, you'll need to know how to approach situations that you previously learned to handle in ADO and now have to tackle with ADO. NET.Just as n-tiered solutions developed using Visual Basic®, C++, and ASP often rely on ADO for their data access needs, Windows® Forms, Web Forms, and Web services rely on ADO.
Data Points - Migrating from ADO to ADO.NET
Tue, 15 Jun 2004 10:00:00 GMT
In recent years ADO has taken the lead as the preferred method for implementing data access in Windows®-based applications.Huge numbers of ADO applications are in use today and many developers are well versed in ADO development.
Data Points - Contrasting the ADO.NET DataReader and DataSet
Tue, 18 May 2004 10:00:00 GMT
Data Points - Saving Parent-child Data in a Multitiered App Using ADO.NET
Tue, 20 Apr 2004 10:00:00 GMT
Data Points - Creating Audit Tables, Invoking COM Objects, and More
Tue, 16 Mar 2004 10:00:00 GMT
Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL Server™ are all common issues that developers must tackle.
Data Points - Exception-handling Techniques
Tue, 17 Feb 2004 10:00:00 GMT
Data Points - Exploring SQL Server Triggers: Part 2
Tue, 16 Dec 2003 10:00:00 GMT
Data Points - Exploring SQL Server Triggers
Tue, 18 Nov 2003 10:00:00 GMT
Data Points - SQL Server User-defined Functions
Tue, 14 Oct 2003 10:00:00 GMT
Data Points - Exploring the ADO.NET DataRow
Tue, 16 Sep 2003 10:00:00 GMT
Data Points - Developing Apps with the .NET Compact Framework, SQL Server CE, and Replication
Tue, 12 Aug 2003 10:00:00 GMT
Data Points - Managing Hierarchical Inserts in ASP.NET and ADO.NET
Tue, 17 Jun 2003 10:00:00 GMT
Data Points - Techniques in Filling ADO.NET DataTables: Performing Your Own Analysis
Tue, 13 May 2003 10:00:00 GMT
How do you know which technique is best for retrieving data and populating a DataSet in ADO.NET?. Since the Microsoft .NET Framework offers so many choices on how to write the code, many developers are now taking a close look at the different options. See what they are.
Data Points - Techniques for Managing Rowset Paging
Tue, 15 Apr 2003 10:00:00 GMT
There are a number of ways to handle paging in Web applications. This month I'll examine several paging techniques and weigh their pros and cons. John Papa discusses how to manage paging and caching issues through the lower tiers of an n-tiered architecture, including how to make SQL Server manage the paging on your app's behalf.
Data Points - Expressions in ADO.NET
Tue, 17 Dec 2002 10:00:00 GMT
Managing relations in a database became a whole lot easier with ADO. NET.Instead of returning a single rowset to a data store, you can return a series of rowsets and relate them within a DataSet.There are numerous advantages to using related DataTables in ADO.
Data Points - DataRelations in ADO.NET
Tue, 15 Oct 2002 10:00:00 GMT
One of the biggest differences between traditional ADO and ADO. NET is that the rowsets stored within ADO. NET can be truly relational.For example, a DataSet can store one DataTable containing customers and another DataTable containing the customers' orders.
Data Points - Five Ways to Rev up Your SQL Performance
Tue, 18 Jun 2002 10:00:00 GMT
Data Points - Building a Tiered Web App Using the DataSet and the ASP DataGrid
Tue, 16 Apr 2002 10:00:00 GMT
Data Points - Establishing Relationships Between Rowsets with ADO.NET
Tue, 15 Jan 2002 10:00:00 GMT
Data Points - Using the ADO.NET DataSet for Multitiered Apps
Tue, 18 Dec 2001 10:00:00 GMT
Data Points - Abstracting ADO.NET
Tue, 16 Oct 2001 10:00:00 GMT
Data Points - ADO to XML: Building a Data Access Tier with the DataManager Component
Tue, 17 Jul 2001 10:00:00 GMT
Data Points - Revisiting the Ad-Hoc Data Display Web Application
Tue, 15 May 2001 10:00:00 GMT
Secure Sockets Layer - Protect Your E-Commerce Web Site with SSL and Digital Certificates
Tue, 13 Mar 2001 10:00:00 GMT
Security is one of the most important factors in the future growth of e-businesses. Making sure that communications remain secure between customers and the Web server is a critical issue. Secure Sockets Layer (SSL) is the standard that secure Web sites are built upon today. This article presents an overview of SSL-based Web security, explaining such fundamental concepts as digital certificates and their distribution, encryption, and the proper configuration of Microsoft Internet Information Services (IIS). Acquiring a certificate, installing it, and configuring IIS for SSL are outlined in a step-by-step process.
Taming the Stateless Beast - Managing Session State Across Servers on a Web Farm
Tue, 12 Sep 2000 10:00:00 GMT
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here. The article begins with a description of the SQL Server database used to store state information, the stored procedures used to update it, and the retrieval of session data. ASP code drives the session manager tool and the COM and COM+ components that run the stored procedures.