修改网页的MSSQL语句

Question

我已经为我的网站创建了一个简单的数据库，它有一个内容管理系统，其中管理员可以添加项目，这些项目最终将存储在数据库中。但我注意到一个问题，每当我测试向我的网站添加新项目时，id列在删除并再次添加新项目后继续增加。假设我的数据库中有8个固定项，分别具有1-8个id。我现在将创建第9个条目，它将为我提供id 9，但是当我删除它并创建一个新条目时，id编号将是10，以此类推。我想要发生的是id留在9号。

以下是我的数据概述的图像：

​

​

如您所见，我的第9项的id为22，这不是我们想要的结果。

下面是我的SQL语句：

        /****** Object:  Table [dbo].[guitarItem]    Script Date: 21/10/2016    15:20:18 ******/
   SET ANSI_NULLS ON
   GO
   SET QUOTED_IDENTIFIER ON
   GO
   SET ANSI_PADDING ON
   GO
   CREATE TABLE [dbo].[guitarItem](
      [id] [int] IDENTITY(1,1) NOT NULL,
      [type] [varchar](50) NOT NULL,
      [model] [varchar](50) NOT NULL,
      [price] [float] NOT NULL,
      [image1] [varchar](255) NULL,
      [image2] [varchar](255) NULL,
   PRIMARY KEY CLUSTERED 
   (
    [id] ASC
   )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,     ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    GO
   SET ANSI_PADDING OFF
    GO
   SET IDENTITY_INSERT [dbo].[guitarItem] ON
    INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (1, N'Ibanez', N'ARZ307', 9000.00 , N'../Images/Guitar Brands/Ibanez Guitars/ibanezARZ307.jpg', N'../Images/Guitar Brands/Ibanez Guitars/ibanezARZ307StandingPosition.png')
    INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (2, N'Ibanez', N'DT420TCR', 11000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezDTR420TCR.jpg', N'../Images/Guitar Brands/Ibanez Guitars/ibanezDTR420TCRStandingPosition.png')
    INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2])    VALUES (3, N'Ibanez', N'JBM100', 18000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezJBM100.jpg', N'../Images/Guitar Brands/Ibanez Brands/ibanezJBM100StandingPosition.png')
   INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1],   [image2]) VALUES (4, N'Ibanez', N'M8M', 13000.00, N'../Images/Guitar   Brands/Ibanez Guitars/ibanezM8M.png', N'../Images/Guitar Brands/Ibanez   Guitars/ibanezM8MStandingPosition.png')
  INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (5, N'Ibanez', N'RGAIX7FM', 15000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezRGAIX7FM.jpg', N'../Images/Guitar Brands/Ibanez Guitars/ibanezRGAIX7FMStandingPosition.png')
    INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2]) VALUES (6, N'Ibanez', N'JEM77P', 30000.00, N'../Images/Guitar Brands/Ibanez Guitars/ibanezJEM77P.jpg', N'../Images/Guitar Brands/Ibanez   Guitars/ibanezJEM77PStandingPosition.png')
   INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2])    VALUES (7, N'Ibanez', N'AR325', 8000.00, N'../Images/Guitar Brands/Ibanez   Guitars/ibanezAR325.jpg', N'../Images/Guitar Brands/Ibanez  Guitars/ibanezAR325StandingPosition.png')
    INSERT [dbo].[guitarItem] ([id], [type], [model], [price], [image1], [image2])     VALUES (8, N'Ibanez', N'PGM3', 36000.00, N'../Images/Guitar Brands/Ibanez    Guitars/ibanezPGM3.jpg', N'../Images/Guitar Brands/Ibanez   Guitars/ibanezPGM3StandingPosition.png')


 SET IDENTITY_INSERT [dbo].[guitarItem] OFF

Answer 1

下面是一个可能的示例列表。对于SQL和ASP.Net：(有些还引用了其他资源)

ASP.NET

Stored Procedure with parameters into DataGridView in C# Populate DataGridView from a Stored Procedure https://www.codeproject.com/Questions/396443/Displaying-results-from-a-stored-procedure-into-da http://asp.net-informations.com/gridview/procedure.htm

SQL

https://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql-server-stored-procedure-with-parameters/ https://www.codeproject.com/articles/126898/sql-server-how-to-write-a-stored-procedure-in-sql https://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure-tutorial/ https://msdn.microsoft.com/en-us/library/ms345415.aspx

如果提到的链接没有提供足够的示例，请使用google/bing。

短语：

链接到sql存储过程的

• sql存储过程
• datagridview