Answer My Query

The SqlBulkCopy class provides a mechanism for efficiently importing large amounts of data into a Microsoft SQL Server database. Compared to importing data by executing one INSERT statement for each record to import, SqlBulkCopy is noticeably faster when importing thousands (or more) records. In a nutshell, importing data using SqlBulkCopy entails creating a SqlBulkCopy object, specifying the destination database and table, and providing the data to import in the form of a DataTable, DataRow, or DataReader. In Using SqlBulkCopy To Perform Efficient Bulk SQL Operations we looked at how to use SqlBulkCopy to programmatically import data from an uploaded Excel spreadsheet into a SQL Server database.

While Using SqlBulkCopy To Perform Efficient Bulk SQL Operations showed how to use the SqlBulkCopy class, it did not explore how SqlBulkCopy imports fare in the face of an error. What happens if, when importing a total of 10,000 records, an error occurs when importing record number 501? Should those first 500 records be committed or should the entire batch be rolled back? This article examines the default behavior of the SqlBulkCopy class in the face of an error. It also looks at how to perform bulk copy operations under the umbrella of a transaction. Read on to learn more!

Note: If you have not yet read Using SqlBulkCopy To Perform Efficient Bulk SQL Operations, please do so before reading this article...
Read More >

Santiago Barro and his development team have created a powerful WinForms ERP application called BinaryActiva. Btw, that’s Santiago on the upper left:

The WinForms ERP application is the main client which supports business activities like: Purchasing, Sales, Stocks, Production, CRM, HR, and more. They’ve also built an ASP.NET website that integrates with their CRM module to send SMS updates!

So why did they build both the WinForms and ASP.NET applications using their DevExpress Suite? Santiago points out:

DevExpress controls are always evolving. Using their controls in applications will always give a consistent and professional interface similar to that of any application developed by the major software development companies.

DevExpress makes the cool tools and teams like Binary Menorca use them to produce award winning applications. Sounds like a fair deal to me. Check out this photo of the guys winning the "Young Enterprise Award" in their native country of Spain. I think the guy on the right is holding a copy of DXPerience behind his back. I'm just kidding, of course, their good work earned them the awards. We're just happy that they chose DevExpress tools to help them succeed.

Read the full Binary Menorca S.L. case study and learn how Santiago and his team leveraged DevExpress tools into a powerful ERP application.

I ran across this error after pushing out an upgraded .NET 4.0 MVC2 application to its existing IIS website.  After some digging around I found this document on MSDN: How to: Upgrade an ASP.NET Web Application to ASP.NET 4

Since the application was previously built on version 3.5, IIS was configured to run as Asp.Net 2.0. Well it turns out IIS runs under the new framework version 4.0. (not like 3.0, or 3.5 when the Application Pool runs as 2.0)

Kind of one those "I should have figured that out much quicker moments"… A simple change to the app pool to target 4.0, and were on our way.

This is an exciting time for web design. With growing usage of modern web browsers; the ability to use whatever font you like in your website is now possible. However there are copyright and licensing issues which limits your ability to do so. That’s where Typekit comes in. Typekit has worked with major foundries to develop a consistent web-only font linking license.

Typekit provides a platform that hosts both free and commercial fonts; and allows you to add a line of code to your pages and choose from hundreds of fonts. Simple, bulletproof, standards compliant, accessible, and totally legal.

Typekit offers a free plan that let you use 2 fonts on 1 website from their trial library with 5GB of monthly bandwidth. Their paid plan starts from $24.99/year which allows you to use 5 fonts from personal library on 1 website with 10GB of monthly bandwidth.

Typekit is produced by Small Batch Inc;Founded in 2008 by Jeffrey Veen, Bryan Mason, Greg Veen, and Ryan Carver. Visit Typekit: http://typekit.com/

Similar Posts:

• Font Squirrel: Free Fonts and CSS @font-face Kits For Designers
• Free Pattern and Texture Resources For Web Designers
• CSS Menus – Dozens of CSS Menus From CSSplay
• Resource Kit To Create, Customize & Find Twitter Backgrounds
• Find & Compare PHP, CSS, JavaScript and Ruby Frameworks

You can also stay updated by following us on Twitter, becoming a fan on Facebook or by subscribing to our FriendFeed.

Back in January I asked for opinions on Headings, heading hierarchy, and document outlines, hoping for a discussion that could lead to a conclusive recommendation.

Unfortunately it seems very difficult to reach consensus on this topic. However, with input from the discussion in the comments on that post, along with private discussions via email and face-to-face, I see two options:

1. Use headings for both document and site structure.
2. Use headings only for the structure of the actual content, and use WAI-ARIA landmark roles for anything outside the content area.

Read full post

Posted in (X)HTML, Accessibility.