求QuickStart最后面的示例应用程序两个例子里用到的数据库：grocertogo，portal

[zedan]

我装了ASP.NET的QuickStart，也下载装了MSDE，也有SQL2000，但QuickStart里有几个例子用到的数据库在我的MSDE上没有：grocertogo，portal这两个，而我的MSDE装时只有master,model,msdb,tempdb这几个，就连是Northwind和pubs都是从SQL2000那里Copy过来的，现在想要最后面的 示例应用程序-->个性化门户 和-->电子商务店面 这两个例子里用到的数据库，除了grocertogo，portal这两个，应该没有了吧？哪位大哥有的话就帮帮忙弄下来发到我的邮箱：[e-mail],谢谢了，急用！！

[hackate]

你到站长站搜索一下，我记得那有下载

[zedan]

上面的兄弟，我在 中国站长站 找了很久都没找到，不知道是没有了还是我找不到，到Google上也找不到有相关的，那位有现成的copy下来发给我好吗？？？谢谢了

[athossmth]

C:\Program Files\Microsoft.NET\SDK\v1.1\QuickStart\aspplus\samples\grocertogo\data\grocertogo.mdb

[athossmth]

C:\Program Files\Microsoft.NET\SDK\v1.1\QuickStart\aspplus\samples\portal\data\portal.mdb

C:\Program Files\Microsoft.NET\SDK\v1.1\QuickStart\aspplus\samples\portal\data\portal.sql

[athossmth]

应该是两个mdb文件在你的本机。其中portal带sql脚本，脚本内容如下：

if exists (select * from sysobjects where id = object_id(N'[dbo].[CreatePersonalizationAccount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CreatePersonalizationAccount]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[GetPublicModules]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetPublicModules]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[GetSiteLinks]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetSiteLinks]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[LoadPersonalizationSettings]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[LoadPersonalizationSettings]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[SavePersonalizationSettings]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SavePersonalizationSettings]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_CreateProfile]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_CreateProfile]
GO

if exists (select * from sysobjects where id = object_id(N'[dbo].[sp_ValidateUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_ValidateUser]
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO



CREATE Procedure CreatePersonalizationAccount
(
@UserId varchar(50)
)
As
DECLARE @PageNames varchar(8000)
DECLARE @PageModules_0L varchar(8000)
DECLARE @PageModules_0R varchar(8000)
DECLARE @PageModules_1L varchar(8000)
DECLARE @PageModules_1R varchar(8000)
DECLARE @PageModules_2L varchar(8000)
DECLARE @PageModules_2R varchar(8000)
DECLARE @PageIndex VARCHAR(50)
DECLARE @BackColor varchar(15)
DECLARE @LeftColor varchar(15)
DECLARE @HeadColor varchar(15)
DECLARE @SubheadColor varchar(15)
DECLARE @ColorScheme varchar(15)
DECLARE @SiteDirectory_Links VARCHAR(200)
DECLARE @CM_Constructors varchar(5)
DECLARE @CM_Properties varchar(5)
DECLARE @CM_Methods varchar(5)
DECLARE @CM_Fields varchar(5)
DECLARE @CM_Implements varchar(5)
DECLARE @CM_Hierarchy varchar(5)
DECLARE @CM_Subclasses varchar(5)
DECLARE @FavoriteLinks_List varchar(8000)
DECLARE @FavoriteLinksLeft_List varchar(8000)
SELECT @PageNames = CONVERT(varchar(8000),PageNames),
@PageModules_0L = CONVERT(varchar(8000),PageModules_0L),
@PageModules_0R = CONVERT(varchar(8000),PageModules_0R),
@PageModules_1L = CONVERT(varchar(8000),PageModules_1L),
@PageModules_1R = CONVERT(varchar(8000),PageModules_1R),
@PageModules_2L = CONVERT(varchar(8000),PageModules_2L),
@PageModules_2R = CONVERT(varchar(8000),PageModules_2R),
@PageIndex = PageIndex,
@SiteDirectory_Links = SiteDirectory_Links,
@BackColor = BackColor,
@LeftColor = LeftColor,
@HeadColor = HeadColor,
@SubheadColor = SubheadColor,
@ColorScheme = ColorScheme,
@FavoriteLinks_List = CONVERT(varchar(8000),FavoriteLinks_List),
@FavoriteLinksLeft_List = CONVERT(varchar(8000),FavoriteLinksLeft_List)

FROM Personalization Where UserId='DEFAULT'
INSERT INTO Personalization Values ( @UserId,
@PageNames,
@PageModules_0L,
@PageModules_0R,
@PageModules_1L,
@PageModules_1R,
@PageModules_2L,
@PageModules_2R,
@PageIndex,
@SiteDirectory_Links,
@BackColor,
@LeftColor,
@HeadColor,
@SubheadColor,
@ColorScheme,
@FavoriteLinks_List,
@FavoriteLinksLeft_List
)
return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO


CREATE Procedure GetPublicModules As
SELECT * FROM Modules WHERE Private != 1
return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO



Create Procedure GetSiteLinks As
SELECT * FROM SiteDirectory
return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO


CREATE Procedure LoadPersonalizationSettings
(
@UserId varchar(50)
)
As
SELECT * FROM Personalization WHERE UserID=@UserId
return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO


CREATE Procedure SavePersonalizationSettings
(
@UserId varchar(50),
@PageNames varchar(8000),
@PageModules_0L varchar(8000),
@PageModules_0R varchar(8000),
@PageModules_1L varchar(8000),
@PageModules_1R varchar(8000),
@PageModules_2L varchar(8000),
@PageModules_2R varchar(8000),
@PageIndex varchar(200),
@SiteDirectory_Links varchar(200),
@BackColor varchar(15),
@LeftColor varchar(15),
@HeadColor varchar(15),
@SubheadColor varchar(15),
@ColorScheme varchar(15),
@FavoriteLinks_List varchar(8000),
@FavoriteLinksLeft_List varchar(8000)
)
As
UPDATE Personalization
SET
PageNames=@PageNames,
PageModules_0L=@PageModules_0L,
PageModules_0R=@PageModules_0R,
PageModules_1L=@PageModules_1L,
PageModules_1R=@PageModules_1R,
PageModules_2L=@PageModules_2L,
PageModules_2R=@PageModules_2R,
PageIndex=@PageIndex,
SiteDirectory_Links = @SiteDIrectory_Links,
BackColor = @BackColor,
LeftColor = @LeftColor,
HeadColor = @HeadColor,
SubheadColor = @SubheadColor,
ColorScheme = @ColorScheme,
FavoriteLinks_List = @FavoriteLinks_List,
FavoriteLinksLeft_List = @FavoriteLinksLeft_List
WHERE UserId=@UserID
/* set nocount on */
return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO




CREATE proc sp_CreateProfile @UserId varchar(15), @Password varchar(15), @FirstName varchar(15), @LastName varchar(15),
@Address varchar(50), @State varchar(2), @Zip varchar(5), @Phone varchar(15),@City varchar(50)
as
insert into UserData
values (@UserId , @Password , @FirstName , @LastName ,@Address, @State, @Zip, @Phone ,@City )

return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO



CREATE proc sp_ValidateUser @UserId varchar(20), @Password varchar(15) , @IsValid Int output
as
if (select count(*) from UserData where Userid= @UserId and Password = @Password ) = 1
select @ISValid = 1
else
select @IsValid = 0
return

GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO