Get Proper Filtered Results from a Data View   01 Apr 2008 01:36 GMT
Ever notice how your data isn't filtered properly even though you've set the Row Filter Expression correctly?
Source: DevX

Building Truly Useful Extension Methods   31 Mar 2008 03:25 GMT
Use extension methods to breathe new life into old classes—even classes that you didn't write!
Source: DevX

Script.aculo.us Controls: Do Your Web Users a Favor   28 Mar 2008 22:53 GMT
Learn how to integrate Script.aculo.us web controls into your web applications to make the end-user experience more pleasant.
Source: DevX

Capitalizing on Microsoft Dynamics CRM 3.0 Callouts: Advanced Features   27 Mar 2008 00:53 GMT
Callouts can add business value, but just as with any other code, you need to be able to handle exceptions and debug the callout code.
Source: DevX

Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Importing the Excel Spreadsheet   26 Mar 2008 00:00 GMT

Over the past four installments in this article series we have: created a SQL Server database for our web application; created an ASP.NET web page that enabled the visitor to upload an Excel spreadsheet and view its contents in a GridView; and created a Data Access Layer (DAL) using Typed DataSets for accessing our application database. All that remains is to import the uploaded Excel spreadsheet's data into the application database.

In a perfect world, a user would carefully check the data in the Excel spreadsheet and cross-reference it with the data already existing in the application database. But our users are humans and bound to err. Therefore, it behooves us to design the import functionality so that it can gracefully handle common types of mistakes. We'll examine two such cases: preventing duplicate entries and ensuring that the imported data is in the appropriate format.

Read on to learn more!
Read More >

Source: 4GuysFromRolla

Using Explicit Casting to Display Data   25 Mar 2008 02:09 GMT
Explicit casting offers better performance while avoiding the cost of reflection.
Source: DevX

Visual Basic and Respect   24 Mar 2008 18:29 GMT
Will VB's new LINQ to XML prowess finally gain it the community respect accorded to other mainstream languages?
Source: DevX

What's New in Visual Basic 9.0? Part 2   19 Mar 2008 04:17 GMT
The release of Visual Studio 2008 updates Visual Basic to version 9.0, with several key language enhancements and LINQ support. Part Two of this series will walk you through VB 9's new LINQ support features and other time-saving enhancements.
Source: DevX

Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters: Creating a Data Access Layer (DAL)   19 Mar 2008 00:00 GMT

Over the course of the past three tutorials we have created an ASP.NET page that allows the visitor to upload and display an Excel spreadsheet in a GridView. Our end goal is to allow the user to import the rows in the spreadsheet into the two tables of our application database, a task we will complete in this fourth installment.

In Displaying the Uploaded Excel Spreadsheet we saw how to use an OleDbConnection to programmatically connect to the Excel spreadsheet and bind it to the GridView. Likewise, we could use this same style of coding to insert data into our application database tables - connecting to the SQL Server database from code within the ASP.NET page and issuing the INSERT statements. A better approach, however, is to design a tiered architecture that separates out the different responsibilities into different layers. Specifically, we will place the code for inserting data into our database into a separate Data Access Layer (DAL), which we will create using Typed DataSets.

With the DAL created, we can then wrap up the page's core functionality: connecting to the Excel spreadsheet, enumerating its rows, and using the DAL to insert the rows into the database. Read on to learn more!
Read More >

Source: 4GuysFromRolla

Autocomplete Combo Boxes   17 Mar 2008 23:26 GMT
If you want autocomplete in VB, you've got to do it yourself and this tip shows you how.
Source: DevX