如何使用此特定行指定userId？ [英] How do I designate the userId with this particular row?

问题描述

大家好，



我的数据库中有两个表，一个是aspnet_SearchGen和aspnet_Genealogy，表的代码是如下：

Hi Everyone,

I have two tables in my database, one is aspnet_SearchGen and aspnet_Genealogy, the code for the tables are as follows:

CREATE TABLE [dbo].[aspnet_SearchGen] (
    [SearchGenId]       INT            IDENTITY (1, 1) NOT NULL,
    [FamilyName]        CHAR (200)     NOT NULL,
    [FirstName]         CHAR (200)     NULL,
    [MiddleName1]       CHAR (200)     NULL,
    [MiddleName2]       CHAR (200)     NULL,
    [MiddleName3]       CHAR (200)     NULL,
    [Gender]            CHAR (10)      NULL,
    [DOB]               VARCHAR (20)   NOT NULL,
    [COOB]              NVARCHAR (200) NULL,
    [SOB]               NVARCHAR (200) NULL,
    [COB]               NVARCHAR (200) NULL,
    [Newsletter]        CHAR (10)      NULL,
    [GenType]           NVARCHAR (200) NULL,
    [GenRank]           NVARCHAR (200) NULL,
    [GenTitles]         NVARCHAR (200) NULL,
    [GenTitles1]        NVARCHAR (200) NULL,
    [GenTitles2]        NVARCHAR (200) NULL,
    [DOD]               VARCHAR (20)   NULL,
    [COOD]              NVARCHAR (200) NULL,
    [SOD]               NVARCHAR (200) NULL,
    [COD]               NVARCHAR (200) NULL,
    [DateTimeSearchGen] DATETIME       NULL,
    PRIMARY KEY CLUSTERED ([SearchGenId] ASC)
);

和

and

CREATE TABLE [dbo].[aspnet_Genealogy] (
    [GenealogyId]       INT              IDENTITY (1, 1) NOT NULL,
    [RelationshipId1]   INT              NULL,
    [Relationship1]     NVARCHAR (200)   NULL,
    [TRelationshipId1]  INT              NULL,
    [TRelationship1]    NVARCHAR (200)   NULL,
    [FamilyName]        CHAR (200)       NOT NULL,
    [FirstName]         CHAR (200)       NULL,
    [MiddleName1]       CHAR (200)       NULL,
    [MiddleName2]       CHAR (200)       NULL,
    [MiddleName3]       CHAR (200)       NULL,
    [Gender]            CHAR (10)        NULL,
    [DOB]               VARCHAR (20)     NOT NULL,
    [COOB]              NVARCHAR (200)   NULL,
    [SOB]               NVARCHAR (200)   NULL,
    [COB]               NVARCHAR (200)   NULL,
    [Newsletter]        CHAR (10)        NULL,
    [GenType]           NVARCHAR (200)   NULL,
    [GenRank]           NVARCHAR (200)   NULL,
    [GenTitles]         NVARCHAR (200)   NULL,
    [GenTitles1]        NVARCHAR (200)   NULL,
    [GenTitles2]        NVARCHAR (200)   NULL,
    [DOD]               VARCHAR (20)     NULL,
    [COOD]              NVARCHAR (200)   NULL,
    [SOD]               NVARCHAR (200)   NULL,
    [COD]               NVARCHAR (200)   NULL,
    [UserId]            UNIQUEIDENTIFIER NULL,
    [UserName]          nvarchar(256)    NULL,
    [DateTimeGenealogy] DATETIME         NOT NULL,
    [SearchGenId1]      INT              NULL,
    CONSTRAINT [PK_aspnet_Genealogy] PRIMARY KEY CLUSTERED ([GenealogyId] ASC),
    CONSTRAINT [FK_aspnet_Genealogy_To_aspnet_SearchGen] FOREIGN KEY ([SearchGenId1]) REFERENCES [dbo].[aspnet_SearchGen] ([SearchGenId]),
    CONSTRAINT [FK_aspnet_Genealogy_To_aspnet_Users] FOREIGN KEY ([UserId]) REFERENCES [aspnet_Users]([UserId])
);

我有一个页面调用default.aspx，它将数据发布到aspnet_SearchGen，然后我转到一个名为Results.aspx的页面，我想将该数据插入到表，aspnet_Genealogy。 aspnet_SearchGen是用户构建其族树时用于搜索引擎的表。 aspnet_Genealogy表将指定该特定行的用户标识和用户名以构建系列树页面ResultsLayout.aspx。



Default.aspx，Default.aspx.cs工作正常，我能够插入到aspnet_SearchGen表中。我还没弄清楚如何插入aspnet_Genealogy表。我能够发布到Results.aspx，我希望能够将相同的数据插入到aspnet_Genealogy中，并将该数据行与UserId和UserName相关联。我相信我应该能够使用SP来做到这一点。我只是不知道将userId和Username与数据行相关联的最佳方法是什么。



有没有人有任何想法？



期待很快收到你的回复。



谢谢







ASW

I have a page call default.aspx which post the data to aspnet_SearchGen, then I go to a page called Results.aspx which I want to insert that data to table, aspnet_Genealogy. The aspnet_SearchGen is the table that I use for my search engine when a user is building his family tree. The aspnet_Genealogy table will designate the userid and username to that particular row to build a family tree page, ResultsLayout.aspx.

The Default.aspx, Default.aspx.cs are working fine, I am able to insert into aspnet_SearchGen table. I have not figure out how to insert into aspnet_Genealogy table yet. I am able to post to Results.aspx, I want to be able to insert the same data into aspnet_Genealogy and associate that data row with a UserId and UserName. I believe I should be able use a SP to do this. I just do not know what the best way is to associate the userId and Username with the data row.

Does anyone have any ideas?

Look forward to hearing from you soon.

Thanks



ASW

推荐答案

当您在aspnet_Genealogy表中将SearchGenId作为外键时。为什么在aspnet_Genealogy中需要相同的数据是多余的？



我不确定你是如何获得用户ID和用户名的，可能是你可以维护的与会话和访问。

When you have SearchGenId as a foreign key in aspnet_Genealogy table. why do you require the same data to be redundant in aspnet_Genealogy ?

I'm not sure how you are getting the user id and user name , may be you can maintain with in session and access across.

这篇关于如何使用此特定行指定userId？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！