You searched for the word(s): userid:834178

More Search Options

RSS Available

• data binding question for a simple enhancement

  I would like to display the albumn titles on the Photos.aspx and Details.aspx pages. I'm having trouble getting it to work. I thing the way I'm supposed to do it is to bind a control to the output of a SQL statement based on the query string. The query string contains the AlbumID. I've created a stored procedure that works. the code is: ALTER PROCEDURE GetAlbumTitle @AlbumID as int AS SELECT *, 0 AS NumberOfPhotos FROM [Albums] WHERE ([Albums].[AlbumID] = @AlbumID) RETURN I think I'm

  Posted to Personal Site Starter Kit (Forum) by mreaves2008 on 12/11/2008
  Filed under: data binding

• Re: How to re-create Personal.mdf

  I solved this by, deleting the *.mdf file, creating a new database (see above) and creating the tables & stored proc again using the personal-add.sql code in the SQL 2008 mgmt studio. I had to add permissions to the database folder for the user called SQLServerMSSQLuser$[hostname]$SQLExpress.... I got one of the other starter kits that uses a DB working then I established the same permissions. I hope that helps. I'm no pro. It took me most of the day. Cheers, Mike

  Posted to Personal Site Starter Kit (Forum) by mreaves2008 on 10/30/2008

• Re: How to re-create Personal.mdf

  Thanks for that Serk4, but when you say "recreate it", do you mean in something like Query Analyser,.. in other word, run the SQL to recreate the tables / procs? How do I do that. If that's the way, which tool should I use?

  Posted to Personal Site Starter Kit (Forum) by mreaves2008 on 10/25/2008