Database Tutorials & Articles
-
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.
-
To SP or not to SP in SQL Server
by Douglas ReillyThe topic of using or not using stored procedures reaches the level of religious fervor in many quarters. Douglas Reilly, a Microsoft MVP, weighs in on the topic with an in-depth analysis.
-
Filtering and Sorting in ADO.NET
by Martin ZahnADO.NET supports many ways to manage memory-resident data returned in a DataSet. This example demonstrates how to use the additional functionality exposed by ADO.NET to sort and filter data.
-
Query Tool to Excel using C# and .NET
by Mike GoldDemonstrates how to use .NET interop to perform an SQL query and then send the results into an Excel spreadsheet.
-
Building a Full-Featured Custom DataGrid Control
by Dimitrios MarkatosIn this article, we will demonstrate how you can build your very own Datagrid control component, one that you will be able to customize, and more importantly reuse. Based on this ability, you will then end up with one powerful control that will have many implementations, from which you could learn about creating almost any other types of custom controls.
-
SQL Injection Attacks by Example
by Stephen J. FriedlSteve Friedl takes a look at how your site could be vulnerable to SQL injection attacks - complete with numerous examples - and the action you can take to prevent them.
-
Tree structures in ASP.NET and SQL Server
by James CrowleyTakes a look at how tree structures can be usefully stored in a relational database such as SQL Server, and how to implement web directory-like features such as breadcrumbs.
-
Introducing a post-relational database for .NET
by John SasakThis is a step by step guide for a post-relational database for .NET, Matisse. The article is aiming at helping developers quickly evaluate this alternative solution as .NET database when they face problems of productivity, flexibility, extensibility, or maintainability.
-
Extracting the Country from the IP Address:- How To?
by Amit GuptaGet to know from where the visitors to your website are coming. Amit shows you how you can know the Country of a visitor through his IP Address without using COM.
-
Using ADO.NET with SQL Server
by James CrowleyAn extensive examination of using ADO.NET to access SQL Server databases, from establishing connections and executing stored procedures, to connection pools, data readers and data sets.
-
In Depth ASP.NET using ADO.NET
by John GodelIn this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET. In particular, with this article we will cover ASP.NET server controls, ADO.NET DataSource, and creating Templated DataBound Controls, ASP.NET forms, using data with controls. John Godel