Does anyone know if you can sort the Albums.aspx by newest added by default? Currently when I add a new album it appends to the bottom of the screen. I would like the last added album to be the first one on the screen.

Thanks!

If your images/image name is coming from the database,  You can use order by in your "select" query to sort it.

Better if you have a column in table storing the record date, you can probably sort it using record date with descending order.

"select image from table order by desc" and bind it to the control you are using to display it.

I'm not sure if this is correct or not, but would this stored proc be what is pulling the albums? If so can it be modified to sort the [Albums].[AlbumID] field in DESC order??

 ALTER PROCEDURE GetAlbums

Yes certainly. But make sure that the Album Id is getting incremented on every record insertion.

 It does get incremented every time a album gets added. My question is how do I change the code below to return in DESC order?

ALTER PROCEDURE GetAlbums

ALTER PROCEDURE GetAlbums

@IsPublic bit

AS

SELECT

[Albums].[AlbumID],

[Albums].[Caption],

[Albums].[IsPublic],

Count([Photos].[PhotoID]) AS NumberOfPhotos

FROM [Albums] LEFT JOIN [Photos]

ON [Albums].[AlbumID] = [Photos].[AlbumID]

WHERE

([Albums].[IsPublic] = @IsPublic OR [Albums].[IsPublic] = 1)

GROUP BY

[Albums].[AlbumID],

[Albums].[Caption],

[Albums].[IsPublic]

ORDER BY [Albums].[AlbumID] DESC

RETURN