This is part I of the tutorial that teaches you how to connect to a SQL database from ASP .NET using SQL Authentication. This part shows you how to set up MSDE for Mixed Mode and how to use Web Data Administrator to create databases and users.

This is part II of the tutorial that teaches you how to connect to a SQL database from ASP .NET using SQL Authentication. This part shows you how to connect to the database using ASP .NET code and Visual Studio .NET's features.

The tutorial shows you how to create stored procedures, after which you'll see how to use stored procedures in an ASP .NET web application.

This tutorial covers the creation of a DataList control to retrieve records from a database. Also shows you how to make the DataList esthetic by changing its attributes.

It simply shows how to bind a DataGrid to an array using C# code.

Ideally, every application built would be designed with correct date handling techniques. In practice, applications are often built using ad hoc date formatting to match a corporate culture, the default format on a company’s server, or the favorite format of the lead developer. Also, many applications are not locale aware or were not designed to be deployed in an environment where locale issues were not considered important. Because of this it is extremely important to know the date formats in use for input and output when building applications that will integrate with other systems or databases and to handle these formats explicitly.

Working on a multi-developer ASP.NET project while sharing one web.config can be time consuming and troublesome. Usually, each developer may have path and other settings specific to their development machine, such as Database connection strings, paths, e-mail addresses, etc. For example, each developer on a project may be running a database locally that the application relies on during development. Therefore, the connection string would be different for each developer.

In this tutorial you'll find out how to validate a TextBox and RadioButtonList control on a webform using RequiredFieldValidator, which will show a warning and stop the submission of the form if a required field has no value.

Learn how to serialize .NET classes to Xml at runtime using System.Xml.Serialization.XmlSerializer. Then, use SQL Server's OPENXML functionality to bulk load hundreds of records across multiple tables in a single stored procedure call.

The control offers a very user friendly mobile device experience in that it allows the user to use their stylus / mouse to adjust the weight for a given decision criteria instead of typing the numbers.