In Microsoft's free ASP.NET Development Tools ASP.NET Webmatrix we can easily use template columns in DataGrid to display data.
This example uses the PUBS database that comes with SQL Server2000.
First, open ASP.NET WebMatrix to create a new file, type "Simple Data Report" in "Data Pages", then switch to the Code view, the default database connection string is:
DIM Connectionstring as string = "server = (local); database = public = true"
Change to:
DIM Connectionstring As String = "Server = (local); Database = PUBS; UID = SA; PWD = SA"
