The readme for TheBeerHouse explains how to attach a DB to a local SQL Server. This is probably also discussed in the deployment chapter. This is sometimes needed because the SQL Server utilities (such as Sql Server Management Studio) can't open tables from a DB that merely exists in the App_Data folder. Only Visual Studio, and ASP.NET, know how to auto-attach to a DBF file.

Eric

Thank you Jimi,

I got them work. Thank you for your help.




jophie

I can get the search control running well and am very happy with it but I now have a problem that I hope is easy to fix. When I go to log in on the login view and press return after fill out the textboxs the required field valiator message appears for the search control!
Not sure why this is happening, when the user clicks the loging button it is fine. This problem happens awell with any other detailview buttons aswell. When the user presses the the button it expects the search control to have a value.
Any ideas where I have gone wrong

Jez

Jez - could well be that i've updated my own version of this forgetting to do the same with the online one. Basically, you need to amend the search.ascx page and add the following onto the button code:

CausesValidation="false"

the entire line would then look like:

<asp:Button ID="imgGo" runat="server" CausesValidation="false" Text="Search" OnClick="imgGO_Click" />

hope this works for you

jimi

http://www.originaltalent.com

Couple of questions:

Why do we need to create the following indexes?
Why can we just use PK_tbh_Articles for these columns?


IX_tbh_Articles_Approved
IX_tbh_Articles_ReleaseDate
IX_tbh_Articles_OnlyForMembers

And how come you create more then one index on same table,
"Only one full-text index is allowed per table" (MSDN - CREATE FULLTEXT INDEX )


Also, when I create PK_tbh_Articles index i get this warning:
Warning: Table or indexed view 'Database.dbo.tbh_Articles' has full-text indexed columns that are of type image, text, or ntext. Full-text change tracking cannot track WRITETEXT or UPDATETEXT operations performed on these columns.