Using System DSN in connection strings section of web.config

<add name="connectionname" connectionString="Dsn=DSNNetData"
providerName=”System.Data.Odbc” />

Opitmistic Conccurrency

A good discussion and example of the benefits of optimistic concurrency
http://msdn2.microsoft.com/en-us/library/aa0416cz.aspx

Using an SQLDataSOurce from code-behind.

MSDN Sqldatasource.Select
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.select.aspx

Programmticallty accessing and using a SQLDATASOURCE
http://www.codeprof.com/dev-archive/208/12-45-2089876.shtm

Algining Gridview controls within a Panel

Some Talk on Rick’s blog about gridview and alignment techniques.
http://www.west-wind.com/weblog/posts/138073.aspx

Site regarding differences between DetailsView and FormView for the inserting of data.
http://aspnet.4guysfromrolla.com/articles/050207-1.aspx

Setting default options on a datasource
http://p2p.wrox.com/topic.asp?TOPIC_ID=51739


Use bind to set the appropriate bindings..

Solution for binding to a database field in a template field
http://www.gridviewguy.com/ArticleDetails.aspx?articleID=147

CSS Menu

Three level CSS menu
http://www.builderau.com.au/program/css/soa/Creating-a-three-level-rollover-vertical-menu-with-CSS/0,339028392,339285591,00.htm

Working With Connection Strings in VS2008/2005

Working with connection strings
http://msdn2.microsoft.com/en-us/library/ms254978(VS.80).aspx

‘Sample VB Code

Dim builder As New System.Data.SqlClient.SqlConnectionStringBuilder
builder("Data Source") = "(local)"
builder("Integrated Security") = True
builder("Initial Catalog") = "AdventureWorks;NewValue=Bad"
Console.WriteLine(builder.ConnectionString)

Keyboard Shortcuts in SQL Server 2005/Express


Keyboard Shortcuts
http://msdn2.microsoft.com/en-us/library/ms174205.aspx

HISTORY:

Blog regarding the announcement of XM the new light weight management studio
http://blogs.msdn.com/sqlexpress/archive/2004/07/02/172252.aspx

DOWNLOAD:
Yukon/SQL Server 2005 – SSMS free version
http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en