Asp.net在DB中存储值 [英] Asp.net to store value in the DB

问题描述

1.UserInfo

  CREATE   TABLE  [dbo]。[userInfo]（
 [userId] [ bigint ]  IDENTITY （ 1 ， 1 ） NOT   NULL ，
 [email] [ nvarchar ]（ 30 ） NOT   NULL ，
 [密码] [ nvarchar ]（ 20 ） NOT  < span class =code-keyword> NULL ，
 [firstName] [ nvarchar ]（ 50 ） NULL ，
 [lastName] [ nvarchar ]（ 50 ）  NULL ，
 [activationKey] [ nvarchar ]（ 800 ） NULL ，
 [有效] [位<​​/ span>]  NULL ，
 [createdOn] [ datetime ]  NULL ，
 [modifiedOn] [ datetime ]  NULL ，
  PRIMARY   KEY   CLUSTERED  
（
 [userId]  ASC  
） WITH （PAD_INDEX =  OFF ，STATISTICS_NORECOMPUTE =  OFF ，IGNORE_DUP_KEY =  OFF ，ALLOW_ROW_LOCKS =  ON ，ALLOW_PAGE_LOCKS =  ON ） ON  [ PRIMARY ]，
  UNIQUE   NONCLUSTERED  
（
 [email]  ASC  
） WITH （PAD_INDEX =  OFF ，STATISTICS_NORECOMPUTE =  OFF ，IGNORE_DUP_KEY =  OFF ，ALLOW_ROW_LOCKS =  ON ，ALLOW_PAGE_LOCKS =  ON ） ON  [ PRIMARY ] 
） ON  [ PRIMARY ] 
  GO  

2.FileInfo

  CREATE   TABLE  [dbo]。[fileInfo]（
 [fileId] [ bigint ]  IDENTITY （ 1 ， 1 ） NOT   NULL ，
 [userId] [ bigint ]  NULL ，
 [fileName] [ nvarchar ]（ 50 ） NOT   NULL ，
 [fileType] [ nvarchar ]（ 50 ） NOT   NULL ，
 [fileSize] [ nvarchar  ]（ 100 ） NOT   NULL ，
 [filePath] [ nvarchar ]（ 200 ） NOT   NULL ，
 [createdOn] [ datetime ]  NULL ，
 [statusId] [ bigint ]  NULL ，
 [lastModifiedOn] [ datetime ]  NULL ，
  PRIMARY   KEY   CLUSTERED  
（
 [fileId] < span class =code-keyword> ASC  
） WITH （PAD_INDEX =  OFF ，STATISTICS_NORECOMPUTE =  OFF ，IGNORE_DUP_KEY =  OFF ，ALLOW_ROW_LOCKS =  ON ，ALLOW_PAGE_LOCKS =  ON ） ON  [ PRIMARY ] 
） ON  [ PRIMARY ] 
 
  GO  
 
  ALTER   TABLE  [dbo]。[fileInfo]  WITH  检查  ADD   FOREIGN   KEY （[statusId]）
  REFERENCES  [dbo]。[status]（ [statusId]）
  GO  
 
  ALTER   TABLE  [dbo]。[fileInfo]  WITH   CHECK   ADD   FOREIGN   KEY （[statusId]）
  REFERENCES  [dbo]。[status]（[statusId]）
  GO  
 
  ALTER   TABLE  [dbo]。[fileInfo]  WITH   CHECK   ADD   FOREIGN   KEY （[statusId]）
  REFERENCES  [dbo]。[status]（[statusId]）
  GO  
 
  ALTER   TABLE  [dbo]。[fileInfo]  WITH   CHECK   ADD   FOREIGN   KEY （[userId]）
  REFERENCES  [dbo]。[userInfo]（[userId]）
  GO  
 
  ALTER   TABLE  [dbo]。[fileInfo]  WITH   CHECK   ADD   FOREIGN   KEY （[userId]）
  REFERENCES  [dbo]。[userInfo]（[userId]）
  GO  
 
  ALTER  表 [dbo]。[fileInfo]  WITH   CHECK   ADD   FOREIGN   KEY （[userId]）
  REFERENCES  [dbo]。[userInfo]（[userId]）
  GO  

它无法存储到DB中的用户ID。

 < span class =code-keyword> string  query2 =   INSERT INTO fileInfo（userId，fileName，fileType ，fileSi ze，filePath，statusId，createdOn）VALUES（@ userId，@ FileName，@ FileType，@ fileSize，@ filePath，3，@ createdOn）; 
  string  u_id =  从userInfo中选择userId其中email =' + keyid +  '; 

请推荐朋友们！

预先感谢朋友！

解决方案

表fileinfo对userid和statusid有外键约束。



确保在将相关表格中的相关表格中存在已经存在的用户标识和Statusid之前已存在。

1.UserInfo

CREATE TABLE [dbo].[userInfo](
    [userId] [bigint] IDENTITY(1,1) NOT NULL,
    [email] [nvarchar](30) NOT NULL,
    [password] [nvarchar](20) NOT NULL,
    [firstName] [nvarchar](50) NULL,
    [lastName] [nvarchar](50) NULL,
    [activationKey] [nvarchar](800) NULL,
    [active] [bit] NULL,
    [createdOn] [datetime] NULL,
    [modifiedOn] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
    [userId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
UNIQUE NONCLUSTERED
(
    [email] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

2.FileInfo

CREATE TABLE [dbo].[fileInfo](
    [fileId] [bigint] IDENTITY(1,1) NOT NULL,
    [userId] [bigint] NULL,
    [fileName] [nvarchar](50) NOT NULL,
    [fileType] [nvarchar](50) NOT NULL,
    [fileSize] [nvarchar](100) NOT NULL,
    [filePath] [nvarchar](200) NOT NULL,
    [createdOn] [datetime] NULL,
    [statusId] [bigint] NULL,
    [lastModifiedOn] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
    [fileId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[fileInfo]  WITH CHECK ADD FOREIGN KEY([statusId])
REFERENCES [dbo].[status] ([statusId])
GO

ALTER TABLE [dbo].[fileInfo]  WITH CHECK ADD FOREIGN KEY([statusId])
REFERENCES [dbo].[status] ([statusId])
GO

ALTER TABLE [dbo].[fileInfo]  WITH CHECK ADD FOREIGN KEY([statusId])
REFERENCES [dbo].[status] ([statusId])
GO

ALTER TABLE [dbo].[fileInfo]  WITH CHECK ADD FOREIGN KEY([userId])
REFERENCES [dbo].[userInfo] ([userId])
GO

ALTER TABLE [dbo].[fileInfo]  WITH CHECK ADD FOREIGN KEY([userId])
REFERENCES [dbo].[userInfo] ([userId])
GO

ALTER TABLE [dbo].[fileInfo]  WITH CHECK ADD FOREIGN KEY([userId])
REFERENCES [dbo].[userInfo] ([userId])
GO

It cannot able to store to userid in DB.

string query2 = "INSERT INTO fileInfo(userId,fileName,fileType,fileSize,filePath,statusId,createdOn) VALUES (@userId,@FileName, @FileType,@fileSize,@filePath,3,@createdOn)";
           string u_id = "select userId from userInfo where email='" + keyid + "'";

Please refer Friends!
Advance Thanks Friends!

解决方案

Table fileinfo has foreign key constraint on userid and statusid.

make sure ralated userid and Statusid are already present in the related tables before you insert them into fileinfo.

这篇关于Asp.net在DB中存储值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！