html连接sqlserver数据库,C# 连接sqlServer数据库

连接sqlServer数据库

一.创建数据库

在用[Microsoft SQL Server Management Studio]工具，建立一个数据库，然后执行下面脚本

CREATE TABLE [dbo].[Company](

[Id] [int] IDENTITY(1,1) NOT NULL,

[Name] [nvarchar](500) NULL,

[CreateTime] [datetime] NOT NULL,

[CreatorId] [int] NOT NULL,

[LastModifierId] [int] NULL,

[LastModifyTime] [datetime] NULL,

CONSTRAINT [PK_Company] 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]

GO

INSERT INTO [dbo].[Company]

([Name]

,[CreateTime]

,[CreatorId]

,[LastModifierId]

,[LastModifyTime])

VALUES

('腾讯','2020-05-26',1,1,'2020-05-26')

二.

二.设置App.config中的连接字符串&#x