Heres an article that gives an overview of using SQL Server 2005 Express Edition with Visual Studio