SQL Tutorials & Articles
-
SharePoint, Document Library and SQL Server
by S.S. AhmedThis tutorial shows how you can capture a document in SharePoint's document library, retrieve information from its properties and store in in SQL Server. It will teach you how to use Event Handler Toolkit.
-
High-Performance .NET Application Development & Architecture
by Dimitrios MarkatosThis article demonstrates the art of creating and architecting high-performance and scalable .NET applications, covering all stages, from planning to development and their perspective best practices.
-
DataGrid/GridView Paging and Sorting Using A DataReader
by Dimitrios MarkatosThis article will demonstrate two ways one could implement the DataReader to bind a DataGrid, that includes caching, paging and persistent bi-directional sorting, all without the use of a DataAdapter/DataSet at all, and includes ASP.NET 2.0 GridView version!
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid (i.e. HotMail & Yahoo)
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid with all the features you'd find set up on Hotmail or Yahoo. As an added bonus we'll be performing all of our data tasks strictly utilizing Microsoft's new Data Access Application Block or DAAB v2.
-
Implementing ODBC in ASP .NET
by Jason G. WilliscroftWith Microsoft's ODBC data server controls, .NET finally supports ODBC... but not very well. HotQuant, LLC, has published an in-depth technical article demonstrating an effective workaround.
-
XML Strengths & Weakness’ with DOM, ASP & XSL
by Nakul GoyalNakul Goyal introduces the XML technology, and how it can be used in your ASP and Visual Basic programs.
-
SQL Distributed Management Objects
by S.S. AhmedYou will learn how to administer SQL Server remotely. I have selected VB to develop a component that will be used in ASP scripts to harness the power of SQL-DMO.
-
Implementing Error Logging
by Carvin WilsonHow to implement error logging in ASP 3.0
-
Creating a Members Area in ASP
by James CrowleyA complete tutorial on how to create your own 'members-only' area on your website.
-
SQL Server Locks
by Michael BalloniSQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK
-
Interview with Matthew Reynolds
by James CrowleyA technical Interview with Matthew Reynolds, author of Beginning E-Commerce with Visual Basic, ASP, SQL Server 7.0 and MTS
-
Introducing Windows Forms
by MicrosoftLearn about the new forms package, allowing developers to take full advantage of the rich user interface features available in Windows
-
VB Conventions
by MSDN CommunitiesExtracts from a number of MSDN articles on coding and naming conventions in VB.
-
Domain Driven Design: A Step by Step Guide - Part 1
by Casey CharltonThere is a lot of interest in DDD recently, both in the book, and in the methodology, and in the buzzword. Casey aims to clear up the confusion and start to demystify it.
-
The Need for Partnership as a Small Business
by James CrowleyCombine forces and be stronger as a small business
-
Effective Controls for Attaining Continuous Application Security Throughout the Web Application Development Life Cycle
by Caleb SimaImproving your Web application development process is one of the best ways to avoid security vulnerabilities and nasty surprises during security assessments. Learn about the points in the software development life cycle where additional security awareness and training is needed to ensure that your organization remains successful and secure.
-
Web Application Vulnerability Assessment Essentials
by Caleb SimaIt is important for a business to understand the fundamentals of running a vulnerability assessment in order to determine how one will be run and what can be expected from the results. A web application security scanner can automate the process, but a quality assessment may still require actual human eyes to catch specific issues. Learn more about the whys and hows of vulnerability assessments.
-
Using WMI From Managed Code
by Andriy KlyuchevskyyWindows Management Instrumentation (WMI) is Microsoft's implementation of Web-Based Enterprise Management (WBEM) and the Common Information Model (CIM). Although WMI is COM-based, Andriy Klyuchevskyy shows you how you can access it from C# and VB.NET through System.Management, thanks to COM Inter-Op.
-
Selecting, Confirming & Deleting Multiple Checkbox Items In A DataGrid/GridView - Part 2: Maintaining CheckBox State Acr
by Dimitrios MarkatosIn this article, we will examine how to create a fully functional DataGrid and GridView in .NET 2.0 with all the features you'd find set up on Hotmail, Yahoo, and AOL Mail, and further demonstrate how you can multi-select items across pages and batch delete them all.
-
Generate Thumbnail Images from PDF Documents in .NET
by Jonathan HodgsonThis article presents VB.NET code to create thumbnail images from a directory of Adobe Acrobat PDF documents using the .NET Framework.